金融其它数据库
9同行回答
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
-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
Examples:
db2pd -dbpartitionnum 0,1 -db sample -locks
db2pd -dbp 0,1 -database sample -locks app=
db2pd -alldbp -alldbs收起
-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=
Agents
-fcm [hwm] [
FCM Information
-memsets [file=
Memory Sets
-mempools [file=
Memory Pools
-memblocks [[dbms, fcm, fmp, appctl
Memory Blocks
-dbmcfg [file=
DBM Config
-sysplex [db=
Sysplex List
-utilities [file=
Utilities
-fmp
FMP Table
-latches [group] [file=
Latches
-stack all
Produce stack trace for all TIDs in db2sys.exe.
Database scope options:
-applications [[
Applications
-transactions [
Transactions
-bufferpools [
Buffer Pools
-pages [
Bufferpool Pages
-logs [file=
Transaction Logs
-locks [
Locks
-tablespaces [
Tablespaces/Containers
-dynamic [file=
Dynamic Cache
-static [file=
Static Cache
-memsets [file=
Memory Sets
-mempools [file=
Memory Pools
-memblocks [[dbms, fcm, fmp, appctl
Memory Blocks
-dbcfg [file=
Database Config
-catalogcache [file=
Catalog Cache
-tcbstats [all|index] [
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
Examples:
db2pd -dbpartitionnum 0,1 -db sample -locks
db2pd -dbp 0,1 -database sample -locks app=
db2pd -alldbp -alldbs收起
浏览1266
env | grep DB2PDOPT收起
浏览1246