IZ58400: LOAD FROM CURSOR WITH DATABASE CLAUSE ('REMOTE-FETCH') FAILS OR TRAPS IF DB2_PARTITIONEDLOAD_DEFAULT=NO

DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as fixed if next.

Error description

• Loading from a CURSOR that was defined with the DATABASE clause
  (also known as a 'remote-fetch' load) may fail with an SQL1024N
  if the DB2_PARTITIONEDLOAD_DEFAULT is set to no or false, and
  the instance is DPF (including single-node DPF).
  
    SQL3254N  The utility is beginning to load data from the Table
  ""."" in database"".
    SQL1024N  A database connection does not exist.
  SQLSTATE=08003
  
  In some scenario's a trap has occurred, but is unlikely.
  

Local fix

• Unset DB2_PARTITIONEDLOAD_DEFAULT (or set to 'yes') if this
  makes sense from your application perspective.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * all users running load                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Loading from a CURSOR that was defined with the DATABASE     *
  * clause                                                       *
  * (also known as a 'remote-fetch' load) may fail with an       *
  * SQL1024N                                                     *
  * if the DB2_PARTITIONEDLOAD_DEFAULT is set to no or false,    *
  * and                                                          *
  * the instance is DPF (including single-node DPF).             *
  *                                                              *
  *                                                              *
  *                                                              *
  *   SQL3254N  The utility is beginning to load data from the   *
  * Table                                                        *
  * ""."" in database"".                                         *
  *                                                              *
  *   SQL1024N  A database connection does not exist.            *
  *                                                              *
  * SQLSTATE=08003                                               *
  *                                                              *
  *                                                              *
  *                                                              *
  * In some scenario's a trap has occurred, but is unlikely.     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to product DB2 v9.1 fixpak 9                         *
  ****************************************************************
  

Problem conclusion

Temporary fix

• Unset DB2_PARTITIONEDLOAD_DEFAULT (or set to 'yes') if this
  makes sense from your application perspective.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  IZ58401 IC65694

Fix information

Applicable component levels

• R910 PSN

     UP

• R910 PSY

     UP

• R950 PSN

     UP

• R950 PSY

     UP