IT26487: OFFLINE BACKUP MAY FAIL WITH SQL2048N WHEN PROCESSING AN MDC TABLE

APAR status

• Closed as program error.

Error description

• Offline backup may fail SQL2048N if there is an MDC table within
  an SMS tablespace.
  
  
  The following messages will be in the diaglog:
  
  FUNCTION: DB2 UDB, ABP, ABPIcoordAgent::spawnIcoordAgent,
  probe:200
  MESSAGE : ZRC=0x8005006D=-2147155859=SQLE_CA_BUILT
            "SQLCA has been built and saved in component specific
  control block."
  CALLED  : DB2 UDB, base sys utilities,
  sqeIcoordCB::DispatchIndependentDBAgent
  RETCODE : ZRC=0x80A90442=-2136406974=ABP_NO_AGENT
            "Maximum number of connections reached."
  
  FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, probe:1108
  
  FUNCTION: DB2 UDB, database utilities, sqlubReadSMS, probe:1109
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All                                                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * None                                                         *
  ****************************************************************
  

Problem conclusion

• Upgrade to DB2 V11.1 Mod4 Fixpack 5
  

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