CAWGJRD2 Glossary

CAWGJRD2/RECORD

1

374

H

NV

RECORD IN HEX

USER/ID

1

8

C

AUTHORIZATION ID

SYS/ID

9

4

C

SMF SYSTEM ID

FILLER01

13

1

B

FILLER

CONNECT/DATE

14

3

P

YYDDD NV

DATE CONNECTED

CONNECT/TOD

17

4

B

.2 HS NV

TIME CONNECTED, 1/100 SEC

CONNECTION/NAME

21

8

C

USERS HOST

PLAN/NAME

29

8

C

PLAN NAME

CORRELATION/ID

37

12

C

CORRELATION ID

NETWORK/ID

49

16

C

NETWORK ID

SUBSYS/ID

65

4

C

WHAT YOU NAMED DB2

RELEASE/IND

69

1

B

NV

DB2 RELEASE INDICATOR

FILLER02

70

1

B

NV

RESERVED FIELD

REASON/CODE

71

2

B

NV

, FOR ACCOUNTING INVOCATION

IFCID#

73

4

B

NV

, SEQUENCE NUMBER FOR

DESTINATION#

77

4

B

NV

, SEQUENCE NUMBER FOR

TRACE#/MASK

81

4

B

NV

ACTIVE TRACE NUMBER MASK

COMMITS

85

4

B

NUMBER OF COMMITS

ABORTS

89

4

B

NUMBER OF ABORTS

CONNECT/TIME

93

4

B

.2 KS

ELAPSED 1/100 SEC

CPU/TIME

97

4

B

.2 KS

TCB CPU 1/100 SEC

SRB/TIME

101

4

B

.2 KS

SRB CPU 1/100 SEC

IO/WAIT/TIME

105

4

B

.2 KS

IO WAIT 1/100 SEC (CLASS 3)

LOCK/TIME

109

4

B

.2 KS

LL TIME 1/100 SEC (CLASS 3)

WAIT/EVENTS

113

4

B

WAIT TRACE EVENTS (CLASS 3)

TRACE/EVENTS

117

4

B

ENTRY/EXIT EVENTS (CLASS 2)

GET/PAGE/BP0

121

4

B

NUMBER OF GET PAGE REQUEST

EXPAND/BP0

125

4

B

" CAUSING BP EXPANSION

SYSPAGE/UP/BP0

129

4

B

UPDATE SYSPAGE

UWPAGE/UP/BP0

133

4

B

UPDATE UNIT OF WORK PAGE

READ/SYNC/BP0

137

4

B

SYNCHRONOUS READ REQUEST

READ/PREF/BP0

141

4

B

REPFETCH READ REQUEST

GET/PAGE/BP1

145

4

B

NUMBER OF GET PAGE REQUEST

EXPAND/BP1

149

4

B

" CAUSING BP EXPANSION

SYSPAGE/UP/BP1

153

4

B

UPDATE SYSPAGE

UWPAGE/UP/BP1

157

4

B

UPDATE UNIT OF WORK PAGE

READ/SYNC/BP1

161

4

B

SYNCHRONOUS READ REQUEST

READ/PREF/BP1

165

4

B

REPFETCH READ REQUEST

GET/PAGE/BP2

169

4

B

NUMBER OF GET PAGE REQUEST

EXPAND/BP2

173

4

B

" CAUSING BP EXPANSION

SYSPAGE/UP/BP2

177

4

B

UPDATE SYSPAGE

UWPAGE/UP/BP2

181

4

B

UPDATE UNIT OF WORK PAGE

READ/SYNC/BP2

185

4

B

SYNCHRONOUS READ REQUEST

READ/PREF/BP2

189

4

B

REPFETCH READ REQUEST

GET/PAGE/BP32

193

4

B

NUMBER OF GET PAGE REQUEST

EXPAND/BP32

197

4

B

" CAUSING BP EXPANSION

SYSPAGE/UP/BP32

201

4

B

UPDATE SYSPAGE

UWPAGE/UP/BP32

205

4

B

UPDATE UNIT OF WORK PAGE

READ/SYNC/BP32

209

4

B

SYNCHRONOUS READ REQUEST

READ/PREF/BP32

213

4

B

REPFETCH READ REQUEST

DEADLOCK

217

4

B

NUMBER OF DEADLOCKS

SUSPEND/LOCK

221

4

B

HAD TO WAIT FOR LOCK, COUNT

TIMEOUT/LOCK

225

4

B

TIMED-OUT WAITING, COUNT

ESCALATE/SHR

229

4

B

LOCK ESCALATED TO SHARE MODE

ESCALATE/EXC

233

4

B

LOCK ESCALATED TO EXCL. MODE

LOCKS/HELD

237

4

B

MAXIMUM PAGE LOCKS HELD

SELECT

241

4

B

SQL SELECT

INSERT

245

4

B

SQL INSERT

UPDATE

249

4

B

SQL UPDATE

DELETE

253

4

B

SQL DELETE

DESCRIBE

257

4

B

SQL DESCRIBE

PREPARE

261

4

B

SQL PREPARE

OPEN

265

4

B

SQL OPEN

CLOSE

269

4

B

SQL CLOSE

CREATE/TABLE

273

4

B

SQL CREATE TABLE

CREATE/INDEX

277

4

B

SQL CREATE INDEX

CREATE/TABLESP

281

4

B

SQL CREATE TABLESPACE

CREATE/SYNONYM

285

4

B

SQL CREATE SYNONYM

CREATE/DATABASE

289

4

B

SQL CREATE DATABASE

CREATE/STOGROUP

293

4

B

SQL CREATE STORAGE GROUP

CREATE/VIEW

297

4

B

SQL CREATE VIEW

DROP/INDEX

301

4

B

SQL DROP INDEX

DROP/TABLE

305

4

B

SQL DROP TABLE

DROP/TABLESP

309

4

B

SQL DROP TABLESPACE

DROP/DATABASE

313

4

B

SQL DROP DATABASE

DROP/SYNONYM

317

4

B

SQL DROP SYNONYM

DROP/STOGROUP

321

4

B

SQL DROP STOGROUP

DROP/VIEW

325

4

B

SQL DROP VIEW

ALT/STOGROUP

329

4

B

SQL ALTER STOGROUP

FETCH

333

4

B

SQL FETCH

ALT/TABLESP

337

4

B

SQL ALTER TABLESPACE

ALT/TABLE

341

4

B

SQL ALTER TABLE

ALT/INDEX

345

4

B

SQL ALTER INDEX

COMMENT/ON

349

4

B

SQL COMMENT ON

LOCK/TABLE

353

4

B

SQL LOCK TABLE

GRANT

357

4

B

SQL GRANT

REVOKE

361

4

B

SQL REVOKE

BIND

365

4

B

SQL INCREMENTAL BIND

LABEL/ON

369

4

B

SQL LABEL ON