Local Data Area View Description

In the following table, all fields are listed and described in the order in which they appear in the local data area L-NMHIST. The actual file listing follows the table.

The letter D in the DE column indicates that the field is a descriptor. A format indicator followed by a numeric field length is found in the Format/Length column. Possible format indicators include A (alphanumeric), B (binary), and N numeric.

Lvl/Field DE Format/
Length
Description
1 REVIEW-NM-FILE-VIEW     View name to be used when reading the Natural Review repository file.
2 CONTROL-FIELDS     History record control fields group name.
3 NM-SUBSYSTEM   A2 Natural Monitor subsystem type. Response time subsystem history records have a NM-SUBSYSTEM value of RT.
3 NM-DATE-SAVED   N8.0 For RT subsystem history reports this field contains the date (in YYYYMMDD format) that the record was saved.
3 NM-TIME-SAVED   N6.0 For RT subsystem history reports this field contains the time (in HHMMSS 24-hour format) that the record was saved.
3 NM-DATE-COMPLEMENT   N8.0 For RT subsystem history reports this field contains the twos-complement of the date that the record was saved.
3 NM-TIME-COMPLEMENT   N6.0 For RT subsystem history reports this field contains the twos-complement of the time that the record was saved.
3 NM-SORT-FLD   A32 For RT subsystem history reports this field contains the report name for which the record was saved.
3 NM-SEQ   B2 For RT subsystem history reports this field contains the record sequence number for the record that was written. A value of 1 in this field denotes that the record is a response time interval record (corresponding to the VW and VH display). A value greater than 1 in this field denotes the record sequence number for detailed records.
2 NM-RECORD-TYPE   B4 This field is not currently used.
2 RESPONSE-TIME-SUBSYSTEM     Response time subsystem fields group name.

The following fields refer to response time subsystem report definitions (ER (edit report) command):

Lvl/Field DE Format/
Length
Description
3 RT-REPORT-NAME   A32 Report name.
3 RT-DEF-INTERVAL   B2 Graphing interval parameter.
3 RT-DEF-THRESHOLD   B2 Response time threshold at which a detail record is to be created.
3 RT-DEF-MAX-DETAIL   B2 Number of detail records to be retained.
3 RT-DEF-WRAP-OPTION   A4 Detail record wrapping option.
3 RT-DEF-TS-OPTION   A4 Transaction summary record option.
3 RT-DEF-AUTOSTART   A1 Autostart indicator.
3 RT-DEF-HISTORY-INTERVAL   N3.0 History interval (in minutes).
3 RT-DEF-USERID   A8 User ID selection criterion.
3 RT-DEF-PGMNAME   A8 TP transaction program name selection criterion.
3 RT-DEF-NATAPPL   A8 Natural application selection criterion.
3 RT-DEF-NATPGM   A8 Natural program selection criterion.
3 RT-DEF-HISTORY-REFRESH   A1 History refresh indicator.

The following fields refer to response time subsystem interval data historical records (VW and VH (view and view horizontal) commands):

Lvl/Field DE Format/
Length
Description
3 RT-VW-START-DATE   A8 Start date for interval data historical record (for DATE=OLD in YY/MM/DD format; for DATE=NEW in YYYYMMDD format).
3 RT-VW-START-TIME   A8 Start time for interval data historical record (in HH:MM:SS 24-hour format).
3 RT-VW-THRESHOLD   B4 Interval threshold specified.
2 RT-VW-DATA     Periodic group for interval data historical record.
3 RT-VW-INTERVAL   B4(1:11) MU containing the intervals for which the interval data historical record was created.
3 RT-VW-TRANS   B4(1:11) MU containing the number of transactions for each interval.
3 RT-VW-ACALLS   B4(1:11) MU containing the number of database calls for each interval.

The following fields refer to response time subsystem detailed transaction historical records (VD (view detail) command):

Lvl/Field DE Format/
Length
Description
2 RT-VD-USERID   A8 TP system user ID.
2 RT-VD-TERMINAL-NAME   A8 TP system terminal name for RT subsystem historical detailed record.
2 RT-VD-NATURAL-UID   A8 Natural user ID (*USER).
2 RT-VD-PROGRAM   A8 TP system transaction program name.
2 RT-VD-TRANS-ENDTIME   A8 The transaction end time (in HH:MM:SS 24-hour format).
2 RT-VD-TRANS-NUMBER   B4 The TP system transaction number.
2 RT-VD-ADABAS-CALLS   B4 The total number of database calls issued.
2 RT-VD-ADABAS-CALLS-TR   B4 The total number of database calls issued for which Natural Monitor has been able to calculate a database elapsed time.
2 RT-VD-TOTAL-ELAPSE-TIME   B4 The total database elapse time (in milliseconds) for all database calls issued.
2 RT-VD-TOTAL-COMMAND-TIME   B4 The total database command time (in units of 16 microseconds) for all database calls issued.
2 RT-VD-RSP-TIME   B4 The response time (in milliseconds).
2 RT-VD-CPU-TIME   B4 This field is not currently used.
2 RT-VD-HIGH-CMD   A2 The database command issued by the Natural program that had the highest database command time.
2 RT-VD-HIGH-DBID   B2 The database ID accessed by the Natural program that had the highest database command time.
2 RT-VD-HIGH-FNR   B2 The database FNR accessed by the Natural program that had the highest database command time.
2 RT-VD-HIGH-STMT   B3 The Natural statement number that generated the database command within the Natural program that had the highest database command time.
2 RT-VD-HIGH-LEVEL   B1 The Natural call level of the Natural program that had the highest database command time.
2 RT-VD-THREAD-NUMBER   B1 The Natural thread number that was used by the Natural transaction.
2 RT-VD-HIGH-ADABAS-CALLS   B4 The total number of database calls issued by the Natural program that had the highest database command time
2 RT-VD-HIGH-NATURAL-LOADS   B4 The total number times the Natural program that had the highest database command time was loaded.
2 RT-VD-HIGH-ELAPSE-TIME   B4 The database elapsed time for the Natural program that had the highest database command time.
2 RT-VD-HIGH-COMMAND-TIME   B4 The database command time for the Natural program that had the highest database command time.

The following fields are superdescriptors used to read the Natural Review repository file:

Lvl/Field DE Format/
Length
Description
2 NM-KEY D A50 Primary search key superdescriptor for reading the Natural Review repository file.
2 NM-KEY-2S D A50 Secondary twos-complement search key superdescriptor for reading the Natural Review repository file.
2 NM-KEY1 D A48 Internal use search key superdescriptor for reading the Natural Review repository file.
2 NM-KEY1-2S D A48 Internal use search key superdescriptor for reading the Natural Review repository file.
2 NM-KEY2-2S D A16 Internal use search key superdescriptor for reading the Natural Review repository file.