db2 "create table db2admin.stud ( sid int,sname char(9), contact int) in dms8k0"
db2 "alter table db2admin.stud data capture none locksize row pctfree 50 append off not volatile"
db2 "alter table db2admin.stud pctfree 10"
db2 create summery table db2admin.studmq(sid,sname) as (select sid,sname from db2admin.stud)
data initially deffered refresh immediate enable query optimization in sms8k0
db2 create large tablespace systoolspace in database partition group ibmcatgroup pagesize 8k
managed by automatic storage autoresize yes initialsize 1m maxsize none extentsize 4
prefetchsize automatic bufferpool bp8k0 overhead 7.500000 transferrate 0.060000 no file system
caching dropped table recovery on
db2 "set current isolation level cs" [/rs/rr/ur]
db2 "set current explain mode yes" [/no/explain]
db2exfmt
db2 catalog node nod1 remote <ip> server <port>
db2 catalog db nod at nod1
db2 "select card,npages,fpages,pctfree from syscat.tables where TABNAME='STUD'"
db2 "select data_object_p_size from table(sysproc.admin_get_tab_info('db2admin','stud'))"
db2 "select substr(tabname,1,15) as tabname,status,type from syscat.tables where type = x "
db2 "call get_db_size_info(?,?,?,0)"
CALL SYSPROC.ADMIN_CMD( 'force application ( 41408, 55458 )' )
db2ckbkp -t <backup file>
db2ckrst
db2pd -db nod -dbptnmem
db2pd -db nod -transactions -agents -locks -file nodpdlock.out
|awk '/address/^0x { $2,$8,$9,$10}'
db2top
db2acsutil
db2audtl
db2undgp revoke exe permosion
db2sync
db2systray
No comments:
Post a Comment