Installing Database Monitor

These instructions describe how to install Database Monitor.

Before You Begin

Please review the following information before installing Database Monitor. .

When installing Database Monitor in an HA environment:

1. Stop the replication of user profiles from production to HA system by either ending the replication software or ending the replication of the user profiles.
2. Install Database Monitor on the HA and production systems.
3. Setup Database Monitor replication per the HA Setup instructions. To view these instructions, see Database Monitor Setup in an HA Environment.
4. Start replication (including the user profiles).

System requirements

Database Monitor for IBM i requires that IBM i version 7.3 or higher be installed on your system. It is supported by single-byte systems only.

If FTP is not available, you must install the product manually. See Manual Installation of Powertech IBM i Products.

Proper Authorization

The installation of Database Monitor requires use of a profile with QSECOFR authority.

Licensing

Database Monitor requires that you enter a valid license key. Contact keys@fortra.com if you need to request a new license key.

System values

It is Fortra's goal not to change system values on customer systems because we recognize that security-conscious organizations have rigorous change control processes in place for even small changes to system values. Therefore, we ask you to make any system value changes that are needed. However, the Database Monitor installation process could change a system value to allow the install to proceed if a system value is not set as specified below. If the Installation Wizard changes a system value during install, it changes it back to its original value when the install completes. To install Powertech Database Monitor on your system, the following system values that control object restores must be configured as shown.

• Set QALWOBJRST to *ALWPGMADP (at a minimum) to allow the system to restore programs that adopt authority. Many Powertech Database Monitor programs adopt the authority of the product owner, rather than forcing you to give authority directly to administrators and end users. (Note: For some system configurations, *ALL is required temporarily.)
• QALWUSRDMN controls which libraries on the system can contain certain types of user domain objects. You should set the system value to *ALL, or include QTEMP and the name of the Database Monitor product library DATATHREAD for the product to function properly.
• QVFYOBJRST can be 1, 2, or 3. This allows Database Monitor to restore all objects regardless of their signature. (Note: If you normally check signatures, remember to check this system value after the Authority Broker install process completes.)
• Set QFRCCVNRST (Force conversion on restore) to 0, Do not convert anything.

Installing Database Monitor

Ensure the following servers are available and running prior to installation:

• FTP Server
• Remote Command Server

Follow these instructions to install Database Monitor:

1. Download the Database Monitor installer (setupDatabaseMonitor.exe) from the Fortra Download Page on our website. Double-click it to start it.
2. On the Choose Components panel, select which components you want to install. You can choose to install the Manuals and the Software for IBM i. Click Next.
3. If you’re only installing the Manuals, the process completes and the installer closes. The Manuals have been installed. You can skip the rest of these steps.
   NOTE: The manuals are installed to the following location: C:\Program Files\PowerTech\Database Monitor\manuals

   If you’re loading the Software for IBM i, continue to step 4.

4. On the Choose a Destination IBM i panel:
   1. Select or enter the IBM i where you want to load Database Monitor.
   2. Enter a user profile and password that’s a member of the user class *SECOFR and has at least the following special authorities: *ALLOBJ, *SECADM, *JOBCTL, *SAVSYS, *IOSYSCFG, and *AUDIT. The user profile should have Limit capabilities set to *NO. This profile will be used to restore and copy objects, and for product maintenance on the IBM i.
   3. (Optional) In the Advanced Settings section:
      • Enter a port number or use the arrows if you want to change the FTP port number to something other than the default of 21.
      • Select Secure File Transfer if you want to use FTPS (FTP over SSL) during the file transfer. The default FTPS secure port is 990, but it can be changed to the required secure port for your environment.
      • In the Timeout (seconds) field, enter the number of seconds the session should be kept active during an FTP transfer. You can choose anywhere between 25 and 1800 seconds (30 minutes).
        NOTE: If the transfer takes longer than the amount of time specified, the session will expire.
   4. Click Next.
5. You have two options on the Product Load Options panel:
   1. Click Immediate Load if you’d like to load the product on the IBM i now.
      NOTE: If you're doing an update, this ends Database Monitor until the product load completes. After you are done, we’ll restart the product.
   2. Click Staged Load if you’d like to transfer the objects now and load them on the IBM i at a later time.
      NOTE: See “Loading Staged Objects on the IBM i” below for instructions on how to load the staged objects on your selected IBM i system.

6. The Product Load Progress panel for Database Monitor launches. When the processing is complete, you have two choices:

   • If this is the only installation or update of Database Monitor that you're doing, click Finish.
   • If you have installs or updates to do on other IBM i systems, click Restart. Then, return to step 4.
   NOTE: If the Product Load Progress panel ends with an overall Failed message, the product upload could not complete properly. To find the reason the upload failed, click View Logs and review your logs. You can also use Download at the top of the logs to save the information for future review.

The installation process displays the job log name, user, and job log number. Use the WRKSPLF command to display the job log for complete information on the Database Monitor install.

Database Monitor installs the following product libraries, user profiles, and command on your system. It also creates the DATATHREAD subsystem if it doesn’t already exist.

Installed on System	Description
Library (*LIB)	DATATHREAD in QSYS
Profile (*USRPRF)	DATATHREAD in QSYS
Class (*CLS)	DATATHREAD in QUSRSYS
Subsystem (*SBSD)	DATATHREAD in QUSRSYS
Job Queue (*JOBQ)	DTJOBQ in QUSRSYS
Command (*CMD)	STRDT in QGPL

Loading Staged Objects on the IBM i

If you chose to stage your objects during step 5b of the installation or update process, do the following to manually load them on the IBM i you identified above.

1. On the IBM i, execute the following command to display the Work with Loads panel:

   HSLOADMGR/HSWRKLOAD

2. Enter option 1, Load, next to the Load Name for Powertech Database Monitor and press Enter.

After You Are Done

Congratulations! Database Monitor is now installed. Read the following for additional information and your next steps.

Starting Database Monitor for IBM i

To start Database Monitor for IBM i, enter the following command:

STRDT

(this command is in the QGPL Library)

The first time you enter the STRDT command to start Database Monitor for IBM i, a series of prompt screens displays asking you to enter the following information:

• The name of the system on which Database Monitor for IBM i is installed
• The IP address of the e-mail server to which Database Monitor for IBM i should send notifications
• The “Reply to” e-mail address
• The Database Monitor for IBM i license code you received from Fortra

Contacting Us

For additional resources, or to contact Technical Support, visit the Fortra Support Portal at https://support.fortra.com.