|
con-no | Number of the conversation; number of the SQL conversation, assigned internally by UDS/SQL; conversations are numbered consecutively during each session segment. |
t | Time interval from 1..999 minutes |
The DISPLAY SQL command logs information to the database administrator’s terminal or to the operator console as follows:
VG=con-no
all information for conversation con-no
OPTION=ALL
all conversations, sorted in order of increasing age
OPTION=ALL,VG=con-no
all conversations, beginning with the conversation specified, sorted in order of increasing age
OPTION=IDLE
the conversations inactive for the longest amount of time, sorted in order of increasing duration of inactivity
OPTION=IDLE,TIME=t
all inactive conversations that have been inactive at least t minutes, sorted in order of increasing duration of inactivity
The following sections describe the output of the various DISPLAY SQL commands.
Show all information for a conversation
Input format: DISPLAY SQL,VG=con-no
|
|
|
Explanations:
con-no | |
Conversation number; up to eight digits; number for the SQL conversation, assigned internally by UDS/SQL. Conversations are numbered consecutively during each part of a session. | |
appl-/user-name | |
openUTM application name/user name; up to 17 characters | |
tsn | Task serial number under which the application program is running; up to four |
date | Time stamp for the beginning of the conversation in UDS/SQL: |
no-ta | Number of completed SQL transactions in the conversation; up to four digits |
no-stmt | |
Number of SQL statements processed in the conversation; up to four digits | |
mem | Amount of SQL-specific memory, in Kbyte; up to four digits |
opcode | Current or most recent SQLU statement code; up to six characters, as follows: PERMIT PERMIT CLOCUR CLOSE CURSOR COMWOR COMMIT WORK CRETV CREATE TEMPORARY VIEW DCLCUR DECLARE CURSOR DELPOS DELETE POSITIONED DELSRC DELETE SEARCHED FETCH FETCH INSERT INSERT OPECUR OPEN CURSOR RESCUR RESTORE CURSOR ROLWOR ROLLBACK WORK SELECT SELECT SETTA SET TRANSACTION STOCUR STORE CURSOR UPDPOS UPDATE POSITIONED UPDSRC UPDATE SEARCHED |
ta-id | Global transaction ID of the currently open TA in the conversation; up to eight characters, or "- - -" if no TA is open or has as yet been opened due to the DAL command STOP NEW. |
time | Duration of inactivity, in minutes; up to four digits, or "- - -" if a TA is open, i.e. the conversation is active. |
If the amount of space for a particular output field is insufficient to display the current value, the string ">>...>" is displayed instead.
Show all active and inactive conversations
Input format: DISPLAY SQL,OPTION=ALL
|
Explanations:
Conversation number; up to eight digits;
con-no | Conversation number; up to eight digits; number for the SQL conversation, assigned internally by UDS/SQL. Conversations are numbered consecutively during each session segment. |
type | Type of application which initiated the operation: UTM BATCH |
date | Time stamp for the beginning of the conversation in UDS/SQL: |
mem | Amount of SQL-specific memory, in Kbytes; up to four digits |
ta-id | Global transaction ID of the currently open TA in the conversation; up to eight characters, or "- - -" if no TA is open or has as yet been opened due to the DAL command STOP NEW. |
time | Duration of inactivity, in minutes; up to four digits, or "- - -" if a TA is open, i.e. the conversation is active |
n | Number of conversations not yet shown; up to four digits |
If the amount of space for a particular output field is insufficient to display the current value, the string ">>...>" is displayed instead.
All active conversations are shown, sorted in order of increasing age, beginning with the most recent conversation.
As many conversations are shown as will fit on the screen. If they will not all fit, the number of remaining conversations is indicated at the bottom. These conversations can be displayed by means of the DAL command CONTINUE.
Show all active and inactive conversations, beginning with the specified conversation number
Input format: DISPLAY SQL,OPTION=ALL,VG=con-no
|
Explanations:
con-no | Conversation number; up to eight digits; number for the SQL conversation, assigned internally by UDS/SQL. Conversations are numbered consecutively during each session segment. |
type | Type of application which initiated the operation: UTM BATCH |
date | Time stamp for the beginning of the conversation in UDS/SQL: |
mem | Amount of SQL-specific memory, in Kbyte; up to four digits |
ta-id | Global transaction ID of the currently open TA in the conversation; up to eight characters, or "- - -" if no TA is open or has as yet been opened due to the DAL command STOP NEW. |
time | Duration of inactivity, in minutes; up to four digits, or "- - -" if a TA is open, i.e. the |
n | Number of conversations not yet shown; up to four digits |
If the amount of space for a particular output field is insufficient to display the current value, the string ">>...>" is displayed instead.
All conversations are shown, sorted in order of increasing age, beginning with the conversation specified.
As many conversations are shown as will fit on the screen. If they will not all fit, the number of remaining conversations is indicated at the bottom. These conversations can be displayed by means of the DAL command CONTINUE.
Show the conversations inactive for the longest amount of time
Input format: DISPLAY SQL,OPTION=IDLE
|
Explanations:
con-no | Conversation number; up to eight digits; number for the SQL conversation, assigned internally by UDS/SQL. Conversations are numbered consecutively during each session segment. |
type | Type of application which initiated the operation: UTM BATCH |
date | Time stamp for the beginning of the conversation in UDS/SQL: |
mem | Amount of SQL-specific memory, in Kbytes; up to four digits |
time | Duration of inactivity, in minutes; up to four digits, or "- - -" if a TA is open, i.e. the conversation is active |
n | Number of inactive conversations not yet shown; up to four digits |
If the amount of space for a particular output field is insufficient to display the current value, the string ">>...>" is displayed instead.
The conversations inactive for the longest amount of time are shown, sorted in order of increasing duration of inactivity.
As many conversations are shown as will fit on the screen. If they will not all fit, the number of remaining inactive conversations is indicated at the bottom. These conversations can be displayed by means of the DAL command CONTINUE.
Show all inactive conversations that have been inactive for a particular amount of time
Input format: DISPLAY SQL,OPTION=IDLE,TIME=t
|
Explanations:
con-no | Conversation number; up to eight digits; number for the SQL conversation, assigned internally by UDS/SQL. Conversations are numbered consecutively during each session segment. |
type | Type of application which initiated the operation: UTM BATCH |
date | Time stamp for the beginning of the conversation in UDS/SQL: |
mem | Amount of SQL-specific memory, in Kbytes; up to four digits |
time | Duration of inactivity, in minutes; up to four digits |
n | Number of inactive conversations not yet shown; up to four digits |
If the amount of space for a particular output field is insufficient to display the current value, the string ">>...>" is displayed instead.
Conversations that have been inactive for at least t minutes are shown, sorted in order of increasing duration of inactivity.
As many conversations are shown as will fit on the screen. If they will not all fit, the number of remaining inactive conversations is indicated at the bottom. These conversations can be displayed by means of the DAL command CONTINUE.