Previous Topic: OPER WATCH DB ParametersNext Topic: OPER WATCH LTERM


OPER WATCH DB Usage

Display update frequency

Displays are updated every five seconds or at the interval specified in the OPER TIME command. (In some cases, such as under UCF, you must press Enter to update the screen with the most current information.)

OPER WATCH DB display

The following table explains the information displayed from the OPER WATCH DB command.

Field displayed

Description/meaning

TASK ID

Task thread ID (8-digit system-assigned value)

ORIG

ID of the originating interface, such as DBDC or BATC

IDMSPROG

Name of the program associated with the run unit

SUBSCHM

Name of the subschema invoked by the program

PRI

Priority

STA

Status

Note: For more information about a matrix of the possible transaction status values, see the section DCMT DISPLAY TRANSACTION.

V#

Verb number of the last DML statement issued

PAGEREAD

Number of pages read from disk for the transaction

PAGEWRIT

Number of pages written to disk for the transaction

CALLIDMS

Number of calls made to CA IDMS

LOCK-REQ

Number of calls made to the database key-locking routine

OPER WATCH DB IO

The following table explains the information displayed from the OPER WATCH DB IO command.

Field displayed

Description/meaning

Task-ID

Task thread ID (8-digit system-assigned value)

Org/Ltrm

ID of the originating logical terminal

IDMSPROG

Name of the program associated with the database I/O operation

PagReq

Number of pages requested from disk for the transaction

PgRead

Number of requests to read from disk for the transaction (the number of start IOs for chained processing plus the number of pages physically read through unchained processing)

StIO

Number of start IOs issued for chained processing

PgIO

Total number of pages physically read using chained processing

WrtRq

Number of pages requested to be written to disk for the transaction

PgWrt

Number of pages written to disk for the transaction

JrWrt

Number of database I/O operations written to the journal

Rd/Wt

Number of times the target database buffer selected by a transaction already contained a page that had to be written

OPER WATCH DB IOD

This following table explains the information displayed from the OPER WATCH DB IOD command that is in addition to the information displayed by the OPER WATCH DB IO command.

Field displayed

Description/meaning

Driver

Type of driver

Area

Name of the area associated with the driver

Pg/IO

Ratio pages read to start IOs

JWait

Number of times the write driver had to wait for another task to finish writing to the journal

Examples: OPER WATCH DB DBNAME Output

This example shows the output from the OPER WATCH DB command:

IDMS-DC Release 1700 Display DB activity Line 1 of 15 Task Id Orig IDMSProg Subschem Pri Sta V# PageRead PageWrit CallIDMS LOCK-Rq 000000010 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003 00000001 0000000009 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003 00000001 0000000008 DBDC RHDCLGSD IDMSNWK9 253 A 56 00000000 00000000 00000003 00000001 0000000007 DBDC RHDCRUAL IDMSSECS 253 A 95 00000000 00000000 00000008 00000001 0000000007 DBDC RHDCRUAL IDMSSECS 253 A 95 00000002 00000000 00000013 00000001 0000000006 DBDC RHDCRUAL IDMSNWK8 253 A 54 00000000 00000000 00000003 00000001 0000000006 DBDC RHDCRUAL IDMSNWK8 253 A 54 00000000 00000000 00000003 00000001 0000000005 DBDC RHDCRUAL IDMSSECU 253 A 54 00000000 00000000 00000004 00000001 0000000005 DBDC RHDCRUAL IDMSSECU 253 A 95 00000002 00000000 00000027 00000001 0000000004 DBDC RHDCRUAL IDMSNWK6 253 A 95 00000000 00000000 00000009 00000001 0000000004 DBDC RHDCRUAL IDMSNWK6 253 A 95 00000039 00000000 00001749 00000001 0000000003 DBDC RHDCRUAL IDMSNWKL 253 A 54 00000000 00000000 00000003 00000001 0000000003 DBDC RHDCRUAL IDMSNWKL 253 A 54 00000000 00000000 00000003 00000001 0000000002 DBDC RHDCRUAL IDMSNWK7 253 A 54 00000000 00000000 00000003 00000001 0000000002 DBDC RHDCRUAL IDMSNWK7 253 H 95 00000015 00000000 00000139 00000040 ******************************* LAST PAGE **********************************

IDMS DB/DC V72 - Tasks active:31 Time: 09:38:38

This example shows the output from the OPER WATCH DB IO command:

IDMS-DC Release 1700 Display DB IO activity Line 1 of 15 Task Id Org/Ltrm IDMSProg PagReq PgRead StIO PgIO WrtRq PgWrt JrWrt R/W 00000010 DBDC RHDCLGSD 0 0 0 0 0 0 0 0 00000009 DBDC RHDCLGSD 0 0 0 0 0 0 0 0 00000008 DBDC RHDCLGSD 0 0 0 0 0 0 0 0 00000007 DBDC RHDCRUAL 3 0 0 0 0 0 0 0 00000007 DBDC RHDCRUAL 6 2 0 0 0 0 0 0 00000006 DBDC RHDCRUAL 0 0 0 0 0 0 0 0 00000006 DBDC RHDCRUAL 0 0 0 0 0 0 0 0 00000005 DBDC RHDCRUAL 0 0 0 0 0 0 0 0 00000005 DBDC RHDCRUAL 5 2 0 0 0 0 0 0 00000004 DBDC RHDCRUAL 3 0 0 0 0 0 0 0 00000004 DBDC RHDCRUAL 874 39 0 0 0 0 0 0 00000003 DBDC RHDCRUAL 0 0 0 0 0 0 0 0 00000003 DBDC RHDCRUAL 0 0 0 0 0 0 0 0 00000002 DBDC RHDCRUAL 0 0 0 0 0 0 0 0 00000002 DBDC RHDCRUAL 51 15 0 0 0 0 0 0 ******************************* LAST PAGE ********************************** IDMS DB/DC V72 - Tasks active:31 Time: 09:38:38

This example shows the output from the OPER WATCH DB IOD command:

IDMS-DC Release 1700 Display Active DB Drivers Line 1 of 4 Driver --------- Area ------------ Start-IO Pg-IOs Pg/IO PgWrt JrWrt JWai READ DBCR.BRNCHTEL 0 0 READ DBCR.ACCTHIST 0 0 READ CATSYS.DDLCAT 0 0 READ CATSYS.DDLCATX 0 0 ******************************* LAST PAGE ********************************** IDMS DB/DC V72 - Tasks active:32 Time: 09:36:04