Long Names
This panel shows the long names for the connection ID and the package name of a selected thread.
With this information, you can uniquely identify the individual owners of the various threads.
On the display, the first few lines of output identify the thread. This information is issued by using the PLAN major command.
By using the lnam minor command, the information on the following panel is displayed.
________________ ZLNAM VTM O2 V550./C SE11 05/13/13 0:41:45 2
> Help PF1 Back PF3
> THREAD INFORMATION: Enter a selection letter on the top line.
> A-THREAD DETAIL B-LOCK COUNTS C-LOCK WAITS D-LOCKS OWNED E-GLOBAL LOCKS
> F-CURRENT SQL G-SQL COUNTS H-DISTRIBUTED I-BUFFER POOL J-GROUP BP
> K-PACKAGES L-RES LIMIT M-PARALLEL TASKS N-UTILITY O-OBJECTS
> P-CANCEL THREAD Q-DB2 CONSOLE R-DSN ACTIVITY S-APPL TRACE T-ENCLAVE
> *-LONG NAMES W-ACCEL ACTIVITY
===============================================================================
> LONG NAMES
PLAN
+ Thread: Plan=DISTSERV Connid=SERVER Corrid=db2jcc_appli Authid=HONG
+ Dist : Type=DATABASE ACCESS, Luwid=G9417256.GAAC.CB811AF115F0=7367
+ Location : 9.65.114.86,Host Name=sig-9-65-114-86.mts.ibm.com
lnam
+ Collection ID :
+ NULLID
+
+ Package Name :
+ SYSLH200
+
+ End User ID :
+ myUserID-this is a very long user id I will use to populated some long fie
+ lds in EDMPool Dynamic sql cache entries.
+
+ End User TXID :
+ myApplicationInformation-also a very long application information line.
+
+ End User WS Name :
+ myWorkStation-this is the work station field set by using serDB2ClientWork
+ Station method
+
+ Trusted Context :
+ N/P
+
+ Role Name :
+ N/P
+
+ Original Appl ID :
+ N/P
+
+ Original OPID :
+ N/P
+
+ Authorization ID :
+ N/P
+
+ Correlation Token:
+ N/P
+
+ Account Location :
+ N/P
+
+ Account Info :
+ N/P
+
+ Account String :
+ N/P
===============================================================================Navigation
You can scroll through the information using F7 and F8.
For additional information about:
- Related topics, select one of the options at the top of the panel.
- Other topics, use the PF keys.
Fields
- Collection ID
- The name of the collection ID.
- Package name
- The name of the package.
- End User ID
- The name of the end user.
- End User TXID
- The transaction name of the end user.
- End User WS Name
- The workstation name of the end user.
- Trusted Context
- The name of the trusted context.
- Role Name
- The name of the role that is associated to the author ID.
- Original Appl ID
- The authorization ID.
- Original OPID
- The original operator ID.
- Authorization ID
- Original application user ID.
- Correlation Token
- The correlation token.
- Account Location
- The Db2 LOCATION name of the Db2 system that creats the QMDAINFO values if QMDALOCN is truncated.
- Account Information
- The maximum length of this field is 200 bytes. You can specify this suffix for the accounting string.
- Account String
- The extended accounting string area.
- If QMDAASTR is defined by QMDAINFO, this area contains all the remaining bytes beyond position 142 for QMDAACCT.
- If QMDAASTR is defined by QMDASQLI, this area contains all the remaining bytes beyond position 200 for QMDASUFX.
- Otherwise, this area contains all bytes beyond position 247.