IBM Support

IT32169: SQL PIT RESTORE MAY FAIL WITH IN-MEMORY OLTP DATABASE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • PIT restore of SQL In-Memory OLTP database may fail when "move"
    option is added to restore command, which is supposed to be
    skipped for in-memory database directory. The following error
    is displayed in the job log:
    
    ERROR,1581430572066,<date,time,timezone>,2,CTGGE0086,[host-name/
    ip] Failed to restore the database [sql-database] of instance
    [sql-instance] error[ProcessStatementOutput: SQL_ERROR
    [[Microsoft][ODBC SQL Server Driver][SQL Server]The file
    'WWI_InMemory_Data_1' cannot be moved by this RESTORE
    operation.[Microsoft][ODBC SQL Server Driver][SQL
    Server]Problems were identified while planning for the RESTO].
    
    Versions affected: 10.1.*
    
    Additional keywords: TS003342871
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus level 10.1.3, 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 IBM Spectrum Protect Plus level        *
    * 10.1.5.2199 and 10.1.6. Note that this is subject to change  *
    * at the discretion of IBM.                                    *
    ****************************************************************
    

Problem conclusion

  • Made changes for not using move option while applying logs to in
    memory database.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT32169

  • Reported component name

    SP PLUS

  • Reported component ID

    5737SPLUS

  • Reported release

    A15

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-03-13

  • Closed date

    2020-03-25

  • Last modified date

    2020-03-25

  • 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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A15","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
31 January 2024