Distanz | Länge | Feldinhalt |
Header: | ||
0 | 2 | Länge des Satzes |
2 | 2 | leer |
4 | 3 | Satzkennzeichen "DBH" (abdruckbar) |
7 | 1 | NAM-Kennzeichen des DBH, auf den sich der Datensatz bezieht |
8 | 8 | Zeit im STCK-Format |
16 | 10 | Datum (Format jjjj-mm-tt), Local Time (abdruckbar) |
26 | 8 | Zeitstempel (Format hh:mm:ss), Local Time (abdruckbar) |
34 | 10 | Datum (Format jjjj-mm-tt), Universal Time (abdruckbar) |
44 | 8 | Zeitstempel (Format hh:mm:ss), Universal Time (abdruckbar) |
52 | 12 | Filler für Erweiterungen |
aktuelle Werte: | ||
Werte zur DBH-Maske I/O: | ||
64 | 4 | Number of Spaces |
68 | 4 | Number of Cursor Files |
72 | 4 | Number of LOG Files |
76 | 8 | Filler für Erweiterungen |
84 | 4 | 4Kbyte Blocks / Written Blocks on LOG Files (float) |
88 | 8 | Filler für Erweiterungen |
96 | 64 | Filler für Erweiterungen |
Werte zur DBH-Maske 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 für Erweiterungen |
Werte zur DBH-Maske 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 für Erweiterungen |
Werte zur DBH-Maske 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 für Erweiterungen |
272 | 4 | Parallel Open Spaces |
276 | 4 | Open Cursors |
280 | 4 | Work-Container Maximal |
284 | 4 | Work-Container Current |
288 | 4 | Transfer-Container Maximal |
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 für Erweiterungen |
Werte zur DBH-Maske TRANSACTIONS: | ||
336 | 4 | aktive Users |
340 | 4 | Open TAs |
344 | 4 | Group Commit (float) |
348 | 4 | Group Commit/IV (float) |
Werte zur DBH-Maske STATEMENTS: | ||
352 | 4 | Statements Number |
356 | 4 | Statements Active |
360 | 4 | Statements Waiting |
364 | 20 | Filler für Erweiterungen |
kumulative Werte: | ||
Werte zur DBH-Maske 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 für Erweiterungen |
Werte zur DBH-Maske SERVICE TASKS: | ||
496 | 4 | Number of Orders |
500 | 12 | Filler für Erweiterungen |
Werte zur DBH-Maske 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 Authorization1 |
564 | 4 | Number of Authentication Opt.1 |
568 | 4 | Number of Authorization Opt.1 |
572 | 36 | Filler für Erweiterungen |
Werte zur DBH-Maske 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 für Erweiterungen |
Werte zur DBH-Maske STATEMENTS: | ||
640 | 4 | Statements Local DML |
644 | 4 | Statements Local SQL |
648 | 4 | Statements Remote DML |
652 | 4 | Statements Remote SQL |
656 | 16 | Filler für Erweiterungen |
Nicht auf Maske ausgegebene Werte: | ||
672 | 10 | DBH Session Begin Datum (Format jjjj-mm-tt, local time)2 |
682 | 8 | DBH Session Begin Zeit (Format hh:mm:ss, local time) 2 |
Tabelle 36: Layout des DBH-Satzes
1Feld wird nur auf SYSLST und in Datei ausgegeben
2Feld wird nur in Datei ausgegeben