Manually configuring DB2 v10.5

Manually configuring DB2® v10.5 servers for use by Maximo® Asset Management.

1. Log in to the system as a user that has administrative permissions on the system.
2. Create system users if they do not exist on the system.
   • Windows
     • db2admin
     • maximo
   • Linux or UNIX
     • db2admin
     • maximo
     • ctgfenc1
     • ctginst1

       The ctginst1 user ID must be assigned to db2iadm1 as its primary group.

3. Open a console window and set up the DB2 environment:
   • Windows

     db2cmd 

   • Linux or UNIX

     Ensure that the /opt/ibm/db2/V10.5/bin, /opt/ibm/db2/v10.5/instance, and /opt/ibm/db2/V10.5/adm directories are added to your PATH.

4. Create the DB2 instance:
   • Windows

     db2icrt -s ese -u db2admin,myPassword -r 50005,50005 ctginst1
     set db2instance=ctginst1
     db2start
     db2 update dbm config using SVCENAME 50005 DEFERRED
     db2stop
     db2set DB2COMM=tcpip
     db2start

   • Linux orUNIX

     db2icrt -s ese -u ctgfenc1 -p 50005 ctginst1
     . /home/ctginst1/sqllib/db2profile
     db2start
     db2 update dbm config using SVCENAME 50005 DEFERRED
     db2stop
     db2set DB2COMM=tcpip
     db2start

5. Create the database.

   db2 create db 'maxdb76' ALIAS 'maxdb76' using codeset UTF-8 territory US pagesize 32 K
   db2 connect to 'maxdb76'
   db2 GRANT DBADM ON DATABASE TO USER db2admin (windows only)
   db2 GRANT SECADM ON DATABASE TO USER db2admin (windows only)
   db2 connect reset

6. Configure the database.

   db2 update db cfg for maxdb76 using SELF_TUNING_MEM ON
   db2 update db cfg for maxdb76 using APPGROUP_MEM_SZ 16384 DEFERRED
   db2 update db cfg for maxdb76 using APPLHEAPSZ 2048 AUTOMATIC DEFERRED
   db2 update db cfg for maxdb76 using AUTO_MAINT ON DEFERRED
   db2 update db cfg for maxdb76 using AUTO_TBL_MAINT ON DEFERRED
   db2 update db cfg for maxdb76 using AUTO_RUNSTATS ON DEFERRED
   db2 update db cfg for maxdb76 using AUTO_REORG ON DEFERRED
   db2 update db cfg for maxdb76 using AUTO_DB_BACKUP ON DEFERRED
   db2 update db cfg for maxdb76 using CATALOGCACHE_SZ 800 DEFERRED
   db2 update db cfg for maxdb76 using CHNGPGS_THRESH 40 DEFERRED
   db2 update db cfg for maxdb76 using DBHEAP AUTOMATIC
   db2 update db cfg for maxdb76 using LOCKLIST AUTOMATIC DEFERRED
   db2 update db cfg for maxdb76 using LOGBUFSZ 1024 DEFERRED
   db2 update db cfg for maxdb76 using LOCKTIMEOUT 300 DEFERRED
   db2 update db cfg for maxdb76 using LOGPRIMARY 20 DEFERRED
   db2 update db cfg for maxdb76 using LOGSECOND 100 DEFERRED
   db2 update db cfg for maxdb76 using LOGFILSIZ 8192 DEFERRED
   db2 update db cfg for maxdb76 using SOFTMAX 1000 DEFERRED
   db2 update db cfg for maxdb76 using MAXFILOP 32768 DEFERRED #32-bit Windows
   db2 update db cfg for maxdb76 using MAXFILOP 65335 DEFERRED #64-bit Windows
   db2 update db cfg for maxdb76 using MAXFILOP 30720 DEFERRED #32-bit UNIX
   db2 update db cfg for maxdb76 using MAXFILOP 61440 DEFERRED #64-bit UNIX
   db2 update db cfg for maxdb76 using PCKCACHESZ AUTOMATIC DEFERRED
   db2 update db cfg for maxdb76 using STAT_HEAP_SZ AUTOMATIC DEFERRED
   db2 update db cfg for maxdb76 using STMTHEAP AUTOMATIC DEFERRED
   db2 update db cfg for maxdb76 using UTIL_HEAP_SZ 10000 DEFERRED
   db2 update db cfg for maxdb76 using DATABASE_MEMORY AUTOMATIC DEFERRED
   db2 update db cfg for maxdb76 using AUTO_STMT_STATS OFF DEFERRED
   db2 update db cfg for maxdb76 using STMT_CONC LITERALS DEFERRED
   db2 update alert cfg for database on maxdb76 using db.db_backup_req SET THRESHOLDSCHECKED YES
   db2 update alert cfg for database on maxdb76 using db.tb_reorg_req SET THRESHOLDSCHECKED YES
   db2 update alert cfg for database on maxdb76 using db.tb_runstats_req SET THRESHOLDSCHECKED YES
   db2 update dbm cfg using PRIV_MEM_THRESH 32767 DEFERRED
   db2 update dbm cfg using KEEPFENCED NO DEFERRED
   db2 update dbm cfg using NUMDB 2 DEFERRED
   db2 update dbm cfg using RQRIOBLK 65535 DEFERRED
   db2 update dbm cfg using HEALTH_MON OFF DEFERRED
   #
   # Windows: AGENT_STACK_SZ 1000
   # Unix   : AGENT_STACK_SZ 1000
   #
   db2 update dbm cfg using AGENT_STACK_SZ 1000 DEFERRED
   db2 update dbm cfg using MON_HEAP_SZ AUTOMATIC DEFERRED
   db2set DB2_SKIPINSERTED=ON
   db2set DB2_INLIST_TO_NLJN=YES
   db2set DB2_MINIMIZE_LISTPREFETCH=Y
   db2set DB2_EVALUNCOMMITTED=YES
   db2set DB2_FMP_COMM_HEAPSZ=65536
   db2set DB2_SKIPDELETED=ON
   db2set DB2_USE_ALTERNATE_PAGE_CLEANING=ON

7. For Linux orUNIX, log into the system as the ctginst1 user, and then restart the DB2 command-line environment.

   su - ctginst1
   db2

8. Restart DB2.

   db2stop force
   db2start

9. Reconnect to the database.

   db2 connect to 'maxdb76'

10. Create a buffer pool.

    db2 CREATE BUFFERPOOL MAXBUFPOOL IMMEDIATE SIZE 4096 AUTOMATIC PAGESIZE 32 K

11. Create table spaces.

    db2 CREATE REGULAR TABLESPACE MAXDATA PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE INITIALSIZE 5000 M BUFFERPOOL MAXBUFPOOL
    db2 CREATE TEMPORARY TABLESPACE MAXTEMP PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE BUFFERPOOL MAXBUFPOOL
    db2 CREATE REGULAR TABLESPACE MAXINDEX PAGESIZE 32 K MANAGED BY AUTOMATIC STORAGE INITIALSIZE 5000 M BUFFERPOOL MAXBUFPOOL
    db2 GRANT USE OF TABLESPACE MAXDATA TO USER MAXIMO

12. Create Schema

    db2 create schema maximo authorization maximo

13. Grant authority to maximo.

    db2 GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,
    LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT,SECADM ON DATABASE TO USER MAXIMO
    
    db2 GRANT USE OF TABLESPACE MAXDATA TO USER MAXIMO
    
    db2 GRANT  CREATEIN,DROPIN,ALTERIN ON SCHEMA MAXIMO TO USER MAXIMO

14. Break the database connection.

    db2 connect reset

15. Exit the DB2 command-line environment
16. Install the appropriate fix pack that is indicated in the prerequisites topic in the chapter that describes how to prepare for the installation. Ensure that you review and complete all the installation and postinstallation tasks that are contained within the fix pack readme file. Failure to do so can potentially cause the Maximo Asset Management installation to fail.