PM92665: SET RC=00 FOR MSGINZU103W

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• Add a new parameter allowing to set the return code applicable
  when the processing of a SELECT statement is automatically
  switch to SQL mode whatever the syntax used.
  
  MSGINZU103 MSGINZU103W INZU103W INZU103
  MR1002122234
  PB11722
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: HPU should end with cond code zero      *
  *                      regardless native or SQL mode attached. *
  *                      * Title: HPU should end with cond code  *
  *                       zero regardless native or SQL mode     *
  *                      * Description: Currently HPU finishes   *
  *                       with RC=4 if SQL mode invoked.         *
  *                       Customers migrating from CA FASTUNLOAD *
  *                       using SQL-ACCESS EXTENSION (much like  *
  *                       HPU SQL mode), have coded their        *
  *                       applications expecting unload to end   *
  *                       with COND CODE zero if the unload was  *
  *                       successful regardless which method was *
  *                       used to fulfill the request.           *
  *                      * Suggested Solution: HPU should        *
  *                       provide a compatible mechanism for     *
  *                       customers migrating from CA FASTUNLOAD *
  *                       This mechanism would specify that HPU  *
  *                       should end with COND CODE zero if the  *
  *                       unload was successful regardless which *
  *                       method (native or SQL) was used to     *
  *                       fulfill the request.                   *
  *                      This mechanism would override the       *
  *                      current default HPU behavior of ending  *
  *                      with COND CODE 4 if unload was done via *
  *                      SQL mode processing (rather than native *
  *                      mode).                                  *
  *                      PB 11722                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Enhancement.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

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

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

Modules/Macros

• INZ$$PRM
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R420 PSY UK96461

     UP13/08/08 P F308

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.