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.

Before You Update

Note: If your version is V3R2M0 or lower, refer to Upgrading Database Monitor for IBM i from R03M01 (3.01) or Lower.

The Database Monitor for IBM i update is installed over your existing Database Monitor for IBM i installation. Powertech recommends saving a backup of your existing Database Monitor for IBM i library before updating.

Note: When installing Database Monitor for IBM i 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 for IBM i on the HA and production systems.
  3. Setup Database Monitor for IBM i replication per the HA Setup instructions (see Database Monitor for IBM i Setup in an HA Environment)
  4. Start replication (including the user profiles).

Licensing

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

System Values

It is Powertech’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 for IBM i 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 for IBM i 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 for IBM i 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 for IBM i product library DATATHREAD for the product to function properly.
  • QVFYOBJRST can be 1, 2, or 3. This allows Database Monitor for IBM i to restore all objects regardless of their signature. 
  • Set QFRCCVNRST (Force conversion on restore) to 0, Do not convert anything. 

System Requirements

Database Monitor for IBM i 3 requires that IBM i version 7.2 or higher be installed on your system. The latest version supported on V6R1 is 3.11. The latest version of Database Monitor for IBM i that is supported on 7.1 is 3.14.
Note: During installation an FTP connection is initiated. The FTP server responds with messages that prompt for FTP login credentials. The standard port reserved to establish an FTP connection to the IBM i is port 21. Consequently, it is required that this port is open and ‘listening’ on the server in order to establish a connection with the Installation Wizard and facilitate a successful installation.

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

Updating Database Monitor for IBM i

The Database Monitor for IBM i installation process is completely automated.

Note: It is best to update at a time when your system is not particularly busy. Only end Database Monitor for IBM i when you are ready to begin the update procedure.

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

  • FTP Server
  • Remote Command Server 

Do the following to update Database Monitor for IBM i:

  1. Download the Database Monitor for IBM i Installer (setupDataThread.exe) to your PC from the Database Monitor for IBM i download page
  2. End Database Monitor for IBM i using STRDT, option 17, ENDALL. Once all subsystem jobs have ended, you can end the Database Monitor for IBM i subsystem. Back out of any Database Monitor for IBM i menu screens you or others may have open.
  3. Double-click the .exe file to start the Wizard. When prompted, enter the name of the system on which you want to update Database Monitor for IBM i, a user profile, and password.

    Note: Make sure the user profile is a member of the user class *SECOFR and has at least the following special authorities: *ALLOBJ, *SECADM, *JOBCTL, *IOSYSCFG, and *AUDIT. The user profile should have Limit capabilities set to *NO.

  4. The Wizard updates Database Monitor for IBM i on your system. When the update completes, you can select to view the install log. 
  5. When you are finished updating, click Finish to remove the Wizard from your PC. 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 for IBM i update.

Your Database Monitor for IBM i installation includes 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

Product Library

DATATHREAD

User Profiles

DATATHREAD, which has a user class of *USER

The profile is set to Password = *NONE so it can’t be used to sign on to the system.

Commands

STRDT

Subsystem

DATATHREAD

Restart Database Monitor for IBM i

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

STRSBS Datathread
STRDT

option 17, STRMGR

Note: The Database Monitor for IBM i Administrator's Guide can be found at Powertech Product Manuals.


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: November 07, 2018