This site will undergo a maintenance outage on Saturday, 13 September beginning at 2:30 AM Central/1 PM IST for a platform upgrade. The downtime will be ~three hours.

Search argument examples—DBD library

The following examples show how to qualify the search for DBD library members.

Related topic

Specifying-search-arguments-in-a-DBD-library

  • Find all of the SHISAM and SHSAM DBDs in the library:

    DLACCESS EQ SHISAM OR DLACCESS EQ SHSAM

  • Find all of the databases that have more than four hierarchic levels defined:

    LEVEL GT 4

  • Find a model DBD that employs paired pointers:

    LOGICAL EQ EXTERNAL AND PTR EQ PAIRED

  • Find the secondary index DBDs based on or pointing to the root segment:

    SECINDEX EQ SRC=ROOT AND SECINDEX EQ TGT=ROOT

  • Find the DBDs that have logical child first pointers but no logical child last pointers:

    POINTER EQ LCHILD AND POINTER NE LCHILDL

  • Find all of the HDAM VSAM or OSAM databases that do not use the randomizer RANDOM01:

    OSACCESS EQ VSAM AND RMNAME NE RANDOM01

    or

    OSACCESS EQ OSAM AND RMNAME NE RANDOM01

    You do not have to specify the DLACCESS keyword because the RMNAME keyword implies that you want only HDAM databases.

  • Find all logical databases that have a segment called COMBPART and all data entry databases (DEDBs) that have a segment called PARTUSED:

    DLACCESS EQ LOGICAL AND SEGNAME EQ COMBPART OR
    DLACCESS EQ DEDB AND SEGNAME EQ PARTUSED


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*