DB2 - Problem description
Problem IT18975 | Status: Closed |
THE IBM SPECTRUM PROTECT ERP INSTALLER OFFERS THE MISLEADING CHOICE TO CONFIGURE BOTH LOGARCHMETHS FOR THE PRODUCT | |
product: | |
DP-MY SAP W/DB2 / 5698ERPD2 / 71A - DB2 | |
Problem description: | |
IBM Spectrum Protect for Enterprise Resource Planning Data Protection for SAP for DB2 is designed to be used with the DB2 log manager as a single one of both log archive methods in the DB2 database configuration, either as LOGARCHMETH1 or as LOGARCHMETH2. In contradiction to the product's design, the following misleading choice is presented by the installer: --------------------------------------- Which DB2 Log Manager method do you want to use for SAP Note: The DB2 instance must be started for the following changes to take effect. Current settings for LOGARCHMETH and corresponding LOGARCHOPT entries will be overridden. ->1- None 2- LOGARCHMETH1 3- LOGARCHMETH2 4- Both ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT --------------------------------------- Since the product is not designed for use with "Both", the installer should not present this choice. The manuals should get updated to document this properly. Adding the product to both log archive methods (e.g. with the intention to store 2 log copies) can yield unexpected results. For example problems with the deletion of obsolete logs by the MAX_VERSIONS parameter have been reported. Customer/L2 diagnostics: na Product versions affected: IBM Spectrum Protect for Enterprise Resource Planning Data Protection for SAP for DB2 Initial impact: Low Additional keywords: Tivoli Storage Manager TSM | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Users of IBM Spectrum Protect for ERP Data Protection for * * SAP for DB2 when installing the product and plan to set the * * profile parameter MAX_VERSIONS to a value greater than zero. * **************************************************************** * PROBLEM DESCRIPTION: * * See error description * **************************************************************** * RECOMMENDATION: * * Do not select to use both DB2 Log Manager methods when * * installing IBM Spectrum Protect for Enterprise Resource * * Planning Data Protection for DB2, or use a fixed version of * * the installer. * * This problem is currently projected to be fixed in level * * 8.1.4. Note that this information is subject to change at * * the discretion of IBM. * **************************************************************** | |
Local Fix: | |
If the product is to store more than one redo log copy, do not select the installer choice "Both", but use the initSID.utl parameter REDOLOG_COPIES instead. | |
Solution | |
The option to configure both log archive methods has been removed from the installer of IBM Spectrum Protect for Enterprise Resource Planning. | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 25.01.2017 29.03.2017 29.03.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |