Table of Contents

DB2 on Ubuntu

Resources

db2exc 9.7.0-8 (amd64 binary) in ubuntu hardy

db2exc package

Ubuntu Server Edition

Downloads

db2exc_9.7.0.orig.tar.gz 388.0 MiB 215c3fd33ae17c5958e60143a12a2fa7

db2exc_9.7.0-8.diff.gz 13.1 KiB b7e6cdaf7cf16f6f0b1e7f0de9e48979

db2exc_9.7.0-8.dsc 566 bytes 4f92a2e685e4b09de12d18cf08bf506c

Steps

wget "http://launchpadlibrarian.net/34194086/db2exc_9.7.0-8_amd64.deb"

apt-get install adduser bc ksh lib32gcc1 lib32stdc++6 libaio1 libc6 libc6-i386 libgcc1 libncurses5 libstdc++5 libstdc++6 libx11-6 libxext6 libxft2 libxi6 libxp6 libxt6 libxtst6

# dpkg -i db2exc_9.7.0-8_amd64.deb

Selecting previously deselected package db2exc.
(Reading database ... 158191 files and directories currently installed.)
Unpacking db2exc (from db2exc_9.7.0-8_amd64.deb) ...
 * Checking for previous DB2 installations...                            [ OK ]
 *      No DB2 installation(s) found
 * Checking for existing DB2 instance data...                            [ OK ]
 *      No DB2 instances found.
Setting up db2exc (9.7.0-8) ...
 * Setting DB2 library path...                                           [ OK ]
 * Registering installation in the DB2 global registry...                [ OK ]
 * Creating new groups and users for DB2 instances...                           
   *      Creating group db2iadm1...                                              
   *      Creating group db2fadm1...                                                
   *      Creating group dasadm1...                                                 
   *      Creating user db2inst1...                                               
   *      Creating user db2fenc1...                                               
   *      Creating user dasusr1...                                                
 * DB2 user and group creation...                                        [ OK ]
 * Creating default instances...                                         [ OK ]
 * Adding instance information to /etc/services...                       [ OK ]
 * Updating DBM configuration...                                         [ OK ]
 * Installing DB2 Express-C 9.7 license...                               [ OK ]
DB2 Express-C for Linux 64bit has been installed in /opt/ibm/db2/V9.7.
DB2 instance db2inst1 and DAS user dasusr1 has been configured.

For more details, consult DB2 Information Center.
http://publib.boulder.ibm.com/infocenter/db2luw/v9r7
  * Starting DAS:                       done.
  * Starting instance db2inst1          done.

Processing triggers for libc6 ...
ldconfig deferred processing now taking place

More info

db2inst1@ub1:~$ db2 start db manager

DB20000I  The START DATABASE MANAGER command completed successfully.

db2inst1@ub1:~$ db2 attach to db2inst1

   Instance Attachment Information

 Instance server        = DB2/LINUXX8664 9.7.0
 Authorization ID       = DB2INST1
 Local instance alias   = DB2INST1

db2inst1@ub1:~$ db2 GET DATABASE MANAGER CONFIGURATION

          Database Manager Configuration

     Node type = Database Server with local and remote clients

 Database manager configuration release level            = 0x0d00

 CPU speed (millisec/instruction)             (CPUSPEED) = 1.889377e-07

 Max number of concurrently active databases     (NUMDB) = 8
 Federated Database System Support           (FEDERATED) = NO
 Transaction processor monitor name        (TP_MON_NAME) =

 Default charge-back account           (DFT_ACCOUNT_STR) =

 Java Development Kit installation path       (JDK_PATH) = /home/db2inst1/sqllib                                                              /java/jdk64

 Diagnostic error capture level              (DIAGLEVEL) = 3
 Notify Level                              (NOTIFYLEVEL) = 3
 Diagnostic data directory path               (DIAGPATH) = /home/db2inst1/sqllib                                                              /db2dump
 Size of rotating db2diag & notify logs (MB)  (DIAGSIZE) = 0

 Default database monitor switches
   Buffer pool                         (DFT_MON_BUFPOOL) = OFF
   Lock                                   (DFT_MON_LOCK) = OFF
   Sort                                   (DFT_MON_SORT) = OFF
   Statement                              (DFT_MON_STMT) = OFF
   Table                                 (DFT_MON_TABLE) = OFF
   Timestamp                         (DFT_MON_TIMESTAMP) = ON
   Unit of work                            (DFT_MON_UOW) = OFF
 Monitor health of instance and databases   (HEALTH_MON) = ON

 SYSADM group name                        (SYSADM_GROUP) = DB2IADM1
 SYSCTRL group name                      (SYSCTRL_GROUP) =
 SYSMAINT group name                    (SYSMAINT_GROUP) =
 SYSMON group name                        (SYSMON_GROUP) =

 Client Userid-Password Plugin          (CLNT_PW_PLUGIN) =
 Client Kerberos Plugin                (CLNT_KRB_PLUGIN) =
 Group Plugin                             (GROUP_PLUGIN) =
 GSS Plugin for Local Authorization    (LOCAL_GSSPLUGIN) =
 Server Plugin Mode                    (SRV_PLUGIN_MODE) = UNFENCED
 Server List of GSS Plugins      (SRVCON_GSSPLUGIN_LIST) =
 Server Userid-Password Plugin        (SRVCON_PW_PLUGIN) =
 Server Connection Authentication          (SRVCON_AUTH) = NOT_SPECIFIED
 Cluster manager                           (CLUSTER_MGR) =

 Database manager authentication        (AUTHENTICATION) = SERVER
 Alternate authentication           (ALTERNATE_AUTH_ENC) = NOT_SPECIFIED
 Cataloging allowed without authority   (CATALOG_NOAUTH) = NO
 Trust all clients                      (TRUST_ALLCLNTS) = YES
 Trusted client authentication          (TRUST_CLNTAUTH) = CLIENT
 Bypass federated authentication            (FED_NOAUTH) = NO

 Default database path                       (DFTDBPATH) = /home/db2inst1

 Database monitor heap size (4KB)          (MON_HEAP_SZ) = AUTOMATIC(90)
 Java Virtual Machine heap size (4KB)     (JAVA_HEAP_SZ) = 2048
 Audit buffer size (4KB)                  (AUDIT_BUF_SZ) = 0
 Size of instance shared memory (4KB)  (INSTANCE_MEMORY) = AUTOMATIC(524288)
 Agent stack size                       (AGENT_STACK_SZ) = 1024
 Sort heap threshold (4KB)                  (SHEAPTHRES) = 0

 Directory cache support                     (DIR_CACHE) = YES

 Application support layer heap size (4KB)   (ASLHEAPSZ) = 15
 Max requester I/O block size (bytes)         (RQRIOBLK) = 32767
 Workload impact by throttled utilities(UTIL_IMPACT_LIM) = 10

 Priority of agents                           (AGENTPRI) = SYSTEM
 Agent pool size                        (NUM_POOLAGENTS) = AUTOMATIC(100)
 Initial number of agents in pool       (NUM_INITAGENTS) = 0
 Max number of coordinating agents     (MAX_COORDAGENTS) = AUTOMATIC(200)
 Max number of client connections      (MAX_CONNECTIONS) = AUTOMATIC(MAX_COORDAG                                                              ENTS)

 Keep fenced process                        (KEEPFENCED) = YES
 Number of pooled fenced processes         (FENCED_POOL) = AUTOMATIC(MAX_COORDAG                                                              ENTS)
 Initial number of fenced processes     (NUM_INITFENCED) = 0

 Index re-creation time and redo index build  (INDEXREC) = RESTART

 Transaction manager database name         (TM_DATABASE) = 1ST_CONN
 Transaction resync interval (sec)     (RESYNC_INTERVAL) = 180

 SPM name                                     (SPM_NAME) =
 SPM log size                          (SPM_LOG_FILE_SZ) = 256
 SPM resync agent limit                 (SPM_MAX_RESYNC) = 20
 SPM log path                             (SPM_LOG_PATH) =

 TCP/IP Service name                          (SVCENAME) = db2c_db2inst1
 Discovery mode                               (DISCOVER) = SEARCH
 Discover server instance                (DISCOVER_INST) = ENABLE

 SSL server keydb file                   (SSL_SVR_KEYDB) =
 SSL server stash file                   (SSL_SVR_STASH) =
 SSL server certificate label            (SSL_SVR_LABEL) =
 SSL service name                         (SSL_SVCENAME) =
 SSL cipher specs                      (SSL_CIPHERSPECS) =
 SSL versions                             (SSL_VERSIONS) =
 SSL client keydb file                  (SSL_CLNT_KEYDB) =
 SSL client stash file                  (SSL_CLNT_STASH) =

 Maximum query degree of parallelism   (MAX_QUERYDEGREE) = ANY
 Enable intra-partition parallelism     (INTRA_PARALLEL) = NO

 No. of int. communication buffers(4KB)(FCM_NUM_BUFFERS) = AUTOMATIC(1024)
 No. of int. communication channels   (FCM_NUM_CHANNELS) = AUTOMATIC(512)
 db2start/db2stop timeout (min)        (START_STOP_TIME) = 10

Usage and other stuff

db create command generated from control center

CREATE DB dbtest AUTOMATIC STORAGE YES ON '/home/db2inst1/databases/dbtest' USING CODESET UTF-8 TERRITORY US ;
UPDATE DB CFG FOR dbtest USING AUTO_MAINT ON;
UPDATE DB CFG FOR dbtest USING AUTO_TBL_MAINT ON;
UPDATE DB CFG FOR dbtest USING AUTO_RUNSTATS ON;
UPDATE ALERT CFG FOR DATABASE ON dbtest USING db.db_backup_req SET THRESHOLDSCHECKED YES;
UPDATE ALERT CFG FOR DATABASE ON dbtest USING db.tb_reorg_req SET THRESHOLDSCHECKED YES;
UPDATE ALERT CFG FOR DATABASE ON dbtest USING db.tb_runstats_req SET THRESHOLDSCHECKED YES;

See db2_creating_database for how this was actually run

More examples

drop database DCQDBTS
CREATE DATABASE DCQDBTS AUTOMATIC STORAGE YES ON '/home/db2inst1' USING CODESET 1252 TERRITORY US
UPDATE DB CFG FOR DCQDBTS USING AUTO_MAINT ON
UPDATE DB CFG FOR DCQDBTS USING AUTO_TBL_MAINT ON
UPDATE DB CFG FOR DCQDBTS USING AUTO_RUNSTATS ON
UPDATE ALERT CFG FOR DATABASE ON DCQDBTS USING db.db_backup_req SET THRESHOLDSCHECKED YES
UPDATE ALERT CFG FOR DATABASE ON DCQDBTS USING db.tb_reorg_req SET THRESHOLDSCHECKED YES
UPDATE ALERT CFG FOR DATABASE ON DCQDBTS USING db.tb_runstats_req SET THRESHOLDSCHECKED YES

drop database DCQDBMA
CREATE DATABASE DCQDBMA AUTOMATIC STORAGE YES ON '/home/db2inst1' USING CODESET 1252 TERRITORY US
UPDATE DB CFG FOR DCQDBMA USING AUTO_MAINT ON
UPDATE DB CFG FOR DCQDBMA USING AUTO_TBL_MAINT ON
UPDATE DB CFG FOR DCQDBMA USING AUTO_RUNSTATS ON
UPDATE ALERT CFG FOR DATABASE ON DCQDBMA USING db.db_backup_req SET THRESHOLDSCHECKED YES
UPDATE ALERT CFG FOR DATABASE ON DCQDBMA USING db.tb_reorg_req SET THRESHOLDSCHECKED YES
UPDATE ALERT CFG FOR DATABASE ON DCQDBMA USING db.tb_runstats_req SET THRESHOLDSCHECKED YES


drop database DCQDBUS
CREATE DATABASE DCQDBUS AUTOMATIC STORAGE YES ON '/home/db2inst1' USING CODESET 1252 TERRITORY US
UPDATE DB CFG FOR DCQDBUS USING AUTO_MAINT ON
UPDATE DB CFG FOR DCQDBUS USING AUTO_TBL_MAINT ON
UPDATE DB CFG FOR DCQDBUS USING AUTO_RUNSTATS ON
UPDATE ALERT CFG FOR DATABASE ON DCQDBUS USING db.db_backup_req SET THRESHOLDSCHECKED YES
UPDATE ALERT CFG FOR DATABASE ON DCQDBUS USING db.tb_reorg_req SET THRESHOLDSCHECKED YES
UPDATE ALERT CFG FOR DATABASE ON DCQDBUS USING db.tb_runstats_req SET THRESHOLDSCHECKED YES