Previous Topic: VMJRAW: RECTYP = 'A9' and CARDTYP = 'C0' (CA VM:Archiver Usage)

Next Topic: VMJRAW: RECTYP = 'AB' and CARDTYP = 'C0' (CA VM:Spool Usage)

VMJRAW: RECTYP = 'AA' and CARDTYP = 'C0' (SQL Usage )

Field Name

Start

Length

Display

Type

Default Column Header

Description

SQLVMID

1

8

 

A/N

MACHINE USERID

User ID creating the record

SQLDUSER

9

8

 

A/N

VM USERID

VM user ID

SQLDUIDN

17

8

 

A/N

SQL USER IDENTIFIER

SQL user identifier

SQLDACNT

25

8

 

A/N

ACCOUNT NUMBER

User data account number

SQLDBASE

33

8

 

A/N

DATABASE NAME

User data database name

SQLEDATE

41

6

 

A/N

END DATE

End date

SQLETIME

47

6

 

A/N

END TIME

End time

SQLPROG

53

8

 

A/N

LAST ACTIVE MODULE

SQL/DS access module last active

SQLACTV

61

4

9,999,999,999

BINP

ACTIVE TIME

SQL/DS time that the user was connected (in seconds)

SQLCPU

65

4

9,999,999,999

BINP

CPU USAGE

SQL/DS processor time used (in milliseconds)

SQLBUFF

69

4

9,999,999,999

BINP

BUFFER READS

Number of looks into the page buffer

SQLRECTYP

75

1

 

A/N

REC TYPE

Record type-code (U)

SQLRECID

76

3

 

A/N

REC ID

Record identifier (SQL)