Topics:

How to catalog a DB2 database

  • Open DB2 Command Window
  • Run "C:\Program Files\IBM\cmgmt\cmbdbcat81" AIX CAT DBP001 KL101234 INSTP001 KL101234.FQDN.COM 50000
Where:
DBP001 is the actual database name
KL101234 is the alias you are going to use to connect to the database, you may keep it the same.
INSTP0001 is the DB2 instance name
Make sure to enter the fully qualified domain name as the hostname (kl101234.fqdn.com)
50000 is the default DB2 port

This is how to uncatalog a database:
  • db2 => list node directory (check node)
  • db2 => uncatalog node INSTP001
  • db2 => list database directory (check db)
  • db2 => uncatalog database KL101234
Test to see if it works:
In your DB2 command line window, run: db2
  • db2 => connect to KL101234 user icmadmin using icmadmin
  • db2 => list tables
Where: the default icmadmin userid is used with password (using) icmadmin

To get the new database to work with the IBM Content Manager Windows client and system administration client:
  • Add to file: C:\Program Files\ibm\CMgmt\cmbds.ini:
    FEDSERVER=KL101234
    FEDSERVERREPTYPE=DB2
    FEDSCHEMA=ICMADMIN
    FEDSSO=FALSE
    FEDDBAUTH=SERVER
    FEDREMOTE=TRUE
    FEDHOSTNAME=kl101234.fqdn.com
    FEDPORT=50000
    FEDREMOTEDB=DBP001
    FEDNODENAME=kl101234
    FEDOSTYPE=AIX
  • Add to file: C:\Program Files\ibm\CMgmt\cmbicmsrvs.ini:
    ICMSERVER=KL101234
    ICMSERVERREPTYPE=DB2
    ICMSCHEMA=ICMADMIN
    ICMSSO=FALSE
    ICMDBAUTH=SERVER
    ICMREMOTE=FALSE
    ICMHOSTNAME=
    ICMPORT=
    ICMREMOTEDB=
    ICMNODENAME=
    ICMOSTYPE=

  • Now you can startup the IBM Content Manager Windows client and system administration client and login.


UNIX Health Check delivers software to scan Linux and AIX systems for potential issues. Run our software on your system, and receive a report in just a few minutes. UNIX Health Check is an automated check list. It will report on perfomance, capacity, stability and security issues. It will alert on configurations that can be improved per best practices, or items that should be improved per audit guidelines. A report will be generated in the format you wish, and the report includes the issues discovered and information on how to solve the issues as well.

Interested in learning more?