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