CDBM operator transaction

You can use CDBM to issue most of the IMS™ operator commands that are valid for DBCTL across the DRA interface to DBCTL to display and change the state of selected resources.

CDBM also provides a means of maintaining a command file which stores commands. You may store commands for any reason, most likely because you want to re-use them. These stored commands may include more databases than the operator transaction panel has space for.

When dealing with databases, you can use an asterisk (*) to refer to generic groups; for example DB21* refers to all databases starting with the characters DB21. You can also use a plus (+) sign in place of a single character; for example, DB+2 displays databases DB12, DB22, DB32, and so on.

You can issue DBCTL commands via a menu panel, as shown in Figure 16. This panel is obtained by starting the CDBM transaction.

Figure 16. CDBM CICS-DBCTL operator transaction panel
  CDBM                  CICS-DBCTL Operator Transaction                 98.135
                                                                      13:24:20
 
  Type IMS command.
              ____________________________________________________________
              ____________________________________________________________
              ____________________________________________________________
              ____________________________________________________________
 
 
  For /DBDUMP or /DBRECOVER commands
 
  Choose one. 1 1. Do not force end of volume
                2. Force end of volume
 
 
  Press enter to display responses.
 
 
  CICS APPLID DBDCCICS
  DBCTL ID    SYS3
 
 
 F1=Help  F2=Maintenance  F3=Exit  F5=Refresh  F12=Cancel

On this panel you can enter a DBCTL command, for example:

/DISPLAY DB ALL

or a group command, for example:

/GROUP SAMPLE STA

There is also a help screen, as shown in Figure 17.

Figure 17. CDBM CICS-DBCTL operator transaction help panel
  CDBM                Help: CICS-DBCTL Operator Transaction
 
 
 CDBM           Use the transaction to send an IMS command to a DBCTL system.
 
 Command        Type the command recognition character / followed by an IMS
                command and press enter to display responses.
 
 Responses      Use the PF keys to page IMS responses.
 
 Wildcards      * or + can be used within one database name.
 
 End of volume  For /DBDUMP or /DBRECOVER commands only
                Choose one.
                  1. Do not force end of volume
                  2. Force end of volume
  CICS APPLID
               These are shown for information.
 DBCTL ID
 Enter the group common maintenance screen.
 
 
 Example        /DIS DB DEPT* displays the status of several databases.
 
 
 F3=Exit  F12=Cancel

An example of the use of a /GROUP command from the CICS-DBCTL Operator Transaction screen is shown in Figure 18.

Figure 18. CICS-DBCTL operator transaction panel showing a GROUP command
 CDBM                  CICS-DBCTL Operator Transaction               98.135
                                                                   13:24:20
 Type IMS command.
             /GROUP SAMPLE STA____________________________________________
              ____________________________________________________________
              ____________________________________________________________
              ____________________________________________________________
 
 
For /DBDUMP or /DBRECOVER commands
 
Choose one. 1 1. Do not force end of volume
              2. Force end of volume
 
 
 Press enter to display responses.
 
 
 CICS APPLID DBDCCICS
 DBCTL ID    SYS3
 
 
F1=Help  F2=Maintenance  F3=Exit  F5=Refresh  F12=Cancel
                                       

Responses to commands issued from the CDBM screen are returned on a screen like the one in Figure 19, which shows the first of a number of screens resulting from a /DISPLAY DB ALL command.

Figure 19. CDBM CICS-DBCTL IMS responses panel
  CDBM                      CICS-DBCTL IMS Responses                 Screen 1
                                                          Responses 1    to 18
                                                                      More:   +
  DATABASE  TYPE  TOTAL UNUSED  TOTAL UNUSED ACC  CONDITIONS
  ACCOUNDB                                   UP   STOPPED, NOTOPEN, NOTINIT
  ADMIDX1                                    UP   STOPPED, NOTOPEN, NOTINIT
  ADMOBJ1                                    UP   STOPPED, NOTOPEN, NOTINIT
  ADMOBJ2                                    UP   STOPPED, NOTOPEN, NOTINIT
  ADMOBJ3                                    UP   STOPPED, NOTOPEN, NOTINIT
  ADMSYSDF                                   UP   STOPPED, NOTOPEN, NOTINIT
  BE1CHKPT  DL/I                             UP   NOTOPEN
  BE1PARTA                                   UP   STOPPED, NOTOPEN, NOTINIT
  BE1PARTB                                   UP   STOPPED, NOTOPEN, NOTINIT
  BE1PARTC                                   UP   STOPPED, NOTOPEN, NOTINIT
  BE1PARTS                                   UP   STOPPED, NOTOPEN, NOTINIT
  BE2ORDER  DL/I                             UP   NOTOPEN
  BE2ORDRX  DL/I                             UP   NOTOPEN
  BE2PARTS  DL/I                             UP   NOTOPEN
  BE2PCUST  DL/I                             UP   NOTOPEN
  BE3ORDER  DL/I                             UP   NOTOPEN
  BE3ORDRX  DL/I                             UP   NOTOPEN
                                                                        More...
 
 F1=Help  F3=Exit  F4=Top  F6=Bottom  F7=Bkwd  F8=Fwd  F9=Retrieve  F12=Cancel

Alternatively, you can issue CDBM and the DBCTL command directly, as follows:

CDBM /xxxxxxxx

where / is the default CRC and xxxxxxxx is a IMS operator command that is valid for use with DBCTL and CDBM.

Note:
IMS requires that each command is prefixed with the default CRC. The CRC is present only for syntax checking; it does not determine to which DBCTL the command is sent. You cannot use a CRC value to route a command to a particular DBCTL system through CDBM. It can be sent only to the one currently connected to CICS®. This DBCTL may have its own CRC value which is different from the default one of '/'. However, this does not matter to CDBM, because the '/' character is used only for syntax checking, and the command is presented to the connected DBCTL without a CRC, using the AIB interface.

The /GROUP may also be entered in this way, for example:

CDBM /GROUP  SAMPLE  DIS.            

DFHDBFK - The CDBM GROUP command file

Before you can use the /GROUP command CDBM requires a file in which all your predefined commands can be stored. This file, DFHDBFK, is the CDBM GROUP command file. It is a VSAM KSDS.

Note:
The DFHDBFK file must be defined as a local file to each region that uses the CDBM transaction. It cannot be shared by multiple regions. If the file is remote, the CDBM transaction receives an error when it attempts to open the file.

The DFHDBFK file is not required until you first attempt to use the /GROUP command.

Record layout in the CDBM GROUP command file

Each record in the DFHDBFK file may be up to 1428 characters long, as follows:

Table 2. Record layout in the CDBM GROUP command file
Field Length Content Description
1 12 Group A 12-character field containing your chosen name for this group. The acceptable characters are A-Z 0-9 $ @ and #. Leading or embedded blanks are not allowed, but trailing blanks are acceptable.
2 10 IMS Command A 10-character field containing any of the IMS command verbs that are valid for CDBM (see topic Commands valid with CDBM for details). Leading or embedded blanks are not allowed, but trailing blanks are acceptable.
Note:
The validity of the IMS command verb is not checked by CDBM. Invalid values will be reported by IMS when the command is attempted.
3 1406 IMS Command parameters Up to 1406 characters of parameters appropriate to the chosen IMS command verb. (This will often consist of lists of databases.)
Note:
Wildcard characters may not be used in the parameters stored in the CDBM Group command file. This is unlike the other functions of the CDBM transaction which permit the use of wildcard characters to describe multiple similarly named databases.

The MAINTENANCE panel for DFHDBFK

If you press the Maintenance key (PF2) on the main CDBM panel, you get the panel shown in Figure 20.

Figure 20. CICS-DBCTL Group Maintenance Panel
 CDBM               CICS/DBCTL COMMAND GROUP MAINTENANCE
 _        ACTION      A add  B browse  D delete  R read  U update
 ____________ GROUP         __________ IMS COMMAND
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 >                                                                 <
 F1=Help  F3=Exit  F12=Cancel                                      

Input fields

The input fields are:

Group, IMS Command and IMS Command parameters are described in Record layout in the CDBM GROUP command file

The Action field will accept one of the following:

A
Add

Add a new record to the DFHDBFK file. If the key already exists, the Add fails.

Note:
To Add a record that is very similar to an existing record, but which has a different key, you may find it helpful to Read the existing record, modify the displayed fields, and then Add this new record.
B
Browse

Displays the contents of the command file, record by record. Specify any key (or none) to indicate where you want the browse to start. Each time you press ENTER, Browse moves on to the next record. At the end of the file you will be prompted to wrap around to the start of the file. You can accept this or not as you prefer. Incomplete keys, and unknown keys are also acceptable as start points. If no key is provided, the browse starts at the first record in the file.

If you have used Browse to locate a specific record for deletion or for update, remember to use Read before either Delete or Update.

D
Delete

Delete a record from the DFHDBFK file. A Delete must be immediately preceded by a Read to lock the required record.

R
Read

Read displays a specific record. Unlike Browse it does not operate on partial, or absent keys, and does not present the next record when you press ENTER.

Read is required before those actions (Delete and Update) which change an existing record. It locks that record against the possibility of being changed by another operator. This action also serves to help you confirm that the correct record has been selected.

A lock is released by ending CDBM, or by your next CDBM Maintenance action (whether that is the Update or Delete you had contemplated, or something different entirely).

U
Update

Update a record in the DFHDBFK file. An Update must be immediately preceded by a Read to lock the required record.

You cannot update the key fields (GROUP and IMS COMMAND).

Reminder::
Use Add to create a new key.
Note:
In the descriptions above, Key refers to the 22 characters at the beginning of each record in the DFHDBFK file (namely the GROUP and IMS COMMAND).

If you press the help key (PF1) from the CICS-DBCTL Maintenance panel, you get the panel shown in Figure 21.

Figure 21. CICS-DBCTL Maintenance help panel
   CDBM                Help: CICS-DBCTL Operator Transaction
 
 
  Maintenance    Store commands for issuing from the CDBM screen.
 
  GROUP          Enter the group you want to store a command in.
 
  IMS COMMAND    Enter a valid IMS command to execute with the supplied data
 
  ACTION         A - Add a command to the command file.
                 B - Browse the contents of the command file.
                 D - Delete a command, only after it has been read.
                 R - Read a command from the file.
                 U - Update a command, only after it has been read.
 
                 Issue commands from the main screen in the format
                 /GROUP group command.
 
  Example        /GROUP SAMPLE DIS shows information for the databases in
 
 
 F3=Exit  F12=Cancel

The following IMS operator commands are valid with CDBM:

The following IMS operator commands are not valid with CDBM and must be issued via the MVS™ console:

For more information, see Appendix A. Migration task summary for DBCTL.

Related concepts
Back to full list of operator communications
Operator communication with DBCTL -- overview
Other related concepts
Operations with DBCTL
Connecting to DBCTL: overview
Dealing with messages from DBCTL and CICS
[[ Contents Previous Page | Next Page Index ]]