Local Data Area View Description

#### Search Results

Search

# 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.