IT32938: CAPTURE_STORAGE_INFO MAY FAIL WITH SQL0443N

Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• In a DPF environment, if any tablespace does not exist on the
  partition the procedure is called from, we will fail with
  SQL0443N.  For example, we call the procedure from node 2, but
  tablespace TEST only exists on nodes 3 and 4, we will return the
  SQL0443N error.  This is due to an incomplete return for a query
  of GetContainerInfo that fails to reset a return code when we
  encounter the missing tablespace on the requesting partition and
  that the information is not currently being collected per
  partition.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * specific to DPF                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * apply containing fix pack                                    *
  ****************************************************************
  

Problem conclusion

• apply m4fp7
  

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:

Fix information

• Fixed component name

  DB2 FOR LUW

• Fixed component ID

  DB2FORLUW

Applicable component levels

• RB10 PSN

     UP

• RB10 PSY

     UP

• RB50 PSN

     UP

• RB50 PSY

     UP