IBM Support

Installing and Configuring Db2 11.1.1 for Maximo 7.6.0.6+

Technical Blog Post


Abstract

Installing and Configuring Db2 11.1.1 for Maximo 7.6.0.6+

Body

For installing WebSphere 9, go to Installing and Configuring WebSphere 9.0.0 for Maximo 7.6.0.6+

Db2 11.1.1 Installation and Configuration

Install Db2 11.1.1

Windows Server Preinstallation Tasks

Log in to the system as a user that has administrative permissions on the system.

  • Create groups:

DB2ADMNS    Description: This group and local administrators will have complete access to all DB2 objects through the operating system.
DB2USERS    Description: This group will have read and execute access to all DB2 objects through the operating system.

  • Create users: ctginst1, db2admin, maximo
  • Add db2admin to Administrators and DB2ADMNS groups

Download Db2  11.1.1

See How to install the 7.6.0 version of Maximo Asset Management with WebSphere Application Server 9.0 and Db2 version 11.1.1

Install Db2 11.1

In Windows, navigate to DB2_AESE_PVU_11.1_Svr_win_86-64\SERVER_AESE_C\image. Double-click setup.exe.

image

Select Custom:

image

Select Install Db2 Server Edition on this computer.

image

Add Db2 Text Search.

image

For the next few screens, accept the defaults, adding passwords as necessary.

image

Activate Db2 Advanced Enterprise Server Edition (AESE) License

Open a Windows command prompt and navigate to at C:\IBM\SQLLIB\BIN. Start the DB2 command-line environment by running db2cmd:

image

db2licm -a command: db2install_path\bin\db2licm -a filename

image

Exit the Db2 command-line environment. Exit the command prompt.


Create Db2 11.1.1 Database for Maximo

Open a Windows command prompt and navigate to C:\IBM\SQLLIB\BIN. set up the Db2 environment line environment:

db2cmd

Create the Db2 Instance

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

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
db2 GRANT SECADM ON DATABASE TO USER db2admin
db2 connect reset

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
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

Restart Db2

db2stop force
db2start

Reconnect to the database

db2 connect to 'maxdb76'

Create a buffer pool

db2 CREATE BUFFERPOOL MAXBUFPOOL IMMEDIATE SIZE 4096 AUTOMATIC PAGESIZE 32 K
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

Create Schema

db2 create schema maximo authorization maximo

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

Break the database connection

db2 connect reset

Exit the Db2 command-line environment.

Next: Installing and configuring Maximo 7.6.0.8 to WebSphere 9.0.0 and Db2 11.1.

Db2 11.1 is out of support. Maximo environments that use Db2 for its database must be upgraded to version 11.5 or later.

Updated 2 Mar 2023

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

UID

ibm11113915