DELETE.DB command

Syntax

1  DELETE.DB DBD(pattern) ? AREA(pattern)? TIMESTMP(
2.1 yyyydddhhmmssth
2.1 CURRENT
1)

Parameters

DBD(pattern)

Specifies the database from which you want to delete 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 deleted. If you specify a HALDB partition name, only the RDE of the partition is deleted.

AREA(pattern)

Specifies the DEDB area for which you want to delete 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 deleted.

TIMESTMP(yyyydddhhmmssth)

Specifies the local timestamp value of the RDE you want to delete. You can use the fully specified local timestamp yyyydddhhmmssth or the keyword CURRENT for the current RDE. If you omit the keyword, all of the RDEs associated with the DBD are deleted.

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.

DELETE.DB with DBDLIB

This example deletes all RDEs, including the current one and any expired ones, for any 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
//DBDLIB    DD DISP=SHR,DSN=IMSVS.DBDLIB
//FABLPRNT  DD SYSOUT=*
//FABLIN    DD *
  DELETE.DB DBD(DH41*)
/*