Database Overview view (IDBSUMR)


You can use the Database Overview view (IDBSUMR) to manage and control IMS databases.

The IDBSUMR view displays a scrollable list of all databases in the IMS subsystems and provides database-level statistics for each of the databases.

You can hyperlink to the IDBSUMR view from the:

  • Databases option in the IMS Easy Menu (EZIMS) and the IMS SSI Easy Menu (EZISSI)
  • Databases Initialized, Gen’ed, and Stopped options in the IMS Resource Menu (EZIMSRS)
  • All Databases option in the IMS DBA Easy Menu (EZIDBA)
  • Filtering options in the IDBMR menu
  • Number of DB field in the IDBSTAR view
  • Count field in the IDBTYPR view
  • Status 1, Status 2, Auth State, and Acc Lvl fields in the IDBEXCP and IDBSUMZ views
  • Physical DBNAME field in several of the database activity views (IDA*)
  • Database field in the cross-reference views (IX*) that include databases
24SEP2015  04:04:31 ------ MAINVIEW WINDOW INTERFACE (V6.1.00) ----------------
CURR WIN ===> 1        ALT WIN ===>                                            
>M1 =IDBSUMR===========I14E52CT=*========24SEP2015==04:04:31====MVIMS====D====397
-                              Database Overview                               
   Related Views                                                               
   . Summary by Status      . Database I/O Delays    . Database Exceptions     
   . Summary by Type        . Data Set I/O Delays    . Database Xref Summary   
                                                                              
CMD DBD/PART IMS  Database                                  OSAM VSAM Auth     
--- Name     ID   Type     Org  Status 1 Status 2 Status 3  Exts Exts State
    BBFDDB01 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB02 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB03 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB04 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB05 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB06 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB07 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB08 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB09 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB10 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH
    BBFDDB11 I10X               NOT-OPEN NOT-INIT NODMB               NOT-AUTH

The following hyperlinks are provided on the view:

Hyperlink from

To access

DBD/PARTName

Database Menu (IDBMR), where you can access more information about the database you selected

Status 1

Database Overview view (IDBSUMR) that is filtered to show all databases with the same status as the selected status

Status 2

Database Overview view (IDBSUMR), which shows all the databases with the status you selected

Status 3

Database Overview view (IDBSUMR), which shows all databases with the same status as the selected status

OSAM Exts

Database Data Sets Summary view (IDDSUMR), which displays OSAM, VSAM, and DEDB data set information

VSAM Exts

Database Data Sets Summary view (IDDSUMR), which displays OSAM, VSAM, and DEDB data set information

Auth State

Database Overview view (IDBSUMR) that is filtered to show all databases with the same authorization state as the selected authorization state

Acc Lvl

Database Overview view (IDBSUMR) that is filtered to show all databases with the same access level as the selected access level

Related topic

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

MainView for DBCTL 5.2