Moving Powertech Database Monitor for IBM i Version 3.x to a New System

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, Simpler Names for HelpSystems Security Software.

Step I – Planning a Database Monitor for IBM i 3.x Move

1. Database Monitor for IBM i 3.x Installation. For best results, before the move, Database Monitor for IBM i must already be installed on the ‘destination’ system so the user profile, SBSD (subsystem description), job queue, and CLS (class of service) are installed properly.
2. The Database Monitor for IBM i Application Preparation. Before moving to the new system, the basic functions within Database Monitor for IBM i should be tested on the ‘source’ system to ensure  the data and historical information is not corrupt and is ready to be used on the destination system after the move.
3. Data Queues. Database Monitor for IBM i stores historical data from monitored files using data queues. Data is moved from the data queues to the Database Monitor for IBM i data ‘vault’ in the form of database files. These queues must not contain data at the time of migration, to avoid data corruption.
4. Monitored files. All monitored files (Option 11) must be de-activated and the Subsystem (DATATHREAD) must be shut down prior to copying the Database Monitor for IBM i library to a SAVF in preparation for the move. Once they are de-activated, some time should be given before shutting down the Database Monitor for IBM i Subsystem in order to allow the monitor job(s) to clear out all of the data queues.
5. Database files holding the historical data. Although it is permissible to move the historical data to a different system, it is recommended that these database files are trimmed prior to the migration, using the ‘Purge and Archive’ procedure available within Database Monitor for IBM i. 

   Note: For additional information about Purge and Archive please consult the Database Monitor for IBM i Administrator’s Guide.​

6. License Key. Obtain a license key for the new system from the Powertech Sales team.

   Note: After normal business hours, contact technical support for a temporary key.

Step II – Install Database Monitor for IBM i R03MXX

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.  

• Database Monitor for IBM i has one profile: DATATHREAD.
• Database Monitor for IBM i has one job queue: QUSRSYS/DTJOBQ.
• Database Monitor for IBM i has one SBSD: QUSRSYS/DATATHREAD
• Database Monitor for IBM i has one CLS: QUSRSYS/DATATHREAD

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. 

Step III – Database Monitor for IBM i Journal and Replication

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.

Step IV – Database Monitor for IBM i Files to Move 

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.

Step VI – License Objects

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. 

Step VII – Move Database Monitor for IBM i Commands 

De-activate all monitored files (2 options to do this).

1. In Option 11  from within Database Monitor for IBM i, enter “29” next to all of the files that are currently activated (they will be highlighted in white).
2. If there are many files activated, you can submit the following command to de-activate all files:

   Note: Ensure Database Monitor for IBM i is in your LIBL (ADDLIBLE DATATHREAD)

3. Submit the command:

   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.

4. 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.

5. 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.

6. Next, shut down the monitor jobs under the Database Monitor for IBM i subsystem. There are two ways to do this:

   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

7. To end the Database Monitor for IBM i subsystem from the command line submit the following command:

   ENDSBS DATATHREAD *IMMED

8. Once the subsystem has been shut down:

   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.

On the source system submit the commands:

1. Create the SAVF file:

   CRTSAVF QGPL/DTSAVF

2. Save the Database Monitor for IBM i library to the SAVF file:

   SAVLIB LIB(DATATHREAD) DEV(*SAVF) SAVF(QGPL/DTSAVF)

On the destination system submit the commands:

1. Create the SAVF file:

   CRTSAVF QGPL/DTSAVF

2. FTP the SAVF file to the destination system. Submit the commands (from the ‘source’ system):

   FTP

3. Sign on with your Username and Password.
4. Enter BIN for a Binary Transfer:

   Bin

5. Transfer the file using the ‘PUT’ command:

   PUT QGPL/DTSAVF QGPL/DTSAVF

6. Install Database Monitor for IBM i.
7. Once the installation is complete, clear the library in preparation for restoring the library that was saved and FTP’d from the source system.
8. Submit the command to clear the library:

   CLRLIB LIB(DATATHREAD)

9. Next, submit the following command to restore the library from the SAVF file:

   RSTLIB SAVLIB(DATATHREAD) DEV(*SAVF) SAVF(QGPL/DTSAVF) MBROPT(*ALL) ALWOBJDIF(*ALL) RSTLIB(DATATHREAD)

10. Once the restore is complete, submit the command to go into Database Monitor for IBM i, navigate to the license key configuration screen, and install the new license key. Submit the command:

    STRDT

11. Take option 18 and insert the new license key for this system.

Step VIII – Restart the Database Monitor for IBM i Subsystem and monitor jobs for Database Monitor for IBM i on the destination system

1. After the license key has been successfully entered, start the Database Monitor for IBM i Subsystem and monitor jobs with the following commands.

   STRSBS DATATHREAD

2. Next, start the monitor jobs under the Database Monitor for IBM i Subsystem using 1 of 2 options:

   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:

   

Step IX – Database Monitor for IBM i Monitored File Activation on the New (Destination) System

Activation

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.

1. Re-activate all monitored files (2 ways to do this).
   • In Option 11  from within Database Monitor for IBM i place 22 next to all of the files that are currently de-activated ( they will be highlighted in yellow ).
   • If there are a lot of  files de-activated you can submit the following command to re-activate them all from a single command.

     Note: make sure Database Monitor for IBM i is in your LIBL ( ADDLIBLE DATATHREAD )

2. Submit the command:

   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.