DB2 - Problem description
Problem IT24403 | Status: Closed |
THE LIMITATION CONCERNING DB2 NON-DEFAULT STORAGE GROUPS AND RESTORE IS NOT DOCUMENTED | |
product: | |
DP-MY SAP W/DB2 / 5698ERPD2 / 71A - DB2 | |
Problem description: | |
DB2 non-default storage groups are not supported for restore by IBM Spectrum Protect and Tivoli Storage Manager for Enterprise Resource Planning - Data Protection for SAP. Listing DB2 storage groups with the DB2 query: db2pd -storagegroups -db [database name] ... will show whether DB2 non-default storage group(s) are present. In the TDI file that is used by the Backup Object Manager for the redirected restore only storage paths for the default storage group will be listed. This is not sufficiently documented in the Knowledge Center. Affected versions: =================== IBM Spectrum Protect for Enterprise Resource Planning - Data Protection for SAP with DB2 7.1 and 8.1 on AIX, Linux, Windows, HP-UX, and Solaris. Initial Impact: Low Additional Keywords: tsm sap db2 erp restore | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of Tivoli Storage Manager for Enterprise Resource * * Planning V7.1.x * * * * Users of IBM Spectrum Protect for Enterprise Resource * * Planning V8.1.x * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR Description * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is * * currently projected to be fixed in the next targeted * * release. * * Note that this information is subject to change at the * * discretion of IBM. * * The updates will be published in the following Documentation * * Updates Techdocs. * * * * IBM Spectrum Protect for Enterprise Resource Planning * * Documentation Updates techdoc * * V8.1: * * http://www-01.ibm.com/support/docview.wss?uid=swg27049254 * * V7.1: * * http://www-01.ibm.com/support/docview.wss?uid=swg27046027 * **************************************************************** | |
Local Fix: | |
To perform a redirected restore of a DB2 database having non-default storage groups modify the TDI file manually and use it together with Backup Object Manager interactive mode restore command like described in the "Redirected restore in interactive mode" : https://www.ibm.com/support/knowledgecenter/SSZHVN_7.1.3/erp.db2 /t_dperp_d_res_redirectedinteract.html | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 16.03.2018 11.06.2018 11.06.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |