Application Trace Lock Detail
This panel shows a summary of all locks that are acquired as a result of the SQL statement.
________________ ZATD2 VTM O2 V550.#P SE12 11/05/13 17:47:29 3
> Help PF1 Back PF3 Up PF7 Down PF8
>
> APPLICATION TRACE: Enter a selection letter on the top line.
> Current Trace Status: INACTIVE
> A-PROGRAM B-SQL INDEX C-SQL DETAIL *-LOCK DETAIL E-EVENT DETAIL
===============================================================================
> APPLICATION TRACE LOCK DETAIL
ATD2
+ Planname=DSNESPCS Connid=TSO Corrid=MIS Authid=MIS
+
: Control= FIRST Valid options are FIRST/LAST/NEXT/PREV/nnnnn/-nnnnn/Snnnnn
+ Current=000001 Total Number of SQL Calls=000004
+
+ Start Time Progname SQL Call Stmt# PSET DPAG IPAG OTHER
+ ------------ -------- ---------------- ----- ------ ------ ------ ------
+ 16:38:49.959 DSNESM68 PREPARE 00189 0 0 0 8
+
+ Locks Acquired By Sql Call
+ ----------------------------------------------------------
+ Type Level Resource Count
+ ---- ----- --------------------------------- -------
+ ROW S DB=DSNDB06 PS=SYSTSTAB 1
+ S DB=DSNDB06 PS=SYSTSTSP 1
+ S DB=DSNDB06 PS=SYSTSCOL 1
+ S DB=DSNDB06 PS=SYSTSTAU 1
+ PALK IS DB=DSNDB06 PS=SYSTSTAB PT=00001 1
+ IS DB=DSNDB06 PS=SYSTSTSP PT=00001 1
+ IS DB=DSNDB06 PS=SYSTSCOL PT=00001 1
+ IS DB=DSNDB06 PS=SYSTSTAU PT=00001 1
+ -------
+ Total Locks Acquired = 8
+
+ Locks Owned At Start Of SQL Call Execution
+ ----------------------------------------------------------
+ Type Level Resource Count
+ ---- ----- --------------------------------- -------
+ SKPT S TOKEN=0E4D2F9F02F2F0F0 1
+ SKCT S PLAN=DSNESPCS 1
+ -------
+ Total Locks Owned = 2
===============================================================================
The data is refreshed each time you press Enter, which shows details for another SQL call. For parallel task activity, these values include locks held by parent and child tasks.
Navigation
For additional
information about
- related topics, select one of the options on the top of the panel.
- other topics, use the PF keys.
Fields
Note: No data
is shown if you specified LOCKDATA=NO in the Specify Application Trace
panel.
- Planname
- The Db2 plan name of the active thread.
- Connid
- The Db2 connection identifier of the active thread.
- Corrid
- The Db2 correlation identifier of the active thread.
- Authid
- The Db2 authorization identifier of the active thread.
- Control
- The next SQL statement that OMEGAMON®
for Db2 PE displays. This panel
initially displays the first SQL statement collected for the thread. Use
these keywords to control the display:
- FIRST
- First SQL statement encountered for the thread.
- LAST
- Last SQL statement encountered for the thread.
- NEXT
- Next SQL statement encountered for the thread.
- PREV
- Previous SQL statement encountered for the thread.
- nnnnn
- The nnnnn (1-99999) entry after the currently displayed SQL statement.
- -nnnnn
- The nnnnn (1-99999) entry before the currently displayed SQL statement.
- Snnnnn
- Statement number nnnnn.
- Current
- The relative number of the SQL statement currently being displayed. This is relative to the total number of calls located for the Db2 unit of work.
- Total Number of SQL Calls
- The total number of SQL calls located for the DB2® unit of work.
- Start Time
- The time the SQL statement was issued.
- Progname
- The name of program that issued the SQL statement.
- SQL Call
- The SQL statement type.
- Stmt#
- The SQL statement precompiler statement number.
- PSET
- The total number of pageset locks acquired by the SQL statement.
- DPAG
- The total number of datapage locks acquired by the SQL statement.
- IPAG
- The total number of index page locks acquired by the SQL statement.
- OTHER
- The total number of other types of locks acquired by the SQL statement.
Locks Acquired and Locks Owned information:
- TYPE
- The lock type owned. Every lock type owned by the thread will be displayed.
- LEVEL
- The lock levels of the various lock types owned. All lock levels owned within a lock type will be listed. Lock levels can be displayed repetitively for a single lock type because of the different resources owned by the locks.
- RESOURCE
- The resource that is the object of the lock. The content of the Resource field is
dependent on lock type. For data page (DPAG) and index page (IPAG) locks,
the resource does not contain the actual data page number that is locked; it
lists the database and pageset that own the data or index page lock. The
Count field will then display how many data or index page locks exist within
the resource (pageset) listed. Note: When you are using an ATF trace from VSAM, and the resource is a table or a datapage in a segmented tablespace, OMEGAMON for Db2 PE will not translate the PSID number (page set ID) to the table name. Instead, OMEGAMON for Db2 PE displays the OBID of the Db2 table. (This is because OMEGAMON for Db2 PE uses IFCIDs 105 and 107 to translate the object identifiers from lock records, and those IFCIDs do not contain OBID-TABLENAME pairs.)
You can execute the following SQL statement to determine the Db2 table name from the displayed PSID.
SELECT NAME, CREATOR FROM SYSIBM.SYSTABLES WHERE DBNAME= 'dbname' AND OBID= nn - COUNT
- The number of locks meeting the type, level, and resource description of the lock.