in0de

db2 "export to data.del of del select * from table"
1,"foo","100"
2,"bar","90"
3,"baz","95"

db2 "expor to data.del of del modified by coldel0X09 select * from table"
1        "foo"       "100"
2        "bar"       "90"
3        "baz"      "95"

#// 변수 초기화
export db=${DBNAME}
diagPath=$(db2 get dbm cfg|grep DIAGPATH)
export diagPath=${diagPath#*=}
logfileSZ=$(db2 get db cfg for $db |grep LOGFILSIZ)
export logfileSZ=${logfileSZ#*=}

#// 아카이브 로그 발생량 측정
find $diagPath -name "db2diag.log*" -type f | xargs egrep -p 'Completed archive|Successfully archived' | grep 'LEVEL: Warning' | cut -c 1-10 |
nawk '{occur[$1]++} END {for (dateItem in occur) print dateItem, occur[dateItem] * 4 * '"$logfileSZ"' / 1024}' | sort -n |
nawk '{sum=sum+$2;if ($2>max){max=$2}} END {print "SUM="sum/1024" GB\n""AVG="sum/NR" MB\n""MAX="max" MB"}'

DB21015E  The Command Line Processor backend process request queue or input
queue was not created within the timeout period.

2009-06-02-11.08.57.099023+540 I521662072A395     LEVEL: Error
PID     : 5398782              TID  : 1           PROC : db2
INSTANCE: sample                             NODE : 000
EDUID   : 1
FUNCTION: DB2 UDB, command line process, clp_start_bp, probe:3
MESSAGE : CLP frontend unable to get REQUEST queue handle
DATA #1 : Hexdump, 4 bytes
0x0FFFFFFFFFFFD448 : 870F 0042                                  ...B

2009-05-15-22.46.53.108696+540 I790856A473        LEVEL: Warning
PID     : 1991526              TID  : 1           PROC : db2agent (SAMPLE) 0
INSTANCE: instance             NODE : 000         DB   : SAMPLE
APPHDL  : 0-1823               APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:128
MESSAGE : Estimated size of backup in bytes:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEDB78 : 0000 09DD 446C 9000                        ....Dl..

2009-05-15-22.46.53.110938+540 I791330A470        LEVEL: Warning
PID     : 1991526              TID  : 1           PROC : db2agent (SAMPLE) 0
INSTANCE: instance             NODE : 000         DB   : SAMPLE
APPHDL  : 0-1823               APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:128
MESSAGE : Actual size of backup in bytes:
DATA #1 : Hexdump, 8 bytes
0x0FFFFFFFFFFEDB80 : 0000 09DD D4D4 7000                        ......p.

2009-05-15-22.46.53.111391+540 I791801A355        LEVEL: Warning
PID     : 1991526              TID  : 1           PROC : db2agent (SAMPLE) 0
INSTANCE: instance             NODE : 000         DB   : SAMPLE
APPHDL  : 0-1823               APPID: *LOCAL.dbpainst.090515090122
FUNCTION: DB2 UDB, database utilities, sqlubcka, probe:130
MESSAGE : Backup Complete.

DB2 Engine
db2 Utilities(Backup, load, import 등)
DB2 Governor
DB2 Snapshot functions
DB2 GUI tools / DB2 Wizards
  (ie. Server profile generated from the Control Center, Redistribution Data wizard) 
DB2 Extenders (ie. Text Information Extender)
any application (ie. WebSphere)

Linux의 경우, sqllib/tmp 에 named pipe를 생성하여
frontend(db2), backend(db2bp) 프로세스 간의 통신을 하기도 한다.

mkdir ${better perf disk path}/newTmpPath
rm -rf ${instance home}/sqllib/tmp
ln -s ${better perf disk path}/newTmpPath ${instance home}/sqllib/tmp

59 23 * * * su - ${instance user} -c "db2diag -A ${diagpath}/db2diag.log" > /dev/null 2>&1

ALTER TABLE foo DROP COLUMN C1
ALTER TABLE bar ALTER COLUMN C1 SET DATA TYPE BIGINT

ALTER TABLE bar ALTER COLUMN C1 SET NOT NULL
ADD COLUMN
ALTER COLUMN DEFAULT VALUE
RENAME TABLE
ALTER COLUMN SET DATA TYPE VARCHAR/VARGRAPHIC/CLOB/BLOB/DBCLOB

REORG TABLE
DROP TABLE
ALTER TABLE
RENAME TABLE
TRUNCATE TABLE

db2 "select TABSCHEMA, TABNAME from SYSIBMADM.ADMINTABINFO where REORG_PENDING = 'Y'"

7        The table is in the reorg pending state. This can occur after
         an ALTER TABLE statement containing a REORG-recommended
         operation.

         Reorganize the table using the REORG TABLE command (note that
         INPLACE REORG TABLE is not allowed for a table that is in the
         reorg pending state).

db2 "select tabname, lob_object_pages from table (snap_get_tab('SAMPLE',-1)) as tab"