IBM Support

IT47525: COPY RETENTION SET RULE CAN FAIL WITH ANR9999D_1267451768 / CLI0111E

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • Running copy retention set, an error may occur from the client
    driver when fetching results.
    The following can be seen in the IBM Storage Protect server
    activity log:
    
    <<
    ANR0232I The retention set copying process XXX for
    storage rule RETPOOL is completed. Data was copied from
    retention set XXX to tape storage pool RET_TAPE_POOL. The
    following results are available: copied files: 0, copied
    bytes: 0 bytes, skipped files: 0, skipped bytes: 0,
    total transferred bytes: 0 bytes, elapsed time: 0 Days,
    0 Hours, XX Minutes. (SESSION: XXXX, PROCESS: XXX, JOB:
    XXX)
    ...
    ANR0162W Supplemental database diagnostic
    information:
    1:22003:-99999 ([IBM][CLI Driver] CLI0111E Numeric
    value out of range. SQLSTATE=22003). (SESSION: XXXXX,
    PROCESS: XXX, JOB: XXX)
    ...
    ANR9999D_1267451768 EndCopyRetsetParentProcess(scret.c:24-
    14) Thread<XXXX>: Error 2343 updating retention set
    statistics to recalculate retention set XXX.(SESSION:
    XXXX, PROCESS: XXX, JOB: XXX)
    >>
    
    This is a continuation of IT46521 that did not fully fix the
    issue.
    
    
    | MDVPARTL 8.1.25.0-TIV_5698MSV | (IT46521)
    
    IBM Storage Protect Versions Affected:
    IBM Storage Protect Server 8.1.25 and higher on all supported
    platforms
    
    Additional Keywords:
    
    TS018024233, TSM, copy retention set. IT46521
    

Local fix

Problem summary

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

Problem conclusion

  • This problem was fixed.
    Affected platforms: AIX, Linux, and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT47525

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    81W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2025-01-13

  • Closed date

    2025-01-30

  • Last modified date

    2025-01-30

  • 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

[{"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"81W"}]

Document Information

Modified date:
29 March 2025