QUERY and REFRESH DBQUERY commands

In a command-level environment, issue the following command after a PSB schedule request for each PCB:

EXEC DLI QUERY PCB(n)

where n is the number of a PCB.

This obtains the status code and other information in the DL/I interface block (DIB). You should get one of the following values in the DIB:

• TH, which means that a PSB has not yet been scheduled and results in a DHTH abend.
• NA, which means that at least one of the databases that can be accessed using this PCB is unavailable, but does not result in an abend.
• NU, which means that at least one of the databases that can be updated using this PCB is unavailable and does not result in an abend.
• (blanks), mean that the data accessible using this PCB is available for all functions that the PCB sensitivity allows.

DIBDBORG, which is returned when DIBSTAT has been set to NA, NU or ␢␢ (blanks). DIBDBORG contains one of the following values describing the database organization:

• DEDB
• GSAM
• HDAM
• HIDAM
• HISAM
• INDEX
• HSAM
• SHISAM
• SHSAM.

DIBDBDNM, which is returned when DIBSTAT has been set to NA, NU or blanks, and contains the DBDNAME. You can refresh these status codes using the command:

EXEC DLI REFRESH DBQUERY