DB2 installation process (CentOS)

DB2 installation process (CentOS) installation. /install create an instance: groupadd database useradd prod-g databaseuseradd prodfenc-g databasmcm/opt/ibm/db2/V9.7/instance. /db2icrt-a server-u prodfenc prod configure instance parameters: cd ~ Prodvi. bashrc # Add at the end. /sqllib/db2profile sets the instance to start su proddb2iauto-on prod at each login to start instance db2start # You must log on with the instance owner and run this command to list all instances db2ilist to view the current instance db2 get instance current instance Configuration Parameter db2 get dbm cfg create/View/connect database db2 create database LEONdb2 list database directorydb2 connect to LEON view tablespace (details) db2 list tablespaces show detail CREATE an 8 k page upper-case buffer pool db2 "create BUFFERPOOL LEON_BU_8K immediate size 2000 PAGESIZE 8 k" db2 drop bufferpool limit CREATE bufferpool leon_bp_8k immediate size 5000 pagesize 8 k create tablespace (8 K page size) mkdir-p/database # can only be created to this layer. The container directory is created by the database. If you create a directory, the following error DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command will be reported when creating The tablespace. during SQL processing it returned: SQL0298N Bad container path. SQLSTATE = 428B2chown-R prod: database db2 "create tablespace LEONSPACE0 pagesize 8192 managed by database using (FILE '/database/container1' 5000) bufferpool leon_bp_8k"