2007-4-30 14:22
beginner-bj
谁的数据库用了裸设备?
至今没用过裸设备。谁的数据库用了裸设备,能不能贴这个命令的结果出来?
db2pd -tablespace -db <dbname>
2007-4-30 19:35
whiterain
我一直都在用raw
2007-4-30 19:51
beginner-bj
那贴出来啊
2007-5-1 21:04
炸鸡
记得的话,我明天回去做。
2007-5-2 14:48
beginner-bj
忘了?
2007-5-4 10:39
wolfop
db2pd -tablespace -db wolf
Database Partition 0 -- Database WOLF -- Active -- Up 0 days 00:00:05
Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC NumCntrs MaxStripe LastConsecPg Name
0x00000002310DB360 0 SMS Regular 4096 32 Yes 32 1 1 Off 1 0 31 SYSCATSPACE
0x00000002310DDB80 1 DMS SysTmp 4096 32 Yes 32 1 1 Off 1 0 31 TEMPSPACE1
0x00000002310DE3E0 2 DMS Large 4096 32 Yes 32 1 1 Off 1 0 31 USERSPACE1
0x00000002310DEC40 3 DMS Large 4096 4 Yes 4 1 1 Off 1 0 3 SYSTOOLSPACE
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM State MinRecTime NQuiescers
0x00000002310DB360 0 15472 15472 15472 0 0 0 0x00000000 0 0
0x00000002310DDB80 1 256000 255968 64 0 255904 64 0x00000000 0 0
0x00000002310DE3E0 2 512000 511968 1888 0 510080 1888 0x00000000 0 0
0x00000002310DEC40 3 8192 8188 112 0 8076 112 0x00000000 0 0
Tablespace Autoresize Statistics:
Address Id AS AR InitSize IncSize IIP MaxSize LastResize LRF
0x00000002310DB360 0 No No 0 0 No 0 None No
0x00000002310DDB80 1 No No 0 0 No 0 None No
0x00000002310DE3E0 2 No No 0 0 No 0 None No
0x00000002310DEC40 3 No Yes 0 -1 No None None No
Containers:
Address TspId ContainNum Type TotalPgs UseablePgs StripeSet Container
0x00000002310DB9E0 0 0 Path 15472 15472 0 /home/db2inst1/db2inst1/NODE0000/SQL00002/SQLT0000.0
0x00000002310DE260 1 0 Disk 256000 255968 0 /dev/datavg/db2temp01
0x00000002310DEAC0 2 0 Disk 512000 511968 0 /dev/datavg/db2users01
0x00000002310DF320 3 0 File 8192 8188 0 /home/db2inst1/db2inst1/NODE0000/SQL00002/SYSTOOLSPACE
2007-5-4 14:46
beginner-bj
原来是这个样子的,谢谢WOLF
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.