IT27903: SQL SERVER APPLICATION BACKUP FAILED TO READ JOURNAL DATA, ERROR[1181]

APAR status

• Closed as program error.

Error description

• During an IBM Spectrum Protect Plus SQL Backup, it can fail
  with the following message in the job log:
  
      Failed to read journal data  error [1181]
  
    This is due to the Update Sequence Number (USN) Journal
    resetting. When the reset of the USN occurs it is to
    force a base backup on the files of the impacted volume
    rather than force the backup to fail and generate the
    message above.
  
  IBM Spectrum Protect Plus Versions Affected:
    10.1.1 and 10.1.2
  Customer/L2 Diagnostics (If Applicable)
    N/A
  
  Initial Impact:
    Low
  

Local fix

•   N/A
  

Problem summary

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

Problem conclusion

• A base backup is forced when a journal reset is detected on a
  volume where a database is located
  

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:

Modules/Macros

• winagent
  

Fix information

• Fixed component name

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels