LIST.DB command

The LIST.DB command shows you the contents of the specified RDEs, with a report.

Subsections:

Syntax

Read syntax diagramSkip visual syntax diagramLIST.DBDBD( pattern)AREA( pattern)TIMESTMP(yyyydddhhmmssthCURRENT)

Parameters

DBD(pattern)
Specifies the database for which you want to list the contents of an RDE. You can specify either of the following patterns:
  • A specific database name or a specific HALDB partition name
  • A partially specified database name pattern or a partially specified HALDB partition name pattern—for example, DH41*, where * means ALL
Note: A partially specified HALDB master name is not supported. If it is specified, this command fails with message FABL0460E or FABL0461E.

For HALDBs, if you specify a HALDB master name, all the RDEs of its partitions are listed. If you specify a HALDB partition name, only the RDE of the partition is listed.

AREA(pattern)
Specifies the DEDB area for which you want to list the contents of an RDE. Only when you specify a specific DEDB name in the DBD parameter, you can specify either of the following patterns:
  • A specific DEDB area name
  • A partially specified DEDB area name pattern
If you omit the keyword, the RDEs for all areas of the DEDB database that is specified with the DBD parameter are listed.
TIMESTMP(yyyydddhhmmssth)
Specifies the local time stamp value of the RDE you want to list. You can use a fully specified local time stamp yyyydddhhmmssth or, to get the current RDE, the keyword CURRENT. If you omit the keyword, all of the RDEs associated with the DBD are listed.

Example

In this example, the following conditions are assumed:

  • The IMS ID is taken from the batch SCD module (DFSVC000) loaded by the IMS load module library IMSVS.SDFSRESL.
  • The LICON data set is dynamically allocated by the LICON utility. The data set name is provided by one of the global option modules.
LIST.DB with ACBLIB
This example lists all current RDEs for the database whose name matches the DH41* pattern.
//LICJOB   JOB
//        EXEC PGM=FABLIU00
//STEPLIB   DD DISP=SHR,DSN=HPS.SHPSLMD0
//          DD DISP=SHR,DSN=IMSVS.SDFSRESL
//ACBLIB    DD DISP=SHR,DSN=IMSVS.ACBLIB
//FABLPRNT  DD SYSOUT=*
//FABLIN    DD *
  LIST.DB DBD(DH41*) TIMESTMP(CURRENT)
/*