PQ75377: ABEND04E RC00D3440B DSNLXGVR:0006 SQLCODE516 DSNL027I DISTRIBUTED SPROC OR STORED PROCEDURE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• After installation of some ptf's all REXX Stored Procedure
  with a RESULT SET are receiving ABEND04E RC00D3440B.
   ABEND04E RC00D3440B DSNLXLLM.DSNLXGVR:0006 SQLCODE516
   DSNL027I 00D3440B DSNLXLLM DSNLXGVR 0006       SQLCALL
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 users running remote stored procedures   *
  *                 with result sets.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00D3440B in DSNLXGVR:0006    *
  *                      or SQLCODE516 occurs when running       *
  *                      remote stored procedures with a result  *
  *                      set.                                    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  When the stored procedure's package is loaded at two different
  levels, two section tables are created.  When processing a
  fetch, describe, or close of a result set cursor, DB2 code did
  not pick up the section table at the correct level. That caused
  the wrong section table to be used and caused ABEND04E in
  DSNLXGVR or SQLCODE516 in DSNXERT2.
  

Problem conclusion

• DB2 code was changed to search for the right section table
  when dealing with remote stored procedure result sets.
  

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:

  UQ79963 UQ79964

Modules/Macros

•    DSNDRDSI DSNLXCQS DSNLXGVR DSNLXMRS DSNLXRSS
  DSNXERT
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R610 PSY UQ79963

     UP03/09/26 P F309

• R710 PSY UQ79964

     UP03/09/26 P F309

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.