PM66724: INZU238E UNEXPECTED UNSUPPORTED SELECT MESSAGE INCORRECTLY ISSUED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• An INZU238E UNEXPECTED UNSUPPORTED SELECT message is issued.
  
  An example of SQL statement leading to the failure follows:
  
  UNLOAD
      TABLESPACE DSNDB06.SYSDBAUT
      DB2 NO
      QUIESCE    NO
      QUIESCECAT NO
     SELECT
     'DB=' CONCAT'''' CONCAT CHAR(NAME) CONCAT'''' CONCAT ',
     CONCAT '  TS=' CONCAT'''' CONCAT'''' CONCAT';'
         FROM SYSIBM.SYSDATABASE
         WHERE NAME NOT LIKE 'DSN%'
         AND NAME NOT LIKE 'DSQ%'
         AND NAME NOT LIKE 'DB2%'
         AND NAME NOT LIKE 'ADB%'
         AND NAME NOT LIKE 'RDBI%'
         AND NAME NOT LIKE 'RAADB%'
         AND NAME NOT LIKE 'TEST%'
         AND NAME NOT LIKE 'TEMP%'
         AND NAME NOT LIKE 'LANDMARK%'
         AND CREATOR NOT LIKE 'DB2SUPT%'
         AND CREATOR NOT LIKE 'DB2ADMIN%'
         AND CREATOR NOT LIKE 'SYSIBM%'
         AND CREATOR NOT LIKE 'CHGMAN%'
         AND CREATOR NOT LIKE 'DBE%'
         AND CREATOR NOT LIKE 'Q%'
         ORDER BY NAME;
  PB11608
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: In some very specific cases of logical  *
  *                      unload involving SQL expression with    *
  *                      concatenation and requiring CCSID       *
  *                      conversion (this occurs if string       *
  *                      constant are used), an INZU238E         *
  *                      UNEXPECTED UNSUPPORTED SELECT message   *
  *                      is issued.                              *
  *                      An example of SQL statement that leads  *
  *                      to the failure is:                      *
  *                      UNLOAD                                  *
  *                         TABLESPACE DSNDB06.SYSDBAUT          *
  *                         DB2 NO                               *
  *                         QUIESCE    NO                        *
  *                         QUIESCECAT NO                        *
  *                        SELECT 'DB=' CONCAT'''' CONCAT        *
  *                       CHAR(NAME) CONCAT'''' CONCAT ','       *
  *                        CONCAT '  TS=' CONCAT'''' CONCAT''''  *
  *                       CONCAT';'                              *
  *                            FROM SYSIBM.SYSDATABASE           *
  *                            WHERE NAME NOT LIKE 'DSN%'        *
  *                            AND NAME NOT LIKE 'DSQ%'          *
  *                            AND NAME NOT LIKE 'DSQ%'          *
  *                            AND NAME NOT LIKE 'DB2%'          *
  *                            AND NAME NOT LIKE 'ADB%'          *
  *                            AND NAME NOT LIKE 'RDBI%'         *
  *                            AND NAME NOT LIKE 'RAADB%'        *
  *                            AND NAME NOT LIKE 'TEST%'         *
  *                            AND NAME NOT LIKE 'TEMP%'         *
  *                            AND NAME NOT LIKE 'LANDMARK%'     *
  *                            AND CREATOR NOT LIKE 'DB2SUPT%'   *
  *                            AND CREATOR NOT LIKE 'DB2ADMIN%'  *
  *                            AND CREATOR NOT LIKE 'SYSIBM%'    *
  *                            AND CREATOR NOT LIKE 'CHGMAN%'    *
  *                            AND CREATOR NOT LIKE 'DBE%'       *
  *                            AND CREATOR NOT LIKE 'Q%'         *
  *                            ORDER BY NAME;                    *
  *                             OUTDDN (SYSREC)                  *
  *                             CCSID (37,37,37)                 *
  *                             FORMAT DELIMITED SEP ';'         *
  *                      INZU238E UNEXPECTED UNSUPPORTED SELECT  *
  *                              UTILITY CANNOT SWITCH TO SQL    *
  *                       PROCESSING                             *
  *                              REASON 0Xdfffc / 0X12894460     *
  *                      PB 11608                                *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  inznodeh was changed to correctly estimate the maximum length
  of the SQL expression.
  

Problem conclusion

• APPLY the PTF.
  

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:

  UK80196

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R410 PSY UK80196

     UP12/07/17 P F207

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.