PH22644: QUERY COMMAND WITH SHOW(ALL) RETURNS GLOBAL STATUS INFORMATION WHICH CAN CAUSE AN ERROR IN RECOVERY EXPERT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• IMS RE BSYDBRDB issues IMS command: QUERY DB SHOW(ALL)
  NAME(xxxxxxxx) with CSLOMCMD API.  RE expects a local status
  response such as LSTT(STA,ALLOC but receives global status
  response such as STT(STA,ALLOC.  The global status information
  is unnecessary for RE and can cause an error.
  BSYI924W - IMS QUERY DB Command Failed on SSID: xxxx
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM IMS Recovery Expert users            *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB recovery utility BSYDBRDB fails with *
  *                      return code 08, if IMS RM global status *
  *                      information for database is enabled.    *
  ****************************************************************
  * RECOMMENDATION: Apply maintenance.                           *
  ****************************************************************
  If IMS RM global command status information for database is
  enabled, database recovery utility BSYDBRDB fails with return
  code 08 and message BSYI924W - IMS QUERY DB Command Failed.
  BSYDBRDB gets database status with QUERY DB SHOW(ALL) command
  via CSLOMCMD API. If IMS RM database global status is enabled,
  API returns not only local status but also global status.
  Global status information is unnecessary and causes an error.
  

Problem conclusion

• Option LOCAL is added for QUERY DB command in order to
  suppress unnecessary global status information.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UI68662

Modules/Macros

• BSY#ICMD BSYXML01
  

Fix information

• Fixed component name

  IMS RECOVERY EX

• Fixed component ID

  5655S9800

Applicable component levels

• R220 PSY UI68662

     UP20/04/01 P F003

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.