Retrieves information from the DB2® database system memory sets.
There is no minimum connection requirement. However, if a database scope option is specified, that database must be active before the command can return the requested information.
>>-db2pd--+------------------------------------------+----------> '- -activestatements--+------------------+-' +-apphdl=appHandle-+ '-file=filename----' >--+----------------------------------------+-------------------> '- -addnode--+-------------+--+--------+-' '-oldviewapps-' '-detail-' >--+----------------+-------------------------------------------> +- -alldatabases-+ '- -alldbs-------' >--+--------------------------------------------------+---------> +- -alldbpartitionnums-----------------------------+ | .-,-------------------------. | | V | | +- -dbpartitionnum----database_partition_number-+--+ | (1) | +------- -global-----------------------------------+ | .-,--------. | | V | | +- -host----hostname-+-----------------------------+ | .-,------------------------------. | | V | | '- -member--+---member_number--|--member_range-+-+-' '-all--------------------------------' >--+---------------------------------------------------------------------------+--> '- -agents--+-------------+--+--------------+--+---------------+--+-------+-' '-db=database-' +-AgentId------+ '-file=filename-' '-event-' '-app=AppHandl-' >--+--------------------------------------------------------+---> | .-all------. .-all-----. | '- -apinfo--+----------+--+---------+--+---------------+-' '-AppHandl-' '-MaxStmt-' '-file=filename-' >--+------------------------------------------------------+-----> '- -applications--+---------------+--+---------------+-' +-AppHandl------+ '-file=filename-' '-agent=AgentId-' >--+--------------------------------------------+---------------> '- -bufferpools--+------+--+---------------+-' '-bpID-' '-file=filename-' >--+-----------------------------------+------------------------> '- -catalogcache--+---------------+-' '-file=filename-' >--+-------------------------------------------------------+----> '- -cfinfo--+---+--+-----+--+-----+--+------+--+------+-' '-#-' '-gbp-' '-sca-' '-lock-' '-list-' >--+-----------------------------+------------------------------> '- -cfpool--+---------------+-' '-file=filename-' >--+-----------------------------------+------------------------> '-+- -cleaner---------------------+-' '- -dirtypages--+-------------+-' +-bp=bpID-----+ +-count=count-+ +-summary-----+ +-temponly----+ '-fixedonly---' >--+------------------------------+-----------------------------> '- -command--+---------------+-' '-file=filename-' >--+----------------------------------+-------------------------> | .-,------------. | | V | | '-+- -database-+----databasename-+-' +- -db-------+ '- -d--------' >--+----------------------------+-------------------------------> '- -dbcfg--+---------------+-' '-file=filename-' >--+-----------------------------+--+------------+--------------> '- -dbmcfg--+---------------+-' '- -dbptnmem-' '-file=filename-' >--+--------------------------------+---------------------------> '- -diagpath--+----------------+-' +-CF--+----+-----+ | '-id-' | '-Member--+----+-' '-id-' >--+-----------------------------------------------------------------------------------------+--> '- -dump--+---------------------------+--+----------------------------------------------+-' +-all--+------------------+-+ '-dumpdir=directory--+-----------------------+-' | '-apphdl=AppHandle-' | '-timeout=timeout-value-' +-apphdl=AppHandle----------+ +-eduid-apphdl=AppHandle----+ '-pid-----------------------' >--+------------------------------+-----------------------------> '- -dynamic--+---------------+-' +-anch=anchID---+ '-file=filename-' >--+------------------------------------------------------+-----> '- -edus--+------------------------------------------+-' '-interval=interval--+-------+--+--------+-' '-top=n-' '-stacks-' >--+-------------------------------------+--+--------------+----> '- -encryptioninfo--+---------------+-' '- -everything-' '-file=filename-' >--+-----------------------------------+------------------------> '-extentmovement--+---------------+-' '-file=filename-' >--+------------------------------------------------+-----------> '- -fcm--+-----+--+---------+--+---------------+-' '-hwm-' '-numApps-' '-file=filename-' >--+------------------+--+-------+--+--------+------------------> '- -file--filename-' '- -fmp-' '- -full-' >--+--------------------------------------------------------------+--> '-+- -fmpexechistory-+--+-------------+--+-----+--+----------+-' '- -fmpe-----------' '-+-pid=pid-+-' '-n=n-' '-genquery-' '-tid=tid-' >--+-----------------------------------------------------+------> '- -fvp--+-agent_eduid-+--+------+--+---------------+-' +-LAM1--------+ '-term-' '-file=filename-' +-LAM2--------+ '-LAM3--------' >--+-------+--+------+--+---------------------------+-----------> '- -gfw-' '- -ha-' '- -hadr--+---------------+-' '-file=filename-' >--+--------+--+--------+---------------------------------------> '- -help-' '- -inst-' >--+-----------------------------------------------------------------------+--> '- -iostat--+-----+--+-----+--+----------+--+-------+--+--------------+-' '- -t-' '- -l-' '- -length-' '-count-' '-COMPUTERNAME-' >--+---------------+--------------------------------------------> '- -interactive-' >--+-----------------------------------------+------------------> '- -latches--+-------+--+---------------+-' '-group-' '-file=filename-' >--+------------------------------------------------------------+--> '- -load--+-----------------+--+---------------+--+--------+-' '-loadID="LOADID"-' '-file=filename-' '-stacks-' >--+------------------------------------------------------------------+--> '- -locks--+---------+--+---------------+--+-----------+--+------+-' '-TranHdl-' '-file=filename-' '-showlocks-' '-wait-' >--+---------------------------+--------------------------------> '- -logs--+---------------+-' '-file=filename-' .-,-----------------. V | >----+---------------+-+--+--------------+----------------------> '- -member--num-' '- -allmembers-' >--+------------------------------------------------------------+--> '-membersubsetstatus--+-------------------+--+-------------+-' '-subsetid=subsetID-' '-db=database-' >--+------------------------------------------------------------------------------------------------+--> | .-,-----------. | | V | | '- -memblocks----+-all-----+-+--+------+--+-----+--+--------+--+------+--+--------+--+---------+-' +-dbms----+ '-skip-' '-top-' '-blocks-' '-sort-' '-PoolID-' '-pid=pid-' +-fcm-----+ +-fmp-----+ +-appl----+ +-db------+ '-private-' >--+-------------------------------+----------------------------> '- -mempools--+---------------+-' '-file=filename-' >--+------------------------------+-----------------------------> '- -memsets--+---------------+-' '-file=filename-' >--+---------------------------------------+--------------------> '- -osinfo--+------+--+---------------+-' '-disk-' '-file=filename-' >--+---------------------------------------------------+--------> '- -pages--+------+--+---------+--+---------------+-' '-bpID-' '-summary-' '-file=filename-' >--+--------+--+---------------+--------------------------------> +- -q----+ '- -quiesceinfo-' +- -quit-+ +-q------+ '-quit---' >--+-------------------------------+----------------------------> '- -recovery--+---------------+-' '-file=filename-' >--+----------------------------+-------------------------------> '- -reopt--+---------------+-' '-file=filename-' >--+----------------------------------------+-------------------> '- -reorgs--+--------------------------+-' '-index--+---------------+-' '-file=filename-' >--+----------------------------------+--+------------+---------> '- -repeat--+---------+--+-------+-' '- -runstats-' '-num sec-' '-count-' >--+------------+-----------------------------------------------> '- -rustatus-' >--+---------------------------------------------------------------------------+--> '--- -scansharing----+----------------------------------------------------+-' '-obj=objectID--pool=poolID--+---------------------+-' +-all-----------------+ '-index=--+-indexID-+-' '-all-----' >--+--------------------------------------------------------+---> '- -serverlist--+-------------------+--+---------------+-' '-subsetid=subsetID-' '-file=filename-' >--+--------------------------------------+---------------------> '- -serviceclasses--+----------------+-' '-serviceclassID-' >--+------------------------------+-----------------------------> '- -sort--+------------------+-' '-apphdl=AppHandle-' >--+---------------------------------------------------------------------------------+--> '- -stack--+-all--------------+--+----------------------------------------------+-' +-apphdl=AppHandle-+ '-dumpdir=directory--+-----------------------+-' '-eduid------------' '-timeout=timeout-value-' >--+-----------------------------+------------------------------> '- -static--+---------------+-' '-file=filename-' >--+-----------------------------------------------------------------------------------------------------+--> '- -statisticscache--+--------------------+--+---------------+--+-----------------------------------+-' +- -db--databasename-+ '-file=filename-' +-summary---------------------------+ '- -alldbs-----------' +-detail----------------------------+ '-find schema=schema--object=object-' >--+-----------------------------------------+------------------> '- -storagegroups--+--------------------+-' '- -storagegroupname-' >--+----------------+-------------------------------------------> '- -storagepaths-' >--+-----------------------------------------------+------------> '- -sysplex--+-------------+--+---------------+-' '-db=database-' '-file=filename-' >--+------------------------------------------------------------------------------------+--> '- -tablespaces--+----------------+--+-------+--+---------------+--+---------------+-' '-Table_space_ID-' '-group-' '-trackmodstate-' '-file=filename-' >--+-------------------------------------------------------------------------------------------------------------+--> '- -tcbstats--+-----------+--+-------+--+------------------------------------------------+--+---------------+-' '-nocatalog-' +-all---+ '-TbspaceID=table_space_ID--+------------------+-' '-file=filename-' '-index-' '-TableID=table_ID-' >--+------------------------+-----------------------------------> '- -temptable--+-------+-' '-reset-' >--+-------------------------------+--+------------+------------> '- -thresholds--+-------------+-' '- -totalmem-' '-thresholdID-' >--+-----------------------------------------------------+------> '- -transactions--+--------------+--+---------------+-' +-TranHdl------+ '-file=filename-' '-app=AppHandl-' >--+--------------------------------+--+-----------+------------> '- -utilities--+---------------+-' '- -version-' '-file=filename-' >--+----------------------------------------------------------------+--> '- -vmstat--+-----+--+----------+--+---------+--+--------------+-' '- -t-' '- -length-' '- -count-' '-COMPUTERNAME-' >--+-----------------------------------------+------------------> '- -wlocks--+--------+--+---------------+-' '-detail-' '-file=filename-' >--+--------------------------------------------------+---------> '- -workactionsets--+-----------------+--+-------+-' '-workactionsetID-' '-group-' >--+------------------------------------------------+-----------> '- -workclasssets--+----------------+--+-------+-' '-workclasssetID-' '-group-' >--+----------------------------------------+------------------>< '- -workloads--+------------+--+-------+-' '-workloadID-' '-group-'
See the -activestatements usage notes.
See Sample output of the db2pd -addnode command.
If an agent ID is specified, information is returned about the agent. If an application ID is specified, information is returned about all the agents that are performing work for the application. Specify this command parameter with the -inst parameter, if you have chosen a database that you want scope output for.
See the agents usage notes.
See Sample output of the db2pd -apinfo command.
create event monitor testit for deadlocks with details history write to file path global
create event monitor testit for deadlocks with details history write to table
The
CREATE EVENT MONITOR statement has additional options, such as the
ability to specify the name of the table space and table into which
data will be written. For details, see the CREATE EVENT MONITOR statement
description. The event monitor with statement history capability affects
all applications and increases the monitor heap usage by the DB2 database manager.See the -apinfo usage notes.
If an application ID is specified, information is returned about that application.
If an agent ID is specified, information is returned about the agent that is working on behalf of the application. See the -applications usage notes.
See Sample output of the db2pd -catalogcache command.
The output for SYSTABLES can have multiple entries for the same table (see DEPT in the output shown previously). Multiple entries correspond to a different version of the statistics for the same table. The usage lock name will be unique among the entries for the same object and soft invalid entries will be marked with an 'S'. See the -catalogcache usage notes.
The cfpool option can be used to monitor command connections and to display Host Channel Adapter (HCA) port mapping information. You can use this information to validate that load balancing between HCA ports is behaving as expected. You can also use this information verify that HCA failover is working as expected (for example, draining connections from an offline connection, or reestablishing connections after the port comes back online).
In addition, information about the cluster interconnect netname of the HCA port to which the XI and lock notification connections are established is included in the output from db2pd when you use the cfpool option.
See Sample output of the -cleaner option.
Specify this option with the -inst command parameter, if you have chosen a database for which you want scope output. See the -dbmcfg usage notes.
See Sample output of the -dirtypages option.
See the -edus usage notes. See also Sample output of the db2pd -edus command.
See the -extentmovement usage notes. See also Sample output of the db2pd -extentmovement command.
See the -fmpexechistory | -fmpe usage notes.
See the -hadr usage notes.
See the -latches usage notes.
Specify a transaction handle to obtain information about the locks that are held by a specific transaction.
Specify with the showlocks command parameter to return detailed information about lock names. For row and block locks on partitioned tables and individual data partitions, showlocks displays the data partition identifier as part of the row with the lock information. . The showlocks parameter displays the table name and schema name of locks.
Specify the wait command parameter to return locks in a wait state and the owners of those locks.
See the -locks usage notes.
This information can also be obtained by running the MON_GET_TRANSACTION_LOG table function.
db2pd -inst -alldbs -memblocks
db2pd -inst -db sample -memblocks
db2pd -db sample -memblocks
db2pd -memblocks
db2pd -memblocks -fmp
See the -memblocks usage notes.
Specify this option with the -inst option to include all the instance-scope information in the returned information. See the -mempools usage notes.
Specify this command parameter with the -inst command parameter to include all the instance-scope information in the returned information. See the -memsets usage notes.
See the -pages usage notes. See also Sample output of the db2pd -pages command.
See the -reorgs usage notes. See also Sample output of the db2pd -reorgs index command.
When the db2pd command with the -repeat parameter is issued on members that are on different hosts, the command is sent from the local host to the remote hosts. The command runs on each remote host until the count value specified is reached. The command runs to completion on one host before it begins on another host.
db2pd -runstats
Table Runstats Information:
Retrieval Time: 08/13/2009 20:38:20
TbspaceID: 2 TableID: 4
Schema: SCHEMA TableName: TABLE
Status: Completed Access: Allow write
Sampling: No Sampling Rate: -
Start Time: 08/13/2009 20:38:16 End Time: 08/13/2009 20:38:17
Total Duration: 00:00:01
Cur Count: 0 Max Count: 0
Index Runstats Information:
Retrieval Time: 08/13/2009 20:38:20
TbspaceID: 2 TableID: 4
Schema: SCHEMA TableName: TABLE
Status: Completed Access: Allow write
Start Time: 08/13/2009 20:38:17 End Time: 08/13/2009 20:38:18
Total Duration: 00:00:01
Prev Index Duration [1]: 00:00:01
Prev Index Duration [2]: -
Prev Index Duration [3]: -
Cur Index Start: 08/13/2009 20:38:18
Cur Index: 2 Max Index: 2 Index ID: 2
Cur Count: 0 Max Count: 0
See Sample output of the db2pd -scansharing command.
Returns information about which members are available for use and the relative load of each of those members.
See the -serverlist usage notes.
See Sample output of the db2pd -serverlist command.
See the -serviceclasses usage notes. See also Sample output of the db2pd -serviceclasses command.
See the -sort usage notes.
Event stack will be output in the following order:
Event flow (recorded event “history”) will be output in the following order:
db2pd -db sample -statisticscache summary
db2pd –statisticscache detail -alldbs
db2pd -db sample -statisticscache find schema=USER1 object=T1
Specify with the Storagegroup ID command parameter to display the information about a specific storage group and its paths.
See the -storagegroups usage notes. See also Sample output of the db2pd -storagegroups command.
See the -storagepaths usage notes. See also Sample output of the db2pd -storagepaths command.
Specify this command parameter with the -inst command parameter, if you have chosen a database for which you want scope output.
See the -sysplex usage notes.
Specify with the group command parameter to display the information about the containers of a table space grouped with the table space.
Specify with the Table_space_ID command parameter to display the information about a specific table space and its containers.
Specify with the trackmodstate command parameter to display the state of a table space with respect to the last or next backup. This parameter requires the trackmod configuration parameter to be set to Yes.
See the -tablespaces usage notes. See also Sample output of the db2pd -tablespaces command.
See the -tcbstats usage notes.
See the -temptable usage notes. See also Sample output of the db2pd -temptable command.
See the -thresholds usage notes. See Sample output of the db2pd -thresholds command.
See the -utilities usage notes.
See Sample output of the db2pd -workclasssets command. See the -workclasssets usage notes.
See Sample output of the db2pd -workloads command.
db2pd -agents
export DB2PDOPT="-agents"
db2pd
echo "-agents" > file.out
db2pd -command file.out
db2pd -inst -alldbs
db2pd -db sample -fvp lam1
The resulting output is as follows:
-------------------------------------------------------------------------
Fenced Vendor Process State Information:
-------------------------------------------------------------------------
Log Manager:
-------------------------------------------------------------------------
LOGARCHMETH1 available.
Vendor EDU is available and running.
startTime: 1155581841 20060814145721
function: sqluvint
This tells you that the fenced vendor process is running in the vendor function sqluvint since August 14, 2006 14:57. Now, if you feel that this has been running too long, or you have determined that this process has hung waiting for TSM resources, you can terminate the fenced vendor process by issuing:
db2pd -db sample -fvp lam1 term
The resulting output is as follows:
-------------------------------------------------------------------------
Fenced Vendor Process State Information:
-------------------------------------------------------------------------
Log Manager:
-------------------------------------------------------------------------
LOGARCHMETH1 available.
Vendor EDU is available and running.
startTime: 1155581841 20060814145721
function: sqluvint
This fenced vendor process has been sent a signal to terminate.
This shows you the same information as the previous output, but also lets you know that the terminate request has been sent. After waiting a few moments, you should notice that the request has taken affect.
-------------------------------------------------------------------------
Fenced Vendor Process State Information:
-------------------------------------------------------------------------
Log Manager:
-------------------------------------------------------------------------
LOGARCHMETH1 available.
Vendor EDU is available and running.
No vendor code being run.
db2pd -db sample -fvp 149
The resulting output is as follows:
-------------------------------------------------------------------------
Fenced Vendor Process State Information:
-------------------------------------------------------------------------
Backup:
-------------------------------------------------------------------------
Media Controller(s):
-------------------------------------------------------------------------
EDU ID: 504
mediaSession: 1
mediaSeqNum: 0
Vendor EDU is available and running.
startTime: 1155583315 20060814152155
function: sqluvint
EDU ID: 505
mediaSession: 2
mediaSeqNum: 0
Vendor EDU is available and running.
No vendor code being run.
This says that DB2 Media Controller 0 (EDU ID: 504) is in vendor code, while DB2 Media Controller 1 (EDU ID: 505) has a fenced vendor process, but is not running vendor code. Now, if you feel that this has been running too long, or you have determined that this process has hung waiting for TSM resources, you can terminate the fenced vendor process by issuing:
db2pd -db sample -fvp 149 term
The resulting output is as follows:
-------------------------------------------------------------------------
Fenced Vendor Process State Information:
-------------------------------------------------------------------------
Backup:
-------------------------------------------------------------------------
Media Controller(s):
-------------------------------------------------------------------------
EDU ID: 504
mediaSession: 1
mediaSeqNum: 0
Vendor EDU is available and running.
startTime: 1155583315 20060814152155
function: sqluvint
This fenced vendor process has been sent a signal to terminate.
EDU ID: 505
mediaSession: 2
mediaSeqNum: 0
Vendor EDU is available and running.
No vendor code being run.
This fenced vendor process has been sent a signal to terminate.
This tells you the same information as the previous output, but notes that both fenced vendor processes have been sent terminate requests and will be terminated shortly.
Event description | EVENT_STATE value | EVENT_TYPE value | EVENT_OBJECT value | EVENT_OBJECT_NAME value |
---|---|---|---|---|
Acquire lock | IDLE | ACQUIRE | LOCK | Lock name |
Escalate lock | EXECUTING | PROCESS | LOCK_ESCALATION | NULL |
Process request | EXECUTING | PROCESS | REQUEST | NULL |
Wait for a new request | IDLE | WAIT | REQUEST | NULL |
Wait for a request to be processed at a remote partition | IDLE | WAIT | REMOTE_REQUEST | NULL |
Wait on a WLM threshold queue | IDLE | WAIT | WLM_QUEUE | Threshold name |
Process a routine | EXECUTING | PROCESS | ROUTINE | NULL |
Re-create an index | EXECUTING | PROCESS | INDEX_RECREATE | NULL |
Build compression dictionary | EXECUTING | PROCESS | COMP_DICT_BLD | NULL |
Implicit rebind | EXECUTING | PROCESS | IMPLICIT_REBIND | NULL |
See Sample output of the db2pd -catalogcache command.
For the -dbcfg parameter, the current values of the database configuration parameters are returned.
For the -dbmcfg parameter, current values of the database manager configuration parameters including the current effective code level (CECL) and current effective architecture level (CEAL) are returned.
See Sample output of the db2pd -edus command.
See Sample output of the db2pd -extentmovement command.
See Sample output of the db2pd -fmpexechistory command.
In a DB2 pureScale environment, the command returns HADR information about log streams being processed by the local member. On a standby, if the command is issued on the replay member, it returns HADR information about all log streams, otherwise, it returns a message indicating that the database is not active on that member and no HADR information. If you use the -allmembers option, it returns the concatenated output from all members. This is one way to tell which member is the replay member. The other way is to look at STANDBY_MEMBER field from primary's monitoring output. If it's issued from a member on the primary, the command returns information about the stream owned by the member and all streams being assisted by the member. To see all of the streams in the cluster, issue the command with the -allmembers option.
Only information relevant to the current settings is shown, so for example if reads on standby is not enabled, information about the replay-only window is not shown.
The length of time, in seconds, that the logger has been waiting on an HADR log shipping request. A value of 0 is returned if the logger is not waiting. When the wait time reaches the value that is returned in the PEER_WAIT_LIMIT field, HADR breaks out of peer state to unblock the primary database.
The average time, in seconds, for each log flush.
The accumulated time, in seconds, that the logger has spent waiting for HADR to ship logs.
The total count of HADR wait events in the logger. The count is incremented every time the logger initiates a wait on HADR log shipping, even if the wait returns immediately. As a result, this count is effectively the number of log flushes while the databases are in peer state.
See Sample output of the db2pd -logs command.
For the -memblocks parameter, there are three sections of output: individual blocks for the memory set, sorted totals grouped by memory pool, and sorted totals for the memory set:
Memory blocks:
Sorted totals reported for each memory pool:
Sorted totals reported for each memory set:
For the -pages parameter, the following information is returned for each page:
See Sample output of the db2pd -pages command.
See Sample output of the db2pd -reorgs index command.
See Sample output of the db2pd -scansharing command.
For the -serviceclasses parameter, the following fields are returned, specific to the headings:
See Sample output of the db2pd -serviceclasses command.
Additional information that can help IBM® Support to analyze and troubleshoot problems might also be returned.
For additional details about the returned information using the -statisticscache command parameter, see the topic "Catalog statistics tables".
Both the -storagegroups parameter and the -storagepaths parameter return the following information:
See Sample output of the dp2pd -storagegroups command and db2pd -storagepaths command.
For the -tablespaces parameter, the output is organized into four segments:
For SMS table spaces, this value reflects the number of pages in the filesystem owned by the table space.
For SMS table spaces, this value reflects the number of pages in the filesystem owned by the table space.
For SMS table spaces, this value reflects the number of pages in the filesystem owned by the table space.
For SMS table spaces, this value is always 0.
Table space Storage Statistics:
See Sample output of the db2pd -tablespaces command.
% Compression = ( Total Bytes Saved ) /
( Total Bytes Saved + Total Stored Temp Bytes )
hotel26:/home/billyp> db2pd -db billdb –temptable
System Temp Table Stats:
Number of Temp Tables : 0
Comp Eligible Temps : 0
Compressed Temps : 0
Total Temp Bytes : 0
Total Bytes Saved : 0
Total Compressed Rows : 0
Total Temp Table Rows: : 0
User Temp Table Stats:
Number of Temp Tables : 0
Comp Eligible Temps : 0
Compressed Temps : 0
Total Stored Temp Bytes : 0
Total Bytes Saved : 0
Total Compressed Rows : 0
Total Temp Table Rows : 0
hotel26:/home/billyp> db2pd -db bill -temptable reset
Resetting counters to 0.
See Sample output of the db2pd -temptable command.
For the -thresholds parameter, the following information is returned:
If the threshold is a queuing threshold, the queue section will also show:
See Sample output of the db2pd -transactions command.
See Sample output of the db2pd -wlocks command.
For the -workactionsets parameter, the following information is returned:
For the -workclasssets parameter, the following information is returned:
For the -workloads parameter, the following information is returned, specific to the headings:
See Sample output of the db2pd -workloads command.
-------------------------------------------------------------------------
Summary of add partition processing done for partition[50]
-------------------------------------------------------------------------
00:Creating database partitions : True
01:Database partitions are created : True
08:Collecting storage information : True
09:Storage information is collected : True
11:FCM Send & Receive daemons are blocked : True
12:FCM Send & Receive daemons are reactivated : True
13:db2start processing is complete : True
Conflicting states or activities for add partition for partition[50]
-------------------------------------------------------------------------
[14] Messages found for partition [50]
-------------------------------------------------------------------------
[Fri Oct 24 16:16:27 2008]:Addnode agent:Got automatic storage details
[Fri Oct 24 16:16:28 2008]:Addnode agent:Skeleton datbase is created
[Fri Oct 24 16:16:28 2008]:Addnode agent:Scanning for db alias=[PE ] name=[PE ]
[Fri Oct 24 16:16:28 2008]:Addnode agent:Found db alias=[PE ] name=[PE ]
[Fri Oct 24 16:16:28 2008]:Addnode agent:Instance directory already exists
[Fri Oct 24 16:16:28 2008]:Addnode agent:Node directory already exists
[Fri Oct 24 16:16:28 2008]:Addnode agent:Node directory is created
[Fri Oct 24 16:16:29 2008]:Addnode agent:Getting automatic storage details
[Fri Oct 24 16:16:29 2008]:Addnode agent:Got automatic storage details
[Fri Oct 24 16:16:30 2008]:Addnode agent:Skeleton datbase is created
[Fri Oct 24 16:16:30 2008]:Addnode agent:Database activation is not required
[Fri Oct 24 16:16:30 2008]:Addnode agent:Database activation is complete
[Fri Oct 24 16:16:30 2008]:Addnode agent:Online mode processing is complete
[Fri Oct 24 16:16:30 2008]:db2start is complete
-------------------------------------------------------------------------
Summary of add partition processing done for partition[0]
-------------------------------------------------------------------------
Conflicting states or activities for add partition for partition[0]
-------------------------------------------------------------------------
Applications with old view of instance for partition [0]
-------------------------------------------------------------------------
App.Handle(00000000,00000072) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000065) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000071) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000005) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000051) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000070) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000069) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000068) view has [3] nodes, instance has [4] nodes
App.Handle(00000001,00000058) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000067) view has [3] nodes, instance has [4] nodes
App.Handle(00000000,00000073) view has [3] nodes, instance has [4] nodes
-------------------------------------------------------------------------
Add partition processing with detail for partition[50]
-------------------------------------------------------------------------
00:Creating database partitions : True
01:Database partitions are created : True
02:Dropping database entries : False
03:Dropping db entries are completed : False
04:Activating databases explicitly : False
05:Database explicit activation is completed : False
06:Updating database configuration : False
07:Database configuration is updated : False
08:Collecting storage information : True
09:Storage information is collected : True
10:Add partition operation is complete : False
11:FCM Send & Receive daemons are blocked : True
12:FCM Send & Receive daemons are reactivated : True
13:db2start processing is complete : True
Conflicting states or activities for add partition for partition[50]
-------------------------------------------------------------------------
restricted :False
db2start :False
db2stop :False
instance quiesced :False
database quiesced :False
quiesce instance :False
unquiesce instance :False
quiesce db :False
unquiesce db :False
activate db :False
deactivate db :False
exclusive use of db :False
create db :False
drop db :False
create tablespace :False
alter tablespace :False
drop tablespace :False
add partition :False
backup database :False
restore database :False
snapshot restore :False
[14] Messages found for partition [50]
-------------------------------------------------------------------------
[Fri Oct 24 16:16:27 2008]:Addnode agent:Got automatic storage details
[Fri Oct 24 16:16:28 2008]:Addnode agent:Skeleton datbase is created
[Fri Oct 24 16:16:28 2008]:Addnode agent:Scanning for db alias=[PE ] name=[PE ]
[Fri Oct 24 16:16:28 2008]:Addnode agent:Found db alias=[PE ] name=[PE ]
[Fri Oct 24 16:16:28 2008]:Addnode agent:Instance directory already exists
[Fri Oct 24 16:16:28 2008]:Addnode agent:Node directory already exists
[Fri Oct 24 16:16:28 2008]:Addnode agent:Node directory is created
[Fri Oct 24 16:16:29 2008]:Addnode agent:Getting automatic storage details
[Fri Oct 24 16:16:29 2008]:Addnode agent:Got automatic storage details
[Fri Oct 24 16:16:30 2008]:Addnode agent:Skeleton datbase is created
[Fri Oct 24 16:16:30 2008]:Addnode agent:Database activation is not required
[Fri Oct 24 16:16:30 2008]:Addnode agent:Database activation is complete
[Fri Oct 24 16:16:30 2008]:Addnode agent:Online mode processing is complete
[Fri Oct 24 16:16:30 2008]:db2start is complete
Total [00] Conflicting application handles for partition [50]
-------------------------------------------------------------------------
Total [01] Conflicting application handles for partition [20]
-------------------------------------------------------------------------
Agents for app_handle 00000000 00000052 : Activity occurrence:[1] time(s) ActivityName:[exclusive use of db]
-------------------------------------------------------------------------
Add partition processing with detail for partition[0]
-------------------------------------------------------------------------
00:Creating database partitions : False
01:Database partitions are created : False
02:Dropping database entries : False
03:Dropping db entries are completed : False
04:Activating databases explicitly : False
05:Database explicit activation is completed : False
06:Updating database configuration : False
07:Database configuration is updated : False
08:Collecting storage information : False
09:Storage information is collected : False
10:Add partition operation is complete : False
11:FCM Send & Receive daemons are blocked : False
12:FCM Send & Receive daemons are reactivated : False
13:db2start processing is complete : False
Conflicting states or activities for add partition for partition[0]
-------------------------------------------------------------------------
restricted :False
db2start :False
db2stop :False
instance quiesced :False
database quiesced :False
quiesce instance :False
unquiesce instance :False
quiesce db :False
unquiesce db :False
activate db :False
deactivate db :False
exclusive use of db :False
create db :False
drop db :False
create tablespace :False
alter tablespace :False
drop tablespace :False
add partition :False
backup database :False
restore database :False
snapshot restore :False
create/alter nodegroup :False
drop nodegroup :False
add storage :False
redistribute :False
Total [00] Conflicting application handles for partition [0]
-------------------------------------------------------------------------
Applications with old view of instance for partition [0]
-------------------------------------------------------------------------
App.Handle(00000000,00000072) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000065) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000071) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000005) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000051) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000070) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000069) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000068) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000001,00000058) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000067) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
App.Handle(00000000,00000073) view has [3] nodes, instance has[4] nodes
[Viewnodes:0:1:2:]
$ db2pd -apinfo AppHdl -db sample
Database Member 0 -- Database SAMPLE -- Active -- Up 0 days 00:01:07 -- Date 2012-11-21-21.16.35.182584
snapapp Time: 11/21/2012 21:16:35
Application :
Address : 0x0000000206490080
AppHandl [nod-index] : 7 [000-00007]
TranHdl : 3
Application PID : 23044
Application Node Name : hotel49
IP Address: n/a
Connection Start Time : (1353550528)Wed Nov 21 21:15:28 2012
Client User ID : juntang
System Auth ID : JUNTANG
Coordinator EDU ID : 18
Coordinator Member : 0
Number of Agents : 1
Locks timeout value : NotSet
Locks Escalation : No
Workload ID : 1
Workload Occurrence ID : 1
Trusted Context : n/a
Connection Trust Type : non trusted
Role Inherited : n/a
Application Status : UOW-Waiting
Application Name : db2bp
Application ID : *LOCAL.juntang.121122021528
ClientUserID : n/a
ClientWrkstnName : n/a
ClientApplName : n/a
ClientAccntng : n/a
CollectActData: N
CollectActPartition: C
SectionActuals: N
UOW start time : 11/21/2012 21:15:57.181341
UOW stop time : 11/21/2012 21:15:30.354421
Last executed statements :
Package cache ID : 0x0000027500000001
Anchor ID : 629
Statement UID : 1
SQL Type : Dynamic
Statement Type : DML, Select(blockable)
Statement : select * from org
List of current activities :
Activity ID : 2
UOW-ID : 2
Package schema : NULLID
Package name : SQLC2K24
Package Version :
Consistency Token : AAAAAJHc
Section number : 1
Statement number : 1
Isolation : CS
Effective degree : 0
Number of subagent(s) : 1
Sourece ID : 0
Cursor ID : 0
Nesting level : 0
Invocation ID : 0
Package cache ID : 0x0000034300000001
Anchor ID : 835
Statement UID : 1
SQL Type : Dynamic
Statement Type : DML, Select (blockable)
Statement : select * from employee
Entry time : 11/21/2012 21:16:07.179827
Local start time : 11/21/2012 21:16:07.179830
Last reference time : 11/21/2012 21:16:07.179827
List of past activities of current UOW :
Activity ID : 3
UOW-ID : 2
Package schema : NULLID
Package name : SQLC2K24
Package Version :
Consistency Token : AAAAAJHc
Section number : 201
Statement number : 1
Isolation : CS
Effective degree : 0
Number of subagent(s) : 1
Sourece ID : 0
Cursor ID : 0
Nesting level : 0
Invocation ID : 0
Package cache ID : 0x0000027500000001
Anchor ID : 629
Statement UID : 1
SQL Type : Dynamic
Statement Type : DML, Select (blockable)
Statement : select * from org
Entry time : 11/21/2012 21:16:19.068520
Local start time : 11/21/2012 21:16:19.068523
Last reference time : 11/21/2012 21:16:19.069663
Activity ID : 1
UOW-ID : 2
Package schema : NULLID
Package name : SQLC2K24
Package Version :
Consistency Token : AAAAAJHc
Section number : 201
Statement number : 1
Isolation : CS
Effective degree : 0
Number of subagent(s) : 1
Sourece ID : 0
Cursor ID : 0
Nesting level : 0
Invocation ID : 0
Package cache ID : 0x0000030100000001
Anchor ID : 769
Statement UID : 1
SQL Type : Dynamic
Statement Type : DML, Select (blockable)
Statement : select * from dept
Entry time : 11/21/2012 21:15:57.270305
Local start time : 11/21/2012 21:15:57.270309
Last reference time : 11/21/2012 21:15:57.272555
Catalog Cache:
Configured Size 819200
Current Size 537464
Maximum Size 4294901760
High Water Mark 589824
SYSTABLES:
Address Schema Name Type TableID TbspaceID LastRefID CatalogCacheLoadingLock CatalogCacheUsageLock Sts
0x00002B3AD9CB5C40 SYSCAT TABLESPACES V 0 0 165 010000003A2B0000405CCBD9C3 000005000C110000405CCBD9C3 V
0x00002B3AD9E97680 DBUSER1 SALES T 16 2 164 010000003A2B00008076E9D9C3 000005000E1B00008076E9D9C3 S
0x00002B3AD9E5F920 DBUSER1 VSTAFAC2 V 0 0 164 010000003A2B000020F9E5D9C3 00000500001D000020F9E5D9C3 V
0x00002B3AD9BEDD60 DBUSER1 PRODUCT T 4 4 164 010000003A2B000060DDBED9C3 00000500061D000060DDBED9C3 S
0x00002B3AD9E62920 SYSIBM SYSPERIODS T 164 0 164 010000003A2B00002029E6D9C3 00000500050800002129E6D9C3 V
0x00002B3AD9E6E1A0 DBUSER1 EMP_PHOTO T 7 2 164 010000003A2B0000A0E1E6D9C3 00000500021B0000A0E1E6D9C3 V
0x00002B3AD9E5A500 SYSPUBLI HMON_COLLECTION 0 0 0 164 010000003A2B000000A5E5D9C3 00000000000000000000000000 I
0x00002B3AD9E11C60 SYSIBM SYSTABLES T 5 0 164 010000003A2B0000601CE1D9C3 0000050004000000611CE1D9C3 V
0x00002B3AD9E6D060 DBUSER1 EMP_RESUME T 8 2 164 010000003A2B000060D0E6D9C3 00000500031B000060D0E6D9C3 V
0x00002B3AD9CB56A0 SYSTOOLS POLICY T 4 5 164 010000003A2B0000A056CBD9C3 000005000D1D0000A056CBD9C3 V
0x00002B3AD9E66C60 DBUSER1 EMPLOYEE T 6 2 164 010000003A2B0000606CE6D9C3 00000500001B0000606CE6D9C3 S
0x00002B3AD9CBE600 SYSCAT TABLES V 0 0 164 010000003A2B000000E6CBD9C3 000005000B11000000E6CBD9C3 V
0x00002B3AD9E642E0 DBUSER1 EMPPROJACT T 11 2 164 010000003A2B0000E042E6D9C3 00000500071B0000E042E6D9C3 S
0x00002B3AD9DA26A0 DBUSER1 CUSTOMER T 6 4 164 010000003A2B0000A026DAD9C3 00000500081D0000A026DAD9C3 S
0x00002B3AD9E996E0 DBUSER1 ACT T 12 2 164 010000003A2B0000E096E9D9C3 000005000A1B0000E196E9D9C3 V
TABLESPACES:
Address Name TbspaceID LastRefID CatalogCacheLoadingLock CatalogCacheUsageLock Sts
0x00002B3AD9BED6C0 SYSCATSPACE 0 164 110000003A2B0000C0D6BED9C3 0000210004000000C0D6BED9C3 V
0x00002B3AD9BE3080 TEMPSPACE1 1 31 110000003A2B00008030BED9C3 00002100050000008030BED9C3 V
0x00002B3AD9BF2F00 USERSPACE1 2 164 110000003A2B0000002FBFD9C3 0000210006000000002FBFD9C3 V
0x00002B3AD9E62EC0 IBMDB2SAMPLEXML 4 164 110000003A2B0000C02EE6D9C3 0000210008000000C02EE6D9C3 V
0x00002B3AD9BF2E00 SYSTOOLSPACE 5 164 110000003A2B0000002EBFD9C3 0000210009000000002EBFD9C3 V
db2pd -db sample -cleaner
Database Partition 0 - Database SAMPLE - Active - Up 0 days 00:06:34 -
Date 08/09/2010 14:17:58
Page Cleaners:
Group ID Clnr Idx State Cycle Task Pgs Gthr Pgs Ga'd IO outstnd Max AIO Pgs Thrsh Pgs D Stl Pgs Skppd
-1 0 Wait 0 None 0 0 0 32 0 0 0
-1 1 Wait 0 None 0 0 0 32 0 0 0
-1 2 Wait 0 None 0 0 0 32 0 0 0
-1 3 Wait 0 None 0 0 0 32 0 0 0
-1 4 Wait 0 None 0 0 0 32 0 0 0
...
Dirty lists for Bufferpool ID : 1
List ID # Dirty Clnr Idx Trigger Target LSN Pgs for Gap
0 4 0 None 0000000000000000 0
0 0 0 None 0000000000000000 0
1 8 1 None 0000000000000000 0
1 0 1 None 0000000000000000 0
2 2 2 None 0000000000000000 0
2 0 2 None 0000000000000000 0
3 1 3 None 0000000000000000 0
db2pd -db sample -dirtypages
Database Partition 0 -- Database SAMPLE -- Active -- Up 0 days 00:00:20 --
Date 08/09/2010 14:11:44
Bufferpool: 1
Dirty pages % : 34 / 1000 (3.40% dirty)
Bufferpool minbuflsn: 000000000138800C
Oldest page info:
DirtyLst TspID PPNum ObjID OPNum Typ UFlag fixcount wgt CPC LSN pgLtch
n/a 0 327 15 3 4 3 0 2 0 000000000138800C 0x07000000323508E8
Dirty pages:
DirtyLst TspID PPNum ObjID OPNum Typ UFlag fixcount wgt CPC LSN pgLtch
0 0 272 14 0 0 3 0 2 0 000000000138881C 0x070000003236C2E8 hX:0 sH:0 xW:0 rC:0
0 0 273 14 1 0 3 0 1 0 000000000138881C 0x070000003236B228 hX:0 sH:0 xW:0 rC:0
0 0 7541 18 9 1 3 0 2 0 000000000138E237 0x07000000323678A8 hX:0 sH:0 xW:0 rC:0
0 0 7540 18 8 1 3 0 2 0 000000000138E402 0x0700000032367A28 hX:0 sH:0 xW:0 rC:0
1 0 6945 15 5 1 3 0 2 0 0000000001388107 0x070000003236F3E8 hX:0 sH:0 xW:0 rC:0
1 0 300 14 4 1 3 0 2 0 000000000138889D 0x070000003236B6A8 hX:0 sH:0 xW:0 rC:0
...
Recovery information:
lowtranlsn : 000000000138E486
minbuflsn : 000000000138800C
nextlsn : 000000000138E4B0
LFH lowtranlsn : 000000000138E486
LFH minbuflsn : 000000000138800C
LFH nextlsn : 000000000138800C
Active Log bytes in use : 25764
Current Softmax : 4096000
DirtyLst - dirty list ID in this bufferpool
TspID - tablespace ID of this page
PPNum - pool page number
ObjID - object ID
OPNum - object page number
Typ - type of the object
UFlag - internal page flag
fixcount - number of active fixes on this page (in-use count)
wgt - weight of the page
CPC - clock
LSN - page LSN
pgLtch - page latch address, hX - held X, sH - # shard holders, xW - # of
X waiters
Database Partition 0 -- Active -- Up 0 days 01:14:05
List of all EDUs for database partition 0
db2sysc PID: 18485
db2wdog PID: 18483
db2acd PID: 18504
EDU ID TID Kernel TID EDU Name USR SYS
====================================================================================================
24 47155322546496 12108 db2pfchr (TESTDB) 0.010000 0.000000
23 47155326740800 12107 db2pclnr (TESTDB) 0.000000 0.000000
22 47155330935104 12106 db2pclnr (TESTDB) 0.000000 0.000000
21 47155335129408 12105 db2pclnr (TESTDB) 0.000000 0.000000
20 47155339323712 12104 db2dlock (TESTDB) 0.000000 0.000000
19 47155343518016 12103 db2lfr (TESTDB) 0.000000 0.000000
18 47155347712320 12102 db2loggw (TESTDB) 0.000000 0.000000
17 47155351906624 12101 db2loggr (TESTDB) 0.080000 0.000000
16 47155356100928 27704 db2agent (TESTDB) (suspended) 0.930000 0.140000
15 47155360295232 18502 db2resync 0.080000 0.000000
14 47155364489536 18500 db2ipccm 0.030000 0.000000
13 47155368683840 18499 db2licc 0.000000 0.000000
12 47155372878144 18498 db2thcln 0.000000 0.000000
11 47155377072448 18497 db2alarm 0.000000 0.000000
1 47155117025600 18493 db2sysc 3.340000 0.070000
... USR DELTA SYS DELTA
... ===============================
... 0.141799 0.045431
... 0.101154 0.045117
... 0.038113 0.020154
... 0.005668 0.007978
... 0.005139 0.004392
... 0.005003 0.004105
... 0.003913 0.004100
... 0.001785 0.001282
... 0.001083 0.001550
... 0.001005 0.000433
... 0.000181 0.000098
... 0.000095 0.000091
... 0.000000 0.000000
... 0.000000 0.000000
... 0.000000 0.000000
db2pd -db testdb -encryptioninfo
Database Member 0 -- Database TESTDB -- Active -- Up 0 days 00:00:16 -- Date 2014-10-03-13.14.20.282623
Encryption Info:
Object Name: TESTDB
Object Type: DATABASE
Encyrption Key Info:
Encryption Algorithm: AES
Encryption Algorithm Mode: CBC
Encryption Key Length: 256
Master Key Label: DB2_SYSGEN_geoffrey_TESTDB_2014-10-01-10.05.01
Master Key Rotation Timestamp: 2014-10-01-10.05.03.000000
Master Key Rotation Appl ID: *LOCAL.geoffrey.141001140444
Master Key Rotation Auth ID: GEOFFREY
Previous Master Key Label: DB2_SYSGEN_geoffrey_TESTDB_2014-10-01-10.05.01
KeyStore Info:
KeyStore Type: PKCS12
KeyStore Location: /home/geoffrey/sqllib/keystore.p12
KeyStore Host Name: hotel85.torolab.ibm.com
KeyStore IP Address: 9.26.120.161
KeyStore IP Address Type: IPV4
db2pd -extentmovement -db PDTEST
Database Member 0 -- Database PDTEST -- Active -- Up 0 days 00:04:33 -- Date 2012-10-26-11.19.52.056414
Extent Movement:
Address TbspName Current Last Moved Left TotalTime
0x00002AAB356D4BA0 DAVID 1168 1169 33 426 329636
db2pd -fmpexechistory pid=761872 n=10
Database Partition 0 -- Active -- Up 0 days 00:00:11
FMP Process:
FmpPid Bit Flags ActiveThrd PooledThrd ForcedThrd Active
761872 64 0x00000002 2 1 1 YES
Active Threads:
EduPid: 123456 ThreadId: 987654
RoutineID Timestamp
1 2009-05-06-17.12.30.000000
2 2009-05-06-17.12.30.005000
1 2009-05-06-17.12.30.100000
EduPid: 234567 ThreadId: 987000
RoutineID Timestamp
1 2009-05-06-17.12.31.000000
3 2009-05-06-17.12.30.000000
Pooled Threads:
ThreadId: 540021
RoutineID Timestamp
4 2009-05-06-17.10.30.000000
Forced Threads:
ThreadId: 120021
RoutineID Timestamp
10 2009-05-06-15.10.30.000000
db2pd -fmpExecHistory pid=761872 n=10 genquery
Database Partition 0 -- Active -- Up 0 days 00:00:11
WITH RTNHIST ( PID, TID, RTNID, RTNTIME) AS
( VALUES (761872, 987654, 1, TIMESTAMP('2009-07-13-16.17.10.818705')),
(761872, 987654, 2, TIMESTAMP('2009-07-13-16.17.11.818710')),... )
SELECT R.PID, R.TID, R.RTNTIME, ROUTINESCHEMA, ROUTINEMUDULENAME, ROUTINENAME, SPECIFICNAME, ROUTINEID
FROM syscat.routines, RTNHIST as R
WHERE ROUTINEID = R.RTNID
ORDER BY R.PID, R.TID, R.RTNTIME ;
The following example is a sample of the output of the db2pd -iostat command:
D:\>db2pd -iostat t l 2 5
Disk: queue %disk tps KBpsR KBpsW ms/R ms/W 12:31:59
HarddiskVolume1 0 100.00 0.00 0 0 0.00 0.00
C: 0 100.00 0.00 0 0 0.00 0.00
D: 0 100.00 0.00 0 0 0.00 0.00
_Total 0 100.00 0.00 0 0 0.00 0.00
Disk: queue %disk tps KBpsR KBpsW ms/R ms/W 12:32:01
HarddiskVolume1 0 0.00 0.00 0 0 0.00 0.00
C: 0 0.00 0.49 0 29 0.00 0.90
D: 0 0.00 0.00 0 0 0.00 0.00
_Total 0 0.00 0.49 0 29 0.00 0.90
Disk: queue %disk tps KBpsR KBpsW ms/R ms/W 12:32:03
HarddiskVolume1 0 0.00 0.00 0 0 0.00 0.00
C: 0 0.00 1.47 0 10 0.00 0.50
D: 0 0.00 0.00 0 0 0.00 0.00
_Total 0 0.00 1.47 0 10 0.00 0.50
Disk: queue %disk tps KBpsR KBpsW ms/R ms/W 12:32:05
HarddiskVolume1 0 0.00 0.00 0 0 0.00 0.00
C: 0 0.00 0.00 0 0 0.00 0.00
D: 0 0.00 0.00 0 0 0.00 0.00
_Total 0 0.00 0.00 0 0 0.00 0.00
Disk: queue %disk tps KBpsR KBpsW ms/R ms/W 12:32:07
HarddiskVolume1 0 0.00 0.00 0 0 0.00 0.00
C: 0 0.00 0.00 0 0 0.00 0.00
D: 0 0.00 0.00 0 0 0.00 0.00
_Total 0 0.00 0.00 0 0 0.00 0.00
Logs:
Current Log Number 9
Pages Written 2
Cur Commit Disk Log Reads 0
Cur Commit Total Log Reads 0
Method 1 Archive Status n/a
Method 1 Next Log to Archive 9
Method 1 First Failure n/a
Method 2 Archive Status n/a
Method 2 Next Log to Archive n/a
Method 2 First Failure n/a
Log Chain ID 0
Current LSO 41372312
Current LSN 0x0000000000092E88
Address StartLSN StartLSO State Size Pages Filename
0x00002AAF85D9A7D8 000000000008AE1D 41363249 0x00000000 4 4 S0000009.LOG
0x00002AAF85D9B038 0000000000000000 41379553 0x00000000 4 4 S0000010.LOG
0x00002AAF85D9B898 0000000000000000 41395857 0x00000000 4 4 S0000011.LOG
venus@baryon:/home/venus =>db2pd -pages -db pdtest
Database Partition 0 -- Database PDTEST -- Active -- Up 0 days 00:01:28
Bufferpool Pages:
First Active Pool ID 1
Max Bufferpool ID 1
Max Bufferpool ID on Disk 1
Num Bufferpools 5
Pages for all bufferpools:
Address BPID TbspaceID TbspacePgNum ObjID ObjPgNum ObjClass ObjType Dirty Prefetched
0x0000002AC22ABAC0 1 0 92 10 0 EMP Data N N
0x0000002AC22ABB80 1 0 2503 10 11 Perm Index N N
0x0000002AC22ABC40 1 0 2501 10 9 Perm Index Y N
0x0000002AC22ABD00 1 0 2494 10 2 Perm Index N N
0x0000002AC22ABDC0 1 0 3437 5 17 Perm Data N N
0x0000002AC22ABE80 1 0 2504 10 12 Perm Index Y N
0x0000002AC22ABF40 1 0 2505 10 13 Perm Index N N
0x0000002AC22AC000 1 0 2506 10 14 Perm Index N N
0x0000002AC22AC0C0 1 0 28 5 0 EMP LOB N N
0x0000002AC22AC180 1 0 2509 10 17 Perm Index N N
0x0000002AC22AC240 1 0 2495 10 3 Perm Index Y N
0x0000002AC22AC300 1 0 2498 10 6 Perm Index Y N
0x0000002AC22AC3C0 1 2 128 4 0 Perm Data Y N
0x0000002AC22AC480 1 0 2499 10 7 Perm Index N N
0x0000002AC22AC540 1 0 99 10 3 Perm Data Y N
0x0000002AC22AC600 1 0 96 10 0 Perm Data Y N
0x0000002AC22AC6C0 1 0 110 5 2 Perm Index N N
0x0000002AC22AC780 1 0 2500 10 8 Perm Index N N
0x0000002AC22AC840 1 0 2740 5 16 Perm Index N N
0x0000002AC22AC900 1 0 2507 10 15 Perm Index Y N
Total number of pages: 20
Summary info for all bufferpools:
BPID TbspaceID ObjID Total Dirty Permanent Temporary Data Index LongField XMLData SMP LOB LOBA BMP
1 0 5 4 0 3 0 1 2 0 0 0 1 0 0
1 0 10 15 7 14 0 3 12 0 0 0 0 0 0
1 2 4 1 1 1 0 1 0 0 0 0 0 0 0
Total number of pages: 20
venus@baryon:/home/venus =>db2pd -pages summary -db pdtest
Database Partition 0 -- Database PDTEST -- Active -- Up 0 days 00:02:07
Bufferpool Pages:
First Active Pool ID 1
Max Bufferpool ID 1
Max Bufferpool ID on Disk 1
Num Bufferpools 5
Total number of pages: 20
Summary info for all bufferpools:
BPID TbspaceID ObjID Total Dirty Permanent Temporary Data Index LongField XMLData SMP LOB LOBA BMP
1 0 5 4 0 3 0 1 2 0 0 0 1 0 0
1 0 10 15 7 14 0 3 12 0 0 0 0 0 0
1 2 4 1 1 1 0 1 0 0 0 0 0 0 0
Total number of pages: 20
Index Reorg Stats:
Retrieval Time: 02/08/2010 23:04:21
TbspaceID: -6 TableID: -32768
Schema: ZORAN TableName: BIGRPT
Access: Allow none
Status: Completed
Start Time: 02/08/2010 23:03:55 End Time: 02/08/2010 23:04:04
Total Duration: 00:00:08
Prev Index Duration: -
Cur Index Start: -
Cur Index: 0 Max Index: 2 Index ID: 0
Cur Phase: 0 ( - ) Max Phase: 0
Cur Count: 0 Max Count: 0
Total Row Count: 750000
Retrieval Time: 02/08/2010 23:04:21
TbspaceID: 2 TableID: 5
Schema: ZORAN TableName: BIGRPT
PartitionID: 0 MaxPartition: 2
Access: Allow none
Status: Completed
Start Time: 02/08/2010 23:04:04 End Time: 02/08/2010 23:04:08
Total Duration: 00:00:04
Prev Index Duration: -
Cur Index Start: -
Cur Index: 0 Max Index: 2 Index ID: 0
Cur Phase: 0 ( - ) Max Phase: 0
Cur Count: 0 Max Count: 0
Total Row Count: 375000
Retrieval Time: 02/08/2010 23:04:21
TbspaceID: 2 TableID: 6
Schema: ZORAN TableName: BIGRPT
PartitionID: 1 MaxPartition: 2
Access: Allow none
Status: Completed
Start Time: 02/08/2010 23:04:08 End Time: 02/08/2010 23:04:12
Total Duration: 00:00:04
Prev Index Duration: -
Cur Index Start: -
Cur Index: 0 Max Index: 2 Index ID: 0
Cur Phase: 0 ( - ) Max Phase: 0
Cur Count: 0 Max Count: 0
Total Row Count: 375000
The following section is an example of output using the -scansharing parameter. The output shows two sharing sets. The table scan set has two groups and the block index scan set has one group.
Database Partition 0 -- Database SAMP -- Active -- Up 0 days 00:00:45
Scan Sets:
TbspaceID TableID ScanObject NumGroups Footprint TableSize FastScanRate SlowScanRate
2 3 0 2 11520 22752 2486 1000
Group Information:
FootPrint NumScannersInGroup
8288 3
Scans In Group :
AgentID ApplID Mode Wrappable Fast/Slow Speed ThrottleTime Absolute Location Remaining Pages
9768 1173 0 0 1 2486 0 32 22751
11332 1165 0 0 1 2486 0 5056 17727
15466 1155 0 0 1 2486 0 8288 14495
Group Information:
FootPrint NumScannersInGroup
3232 2
Scans In Group :
AgentID ApplID Mode Wrappable Fast/Slow Speed ThrottleTime Absolute Location Remaining Pages
15209 1150 0 0 1 2486 0 14080 8703
12103 1148 0 0 1 2486 0 17280 5503
Scan Sets:
TbspaceID TableID ScanObject NumGroups Footprint TableSize FastScanRate SlowScanRate
2 3 1 1 9056 22752 1000 1000
Group Information:
FootPrint NumScannersInGroup
9056 3
Scans In Group :
AgentID ApplID Mode Wrappable Fast/Slow Speed ThrottleTime Relative Location Estimated Remaining Pages
6170 1209 0 0 1 1000 0 896 13535
13645 1215 0 0 1 1000 0 3552 10879
4371 1204 0 0 1 1000 0 9920 4511
The following are samples of the serverlist output
Sample serverlist output from db2pd -serverlist -db sample
Database Member 0 -- Active -- Up 0 days 00:10:43 -- Date 10/06/2010 12:22:39
Server List:
Time: Wed Oct 6 12:13:17
Database Name: SAMPLE
Count: 2
Hostname Non-SSL Port SSL Port Priority
coralxib23.torolab.ibm.com 49712 0 34
coralxib24.torolab.ibm.com 49712 0 65
Sample service subclass output from db2pd -serverlist -alldbs
Database Member 0 -- Active -- Up 0 days 00:06:15 -- Date 10/06/2010 12:18:11
Server List:
Time: Wed Oct 6 12:13:17
Database Name: SAMPLE
Count: 2
Hostname Non-SSL Port SSL Port Priority
coralxib23.torolab.ibm.com 49712 0 34
coralxib24.torolab.ibm.com 49712 0 65
Database Member 0 -- Active -- Up 0 days 00:06:15 -- Date 10/06/2010 12:18:11
Server List:
Time: Wed Oct 6 12:17:00
Database Name: SAMPLE2
Count: 2
Hostname Non-SSL Port SSL Port Priority
coralxib23.torolab.ibm.com 49712 0 56
coralxib24.torolab.ibm.com 49712 0 43
The following example is a sample of the service classes information output for one service superclass and its subclass.
Sample service superclass output:
Service Class Name = SYSDEFAULTSYSTEMCLASS
Service Class ID = 1
Service Class Type = Service Superclass
Default Subclass ID = 11
Effective Service Class State = Enabled
Catalog Service Class State = Enabled
Effective Prefetch Priority = Medium
Catalog Prefetch Priority = Default
Effective Bufferpool Priority = Low
Catalog Bufferpool Priority = Default
Effective Outbound Correlator = None
Catalog Outbound Correlator = None
CPU Shares = 1000
CPU Share Type = Soft
CPU Limit = None
Work Action Set ID = N/A
Collect Activity Opt = None
Collect Request Metrics = Base
Num Connections = 5
Last Statistics Reset Time = 12/16/2008 15:27:42.000000
Num Coordinator Connections = 5
Coordinator Connections HWM = 5
Associated Workload Occurrences (WLO):
AppHandl [nod-index] WL ID WLO ID UOW ID WLO State
10 [000-00010] 0 0 1 UOWWAIT
11 [000-00011] 0 0 1 UOWWAIT
12 [000-00012] 0 0 1 UOWWAIT
13 [000-00013] 0 0 1 UOWWAIT
14 [000-00014] 0 0 1 UOWWAIT
Sample service subclass output:
Service Class Name = SYSDEFAULTSUBCLASS
Service Class ID = 11
Service Class Type = Service Subclass
Parent Superclass ID = 1
Effective Service Class State = Enabled
Catalog Service Class State = Enabled
Effective Prefetch Priority = Medium
Catalog Prefetch Priority = Default
Effective Bufferpool Priority = Low
Catalog Bufferpool Priority = Default
Effective Outbound Correlator = None
Catalog Outbound Correlator = None
Collect Activity Opt = None
Collect Request Metrics = None
Collect Aggr Activity Opt = None
Collect Aggr Request Opt = None
Act Lifetime Histogram Template ID = 1
Act Queue Time Histogram Template ID = 1
Act Execute Time Histogram Template ID = 1
Act Estimated Cost Histogram Template ID = 1
Act Interarrival Time Histogram Template ID = 1
Request Execute Time Histogram Template ID = 1
Access Count = 0
Last Stats Reset Time = 12/16/2008 15:27:42.000000
Activities HWM = 0
Activities Completed = 0
Activities Rejected = 0
Activities Aborted = 0
Associated Agents:
EDU ID AppHandl [nod-index] WL ID WLO ID UOW ID Activity ID
26 10 [000-00010] 0 0 0 0
29 11 [000-00011] 0 0 0 0
28 12 [000-00012] 0 0 0 0
27 13 [000-00013] 0 0 0 0
30 14 [000-00014] 0 0 0 0
Associated Non-agent threads:
PID TID Thread Name
6834 2948590480 db2loggr
6834 2947541904 db2loggw
6834 2946493328 db2lfr
6834 2945444752 db2dlock
6834 2944396176 db2pclnr
6834 2943347600 db2pfchr
6834 2942299024 db2pfchr
6834 2941250448 db2pfchr
db2pd -db testdb -storagegroups
Storage Group Configuration:
Address SGID Deflt DataTag Name
0x00002BA9E6CFF4C0 0 Yes 0 IBMSTOGROUP
0x00002BA9E6D0F4C0 1 No 1 SG_SSD
0x00002BA9E6D1DAE0 2 No 5 SG_IBMSAN
Storage Group Statistics:
Address SGID State NumPaths NumDropPen
0x00002BA9E6CFF4C0 0 0x00000000 1 0
0x00002BA9E6D0F4C0 1 0x00000000 2 0
0x00002BA9E6D1DAE0 2 0x00000000 2 0
Storage Group paths:
Address SGID PathID PathState PathName
0x00002BA99CD23540 0 0 InUse /filesystem1
0x00002BA99CE13540 1 1024 InUse /filesystem2
0x00002BA99CF03540 1 1025 InUse /filesystem3
0x00002BA99D0F3540 2 2048 InUse /filesystem4
0x00002BA99D1E3540 2 2049 InUse /filesystem5
Tablespace Configuration:
...
Tablespace Statistics:
Address Id ... State MinRecTime NQuiescers PathsDropped
0x070000004108AB40 0 ... 0x00000000 0 0 Yes
0x070000004108B520 1 ... 0x00000000 0 0 Yes
0x0700000041078100 2 ... 0x00000000 0 0 Yes
Tablespace Autoresize Statistics:
...
Tablespace Storage Statistics:
Address Id DataTag Rebalance SGID SourceSGID
0x00002BA9E6CFF4C0 0 0 No 0 -
0x00002BA9E6D0F4C0 1 5 No 0 -
0x00002BA9E6D1DAE0 2 1 Yes 1 0
0x00002BA9E73696C0 3 5 No 0 -
Containers:
Address TspId ... PathID StripeSet Container
0x070000004108B240 0 ... 0 0 /dataPath1/inst/NODE0000/TESTDB/T0000000/C0000000.CAT
0x070000004108B398 0 ... 1 0 /dataPath2/inst/NODE0000/TESTDB/T0000000/C0000001.CAT
0x070000004108BBC0 1 ... 0 0 /dataPath1/inst/NODE0000/TESTDB/T0000001/C0000000.TMP
0x070000004108BD18 1 ... 1 0 /dataPath2/inst/NODE0000/TESTDB/T0000001/C0000001.TMP
0x07000000410787A0 2 ... 0 0 /dataPath1/inst/NODE0000/TESTDB/T0000002/C0000000.LRG
0x07000000410788F8 2 ... 1 0 /dataPath2/inst/NODE0000/TESTDB/T0000002/C0000001.LRG
If the table is managed by manual storage, the SGID will output a dash (-).
A new ‘Max HWM' column is added to the db2pd -tablespaces output to indicate the maximum HWM for a DMS table space since the instance was started. The ‘HWM' column in the output is the current HWM, which for a temporary DMS table space, represents the point-in-time value of the amount of disk space used. For SMS table spaces, the HWM and Max HWM will not have any value.
hotel26:/home/billyp> db2pd -db bill -tablespaces
Database Partition 0 -- Database BILL -- Active -- Up 0 days 00:02:15
Tablespace Configuration:
Address Id Type Content PageSz ExtentSz Auto Prefetch BufID BufIDDisk FSC RSE NumCntrs MaxStripe LastConsecPg Name
0x00002B9DCA582720 0 DMS Regular 4096 4 Yes 4 1 1 Off Yes 1 0 3 SYSCATSPACE
0x00002B9DCA583560 1 DMS UsrTmp 4096 2 Yes 2 1 1 Off Yes 1 0 1 DMSUSRTEMP
0x00002B9DCA5863E0 2 DMS Large 4096 32 Yes 32 1 1 Off Yes 1 0 31 USERSPACE1
0x00002B9DCA587220 3 DMS SysTmp 4096 2 Yes 2 1 1 Off N/A 1 0 1 DMSSYSTEMP
0x00002B9DCA58A0A0 4 DMS Large 4096 4 Yes 4 1 1 Off No 1 0 3 SYSTOOLSPACE
Tablespace Statistics:
Address Id TotalPgs UsablePgs UsedPgs PndFreePgs FreePgs HWM Max HWM State MinRecTime NQuiescers
0x00002B9DCA582720 0 12544 12540 12308 0 232 12308 12308 0x00000000 0 0
0x00002B9DCA583560 1 20000 19998 3266 0 16732 3266 3266 0x00000000 0 0
0x00002B9DCA5863E0 2 7168 7136 3232 0 3904 7072 7072 0x00000000 0 0
0x00002B9DCA587220 3 20000 19998 1700 0 18298 1700 2000 0x00000000 0 0
0x00002B9DCA58A0A0 4 256 252 144 0 108 144 200 0x00000000 0 0
hotel26:/home/billyp> db2pd -db billdb -temptable
System Temp Table Stats:
Number of Temp Tables : 0
Comp Eligible Temps : 0
Compressed Temps : 0
Total Stored Temp Bytes : 0
Total Bytes Saved : 0
Total Compressed Rows : 0
Total Temp Table Rows : 0
User Temp Table Stats:
Number of Temp Tables : 0
Comp Eligible Temps : 0
Compressed Temps : 0
Total Stored Temp Bytes : 0
Total Bytes Saved : 0
Total Compressed Rows : 0
Total Temp Table Rows : 0
The same information is stored for system temporary tables as well as user temporary tables. However, all of the counters mentioned previously are cumulative, and are updated as temporary tables are dropped. As such, these counters represent only historical information.
The following example is a sample of the threshold information for a database threshold and its queue.
Threshold Name = MAXDBACTIVITIES
Threshold ID = 6
Domain = 10
Domain ID = 10
Predicate ID = 90
Maximum Value = 2
Enforcement = D
Queueing = Y
Queue Size = 0
Collect Flags = V
Partition Flags = C
Execute Flags = C
Enabled = Y
Check Interval (seconds) = -1
Remap Target Serv. Subclass = 0
Log Violation Evmon Record = Y
Sample database threshold queue output:
Database Threshold Tickets:
Ticket information for threshold: TH1 with threshold ID 1
Activity ID UOW ID Classification AppHandl [nod-index]
1 6 READ_DML 51 [000-00051]
Queue information for threshold: MAXDBACTIVITIES
Max Concurrency = 2
Concurrency = 2
Max Queue Size = 0
Agents Currently Queued:
EDU ID AppHandl [nod-index] Agent Type Activity ID UOW ID
36 14994 [000-14994] 1 4 1
The following example is a sample of the threshold information for a statement threshold:
db2pd -thresholds -db sample db2
Database Member 0 -- Database SAMPLE -- Active -- Up 0 days 00:01:28 -- Date 04/13/2011 09:57:09
Statement Thresholds:
Threshold Name = T_THRESHOLD_FIRING_23
Threshold ID = 1
Domain = 60
Domain ID = 1
Predicate ID = 30
Maximum Value = 60
Enforcement = D
Queueing = N
Queue Size = 0
Collect Flags = V
Partition Flags = C
Execute Flags = C
Enabled = Y
Check Interval (seconds) = -1
Remap Target Serv. Subclass = 0
Log Violation Evmon Record = Y
Statement Text = CREATE TABLE T2 (X INT)
$ db2 "select thresholdname, domain from sysibm.systhresholds"
THRESHOLDNAME DOMAIN
-----------------------------------------------------------------------------------------------------------------
T_THRESHOLD_FIRING_23 SQ
1 record(s) selected.
db2pd -transactions -db sample
Database Member 0 -- Database SAMPLE -- Active -- Up 0 days 01:27:38 -- Date 2012-12-04-14.23.08.373888
Transactions:
Address AppHandl [nod-index] TranHdl Locks State ...
0x00002AAAE633A480 7 [000-00007] 3 0 READ ...
0x00002AAAE633C080 8 [000-00008] 4 0 READ ...
0x00002AAAE633DC80 9 [000-00009] 5 0 READ ...
0x00002AAAE633F880 10 [000-00010] 6 0 READ ...
0x00002AAAE6341480 11 [000-00011] 7 0 READ ...
0x00002AAAE6343080 12 [000-00012] 8 0 READ ...
0x00002AAAE6344C80 13 [000-00013] 9 0 READ ...
0x00002AAAE6346880 14 [000-00014] 10 0 READ ...
0x00002AAAE6348480 15 [000-00015] 11 0 READ ...
0x00002AAAE634A080 16 [000-00016] 12 0 READ ...
0x00002AAAE634BC80 17 [000-00017] 13 0 READ ...
Output from Transactions continued:
... Tflag Tflag2 Firstlsn Lastlsn ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000020 0x0000000000000000 0x000000000003EB46 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
... 0x00000000 0x00000000 0x0000000000000000 0x0000000000000000 ...
Output from Transactions continued:
... Firstlso Lastlso SpaceReserved LogSpace TID ...
... 0 0 0 0 0x00000000031A ...
... 0 0 0 0 0x000000000103 ...
... 0 0 0 0 0x000000000318 ...
... 0 0 0 0 0x000000000105 ...
... 0 0 0 0 0x000000000221 ...
... 0 0 0 0 0x000000000107 ...
... 0 0 0 0 0x000000000108 ...
... 0 0 0 0 0x000000000109 ...
... 0 0 0 0 0x00000000010B ...
... 0 0 0 0 0x00000000010C ...
... 0 0 0 0 0x00000000010E ...
Output from Transactions continued:
... AxRegCnt GXID ClientUserID ClientWrkstnName ClientApplName ClientAccntng
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a n/a n/a
... 1 0 n/a n/a db2evml_DB2DETAILDEADLOCK n/a
Total Application commits : 123
Total Application rollbacks : 139
db2pd -sort -db pdtest
Database Partition 0 -- Database PDTEST -- Active -- Up 0 days 00:05:29
AppHandl [nod-index]
13 [000-00013]
SortCB MaxRowSize EstNumRows EstAvgRowSize NumSMPSorts NumSpills
0x0000002AB7587300 919 50716 644 1 1
KeySpec
VARCHAR:300,VARCHAR:400
SMPSort# SortheapMem NumBufferedRows NumSpilledRows
0 16 0 101
AppHandl [nod-index]
7 [000-00007]
SortCB MaxRowSize EstNumRows EstAvgRowSize NumSMPSorts NumSpills
0x0000002AB74FC540 919 1000 644 1 1
KeySpec
VARCHAR:400,VARCHAR:200,VARCHAR:300
SMPSort# SortheapMem NumBufferedRows NumSpilledRows
0 16 0 101
db2pd -wlocks -db mydb2
Database Partition 0 -- Database MYDB2 -- Active -- Up 0 days 00:02:17
Locks being waited on :
AppHandl [nod-index] TranHdl Lockname Type Mode Conv Sts CoorEDU AppName AuthID AppID
13 [000-00013] 7 0002000B000000000340000452 Row ..X G 352614 db2bp VENUS *LOCAL.venus.071117030309
15 [000-00015] 9 0002000B000000000340000452 Row .NS W 1176046 db2bp VENUS *LOCAL.venus.071117030358
12 [000-00012] 2 0002000B000000000340000452 Row .NS W 1052748 db2bp VENUS *LOCAL.venus.071117030231
12 [000-00012] 2 00020004000000000080001652 Row ..X G 1052748 db2bp VENUS *LOCAL.venus.071117030231
14 [000-00014] 8 00020004000000000080001652 Row .NS W 634900 db2bp VENUS *LOCAL.venus.071117030340
The following example is a sample of the output for the basic work class information:
Work Class Sets:
Address ClassSetID ReferenceCounter
0x00002BA89DDF5AE0 1 1
Work Classes:
Address ClassSetID ClassID ClassName
0x00002BA89DDF5BC0 1 1 WCDML
Attributes:
Work Type: DML
Timeron Cost From: 1 Timeron Cost To: 1000
Address ClassSetID ClassID ClassName
0x00002BA89DDF5C40 1 2 WCDDL
Work Type: DML
The following example is a sample of the output for the default workloads SYSDEFAULTUSERWORKLOAD and SYSDEFAULTADMWORKLOAD:
Database Partition 0 -- Database SB -- Active -- Up 0 days 00:00:57
Workload Definitions:
Address = 0x00002B3E772ACB40
WorkloadID = 1
WorkloadName = SYSDEFAULTUSERWORKLOAD
DBAccess = ALLOW
Maximum Degree = 4
ConcWLOThresID = 0
ConcWLOThresName = ^H
MaxConcWLOs = 9223372036854775806
WLOActsThresName = ^H
WLOActsThresID = 0
MaxWLOActs = 9223372036854775806
ServiceClassID = 13
Collect Activity Opt = None
Collect Lock Timeout = Without History
Collect Deadlock = Without History
Collect Lock Wait = None
Collect Aggr Activity Opt = None
Collect Activity Metrics = Base
Collect Unit of Work Data = None
Act Lifetime Histogram Template ID = 1
Act Queue Time Histogram Template ID = 1
Act Execute Time Histogram Template ID = 1
Act Estimated Cost Histogram Template ID = 1
Act Interarrival Time Histogram Template ID = 1
Address = 0x00002B3E772ACD50
WorkloadID = 2
WorkloadName = SYSDEFAULTADMWORKLOAD
DBAccess = ALLOW
Maximum Degree = DEFAULT
ConcWLOThresID = 0
ConcWLOThresName = ^H
MaxConcWLOs = 9223372036854775806
WLOActsThresName = ^H
WLOActsThresID = 0
MaxWLOActs = 9223372036854775806
ServiceClassID = 13
Collect Activity Opt = None
Collect Lock Timeout = Without History
Collect Deadlock = Without History
Collect Lock Wait = None
Collect Aggr Activity Opt = None
Collect Activity Metrics = Base
Collect Unit of Work Data = None
Act Lifetime Histogram Template ID = 1
Act Queue Time Histogram Template ID = 1
Act Execute Time Histogram Template ID = 1
Act Estimated Cost Histogram Template ID = 1
Act Interarrival Time Histogram Template ID = 1
Usage Privilege Holders:
Address WorkloadID Type AuthID
0x00002B3E772BCD60 1 GROUP PUBLIC
Local Partition Workload Statistics:
Address = 0x00002B3E772DA0C0
WorkloadID = 1
WorkloadName = SYSDEFAULTUSERWORKLOAD
NumWLO = 0
LastResetTime = 10/07/2008 16:34:43.000000
WLO HWM = 0
WLOActHWM = 0
WLOCompleted = 0
ActCompleted = 0
ActAborted = 0
ActRejected = 0
Address = 0x00002B3E7730A0C0
WorkloadID = 2
WorkloadName = SYSDEFAULTADMWORKLOAD
NumWLO = 0
LastResetTime = 10/07/2008 16:34:43.000000
WLO HWM = 0
WLOActHWM = 0
WLOCompleted = 0
ActCompleted = 0
ActAborted = 0
ActRejected = 0
ROLLING UPDATE STATUS: Disk Value Memory Value
Record Type = INSTANCE
ID = 0
Code Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) Not Applicable
State = [NONE]
Last updated = 2013/04/18:02:58:58
Record Type = MEMBER
ID = 0
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:07:59:48
mbserver53.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = MEMBER
ID = 1
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CECL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000)
CEAL = V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000) V:10 R:5 M:0 F:3 I:0 SB:0 (0x0A05000300000000)
Section Level = V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000) V:10 R:5 M:0 F:0 I:0 SB:0 (0x0A05000000000000)
Last updated = 2013/04/18:09:24:18
mbserver55.domain.com: db2pd -ruStatus -localhost ... completed ok
Record Type = CF
ID = 128
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:31:14
Record Type = CF
ID = 129
Code Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Architecture Level = V:10 R:5 M:0 F:4 I:0 SB:0 (0x0A05000400000000) Not Applicable
Last updated = 2013/04/18:07:25:55
D:\>db2pd -vmstat t 2 5
run memory system CPU
--- --------------------------- ----------------- ---------------
r used free pi po int/s cs/s sc/s usr sys idl int
0 3377048 5752420 0 0 3899 15597 136475 0 0 100 0 11:43:49
0 3508340 5622388 0 0 6232 2750 3964 0 11 89 0 11:43:51
0 3622804 5507628 0 0 5589 1381 2332 0 7 93 0 11:43:53
0 3705532 5425536 0 0 4052 1053 2908 0 5 95 0 11:43:55
0 3836708 5294592 0 0 6338 1163 1289 0 9 91 0 11:43:57