PI92553: A LOGICAL UNLOAD FAILS WITH DSNT408I SQLCODE = -4742, ERROR: ...(REASON 4)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A logical unload fails after the following message has been
  issued:
  DSNT408I SQLCODE = -4742, ERROR: THE STATEMENT CANNOT BE
  EXECUTED BY DB2 OR IN THE ACCELERATOR (REASON 4)
  This occurs if all the following conditions are fulfilled:
  - the fix for PI84324 (PB49786) has been applied
  - the QUERY_ACCELERATION feature is applicable (i.e. DB2 FORCE
  is specified and neither - the DB2 HPU QUERY_ACCELERATION NONE
  option nor the DB2 setting QUERY_ACCELERATION=NONE is specified
  - the involved SELECT statement is not a read-only statement
  
  PB51719
  

Local fix

• add the FOR READ ONLY clause to the involved SELECT statement.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 High Performance Unload     *
  *                 z/OS.                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION: A logical unload fails after the        *
  *                      following message has been issued:      *
  *                      DSNT408I SQLCODE = -4742, ERROR: THE    *
  *                       STATEMENT CANNOT BE EXECUTED BY DB2    *
  *                       OR IN THE ACCELERATOR (REASON 4)       *
  *                      This occurs if all the following        *
  *                      conditions are fulfilled:               *
  *                      - the fix for PI84324 (PB49786) has     *
  *                       been applied                           *
  *                      - the QUERY_ACCELERATION feature is     *
  *                       applicable (i.e. DB2 FORCE is          *
  *                       specified and neither - the DB2 HPU    *
  *                       QUERY_ACCELERATION NONE option nor     *
  *                       the DB2 setting                        *
  *                       QUERY_ACCELERATION=NONE is specified)  *
  *                      - the involved SELECT statement is      *
  *                       not a read-only statement              *
  *                      pb51719                                 *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

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:

  UI53550

Modules/Macros

•    INZQRYV8 INZTPMEM INZUTILK
  

Fix information

• Fixed component name

  DB2 HI PERF UNL

• Fixed component ID

  5697F4400

Applicable component levels

• R430 PSY UI53550

     UP18/02/01 P F801

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.