PH33720: DSNTIAUL ENDS WITH RC=04 AFTER SQLCODE -913 ( SQLCODE913 )

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• A DSNTIAUL jobstep ends with RC=04 after getting SQLCODE -913.
  It is a job using DSNTIAUL accessing a table on IDAA
  appliance.
  In this example, DSNTIAUL did issue following messages
  ( ... )
  DSNT490I SAMPLE DATA UNLOAD PROGRAM
            SET CURRENT QUERY ACCELERATION=ELIGIBLE
  DSNT400I SQLCODE = 000,  SUCCESSFUL EXECUTION
  ( ... )
  DSNT408I SQLCODE = -913, ERROR:
  DSNT418I SQLSTATE   = 57033 SQLSTATE RETURN CODE
  DSNT415I SQLERRP    =          SQL PROCEDURE DETECTING ERROR
  DSNT497I RETURN CODE FROM MESSAGE ROUTINE               12
  
  The Job itself ends with RC=04:
  J0112410  $HASP395 DSNTIAUL ENDED - RC=0004
  
  The jobstep should end with RC=12, because DSNTIAUL cannot
  unload data from a table.
  
  ADDITIONAL SYMPTOMS:
  SQLCODE913 MSGDSNT497I
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Db2 11 for z/OS and Db2 12 for z/OS                      *
  * users of DSNTIAUL and IBM Db2 Analytics                      *
  * Accelerator (IDAA).                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DSNTIAUL ends with RC=04 after                               *
  * receiving SQLCODE913 from IDAA.                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply corrective PTF when available                          *
  ****************************************************************
  User ran DSNTIAUL with option SQL. The SQL was run on the
  asscelerator and it hit SQLCODE -913. DSNTIAUL printed out the
  SQL error followed by MSGDSNT497I:
  DSNT497I RETURN CODE FROM MESSAGE ROUTINE               12
  Then it ended with RC=04.
  SQLCODE913 is a severe error, DSNTIAUL should end with RC=12.
  

Problem conclusion

• DSNTIAUL has been changed to end with RC12 after receiving
  severe error from IDAA.
  

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:

  UI74914 UI74915

Modules/Macros

• DSNTIAUL
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RB10 PSY UI74914

     UP21/04/21 P F104

• RC10 PSY UI74915

     UP21/04/21 P F104

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.