Before you can access Performance Warehouse on z/OS® from Performance Expert Client, you must have DB2 Data Server Runtime Client installed with the appropriate
licenses to access DB2 for z/OS. With OMEGAMON for Db2
Performance Expert, you receive a limited license
for this usage.
Procedure
-
Download a version of DB2 Data Server Runtime Client at
Download Db2 Fix Packs by version for Db2 for Linux®, UNIX and Windows
website.
-
Download the member FPEKCNLI from your TKO2WS01 SMPE/E library in binary format. Add the
extension .zip. Extract the zip file, which contains several .lic and .jar
files for the various Data Server Runtime client versions.
-
Locate the \consv_ee\db2\licence folder for your version within the
.zip file. Extract the .lic file to Program Files\IBM\SQLLIB and
the db2cc_license_cisuz.jar file to \IBM\SQLLIB\java
-
Install the downloaded DB2 Data Server Runtime
Client.
-
After successful installation, run the following command to register the license:
db2licm –a nnnn where nnnn is the version-related .lic file
name you have just extracted. Double check with command db2licm –l that you
have the necessary permanent licenses installed.
-
Before you can access your z/OS database, it needs to be
added to your workstation's DB2 catalog. Enter
db2cmd to start the DB2 Command Line Processor window from
\IBM\SQLLIB. At the next prompt, type db2.
Note: For the 9.7 driver, you can use the Client Configuration Assistant to perform this
task.
-
CATALOG TCPIP NODE <node-name> REMOTE <host-name> SERVER <port-number> OSTYPE
OS390 where port number is the port on which the DB2 subsystem is listening, not the port
on which OMEGAMON is listening.
-
CATALOG DATABASE <location-name> AS <alias> AT NODE <node-name>
AUTHENTICATION SERVER
-
CATALOG DCS DATABASE <alias> AS <target-DB-name>