Distance | Length | Field contents |
Header: | ||
0 | 2 | Length of the record |
2 | 2 | Empty |
4 | 3 | “DBH” record ID (printable) |
7 | 1 | NAM ID of the DBH to which the record refers (printable) |
8 | 8 | Time in STCK format |
16 | 10 | Date (yyyy-mm-dd), local time (printable) |
26 | 8 | Timestamp ( hh:mm:ss), local time (printable) |
34 | 10 | Date (format yyyy-mm-dd), universal time (printable) |
44 | 8 | Time stamp (format hh:mm:ss), universal time (printable) |
52 | 12 | Filler for extensions |
Current values: | ||
Values for the DBH form I/O: | ||
64 | 4 | Number of Spaces |
68 | 4 | Number of Cursor Files |
72 | 4 | Number of LOG Files |
76 | 8 | Filler for extensions |
84 | 4 | 4Kbyte Blocks / Written Blocks on LOG Files (float) |
88 | 8 | Filler for extensions |
96 | 64 | Filler for extensions |
Values for the DBH form SERVICE TASKS: | ||
160 | 4 | Service Tasks Maximal |
164 | 4 | Service Tasks Current |
168 | 4 | Service Tasks Active |
172 | 4 | Service Tasks Free |
176 | 4 | Service Tasks Load (float) |
180 | 4 | Orders Not Processed |
184 | 4 | Orders Not Fetched |
188 | 4 | Filler for extensions |
Values for the DBH form SQL INFORMATION: | ||
192 | 4 | Max. SQL Cursors |
196 | 4 | Act. SQL Cursors |
200 | 4 | Plans: Number per DBH-Option |
204 | 4 | Plan Buffer: Number of Plans |
208 | 4 | Plan Buffer: Size of Primary Buffer |
212 | 4 | Plan Buffer: Occupation of Primary Buffer |
216 | 4 | Plan Buffer: Size of Secondary Buffer |
220 | 20 | Filler for extensions |
Values for the DBH form SYSTEM INFORMATION: | ||
240 | 4 | Active Suborders for CALL DML |
244 | 4 | Active Suborders for SQL DML |
248 | 4 | Available Suborders Maximal |
252 | 4 | Available Suborders Current |
256 | 4 | Used Suborders Maximal |
260 | 4 | Used Suborders Current |
264 | 8 | Filler for extensions |
272 | 4 | Parallel Open Spaces |
276 | 4 | Open Cursors |
280 | 4 | Work Container Maximum |
284 | 4 | Work-Container Current |
288 | 4 | Transfer-Container Maximum |
292 | 4 | Transfer-Container Current |
296 | 4 | Threads Active |
300 | 4 | Threads Ready |
304 | 4 | Threads Free |
308 | 4 | Threads Waiting |
312 | 4 | Threads TA-Lock |
316 | 4 | Threads Service Task |
320 | 4 | Threads I/O |
324 | 4 | Valid Logging-Info - Number of Blocks |
328 | 8 | Filler for extensions |
Values for the DBH form TRANSACTIONS: | ||
336 | 4 | Active users |
340 | 4 | Open TAs |
344 | 4 | Group Commit (float) |
348 | 4 | Group Commit/IV (float) |
Values for the DBH form STATEMENTS: | ||
352 | 4 | Statements Number |
356 | 4 | Statements Active |
360 | 4 | Statements Waiting |
364 | 20 | Filler for extensions |
Cumulative values: | ||
Values for the DBH form I/O: | ||
384 | 4 | Log. Read on Spaces |
388 | 4 | Log. Write on Spaces |
392 | 4 | Phys. Read on Spaces |
396 | 4 | Phys. Write on Spaces |
400 | 4 | Log. Read on Spaces (System Data) |
404 | 4 | Log. Write on Spaces (System Data) |
408 | 4 | Phys. Read on Spaces (System Data) |
412 | 4 | Phys. Write on Spaces (System Data) |
416 | 4 | Log. Read on Spaces (User Data) |
420 | 4 | Log. Write on Spaces (User Data) |
424 | 4 | Phys. Read on Spaces (User Data) |
428 | 4 | Phys. Write on Spaces (User Data) |
432 | 4 | Log. Read on Cursor Files |
436 | 4 | Log. Write on Cursor Files |
440 | 4 | Phys. Read on Cursor Files |
444 | 4 | Phys. Write on Cursor Files |
448 | 4 | Phys. Read on LOG Files |
452 | 4 | Phys. Write on LOG Files |
456 | 4 | Phys. Read on DA-LOG and CAT-LOG |
460 | 4 | Phys. Write on DA-LOG and CAT-LOG |
464 | 4 | Phys. Read on TA-LOG |
468 | 4 | Phys. Write on TA-LOG |
472 | 24 | Filler for extensions |
Values for the DBH form SERVICE TASKS: | ||
496 | 4 | Number of Orders |
500 | 12 | Filler for extensions |
Values for the DBH form SQL INFORMATION: | ||
512 | 4 | SQL DML |
516 | 4 | UPDATE |
520 | 4 | RETRIEVAL |
524 | 4 | SQL DDL/SSL |
528 | 4 | SQL UTI |
532 | 4 | Plans: Accesses Core |
536 | 4 | Plans: Generated |
540 | 4 | Number of Calls Kernel Control |
544 | 4 | Number of Calls Catalog Manager |
548 | 4 | Number of Calls CALL DML Handler |
552 | 4 | Number of Sort Operations |
556 | 4 | Number of Calls Authentication1 |
560 | 4 | Number of Calls Authorization 1 |
564 | 4 | Number of Authentication Opt.1 |
568 | 4 | Number of Authorization Opt.1 |
572 | 36 | Filler for extensions |
Values for the DBH form TRANSACTIONS: | ||
608 | 4 | Number of Transactions |
612 | 4 | Number of Retrieval Transactions |
616 | 4 | Number of Update Transactions |
620 | 4 | Number of Reset Transactions |
624 | 4 | Number of Locks |
628 | 12 | Filler for extensions |
Values for the DBH form STATEMENTS: | ||
640 | 4 | Statements Local DML |
644 | 4 | Statements Local SQL |
648 | 4 | Statements Remote DML |
652 | 4 | Statements Remote SQL |
656 | 16 | Filler for extensions |
Values not output in a form: | ||
672 | 10 | DBH session begin date (format yyyy-mm-dd, local time)2 |
682 | 8 | DBH session begin time (format hh:mm:ss, local time) 2 |
Table 36: Layout of the DBH record
1Field is only output to SYSLST and to a file
2Field is only output to a file