IT32788: POINT-IN-TIME RESTORE OF SQL FAILS IF THE SQL SERVER LOCALE IS SET TO NON-ENGLISH.

APAR status

• Closed as program error.

Error description

• If the locale of SQL server is defined as non-English,
  Point-in-Time (PIT) restore fails with the error:
  [SQL Server] Invalid value specified for
  the STOPAT parameter.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.4 and 10.1.5            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in Spectrum Protect Plus levels        *
  * 10.1.5.2218 and 10.1.6. Note that this is subject to change  *
  * at the discretion of IBM                                     *
  ****************************************************************
  

Problem conclusion

• Made changes to specify PIT time in ISO 8601 format to handle
  all locales.
  

Temporary fix

Comments

APAR Information

• 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

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels