IBM Support

IT05706: GENERATE BACKUPSET RUNNING CONCURRENT WITH REORG MAY FLOOD ACTIVITY LOG WITH ANR0106E MESSAGES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • During a GENERATE BACKUPSET process, if the server gets into a
    database lock conflict because of a parallel running REORG, the
    activity log may get flooded with with ANR0106E messages.
    
    Customer/L2 Diagnostics:
    The activity log may show the following messages sequence:
    
    10/09/14   17:36:33      ANR0984I Process 42 for GENERATE
    BACKUPSET started in the FOREGROUND at 05:36:33 PM. (SESSION:
    24244, PROCESS: 42)
    [...]
    10/09/14   18:51:36      ANR1880W Server transaction was
    canceled because of a conflicting lock on table
    BACKUP_OBJECTS. (SESSION: 24244, PROCESS: 42)
    
    10/09/14   18:51:37      ANR0106E bfgenset.c(1062): Unexpected
    error 1014 fetching row in table "BFIM_Aggregates".
    (SESSION: 24244, PROCESS: 42)
    [...]
    10/10/14   10:27:08      ANR0106E bfgenset.c(1062): Unexpected
    error 1014 fetching row in table "BFIM_Aggregates".
    (SESSION: 24244, PROCESS: 41)
    10/10/14   10:27:08      ANR0106E bfgenset.c(1062): Unexpected
    error 1014 fetching row in table "BFIM_Aggregates".
    (SESSION: 24244, PROCESS: 42)
    
    Error 1014 mean "DEADLOCK DETECTED"
    
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager Server: 6.x, 7.x  all plattforms
    
    Initial Impact:
    Low
    
    Additional Keywords:
    TSM, REORG, message, loop, backupset
    

Local fix

  • Recycle the Tivoli Storage Manager server and disable REORG for
    tables and indexes while the "generate backupset"
    job is ongoing.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All Tivoli Storage Manager server users.                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See ERROR DESCRIPTION.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available.                           *
    * This problem is currently projected to be fixed in level     *
    * 7.1.3.                                                       *
    * Note that this is subject to change at the discretion of     *
    * IBM.                                                         *
    ****************************************************************
    

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT05706

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-11-25

  • Closed date

    2015-02-03

  • Last modified date

    2015-02-03

  • 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

    TSM SERVER

  • Fixed component ID

    5698ISMSV

Applicable component levels

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"63L","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
03 February 2015