IT43086: DB2 RESTORE WITH POINT-IN-TIME TYPE TO AN ALTERNATE LOCATION MIGHT SHOW DB2 ERROR SQL5099N

APAR status

• Closed as program error.

Error description

• When IBM Spectrum Protect Plus db2 restore job
  is started, then the command log for the restore
  job may contain the Db2 error SQL5099N.
  Even though the job was finished successfully
  and there are no errors in the job log:
  
  stdout:
  ===SPPAgent-output===
  SQL5099N  The value "LOGRETAIN" indicated by the database
  configuration parameter "LOGARCHMETH1" is not valid, reason code
  "13".
  
  
  
  IBM Spectrum Protect Plus Versions Affected:
  IBM Spectrum Protect Plus versions from 10.1.2 and  later
  
  Additional Keywords: SPPLUS, TS008182333, db2,  restore,
  Point-in-time,
  
  LOGARCHMETH1, SQL5099N
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus 10.1.2  till 10.1.14 users who     *
  * restore a Db2 database.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See "Error description".                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in IBM Spectrum Protect Plus level     *
  * 10.1.14.1 and 10.1.15.                                       *
  * Note that this is subject to change at the discretion of     *
  * IBM.                                                         *
  ****************************************************************
  

Problem conclusion

• The redundant setting of the database parameters was removed
  from the IBM Spectrum Protect Plus for Db2 agent so that
  misleading Db2 errors like  SQL5099N will not be printed into
  the command.log.
  

Temporary fix

• If the restore job was finished successfully and there are no
  errors in the job log then the Db2 error SQL5099N printed in the
  command.log for the restore job can be ignored.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• Db2
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels