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=

ITPub博客

DB2 db2pd 选项

最新文章