C:\Documents and Settings\Administrator>db2pd -h
Usage:
-h | -help [file=]
Help
-v | -version [file=]
Version
-osinfo [disk] [file=]
Operating System Information
-dbpartitionnum [,]
Database Partition Number(s)
-alldbpartitionnums
All partition numbers
-database | -db [,]
Database(s)
-alldatabases | -alldbs
All Active Databases
-inst
Instance scope output
-file
All Output to Filename
-command
Read in predefined options
-interactive
Interactive
-full
Expand output to full length
-repeat [num sec] [count]
Repeat every num seconds (default 5) count times
-everything
All options on all database partitions
Instance scope options:
-agents [db=] [[ | [app=]] [file=]
Agents
-fcm [hwm] [] [file=]
FCM Information
-memsets [file=]
Memory Sets
-mempools [file=]
Memory Pools
-memblocks [[dbms, fcm, fmp, appctl , private] | [all]] [top] [blocks] [sort] [PoolID]
Memory Blocks
-dbmcfg [file=]
DBM Config
-sysplex [db=] [file=]
Sysplex List
-utilities [file=]
Utilities
-fmp
FMP Table
-latches [group] [file=]
Latches
*-ha
HA Stats
-edus
List all EDUs in the instance
-dbptnmem
Lists Database Partition Memory statistics
-stack all
Produce stack trace for all TIDs in db2sys.exe.
Database scope options:
-applications [[ | [agent=]] [file=]
Applications
-transactions [ | [app=]] [file=]
Transactions
-bufferpools [] [file=]
Buffer Pools
-pages [] [file=]
Bufferpool Pages
-logs [file=]
Transaction Logs
-locks [] [file=] [showlocks] [wait]
Locks
-tablespaces [] [group] [file=]
Tablespaces/Containers
-dynamic [file=]
Dynamic Cache
-static [file=]
Static Cache
-memsets [file=]
Memory Sets
-mempools [file=]
Memory Pools
-memblocks [[dbms, fcm, fmp, appctl , private] | [all]] [top] [blocks] [sort] [PoolID]
Memory Blocks
-dbcfg [file=]
Database Config
-catalogcache [file=]
Catalog Cache
-tcbstats [all|index] [ []] [file=]
Table Control Block Stats
-reorgs [file=]
Table Reorg Stats
-recovery [file=]
Recovery Status
-reopt [file=]
Reoptimized SQL Statements
-storagepaths
Storage Paths
-hadr [file=]
High Availability Disaster Recovery
-activestatements [file=]
Active Statement List
-workloads [] [group]
Workloads
-serviceclasses []
Service Classes
-workactionsets [] [group]
Work Action Sets
-workclasssets [] [group]
Work Class Sets
-thresholds [] [group]
Thresholds
-statisticscache summary | detail | find schema= bject=
Statistics Cache
Examples:
db2pd -dbpartitionnum 0,1 -db sample -locks
db2pd -dbp 0,1 -database sample -locks app=
db2pd -alldbp -alldbs
C:\Documents and Settings\Administrator>
Usage:
-h | -help [file=]
Help
-v | -version [file=]
Version
-osinfo [disk] [file=]
Operating System Information
-dbpartitionnum [,]
Database Partition Number(s)
-alldbpartitionnums
All partition numbers
-database | -db [,]
Database(s)
-alldatabases | -alldbs
All Active Databases
-inst
Instance scope output
-file
All Output to Filename
-command
Read in predefined options
-interactive
Interactive
-full
Expand output to full length
-repeat [num sec] [count]
Repeat every num seconds (default 5) count times
-everything
All options on all database partitions
Instance scope options:
-agents [db=] [[ | [app=]] [file=]
Agents
-fcm [hwm] [] [file=]
FCM Information
-memsets [file=]
Memory Sets
-mempools [file=]
Memory Pools
-memblocks [[dbms, fcm, fmp, appctl , private] | [all]] [top] [blocks] [sort] [PoolID]
Memory Blocks
-dbmcfg [file=]
DBM Config
-sysplex [db=] [file=]
Sysplex List
-utilities [file=]
Utilities
-fmp
FMP Table
-latches [group] [file=]
Latches
*-ha
HA Stats
-edus
List all EDUs in the instance
-dbptnmem
Lists Database Partition Memory statistics
-stack all
Produce stack trace for all TIDs in db2sys.exe.
Database scope options:
-applications [[ | [agent=]] [file=]
Applications
-transactions [ | [app=]] [file=]
Transactions
-bufferpools [] [file=]
Buffer Pools
-pages [] [file=]
Bufferpool Pages
-logs [file=]
Transaction Logs
-locks [] [file=] [showlocks] [wait]
Locks
-tablespaces [] [group] [file=]
Tablespaces/Containers
-dynamic [file=]
Dynamic Cache
-static [file=]
Static Cache
-memsets [file=]
Memory Sets
-mempools [file=]
Memory Pools
-memblocks [[dbms, fcm, fmp, appctl , private] | [all]] [top] [blocks] [sort] [PoolID]
Memory Blocks
-dbcfg [file=]
Database Config
-catalogcache [file=]
Catalog Cache
-tcbstats [all|index] [ []] [file=]
Table Control Block Stats
-reorgs [file=]
Table Reorg Stats
-recovery [file=]
Recovery Status
-reopt [file=]
Reoptimized SQL Statements
-storagepaths
Storage Paths
-hadr [file=]
High Availability Disaster Recovery
-activestatements [file=]
Active Statement List
-workloads [] [group]
Workloads
-serviceclasses []
Service Classes
-workactionsets [] [group]
Work Action Sets
-workclasssets [] [group]
Work Class Sets
-thresholds [] [group]
Thresholds
-statisticscache summary | detail | find schema= bject=
Statistics Cache
Examples:
db2pd -dbpartitionnum 0,1 -db sample -locks
db2pd -dbp 0,1 -database sample -locks app=
db2pd -alldbp -alldbs
C:\Documents and Settings\Administrator>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11976525/viewspace-676771/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11976525/viewspace-676771/