Fixes are available
DB2 Version 9.5 Fix Pack 3b for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows
APAR status
Closed as program error.
Error description
If customer has a split mirrored db that was put into standby mode using db2inidb, and a parallel offline backup is taken using db2_all, this can cause certain non-catalog nodes to fail the backup. If APAR is not applied, parallel backup of a split mirrored db in standby mode using db2_all will fail on some non-catalog nodes. In the db2diag.log you will see a message similar to the following: 2008-03-04-15.21.13.159703-300 E12827A463 LEVEL: Error PID : 291742 TID : 1 PROC : db2agent (DB8) 0 INSTANCE: eddie2 NODE : 000 APPHDL : 0-248 APPID: *N0.eddie2.080304201035 AUTHID : EDDIE2 FUNCTION: DB2 UDB, base sys utilities, sqleSubsequentConnect, probe:65 MESSAGE : SQL1117N A connection to or activation of database "DB8 " cannot be made because of ROLL-FORWARD PENDING. You might also see the following from the db2_all script: db2y01@uncletitus:/db2/Y01/sqllib/acs>db2_all "<<-0<|| db2 backup db y01 to /dev/null exclude logs" rah: omitting logical node 0 rah: primary monitoring process for db2 is 5554390 uncletitus: SQL2406N The BACKUP cannot be performed because the database needs to be uncletitus: rolled forward. SQLSTATE=57019 uncletitus: db2 backup db y01 ... completed rc=4 uncletitus: SQL2406N The BACKUP cannot be performed because the database needs to be uncletitus: rolled forward. SQLSTATE=57019 uncletitus: db2 backup db y01 ... completed rc=4 uncletitus: uncletitus: Backup successful. The timestamp for this backup image is : 20080213122721 uncletitus: uncletitus: db2 backup db y01 ... completed ok
Local fix
The workaround is to backup the individual non-catalog nodes serially. Defect 379514 will fix this issue.
Problem summary
See notes above.
Problem conclusion
First fixed in DB2 UDB Version 9.5, FixPak 2
Temporary fix
Comments
APAR Information
APAR number
IZ16986
Reported component name
DB2 UDB ESE AIX
Reported component ID
5765F4100
Reported release
950
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-03-04
Closed date
2008-08-26
Last modified date
2008-08-26
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 UDB ESE AIX
Fixed component ID
5765F4100
Applicable component levels
R950 PSY
UP
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.