PM41840: MSGINZU096E UNLOAD SPECIFIES SPACE IN THE SELECT STATEMENT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After fix for APAR PM15452 has been applied, a logical unload
  stops with completion code 8 and issues msg INZU096E
  
  REQUIRED KEYWORD, FROM, NOT SPECIFIED, PROCESSING TERMINATED
  
  This occurs where the SELECT statement involves columns name
  that are also SQL expressions (mainly scalar functions) that are
  not natively supported by DB2 HPU.
  
  ( PTF UK60175 )
  PB11215
  

Local fix

• Place the column name (SPACE) between delimiter characters
  Instead of:
    UNLOAD TABLESPACE DSNDB06.SYSRTSTS
    SELECT SPACE
    FROM SYSIBM.SYSTABLESPACESTATS
  specify:
    UNLOAD TABLESPACE DSNDB06.SYSRTSTS
    SELECT "SPACE"
    FROM SYSIBM.SYSTABLESPACESTATS
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 High Performance Unload.        *
  ****************************************************************
  * PROBLEM DESCRIPTION: After fix for PM15452 has been applied, *
  *                      a logical unload stops with completion  *
  *                      code 8 and issues msgINZU096E REQUIRED  *
  *                      KEYWORD, FROM, NOT SPECIFIED,           *
  *                      PROCESSING TERMINATED. This occurs      *
  *                      where the SELECT statement involves     *
  *                      columns name that are also SQL          *
  *                      expressions (mainly scalar functions)   *
  *                      that are not natively supported by DB2  *
  *                      HPU.                                    *
  *                      PB11215                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  The inzdyacc module was changed to distinguish unsupported
  tokens used as columns name from unsupported tokens actually
  involved in a 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:

Modules/Macros

•    INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R320 PSY UK71901

     UP11/09/17 P F109

• R410 PSY UK71902

     UP11/09/18 P F109

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.