APAR status
Closed as Permanent restriction.
Error description
Tivoli Storage FlashCopy Manager for DB2 backups can fail when using DB2 Automatic Storage if the same paths are specified multiple times upon setting up the database. This is a valid DB2 configuration, but Flashcopy Manager does not support this. This needs to be documented. Initial impact: Medium Platforms Affected: FlashCopy Manager for DB2 2.1, 2.2, and 3.1 L2 diagnostics: A client trace will shows a series of paths specified multiple times: 09:45:03.460 400 (1) esd-clientinterfacevalues.cpp:1015 iter.value().data()=erpprd1 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/log_dir/NODE0000/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/db2prd/NODE0000/SQL00001/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/db2prd/NODE0000/sqldbdir/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata1/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata1/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata1/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata1/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata2/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata2/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata2/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata2/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata3/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata3/db2prd/NODE0000/PRD/ 09:45:03.460 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata3/db2prd/NODE0000/PRD/ 09:45:03.461 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata3/db2prd/NODE0000/PRD/ 09:45:03.461 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata4/db2prd/NODE0000/PRD/ 09:45:03.461 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata4/db2prd/NODE0000/PRD/ 09:45:03.461 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata4/db2prd/NODE0000/PRD/ 09:45:03.461 400 (1) esd-db2BA.cpp:1798 pCurrentPath->path=/db2/PRD/sapdata4/db2prd/NODE0000/PRD/ . Flashcopy Manager assumes the paths are redundant and will fail. Additional Keywords: partitioning
Local fix
DB2 configuration needs to be redesigned. In the example trace above, an additional subdirectory can be introduced, for example: /db2/PRD/sapdata1/cont1/db2prd/NODE0000/PRD/ /db2/PRD/sapdata1/cont2/db2prd/NODE0000/PRD/ /db2/PRD/sapdata1/cont3/db2prd/NODE0000/PRD/ /db2/PRD/sapdata1/cont4/db2prd/NODE0000/PRD/ These 4 paths (including the cont* directory) could then be used to configure Automatic Storage in a way so that Flashcopy Manager sees them as distinct paths.
Problem summary
**************************************************************** * USERS AFFECTED: All users of IBM Tivoli Storage FlashCopy * * Manager for DB2 who back up * * data stored on DB2 Automatic Storage. * **************************************************************** * PROBLEM DESCRIPTION: See ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * **************************************************************** *
Problem conclusion
This APAR will not be fixed. A problem can occur when using IBM Tivoli Storage FlashCopy Manager to protect data stored on DB2 Automatic Storage. Actions to prevent or solve such situations are outlined in the 'Local fix' section.
Temporary fix
Comments
APAR Information
APAR number
IC83834
Reported component name
FLSHCPY DB2 AGE
Reported component ID
5608AC6DB
Reported release
31A
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-05-29
Closed date
2012-08-30
Last modified date
2012-08-30
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS36V9","label":"Tivoli Storage FlashCopy Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"31A","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
30 August 2012