DBRC query request (QUERY)

You can use the DBRC Query request (DSPAPI FUNC=QUERY) along with the TYPE parameter to retrieve various types of information from the RECON data set.

  • Backout (TYPE=BACKOUT)
  • Database (TYPE=DB) - This variation of QUERY returns database registration and status information for:
    • Full-function databases
    • Fast Path databases
    • HALDB databases
    • DBDS or area information and supporting recovery-related information for each DBDS or area (allocation, image copy, recovery, and reorganization)
  • Database partitioning (TYPE=PART)
  • DBDS or area information (TYPE=DBDS)
  • Group and member information for the following group types:
    • Change Accumulation (TYPE=CAGROUP). CA execution information can also be returned.
    • DBDS (TYPE=DBDSGROUP)
    • Database (TYPE=DBGROUP)
    • Recovery (TYPE=RECOVGROUP)
  • Log, Recovery and System Log Data Set (TYPE=LOG)
  • Online Log Data Set (TYPE=OLDS)
  • RECON status (TYPE=RECON) - This variation of QUERY returns RECON header information, as well as the status of the RECON configuration.
  • Subsystem (TYPE=SUBSYS)

Output from query requests are time consistent and access to the RECON data set is restricted during the processing of the request.

If you enable parallel RECON access, then the Query API request returns output as if you specified LIST.xxx STATIC (the RECON data set is not accessible while DBRC processes the Query request).