Managing databases

Use the DL/I application to control all the databases defined for your IMS.

Select the DL/I application from the DATABASE OPTIONS menu.

Figure 1. DL/I DATABASE application for DBCTL

BMC Software -------------------- DATABASE --------------------- AutoOPERATOR
 COMMAND ===>                                                 TGT ===> IMS410
  LC CMDS ==> P, S, DR, DD, DF, DV, L, U
  LC  DATABASE    DATASET ORG    TYPE LNUM  -------- STATUS ---------
      BE1PARTS   DMB NOT AVAIL   DL/I    1  STARTED
      BE2ORDER   DMB NOT AVAIL   DL/I    2  STARTED
      BE2ORDRX   DMB NOT AVAIL   DL/I    3  STARTED
      BE2PARTS   DMB NOT AVAIL   DL/I    4  STARTED
      BE2PCUST   DMB NOT AVAIL   DL/I    5  STARTED
      BE3ORDER   DMB NOT AVAIL   DL/I    6  STARTED
      BE3ORDRX   DMB NOT AVAIL   DL/I    7  STARTED
      BE3PARTS   DMB NOT AVAIL   DL/I    8  STARTED
      BE3PSID1   DMB NOT AVAIL   DL/I    9  STARTED
      B00INP01   DMB NOT AVAIL   DL/I   10  DATABASE LOCKED
      B00OUT01   DMB NOT AVAIL   DL/I   11  DATABASE NOT INITIALIZED
      CUSTHDAM   DMB NOT AVAIL   DL/I   12  STARTED
      CUSTHIDM   DMB NOT AVAIL   DL/I   13  STARTED
      CUSTHISM   ISAM CASE 1     DL/I   14  DATABASE LOCKED
      CUSTINDX   DMB NOT AVAIL   DL/I   15  STARTED
      CUSTVSAM   DMB NOT AVAIL   DL/I   16  STARTED
      DBFSAMD1   FAST PATH       MSDB   17  DATABASE STOPPED
      DBFSAMD2   FAST PATH       MSDB   18  DATABASE IN ERROR
      DBFSAMD3   FAST PATH       DEDB   19  DATABASE NOT INITIALIZED
      DBFSAMD4   DMB NOT AVAIL   DL/I   20  STARTED

This application shows a scrollable list of all the databases by name for both DL/I and Fast Path. The list identifies the data set organization, the database type, the database number, and the status of each database.

Note

Although Fast Path databases are shown in this application, the applications designed specifically for MSDBs and DEDBs display data that is more meaningful for those databases.

Enter any of the following one- or two-character line commands on the line of the database that you want to change.

Line command	Description
P	issues the /STOP DATABASE command to stop the database
S	issues the /START DATABASE command to start the database
DR	issues the /DBRECOVERY DATABASE command with NOFEOV to stop the scheduling of transactions that update or read the database The IMS log does not switch to the next OLDS (online log data set). Note: This line command cannot be used for an MSDB.
DD	issues the /DBDUMP DATABASE command with NOFEOV to stop the scheduling of transactions or programs that update the specified database Transactions reading that database continue. The IMS log does not switch to the next OLDS. Note: This line command cannot be used for a DEBD or MSDB.
DF	issues the /DBRECOVERY DATABASE without NOFEOV to stop the scheduling of transactions that update or read the database The IMS log switches to the next OLDS (online log data set). Note: This line command cannot be used for an MSDB.
DV	issues the /DBDUMP DATABASE command without NOFEOV The command executes the same as /DBDUMP with NOFEOV except the IMS log switches to the next OLDS. Note: This line command cannot be used for a DEBD or MSDB.
L	issues the /LOCK DATABASE command to stop the scheduling of application programs that use the database
U	issues the /UNLOCK DATABASE command to free a database previously locked by the /LOCK command

The following table contains the field descriptions for the DATABASE application:

Field name	Description
DATABASE	one- to eight-character name of the database
DATASET ORG	IMS data set organization, which can be DMB NOT AVAIL: Data Management Block (DMB) control block cannot be located The DMB pool might be too small for the DMB or the database has not been opened yet. ISAM CASE 1: HISAM database (one data set group) ISAM CASE 2: HISAM database (multiple data set groups) SSAM: single segment sequential database HSAM: multiple segment sequential database HD DIRECT: HDAM database (OSAM data set) HD INDEXED: data portion of HIDAM database (OSAM data sets) INDEX DATABASE: primary index to HIDAM database (ISAM data sets), or secondary index to HISAM, HIDAM, or HDAM database (ISAM data sets) HISAM VSAM: HISAM database (one data set group of VSAM data sets) SHISAM VSAM: single segment HISAM database (VSAM data sets) VSAM INDEX-K: primary index to HIDAM database (VSAM Keyed Sequential Data Sets (K SDS)), or secondary index to HISAM, HIDAM, or HDAM database (VSAM KSDS) VSAM HDAM : DAM database (VSAM Entry Sequential Data Sets (ESDS)) VSAM HIDAM: data portion of HIDAM database (VSAM ESDS) VSAM INDEX-K/E: secondary index to HISAM, HIDAM, or HDAM database (VSAM KSDS and ESDS (nonunique keys)) FAST PATH: Fast Path database
TYPE	IMS database type, which can be DL/I: DL/I database MSDB: Fast Path main storage database DEDB: Fast Path data entry database
LNUM	local Data Management Block (DMB) number from the IMS database directory
STATUS	current database status, which can be ALLOCATION FAILURE: dynamic allocation for the database was unsuccessful NOTOPEN: database is not open STOPPED: /STOP DATABASE command was issued for the database OPENED: database is open NOT INITIALIZED: no DBD was found for the database during IMS initialization LOCKED: /LOCK DATABASE command was issued for the database DATABASE IN ERROR: database had a write error /DBD IN PROGRESS: /DBDUMP DATABASE without NOFEOV was issued for the database /DBR IN PROGRESS: /DBRECOVERY DATABASE with NOFEOV was issued for the database INQUIRY ONLY: updates to the database are not allowed The scheduling of any transactions or programs updating the database has been stopped. When INQUIRY ONLY and NOT OPEN are both true, INQ ONLY is shown.

Exceptions off (X OFF) is the default. All databases are displayed with a status, including those that are an exception to normal operation. If X ON for exceptions on is entered in the COMMAND line, only databases in an exception to normal operation are displayed. The exception status can be

DATABASE STOPPED
DATABASE LOCKED
DATABASE IN ERROR

Managing databases

Comments