DBNAME for Database Sessions

Administrative and Operational Enhancements › OPER Enhancements › DBNAME for Database Sessions

DBNAME for Database Sessions

The new option DBName on the OPER WATCH DB command shows the database name or segment name being accessed by active database sessions.

WATCH DB Syntax

The following diagram shows the syntax placement of the new database name option for the OPER WATCH DB command:

►►─ Watch DB ─┬──────────┬──────────────────────────────────────►◄
              ├── IO ────┤
              ├── IOD ───┤
              └─ DBName ─┘

WATCH DB Parameter

This section describes the new database name parameter for the OPER WATCH DB command.

DBName: Displays the database name or segment name being accessed by active database sessions.

More information

For more information about database drivers, see the Database Administration Guide.
For more information about database I/O statistics, see the System Operations Guide.
For more information about the scrolling subcommands, see the section Scrolling Subcommands Parameters.

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 Task Id Org/Ltrm IDMSProg 00000010 DBDC RHDCLGSD 00000009 DBDC RHDCLGSD 00000008 DBDC RHDCLGSD 00000007 DBDC RHDCRUAL 00000007 DBDC RHDCRUAL 00000006 DBDC RHDCRUAL 00000006 DBDC RHDCRUAL 00000005 DBDC RHDCRUAL 00000005 DBDC RHDCRUAL 00000004 DBDC RHDCRUAL 00000004 DBDC RHDCRUAL 874 00000003 DBDC RHDCRUAL 00000003 DBDC RHDCRUAL 00000002 DBDC RHDCRUAL 00000002 DBDC RHDCRUAL ******************************* IDMS DB/DC V72 Display DB IO activity Line 1 of 15 PagReq PgRead StIO PgIO WrtRq PgWrt JrWrt R/W 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 0 0 6 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 2 0 0 0 0 0 0 3 0 0 0 0 0 0 0 39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 51 15 0 0 0 0 0 0 LAST PAGE ********************************** - 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