====== DB2 on Ubuntu ======
===== Resources =====
[[https://launchpad.net/ubuntu/hardy/amd64/db2exc/9.7.0-8|db2exc 9.7.0-8 (amd64 binary) in ubuntu hardy]]
[[https://launchpad.net/ubuntu/+source/db2exc/9.7.0-8|db2exc package]]
[[http://www.ubuntu.com/products/whatisubuntu/serveredition/documentation|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 [[tech:db2: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