db2 "update monitor switches using lock ON sort ON bufferpool ON uow ON table ON statement ON" http://www.db2look.com 最好的DB2网站 |
db2 "get snapshot for database manager" |
High water mark for agents registered = 7 High water mark for agents waiting for a token = 0 Agents registered= 7 Agents waiting for a token= 0 Idle agents= 5 Agents assigned from pool= 158 Agents created from empty Pool = 7 Agents stolen from another application= 0 High water mark for coordinating agents= 7 Max agents verflow= 0 |
db2 "get snapshot for database on DBNAME" |
Database files closed = 0 |
db2 "update db cfg for DBNAME using MAXFILOP N" |
db2 "get snapshot for tablespaces on DBNAME" |
db2 "list tablespaces show detail" |
db2 "list tablespace containers for N show detail" |
$> db2 "create event monitor SQLCOST for statements write to ..." |
$> db2 "set event monitor SQLCOST state = 1" |
$> db2 "set event monitor SQLCOST state = 0" |
$> db2evmon -db DBNAME -evm SQLCOST > sqltrace.txt |
$> more sqltrace.txt |
db2 "get db cfg for DBNAME" |
Lock timeout (sec) (LOCKTIMEOUT) = -1 |
db2 "update db cfg for DBNAME using LOCKTIMEOUT 15" |
db2 "get snapshot for database on DBNAME" |
Locks held currently= 0 Lock waits= 0 Time database waited on locks (ms)= 0 Lock list memory in use (Bytes)= 576 Deadlocks detected= 0 Lock escalations= 0 Exclusive lock escalations= 0 Agents currently waiting on locks= 0 Lock Timeouts= 0 |
db2 "list tablespaces show detail" |
Tablespace ID= 1 Name= TEMPSPACE1 Type= System managed space Contents= Temporary data State= 0x0000 Detailed explanation: Normal Total pages= 1 Useable pages= 1 Used pages= 1 Free pages= Not applicable High water mark (pages)= Not applicable Page size (bytes)= 4096 Extent size (pages)= 32 Prefetch size (pages)= 96 Number of containers= 3 |
db2 "list tablespace containers for 1 show detail" |
Db2 "get snapshot for database on DBNAME" |
Total sort heap allocated= 0 Total sorts = 1 Total sort time (ms)= 8 Sort verflows = 0 Active sorts = 0 Commit statements attempted = 3 Rollback statements attempted = 0 Let transactions = Commit statements attempted + Rollback statements attempted Let SortsPerTX= Total sorts / transactions Let PercentSortOverflows = Sort overflows * 100 / Total sorts |
db2 "get snapshot for database on DBNAME" |
db2 "get snapshot for tables on DBNAME" |
Snapshot timestamp = 09-25-2000 4:47:09.970811 Database name= DGIDB Database path= /fs/inst1/inst1/NODE0000/SQL00001/ Input database alias= DGIDB Number of accessed tables= 8 Table List Table Schema= INST1 Table Name= DGI_ SALES_ LOGS_TB Table Type= User Rows Written= 0 Rows Read= 98857 verflows= 0 Page Reorgs= 0 |