Previous Topic: VMJAREC3: CARDTYP = 'A9' (CA VM:Archiver Usage)

Next Topic: VMJAREC3: CARDTYP = 'AB' (CA VM:Spool Usage)

VMJAREC3: CARDTYP = 'AA' (SQL Usage)

Field Name

Start

Length

Display

Type

Default Column Header

Description

SQLDBASE

29

8

 

A/N

DATABASE NAME

SQL/DS Database name

SQLUSRID

37

8

 

A/N

USER IDENTIFIER

SQL/DS User identifier

SQLVMID

45

8

 

A/N

MACHINE USERID

SQL/DS Database machine user ID

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)

SQLACTV$

185

4

99,999,990.99

BINP

COST FOR CONNECT TIME

Cost for active time

SQLCPU$

189

4

99,999,990.99

BINP

COST FOR CPU USAGE

Cost for CPU usage

SQLPBUF$

193

4

99,999,990.99

BINP

COST FOR BUFFER READS

Cost for page buffer reads