SHOWDBS

#### Search Results

Search

# SHOWDBS

`SHOWDBS`

This command is used to view information on the databases available in your environment and the options (like read-only properties) defined for them as shown in the following example:

          +-------------------SHOWDBS - Defined Databases-------------------+
          !                                                                 !
          !  DBID DB Type          DB Options                               !
          ! ----- ---------------- ---------------------------------------- !
          !     0 ADABAS V82                                                !
          !    10 ADABAS V82                                                !
          !   111 ADAV7            READ                                     !
          !   147 INCORE DB                                                 !
          !   148 PROCESS                                                   !
          !   170 VSAM                                                      !
          !   200 DB2                                                       !
          !   246 DLI                                                       !
          !   247 DLI                                                       !
          !   249 CONNECX                                                   !
          !   250 DB2                                                       !
          ! Default DB type ...... ADABAS V82                               !
          !                                                                 !
          +-----------------------------------------------------------------+

    Top of list

    Enter-PF1---PF2---PF3---PF4---PF5---PF6---PF7---PF8---PF9---PF10--PF11--PF12---
                      Exit                          +     ++                Canc

The information shown is retrieved from the `DB` parameter settings (or corresponding `NTDB` macro) described in the Parameter Reference documentation:

DBID | The database ID
DB Type | The type of database: see Possible Database Types
Default DB type | The default database type
DB Options | One or more options defined for the database: see Possible Database Options

You can page up or down in the SHOWDBS window (depending on how many pages exist) and exit with the following PF keys:

PF3 | Cancel and close window
PF6 | First page
PF7 | Previous page
PF8 | Next page
PF9 | Last page
PF12 | Cancel and close window

## Corresponding API USR8211N

The application programming interface `USR8211N` in the `SYSEXT` system library provides the same information as the `SHOWDBS` system command.