PH61738: UNDESIRABLE MESSAGES INZU080E INZU016E INZU010I WHEN DB2 FORCE SPECIFIED.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The following messages are unduly
  issued :
  
  INZU010I ITEM STARTING AT (n,p) ENDING AT (n,p)
  INZU016E type STATEMENT SYNTAX IS INVALID
  INZU080E ERROR : SELECT FROM VIEW 'creator.view' IS NOT
  SUPPORTED BY THE UTILITY
  
  when all the conditions below are
  fulfilled :
  - DB2 FORCE is specified
  - the SQL statement should be supported in native mode
  - the SQL statement is against a Db2 view
  - the Db2 view is not supported
  

Local fix

• None but these messages may be ignored.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 High Performance Unload for     *
  *                 z/OS                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: The following messages are unduly       *
  *                      issued :                                *
  *                                                              *
  *                      INZU010I ITEM STARTING AT (n,p) ENDING  *
  *                      AT (n,p)                                *
  *                      INZU016E type STATEMENT SYNTAX IS       *
  *                      INVALID                                 *
  *                      INZU080E ERROR : SELECT FROM VIEW       *
  *                      'creator.view' IS NOT SUPPORTED BY THE  *
  *                      UTILITY                                 *
  *                                                              *
  *                      when all the conditions below are       *
  *                      fulfilled :                             *
  *                      - DB2 FORCE is specified                *
  *                      - the SQL statement should be           *
  *                        supported in native mode              *
  *                      - the SQL statement is against a Db2    *
  *                        view                                  *
  *                      - the Db2 view is not supported         *
  *                                                              *
  *                      Local fix : None but these messages     *
  *                      may be ignored.                         *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  undesirable messages INZU080E INZU016E INZU010I when DB2 FORCE
  and SELECT from unsupported view
  

Problem conclusion

• Code has been changed to fix this problem
  

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

• INZTVAR  INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R520 PSY UI98645

     UP24/10/10 P F410

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.