There are three kinds of accounting records generated for users:
Accounting records are also generated for system processes that cannot be attributed to a single user:
| Note: | Internal resource thresholds are not used for system processes. |
Columns: 1 9 17 25 41 53 57 61 65 69 73 75 79 | | | | | | | | | | | | | SQLDBA SQL/DS INIT 051389182005 19 ISQLC0
| Column | Data Type | Description |
|---|---|---|
| 1-8 | CHAR (8) | VM user ID of the database machine (fixed by CP) |
| 9-16 | CHAR (8) | "SQL/DS " |
| 17-24 | CHAR (8) | "INIT " |
| 25-40 | CHAR (16) | Reserved (blanks) |
| 41-52 | CHAR (12) | Date and time of the accounting record (MMDDYYHHMMSS) |
| 53-56 | CHAR (4) | Blank |
| 57-60 | CHAR (4) | Blank |
| 61-64 | INTEGER | Duration of the startup process (in seconds) |
| 65-68 | INTEGER | Processor time used by the startup process (in milliseconds) |
| 69-72 | INTEGER | Number of times the database manager looked at a page buffer during startup (equivalent to issuing COUNTER LPAGBUFF immediately after startup) |
| 73-74 | CHAR (2) | Century number of Date ('19' or '20') |
| 75-78 | CHAR (4) | The xSQL identifier to separate DB2 Server for VM accounting records from other VM accounting records, where x = I for Initialization |
| 79-80 | CHAR (2) | Record identifier (character X'C0') fixed by CP |
Columns: 1 9 17 25 41 53 57 61 65 69 73 75 79 | | | | | | | | | | | | | SQLDBA SQL/DS SYSTEM 051389182005 0083032819 CSQLC0
| Column | Data Type | Description |
|---|---|---|
| 1-8 | CHAR (8) | VM user ID of the database machine (fixed by CP) |
| 9-16 | CHAR (8) | "SQL/DS " |
| 17-24 | CHAR (8) | "SYSTEM " |
| 25-40 | CHAR (16) | Reserved (blanks) |
| 41-52 | CHAR (12) | Date and time of the accounting record (MMDDYYHHMMSS) |
| 53-56 | CHAR (4) | Blank |
| 57-60 | CHAR (4) | Blank |
| 61-64 | INTEGER | Binary zero |
| 65-68 | INTEGER | Processor time used (in milliseconds) |
| 69-72 | INTEGER | Number of times this agent looked at a page buffer (equivalent to issuing COUNTER LPAGBUFF for only this agent) |
| 73-74 | CHAR (2) | Century number of Date ('19' or '20') |
| 75-78 | CHAR (4) | The xSQL identifier to separate DB2 Server for VM accounting records from other VM accounting records, where x = C for Checkpoint or O for Operator). |
| 79-80 | CHAR (2) | Record identifier (character X'C0') fixed by CP |
Columns: 1 9 17 25 41 53 57 61 65 69 73 75 79 | | | | | | | | | | | | | SQLDBA SQL/DS TERM 051389182005 19 TSQLC0
| Column | Data Type | Description | ||
|---|---|---|---|---|
| 1-8 | CHAR (8) | VM user ID of the database machine (fixed by CP) | ||
| 9-16 | CHAR (8) | "SQL/DS " | ||
| 17-24 | CHAR (8) | "TERM " | ||
| 25-40 | CHAR (16) | Reserved (blanks) | ||
| 41-52 | CHAR (12) | Date and time of the accounting record (MMDDYYHHMMSS) | ||
| 53-56 | CHAR (4) | Blank | ||
| 57-60 | CHAR (4) | Blank | ||
| 61-64 | INTEGER | Time, in seconds, from startup to shutdown | ||
| ||||
| 65-68 | INTEGER | DASDIO - Total number of DASD I/Os | ||
| 69-72 | INTEGER | LPAGBUFF - Number of times the database manager looked at a page buffer | ||
| 73-74 | CHAR (2) | Century number of Date ('19' or '20') | ||
| 75-78 | CHAR (4) | The xSQL identifier to separate DB2 Server for VM accounting records from other VM accounting records, where x = T for Termination | ||
| 79-80 | CHAR (2) | Record identifier (character X'C0') fixed by CP | ||
Columns: 1 9 17 25 41 53 57 61 65 69 73 75 79 | | | | | | | | | | | | | SQLDBA JESSICA MYID A1015TEST 051389182005BADDEBTS 19 USQLC0
| Column | Data Type | Description | ||
|---|---|---|---|---|
| 1-8 | CHAR (8) | VM user ID of the database machine (fixed by CP) | ||
| 9-16 | CHAR (8) | VM user ID of the user machine accessing the application server | ||
| 17-24 | CHAR (8) | DB2 Server for VM authorization ID that was established, implicitly or explicitly, using the connect process. Unless the user explicitly changed the connected user ID, the DB2 Server for VM user ID is the same as the VM user ID. | ||
| 25-40 | CHAR (16) | If you have coded your own ARIUXIT exit to generate installation-supplied
data, this data is placed here for CMS applications. If you have not
coded such as exit, this contains character blanks for CMS
applications.
For non-VM DRDA applications, upt o 16 bytes of user-supplied data is put here. For more information, see Supplying Accounting Data from DRDA Applications. | ||
| 41-52 | CHAR (12) | Date and time of the accounting record (MMDDYYHHMMSS) | ||
| 53-60 | CHAR (8) | The name of the package that was last active for the application | ||
| ||||
| 61-64 | INTEGER | Active time (that is, time that the user was connected to an agent) in seconds | ||
| 65-68 | INTEGER | Processor time used (in milliseconds) | ||
| 69-72 | INTEGER | Number of times this agent looked at a page buffer (this value is equivalent to the LPAGBUFF counter value for an individual user) | ||
| 73-74 | CHAR (2) | Century number of Date ('19' or '20') | ||
| 75-78 | CHAR (4) | The xSQL identifier to separate DB2 Server for VM accounting records from other VM accounting records, where x = U for User | ||
| 79-80 | CHAR (2) | Record identifier (character X'C0') fixed by CP | ||
Columns: 1 9 17 25 37 64 73 75 79 | | | | | | | | | SQLDBA JESSICA MYID 051389182005nnTORONET.SP6AGATnnnnnnnn 19RSQLC0
| Column | Data Type | Description |
|---|---|---|
| 1-8 | CHAR (8) | VM user ID of the database machine (application server) |
| 9-16 | CHAR (8) | Access user ID of the application or interactive user (application requester) accessing the application server |
| 17-24 | CHAR (8) | DB2 Server for VM authorization ID that was established, implicitly or explicitly, using the connect process |
| 25-36 | CHAR (12) | Date and time of the accounting record (MMDDYYHHMMSS) |
| 37-63 | CHAR(27) | LU 6.2 LUWID. This field is composed of the following
subfields:
If the LUWID is less than 25 bytes, the remaining columns are padded with blanks |
| 64-72 | Reserved | |
| 73-74 | CHAR (2) | Century number of Date ('19' or '20') |
| 75-78 | CHAR (4) | The xSQL identifier to separate the DB2 Server for VM accounting records from other VM accounting records, where x = R for remote user |
| 79-80 | CHAR (2) | Record identifier (character 'C0') fixed by CP |
Columns: 1 9 17 25 41 53 57 61 65 69 73 75 79 | | | | | | | | | | | | SQLDBA VSEMCH1 MYID USER DATA HERE 051389182005DEBTS 19USQLC0
| Column | Data Type | Description | ||
|---|---|---|---|---|
| 1-8 | CHAR (8) | VM user ID of the database machine (fixed by CP) | ||
| 9-16 | CHAR (8) | For batch and VSE/ICCF environments, the jobname of the user partition. For online environments, the VM user ID of the VSE machine. (The example record above is for online environments.) | ||
| 17-24 | CHAR (8) | DB2 Server for VM connected authorization ID that was established using the connect process (this can be an explicit or implicit connection) | ||
| 25-40 | CHAR (16) | Installation-supplied data. If you are in a batch or VSE/ICCF
environment, and have not coded an accounting exit that supplies information
to this field, the database manager leaves character blanks. In an
online environment, if you have not coded an accounting exit to supply the
information, the following is put in the field:
| ||
| 41-52 | CHAR (12) | Date and time of the accounting record (MMDDYYHHMMSS) | ||
| 53-60 | CHAR (8) | The name of the package that was last active for the application (also referred to as prepname or program name) | ||
| ||||
| 61-64 | INTEGER | Active time (the time that the user was connected to an agent) in seconds | ||
| 65-68 | INTEGER | Processor time used (in milliseconds). In the VSE guest user accounting record passed to VM/ESA, processor time is recorded in thousandths of a second (milliseconds). | ||
| 69-72 | INTEGER | Number of times this agent looked at a page buffer (equivalent to the LPAGBUFF counter value for an individual user) | ||
| 73-74 | CHAR (2) | Century number of Date ('19' or '20') | ||
| 75-78 | CHAR (4) | The xSQL identifier to separate DB2 Server for VM accounting records from other VM accounting records, where x = U for User. | ||
| 79-80 | CHAR (2) | Record identifier (character X'C0') fixed by CP | ||