Preparing the DB2 database

The following steps to prepare the DB2 database assume that you have already installed your DB2 database instance.

Before you begin

These steps assume that your DB2 instance owner is 'db2inst1'. If your instance owner is not 'db2inst1' then change 'db2inst1' references to your user.

The following steps also assume that the Netcool Configuration Manager database user is different from the instance owner and called 'ncmdbuser'. If you are using db2inst1 as the NCM database user, replace all 'ncmdbuser' references in commands with 'db2inst1'.

Procedure

  1. Login into DB2 Server as the instance owner 'db2inst1'.
  2. Create the Netcool Configuration Manager database with a pagesize of 32768: 
    db2 create database ITNCM automatic storage yes pagesize 32768 dft_extent_sz 32
  3. Configure database user privileges. 
    db2 connect to itncm
    Note: The Grant command may fail if your user already has privileges assigned.
    db2 "GRANT BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT ON DATABASE TO USER ncmdbuser"
  4. Update the transaction log size: 
    db2 update db cfg using logfilsiz 5000
db2 update db cfg for itncm using logprimary 200
db2 update db cfg for itncm using logsecond 50
  5. For versions of DB2 prior to 11.0, increase the database storage used for locking. This step is not needed for DB2 11.0 and above: 
    db2 update db cfg for itncm using LOCKLIST 8192
  6. Commit Changes: 
    db2 commit
  7. Reset the database connection: 
    db2 connect reset