PM51070: DSQ23700 TRYING TO CALL ANY STORED PROCEDURE FROM QMF AFTER MIGR ATING TO DB2 V10 NFM 11/10/28 PTF PECHANGE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After migrating db2 to v10 NFM, receiving following msg:
  
  DSQ23700 The stored procedure (sp name) could not be found.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All QMF for TSO/CICS V9 and V10 users who    *
  *                 migrated with stored procedures that         *
  *                 were created prior to DB2 V9.                *
  ****************************************************************
  * PROBLEM DESCRIPTION: After applying PM38018, users who       *
  *                      migrated from DB2 versions prior to     *
  *                      V9 with existing stored procedures      *
  *                      will receive MSGDSQ23700 indicating     *
  *                      the stored procedure(s) could not be    *
  *                      found when they CALL them.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Support for creating versions of stored procedures was
  introduced in DB2 V9. New columns, including an ACTIVE
  column, were introduced to the SYSIBM.SYSROUTINES table,
  where information about stored procedures is recorded.
  If SYSIBM.SYSROUTINES was migrated from an older version of
  DB2, the ACTIVE column contains a BLANK for existing stored
  procedures, rather than the 'Y' or 'N' that is assigned to
  newly created stored procedures.
  
  Code was added to QMF via PM38018 that searched only for an 'Y'
  in the ACTIVE column when trying to verify the existence of a
  stored procedure.  It should have searched for a BLANK as well
  in order to find procedures created prior to DB2 V9 for which
  the ACTIVE was BLANK.
  

Problem conclusion

• When querying SYSIBM.SYSROUTINES to verify the existence of
  a stored procedure, QMF checks for ACTIVE ª= 'N' rather than
  ACTIVE = 'Y'.
  

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:

  UK73526 UK73527

Modules/Macros

• DSQFSDB9 DSQGSDB9 DSQISDB9
  

Fix information

• Fixed component name

  QMF-QUERY MGMT

• Fixed component ID

  566872101

Applicable component levels

• RA10 PSY UK73526

     UP11/11/06 P F111

• R910 PSY UK73527

     UP11/11/06 P F111

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.