The variable parts of the report are described below in accordance with the REPORT-FORMAT parameter PROTOCOL.
Output of statements
PROTOCOL=*STATEMENT(INFORMATION=*STRING-FORMAT)
SESCOSP provides the following information for each statement.
Heading | Contents |
LFD | Internal record number by means of which the lines belonging to different SESCOSP reports can be assigned |
DATE | Date (yyyy-mm-dd) on which the request was accepted |
TIME | Time (hh:mm:ss) at which the request was accepted |
HOST | In distributed processing, the host name; |
APPL/TSN | UTM or DCAM application name; |
USER/PRG | KDCSIGN name in UTM mode or DCAM or TIAM program name; possibly LOGON |
CONV-ID | Conversation ID |
TAC/U-ID | UTM transaction code or |
ITN | SESAM/SQL internal terminal number (specified in hexadecimal format) |
ST-ID | Number of the statement. Forms with the ITN the unique identification of a statement (specified in hexadecimal format). |
STM | Short ID of the SQL statement, of the SQL statement group, or CALL DML operation code |
STM | INS: INSERT |
CPUUnits 1 | CPU time used by the statement in milliseconds or microseconds |
BruttoEI | Elapsed time of the statement in the DBH (without the connection module) (Elapsed Time) |
PhysIO 1 | Number of physical read and write accesses |
In CALL DML | |
Statement | Statement in printable form (for CO-LOG files with standard logging max. 500 bytes) |
Acknowledgement | Acknowledgment in dump format |
Query area | Values in dump format (for CO-LOG files with standard logging max. 1000 bytes) |
Answer area | Values in dump format (for CO-LOG files with standard logging max. 1000 bytes) |
In SQL | |
ICSQL-Params | ICSQL parameters in printable format (for CO-LOG files with standard logging max. 500 bytes) |
SQL-String | SQL string in printable format (for CO-LOG files with standard logging max. 29696 bytes) |
In-Descriptors | Input descriptors (see the section “Representation of data ...” below)(only for CO-LOG files with LONG logging). |
Diagnostic | Diagnostic area in printable format (for CO-LOG files with standard logging max. 500 byte) |
Output | Values in printable format (see the section “Representation of data ...” below) only for CO-LOG files with LONG logging). |
1In SESAM/SQL V9.0 and higher, the values from the service tasks are also contained here
The extent of logging of CO-LOG files is set in the administration statement SET-TUNING-TRACE by means of the operand PROTOCOL=*STD/*LONG, see "SET-TUNING-TRACE".
Representation of data of the data types (NATIONAL) CHARACTER (VARYING)
The input descriptors and the values (In-Descriptors and Output columns) are output for the data types CHARACTER (VARYING) in printable form, e.g.:
|
|
|
|
Printable data of the data types NATIONAL CHARACTER (VARYING) is converted with the CCSN EDF03IRV to CHARACTER format and output. If the data contains non-printable characters, these are also output in the continuation line in hexadecimal format in the Unicode encoding form UTF-16. Data that cannot be converted appears in the CHARACTER format as blanks. If the data contains non-printable characters, these are also output in the continuation line in hexadecimal format in the Unicode encoding form UTF-16. Example (00D6=Ö is not printable):
In-Descriptors: ITEM 1: TYPE = NCHAR(10)
C 4 E
00D6004300340045
Example 1: (normal case, in-descriptors and output)
1. PREPARE statement with SQL string
SESCOSP/SQL VERS. <version> TSN:4IYB ID.:SQLDB112 *** STRING-FORMAT *** <date> <time> PAGE 1
LFD DATE TIME HOST APPL/TSN USER/PRG CONV-ID TAC/U-ID ITN STID STM CPUUnits BruttoEl PhysIO
***********************************************************************************************************************************
0017 <date> <time> D016ZE09 TSN=94E7 UDML202 00000000 XDL1LOE 0002 0017 PRP 0 15 0
ICSQL-Params: ICSQL-Version = X'02', ICSQL-Type = 'PRE', User-Authorization-ID = 'D0USER', Consistency-Level = X'03', TA-A
ccess-Mode = X'02', Current-Catalog-Name = 'STANCAT4', Is-Static-Statement = FALSE, Statement-Class = X'0205
', Statement-ID = 'SQLENTRQ.ST1'
SQL-String: --%PRAGMA DIALECT FULL --%PRAGMA CATALOG "STANCAT4"--%PRAGMA SCHEMA "SCHEMA_0001"--%PRAGMA MODULE "SQLENT
RQ"--%PRAGMA PREFETCH 20 SELECT T1.COLUMN_0001, T1.COLUMN_0003, T2.COLUMN_0017
FROM TABLE_0001 T1, TABLE_0001 T2 /* self join */ WHERE T1.COLUMN_0001 > ? AND T2.COLUMN_0002 > ? AN
D CAST( SUBSTRING(T1.COLUMN_0011 FROM 1 FOR 3000) AS VARCHAR(3000)) = CAST( SUBSTRING(T2.COLUMN_0011 FROM
1 FOR 3000) AS VARCHAR(3000)) ORDER BY CAST( SUBSTRING(T1.COLUMN_0017 FROM 1 FOR 3000) AS VARCHAR(3000)
) ASC
Diagnostic: SQL-State = '00000'
Output: ITEM 1: TYPE = CHAR(50) NAME = COLUMN_0001
<UNKNOWN>
ITEM 2: TYPE = CHAR(50) NAME = COLUMN_0003
<UNKNOWN>
ITEM 3: TYPE = VARCHAR(16000) NAME = COLUMN_0017
<UNKNOWN>
2. SQL statement OPEN cursor
SESCOSP/SQL VERS. <version> TSN:4IYB ID.:SQLDB112 *** STRING-FORMAT*** <date> <time> PAGE 1
LFD DATE TIME HOST APPL/TSN USER/PRG CONV-ID TAC/U-ID ITN STID STM CPUUnits BruttoEl PhysIO
***********************************************************************************************************************************
0018 <date> <time> D016ZE09 TSN=94E7 UDML202 00000000 XDL1LOE 0002 0018 OPC 0 2537 31
ICSQL-Params: ICSQL-Version = X'02', ICSQL-Type = 'OPN', User-Authorization-ID = 'D0USER', Consistency-Level = X'03', TA-A
ccess-Mode = X'02', Current-Catalog-Name = 'STANCAT4', Is-Static-Statement = FALSE, Statement-Class = X'010B
', Statement-ID = 'SQLENTRQ.ST1', Cursor-ID = 'SQLENTRQ.CU03', Is-Scroll-Cursor = FALSE
In-Descriptors: ITEM 1: TYPE = CHAR(20)
BBB
ITEM 2: TYPE = DECIMAL(10,2)
+00000001.11
Diagnostic: SQL-State = '00000'
***********************************************************************************************************************************
3. SQL FETCH statement with result values
SESCOSP/SQL VERS. <version> TSN:4IYB ID.:SQLDB112 *** STRING-FORMAT *** <date> <time> PAGE 1
LFD DATE TIME HOST APPL/TSN USER/PRG CONV-ID TAC/U-ID ITN STID STM CPUUnits BruttoEl PhysIO
***********************************************************************************************************************************
0019 <date> <time> D016ZE09 TSN=94E7 UDML202 00000000 XDL1LOE 0002 0019 FET 0 3 1
ICSQL-Params: ICSQL-Version = X'02', ICSQL-Type = 'FCH', User-Authorization-ID = 'D0USER', Consistency-Level = X'03', TA-A
ccess-Mode = X'02', Current-Catalog-Name = 'STANCAT4', Is-Static-Statement = FALSE, Statement-Class = X'010A
', Statement-ID = 'SQLENTRQ.ST1', Cursor-ID = 'SQLENTRQ.CU03', Fetch-Orientation = X'0000000000000000'
Diagnostic: SQL-State = '00000'
Output: ITEM 1: TYPE = CHAR(50)
VOLLMF
ITEM 2: TYPE = CHAR(50)
AAAAkfdljhgslkdjfhglkdfhg
ITEM 3: TYPE = VARCHAR(16000)
THIS WILL BE A SEMI-LONG VCHAR
***********************************************************************************************************************************
Example 2: BLOCK MODE (Output)
SQL FETCH statement with result values (PREPARE and FETCH as in the normal case)
***********************************************************************************************************************************
0012 <date> <time> D016ZE09 TSN=94E7 UDML202 00000000 XDL1LOE 0002 0012 FET 0 3 0
ICSQL-Params: ICSQL-Version = X'02', ICSQL-Type = 'FCH', User-Authorization-ID = 'D0USER', Consistency-Level = X'03', TA-A
ccess-Mode = X'02', Current-Catalog-Name = 'STANCAT4', Is-Static-Statement = FALSE, Statement-Class = X'010A
', Statement-ID = 'SQLENTRQ.ST1', Cursor-ID = 'SQLENTRQ.CU02', Fetch-Orientation = X'0000000000000000'
Diagnostic: SQL-State = '00000'
Output: ROW 1, SQL-STATE = 00000 -------------------------------------------------------------------------------
ITEM 1: TYPE = CHAR(50)
AAAAkfdljhgslkdjfhglkdfhg
ITEM 2: TYPE = CHAR(50)
AAAAkfdljhgslkdjfhglkdfhg
ITEM 3: TYPE = VARCHAR(16000)
THIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEM
I-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS W
ILL BE A SEMI-LONG VCHARTHIS WILL BE A S
ROW 2, SQL-STATE = 00000 -------------------------------------------------------------------------------
ITEM 1: TYPE = CHAR(50)
BBBAkfdljhgslkdjfhglkdfhg
ITEM 2: TYPE = CHAR(50)
AAAAkfdljhgslkdjfhglkdfhg
ITEM 3: TYPE = VARCHAR(16000)
THIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEM
I-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS W
ILL BE A SEMI-LONG VCHARTHIS WILL BE A S
ROW 3, SQL-STATE = 00000 -------------------------------------------------------------------------------
ITEM 1: TYPE = CHAR(50)
CCCAkfdljhgslkdjfhglkdfhg
ITEM 2: TYPE = CHAR(50)
AAAAkfdljhgslkdjfhglkdfhg
ITEM 3: TYPE = VARCHAR(16000)
THIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEM
I-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS W
ILL BE A SEMI-LONG VCHARTHIS WILL BE A S
ROW 4, SQL-STATE = 00000 -------------------------------------------------------------------------------
ITEM 1: TYPE = CHAR(50)
DDDAkfdljhgslkdjfhglkdfhg
ITEM 2: TYPE = CHAR(50)
AAAAkfdljhgslkdjfhglkdfhg
ITEM 3: TYPE = VARCHAR(16000)
THIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEM
I-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS WILL BE A SEMI-LONG VCHARTHIS W
ILL BE A SEMI-LONG VCHARTHIS WILL BE A S
***********************************************************************************************************************************Example 3: Output of values of multiple fields (Output)
SQL FETCH statement with result values (PREPARE and FETCH as in the normal case)
***********************************************************************************************************************************
0061 <date> <time> D016ZE09 TSN=94E7 UDML202 00000000 XDL1LOE 0002 0061 FET 0 9 0
ICSQL-Params: ICSQL-Version = X'02', ICSQL-Type = 'FCH', User-Authorization-ID = 'D0USER', Consistency-Level = X'03', TA-A
ccess-Mode = X'02', Current-Catalog-Name = 'STANCAT4', Is-Static-Statement = FALSE, Statement-Class = X'010A
', Statement-ID = 'SQLENTRQ.ST1', Cursor-ID = 'SQLENTRQ.CU07', Fetch-Orientation = X'0000000000000000'
Diagnostic: SQL-State = '00000'
Output: ITEM 1: TYPE = CHAR(256)
1 AAAAAAAAAABBBBBBBBBB1CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
2 AAAAAAAAAABBBBBBBBBB2CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
3 AAAAAAAAAABBBBBBBBBB3CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
4 AAAAAAAAAABBBBBBBBBB4CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
5 AAAAAAAAAABBBBBBBBBB5CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
6 AAAAAAAAAABBBBBBBBBB6CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
7 AAAAAAAAAABBBBBBBBBB7CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
8 AAAAAAAAAABBBBBBBBBB8CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
9 AAAAAAAAAABBBBBBBBBB9CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
10 AAAAAAAAAABBBBBBBBBB0CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
11 AAAAAAAAAABBBBBBBBBB1CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
12 AAAAAAAAAABBBBBBBBBB2CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
197 AAAAAAAAAABBBBBBBBBB7CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
198 AAAAAAAAAABBBBBBBBBB8CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
199 AAAAAAAAAABBBBBBBBBB9CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
200 AAAAAAAAAABBBBBBBBBB0CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
ITEM 2: TYPE = CHAR(256)
1 AAAAAAAAAABBBBBBBBBB1CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
2 AAAAAAAAAABBBBBBBBBB2CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
3 AAAAAAAAAABBBBBBBBBB3CCCCCCCCCDDDDDDDDDDEEEEEEEEEEAAAAAAAAAABBBBBBBBBBCCCCCCCCCCDDDDDDDDDDEEEEEEEEEE
***********************************************************************************************************************************Output of I/O statistics for each statement
PROTOCOL=*STATEMENT(INFORMATION=*IO-STATISTICS)
SESCOSP provides the following information for each statement:
Heading | Contents |
LFD | See the “The STRING-FORMAT report” |
DATE | See the “The STRING-FORMAT report” |
TIME | See the “The STRING-FORMAT report” |
APPL/TSN | See the “The STRING-FORMAT report” |
TAC/U-ID | See the “The STRING-FORMAT report” |
ITN | See the “The STRING-FORMAT report” |
ITN | See the “The STRING-FORMAT report” |
ST-ID | See the “The STRING-FORMAT report” |
DBC# | Internal database number by means of which the database name can be obtained via the catalog-space table assignment table (see "Catalog-space table assignment table") |
C-ID | In SQL: number of the statement that declared the cursor, if the evaluated statement refers to a cursor |
STM | See the “The STRING-FORMAT report” |
CPUUnits 1 | See the “The STRING-FORMAT report” |
BruttoEI | See the “The STRING-FORMAT report” |
NettoEl 1 | Activity time of the statement; i.e. the sum of the active time of the user and the active time of all subfunctions (=statement steps) |
PhDBIO 1 | Number of physical read and write accesses of the database |
LgDBIO 1 | Number of logical read and write accesses of the database |
PhCuIO | Number of physical read and write accesses of cursor files |
LgCuIO | Number of logical read and write accesses of cursor files |
Table 26: The IO-STATISTICS report
1In SESAM/SQL V9.0 and higher, the values from the service tasks are also contained here
Example
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 <date> <time> PAGE 1
//
CREATE-REPORT INPUT-FILE = SESAM.CO-LOG, OUTPUT = SESAM.COSP.OUT.IOSTAT, SELECT
= *ALL, REPORT-FORMAT = *PARAMETERS ( PROTOCOL = *STATEMENT ( INFORMATION =
*IO-STATISTICS ), TIME-PRECISION=*PARAMETERS(CPU-TIME=*MICRO-SECONDS ,
ELAPSED-TIME=*MICRO-SECONDS ))
.
.
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 *** IO-STATISTICS *** <date> <time> PAGE 3
LFD DATE TIME APPL/TSN TAC/U-ID ITN STID DBC# C-ID STM CPUUnits BruttoEl NettoEl PhDBIO LgDBIO PhCuIO LgCuIO
0079 <date> <time> TSN=1A2Z DBSRE 0004 0283 0000 A2 90C 429 2808 426 0 0 0 0
007B <date> <time> TSN=1A24 DBSRE 0011 0C14 0001 A1 6 1874 11899 11899 0 4 0 0
007C <date> <time> TSN=1A2Y DBSRE 0001 13A5 0001 A1 6 1700 2581 2581 0 6 0 0
007E <date> <time> TSN=1A4G XDL1DBT3 0015 0026 0003 0026 SEL 4616 10771 10771 0 2 0 0
0080 <date> <time> TSN=1A4M XDL1DBT3 000B 0043 0003 0041 CLC 2802 13086 13086 0 0 0 0
0081 <date> <time> TSN=1A4P XDL1DBT3 000C 0025 0003 0025 SEL 4191 4531 4531 0 2 0 0
0082 <date> <time> TSN=1A4H XDL1DBT3 0005 0034 0002 0034 SEL 3454 3662 3662 0 2 0 0
007A <date> <time> TSN=1A25 DBSRE 0009 0BFB 0001 A1 90B 2129 85790 12139 0 7 0 0
007F <date> <time> TSN=1A22 DBSRE 001C 0851 0001 A1 6 1698 67756 67756 0 5 0 0
0083 <date> <time> TSN=1A23 DBSRE 0002 0A96 0001 A2 90B 1187 1193 1193 0 4 0 1
0084 <date> <time> TSN=1A24 DBSRE 0016 0866 0001 A2 90B 2180 11168 11168 0 4 0 1
0085 <date> <time> TSN=1A22 DBSRE 0017 06D7 0000 A4 90C 355 357 357 0 0 0 0
0086 <date> <time> TSN=1A23 DBSRE 000D 0CB5 0001 A1 6 1610 1611 1611 0 6 0 0
0087 <date> <time> TSN=1A25 DBSRE 000E 0884 0001 A2 90B 2100 2188 2188 0 4 0 1
008A <date> <time> TSN=1A4G XDL1DBT3 0015 0027 0003 0027 SEL 5105 10402 10402 0 2 0 0
008C <date> <time> TSN=1A4M XDL1DBT3 000B 0044 0000 CTA 421 425 425 0 0 0 0
008D <date> <time> TSN=1A24 DBSRE 0011 0C15 0001 A1 6 1910 4149 4149 0 7 0 0
0089 <date> <time> TSN=1A4N XDL1DBT3 001B 002D 0002 002D OPC 10817 63424 31374 1 5 0 6
008E <date> <time> TSN=1A25 DBSRE 0009 0BFC 0001 A1 6 1741 7107 7107 0 4 0 0
008B <date> <time> TSN=1A4H XDL1DBT3 0005 0035 0001 0035 SEL 5775 42389 25097 0 2 0 0
.
.Output of I/O statistics for each statement step
PROTOCOL=*STATEMENT(INFORMATION=*STEP-IO-STATISTICS)
SESCOSP provides this information for each statement step (see the SUB subfunction) and each SQL table.
Heading | Contents |
LFD | See the “The STRING-FORMAT report” |
ITN | See the “The STRING-FORMAT report” |
ST-ID | See the “The STRING-FORMAT report” |
DBC# | See the “The IO-STATISTICS report” |
S# | Identification number of the space in the database. See the assignment table on "Catalog-space table assignment table" (specified in hexadecimal format) |
TB# | Identification number of the table in the space. See the assignment table on "Catalog-space table assignment table" (specified in hexadecimal format) |
C-ID | See the “The IO-STATISTICS report” |
SUB | Subfunction (statement step) |
STM | See the “The STRING-FORMAT report” |
CPUUnits 1 | CPU time used for the statement step, in milliseconds or microseconds |
BruttoEI | Elapsed time of the statement step in the DBH |
NettoEl 1 | Activity time of the statement step |
PhACIO | Number of physical read and write accesses of the access data |
LgACIO | Number of logical read and write accesses of the access data |
PhDAIO | Number of physical read and write accesses of the primary data |
LgDAIO | Number of logical read and write accesses of the primary data |
PhCuIO 2 | Number of physical read and write accesses of cursor files |
LgCuIO 2 | Number of logical read and write accesses of cursor files |
Table 27: The STEP-IO-STATISTICS report
1In SESAM/SQL V9.0 and higher, the values from the service tasks are also contained here
2When SUB=SVT, these values come from the service task
Example
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 <date> <time> PAGE 1
//
CREATE-REPORT INPUT-FILE = SESAM.CO-LOG, OUTPUT = SESAM.COSP.OUT.STEPIO, SELECT
= *ALL, REPORT-FORMAT = *PARAMETERS ( PROTOCOL = *STATEMENT ( INFORMATION =
*STEP-IO-STATISTICS ), TIME-PRECISION=*PARAMETERS(CPU-TIME=*MICRO-SECONDS ,
ELAPSED-TIME=*MILLI-SECONDS ))
.
.
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 *** STEP-IO-STATISTICS *** <date> <time> PAGE 25
LFD ITN STID DBC# S# TB# C-ID SUB STM CPUUnits BruttoEl NettoEl PhACIO LgACIO PhDAIO LgDAIO PhCuIO LgCuIO
0203 0005 0045 0001 0045 INT SEL 1132 2 2 0 0 0 0 0 0
0001 02 0002 BTSC 1607 2 2 0 1 0 1 0 0
0205 001B 0047 0001 0047 PRIO OPC 791 10 10 0 0 0 0 0 0
0001 02 0002 BTSC 1761 3 3 0 0 0 0 0 0
0205 001B 0047 0001 0047 OPT OPC 180 0 0 0 0 0 0 0 0
0205 001B 0047 0001 0047 INT OPC 470 1 1 0 0 0 0 0 0
0001 02 0002 BTSC 5943 23 23 0 2 0 2 0 6
SVT 120 1234 890 1200
0206 0026 00B8 0000 AA PRIO 90C 352 1 1 0 0 0 0 0 0
0206 0026 00B8 0000 AA INT 90C 368 1 1 0 0 0 0 0 0
0207 001A 0014 0000 PRIO CTA 688 100 2 0 0 0 0 0 0
0170 0020 01AA 0001 AD PRIO 6 333 2 2 0 0 0 0 0 0
0170 0020 01AA 0001 AD INT 6 583 6 6 0 0 0 0 0 0
0001 02 0002 BTSC 2907 3722 16 0 7 0 2 0 0
0209 000A 0050 0000 PRIO CTA 340 0 0 0 0 0 0 0 0
0201 0011 0C20 0001 A1 PRIO 6 257 0 0 0 0 0 0 0 0
0201 0011 0C20 0001 A1 INT 6 312 0 0 0 0 0 0 0 0
0001 02 0002 BTSC 1412 182 166 0 4 0 0 0 0
01D0 0024 0001 0001 0001 PRIO SQL 1476 2 2 0 0 0 0 0 0
0001 01 0005 BTSC 4435 33 33 0 3 0 3 0 0
01D0 0024 0001 0001 0001 OPT SQL 118578 939 786 0 0 0 0 0 0
0000 00 0000 BTSC 547 1 1 0 0 0 0 0 0
0001 01 0007 BTSC 1629 33 33 0 1 0 1 0 0
0001 01 000B BTSC 2284 16 3 0 2 0 1 0 8
0001 01 000F BTSC 1420 2 2 0 4 0 1 0 0
0001 01 0012 BTSC 50593 459 185 0 2 0 12 3 347
01D0 0024 0001 0001 0001 INT SQL 1080 1 1 0 0 0 0 0 0
0001 02 0002 BTSC 1262 10 10 0 1 0 1 0 0
020A 001B 0048 0001 0047 PRIO FET 497 3 3 0 0 0 0 0 0
020A 001B 0048 0001 0047 OPT FET 2305 15 15 0 0 0 0 0 0
020A 001B 0048 0001 0047 INT FET 606 1 1 0 0 0 0 0 0
0001 02 0002 BTSC 277 0 0 0 0 0 0 0 2
.
.Output of resource statistics for each statement step (complexity)
PROTOCOL=*STATEMENT(INFORMATION=*STEP-COMPLEXITY)
SESCOSP provides this information for each statement step (see the SUB subfunction) and each SQL table.
Heading | Contents |
LFD | See the “The STRING-FORMAT report” |
ITN | See the “The STRING-FORMAT report” |
ST-ID | See the “The STRING-FORMAT report” |
DBC# | See the “The IO-STATISTICS report” |
S# | See the “The STEP-IO-STATISTICS report” |
TB# | See the “The STEP-IO-STATISTICS report” |
C-ID | See the “The IO-STATISTICS report” |
SUB | See the “The STEP-IO-STATISTICS report” |
STM | See the “The STRING-FORMAT report” |
CPUUnits 1 | See the “The STEP-IO-STATISTICS report” |
BruttoEI | See the “The STEP-IO-STATISTICS report” |
NettoEl 1 | See the “The STEP-IO-STATISTICS report” |
#SI | Number of indexes to be evaluated |
#Att | Number of columns (attributes) to be projected |
#Pra | Number of predicates to be checked |
#Dea | Number of deactivations |
#Cal | Number of kernel calls |
#int.SortRec | Number of records in internal SORT requests |
#ext.SortRec | Number of records in external SORT requests |
Table 28: The STEP-COMPLEXITY report
1In SESAM/SQL V9.0 and higher, the values from the service tasks are also contained here
Example
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 <date> <time> PAGE 1
//
CREATE-REPORT INPUT-FILE = SESAM.CO-LOG, OUTPUT = SESAM.COSP.OUT.STCOMP, SELECT
= *ALL, REPORT-FORMAT = *PARAMETERS ( PROTOCOL = *STATEMENT ( INFORMATION =
*STEP-COMPLEXITY ) )
.
.
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 *** STEP-COMPLEXITY *** <date> <time> PAGE 25
LFD ITN STID DBC# S# TB# C-ID SUB STM CPUUnits BruttoEl NettoEl #SI #Att #Pra #Dea #Cal #int.SortRec #ext.SortRec
0203 0005 0045 0001 0045 INT SEL 1 2 2 0
0001 02 0002 BTSC 2 2 2 0 28 0 0 3
0205 001B 0047 0001 0047 PRIO OPC 1 10 10 0
0001 02 0002 BTSC 2 3 3 0 30 1 0 1
0205 001B 0047 0001 0047 OPT OPC 0 0 0 0
0205 001B 0047 0001 0047 INT OPC 0 1 1 0
0001 02 0002 BTSC 6 23 23 0 30 1 0 1
0206 0026 00B8 0000 AA PRIO 90C 0 1 1 0
0206 0026 00B8 0000 AA INT 90C 0 1 1 0
0207 001A 0014 0000 PRIO CTA 1 100 2 0
0170 0020 01AA 0001 AD PRIO 6 0 2 2 0
0170 0020 01AA 0001 AD INT 6 1 6 6 0
0001 02 0002 BTSC 3 3722 16 1 2 1 1 1
SVT 230 1200 13123456 1255100
0209 000A 0050 0000 PRIO CTA 0 0 0 0
0201 0011 0C20 0001 A1 PRIO 6 0 0 0 0
0201 0011 0C20 0001 A1 INT 6 0 0 0 0
0001 02 0002 BTSC 1 182 166 1 2 1 0 1
01D0 0024 0001 0001 0001 PRIO SQL 1 2 2 0
0001 01 0005 BTSC 4 33 33 0 0 0 0 3
01D0 0024 0001 0001 0001 OPT SQL 119 939 786 0
0000 00 0000 BTSC 1 1 1 0 0 0 0 1
0001 01 0007 BTSC 2 33 33 0 8 0 0 3
0001 01 000B BTSC 2 16 3 0 3 3 0 4
0001 01 000F BTSC 1 2 2 0 1 6 0 3
0001 01 0012 BTSC 51 459 185 0 11 3 1 170
01D0 0024 0001 0001 0001 INT SQL 1 1 1 0
0001 02 0002 BTSC 1 10 10 0 29 1 0 3
020A 001B 0048 0001 0047 PRIO FET 0 3 3 0
020A 001B 0048 0001 0047 OPT FET 2 15 15 0
020A 001B 0048 0001 0047 INT FET 1 1 1 0
0001 02 0002 BTSC 0 0 0 0 30 1 0 1
020B 001F 0267 0000 A0 PRIO 90C 0 0 0 0
020B 001F 0267 0000 A0 INT 90C 0 0 0 0
020E 0005 0046 0002 0046 PRIO SEL 0 0 0 0
020E 0005 0046 0002 0046 OPT SEL 2 10 10 0
020E 0005 0046 0002 0046 INT SEL 1 1 1 0
0002 02 0002 BTSC 1 2 2 0 28 0 0 3
020C 0015 003C 0003 003C PRIO SEL 1 1 1 0
020C 0015 003C 0003 003C OPT SEL 2 29 16 0
020C 0015 003C 0003 003C INT SEL 1 1 1 0
0003 04 0005 BTSC 1 3 1 0 28 0 0 3
020F 000D 0CC3 0001 A1 PRIO 90B 0 0 0 0
020F 000D 0CC3 0001 A1 INT 90B 0 0 0 0
0001 02 0002 BTSC 1 1 1 1 2 1 0 1
..
.
Output of transaction statistics
Output of transaction statistics
PROTOCOL=*TRANSACTION
SESCOSP provides the following information for each transaction.
Heading | Contents |
LFD | The sequential number of the transaction's last statement is logged |
DATE | Start date (yyyy-mm-dd) of the transaction |
TIME | Start time (hh:mm:ss) of the transaction |
APPL/TSN | See the “The STRING-FORMAT report” |
USER/PRG | See the “The STRING-FORMAT report” |
TAC/U-ID | See the “The STRING-FORMAT report” |
ITN | See the “The STRING-FORMAT report” |
ST-ID | The number of the transaction's last statement is logged |
CPUUnits 1 | Sum of the CPU time used by all of the transaction's statements in milliseconds or microseconds |
BruttoEI | Sum of the elapsed times of all of the transaction's statements in the DBH (without connection module) |
TransEl | Total time of the transaction, including communication times and the time taken by the user to pause for thought |
PhACIO | Sum of the physical read and write accesses to the access data of all of the transaction's statements |
LgACIO | Sum of the logical read and write accesses to the access data of all of the transaction's statements |
PhDAIO | Sum of the physical read and write accesses to the primary data of all of the transaction's statements |
LgDAIO | Sum of the logical read and write accesses to the primary data of all of the transaction's statements |
PhCuIO | Sum of the physical read and write accesses to the cursor files of all of the transaction's statements |
LgCuIO | Sum of the logical read and write accesses to the cursor files of all of the transaction's statements |
Table 29: The TRANSACTION report
1In SESAM/SQL V9.0 and higher, the values from the service tasks are also contained here
Example
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 <date> <time> PAGE 1
//
CREATE-REPORT INPUT-FILE = SESAM.CO-LOG, OUTPUT = SESAM.COSP.OUT.TA.ALL, SELECT
= *PARAMETERS( CATALOG-NAMES=*ALL ,USERS=*ALL ,STATEMENTS=*ALL ,
TIME-PERIOD=*ALL ,CPU-TIME=*ALL ,ELAPSED-TIME=*ALL ,
NUMBER-OF-LOGICAL-IO=*ALL ), REPORT-FORMAT = *PARAMETERS ( PROTOCOL =
*TRANSACTION, TIME-PRECISION=*PARAMETERS(CPU-TIME=*MICRO-SECONDS ,
ELAPSED-TIME=*MILLI-SECONDS ))
.
.
SESCOSP/SQL VERS. <version> TSN:9H16 ID.:SQLDB112 *** TRANSACTION *** <date> <time> PAGE 2
LFD DATE TIME APPL/TSN USER/PRG TAC/U-ID ITN STID CPUUnits BruttoEl TransEl PhACIO LgACIO PhDAIO LgDAIO PhCuIO LgCuIO
00C9 <date> <time> TSN=1A24 USER0001 DBSRE 0011 0C1A 4685 14 336 0 16 0 2 0 0
00CB <date> <time> TSN=1A24 USER0002 DBSRE 0016 086B 2006 10 124 0 4 0 0 0 1
00D2 <date> <time> TSN=1A23 USER0001 DBSRE 000D 0CB6 5642 102 1684 0 14 0 2 0 0
00D6 <date> <time> TSN=1A25 USER0002 DBSRE 000E 0887 2327 3 43 0 4 0 0 0 1
00D7 <date> <time> TSN=1A2Z USER0002 DBSRE 0004 0287 2576 25 123 0 4 0 0 0 1
00E0 <date> <time> TSN=1A2Z USER0018 DBSRE 0012 026D 2621 73 368 0 4 0 0 0 1
00E1 <date> <time> TSN=1A23 USER0002 DBSRE 0002 0A99 2366 26 197 0 4 0 0 0 1
.
.