Important Updates to Cybersecurity Software
HelpSystems is updating the names of our cybersecurity software, including the Powertech product line. Don’t worry—the functionality of your products won’t change.
See the new names here > New, Clearer Names for HelpSystems Security Software.
Note: For additional information about Purge and Archive please consult the Database Monitor for IBM i Administrator’s Guide.
Note: After normal business hours, contact technical support for a temporary key.
To successfully move Database Monitor for IBM i from one system to another (i.e. D/R system), you must first install Database Monitor for IBM i on the destination system using the software installer.
The installer creates the required user profile, SBSD, CLS, and job queue for Database Monitor for IBM i.
Note: If the user profile, CLS, SBSD, or job queue exists, installation will fail. If installation fails, delete this user profile and/or CLS, SBSD, job queue, and try the installation again.
Database Monitor for IBM i has one journal, DTJOURNAL, which is used when journaling is configured within Database Monitor for IBM i (Option 11) for monitoring files. This Option is turned on by selecting ‘D’ for the action selected. Refer to Database Monitor for IBM i Setup in an HA Environment for more information.
All files within the Database Monitor for IBM i library will be saved to a SAVF file and then copied to the ‘destination’ system and restored after the Database Monitor for IBM i application has been installed and the library has been cleared.
Database Monitor for IBM i 3.07, or later, has the ability to enter multiple licenses (press F7 – License List on License Setup screen). If multiple licenses have been entered and a license is included for the new system, the DATATHREAD/PDT9800U and DATATHREAD/PDT9800U2 user spaces will be copied with the SAVF file and restored on the new system.
Step VII has the commands to use to save and restore the files, index and the license object to the new system.
De-activate all monitored files (2 options to do this).
Note: Ensure Database Monitor for IBM i is in your LIBL (ADDLIBLE DATATHREAD)
CALL IDT465 PARM(‘0’ ‘*ALL’ ‘ ‘)
Note: Ensure ALL files have been de-activated by navigating to Option 11 from within Database Monitor for IBM i and checking to make sure all monitored files are presently colored yellow, indicating that they are not activated.
After all the data queues are empty, shut down the subsystem. The subsystem monitor job IDT450 is the job that cleans out the data queues and moves the data to the database files and should be running.
To check the data queues for data submit the command:
CALL DQVIEW SLAW (press ENTER twice to view)
This will list the data queues and show if there is any data in them. Example:
Note: To view other DTAQs, type over an existing line, Press Enter.
In this example the data queues are empty and it is now safe to stop all the monitor jobs and shut down the Database Monitor for IBM i subsystem. Hit F12 to exit DQVIEW.
Note: If there is any data in any of the data queues please allow the IDT450 monitor job/s to run until the data queues are empty.
a. From option 17 within Database Monitor for IBM i, submit the command ENDALL.
b. With Database Monitor for IBM i in the LIBL, from the command line, submit the following command:
CALL END460
ENDSBS DATATHREAD *IMMED
a. Copy the Database Monitor for IBM i library on the ‘source’ system to a SAVF file.
b. FTP the SAVF file to the ‘destination’ system.
c. Clear the library that was created from the installation.
d. Restore the library from the SAVF file.
CRTSAVF QGPL/DTSAVF
SAVLIB LIB(DATATHREAD) DEV(*SAVF) SAVF(QGPL/DTSAVF)
CRTSAVF QGPL/DTSAVF
FTP
Bin
PUT QGPL/DTSAVF QGPL/DTSAVF
CLRLIB LIB(DATATHREAD)
RSTLIB SAVLIB(DATATHREAD) DEV(*SAVF) SAVF(QGPL/DTSAVF) MBROPT(*ALL) ALWOBJDIF(*ALL) RSTLIB(DATATHREAD)
STRDT
STRSBS DATATHREAD
a. From the command line submit the command:
ADDLIBLE DATATHREAD
CALL STR460
b. From Option 17 in Database Monitor for IBM i submit the command STRMGR.
The following ‘minimum’ list of monitor jobs should now start under the Database Monitor for IBM i Subsystem
List the Subsystem details:
WRKACTJOB SBS(DATATHREAD)
List of minimum jobs that should have started:
Example:
After the license key has been entered, the Subsystem and the monitor jobs started, the monitored files that were de-activated can be re-activated.
Note: make sure Database Monitor for IBM i is in your LIBL ( ADDLIBLE DATATHREAD )
CALL IDT465 PARM(‘1’ ‘*ALL’ ‘ ‘)
Note: Using the command CALL IDT465 to re-activate the files will actually re-activate the files that were de-activated previously automatically.
Note: Please check to ensure ALL appropriate files have been activated by navigating to Option 11 from within Database Monitor for IBM i and check to make sure all appropriate monitored files are presently colored white, indicating they have been activated successfully.
Still have questions? We can help. Submit a case to Technical Support.