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

8.1.25.000-IBM-SPSRV-WindowsX64-340
8.1.25.000-IBM-SPSRV-Linuxx86_64-340
8.1.25.000-IBM-SPSRV-Linuxs390x-340
8.1.25.000-IBM-SPSRV-Linuxppc64le-340
8.1.25.000-IBM-SPSRV-AIX-340

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 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)
  ...
  
  2024.05.10 15:27:49 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)
  >>
  
  
  
  Further the SQL DBSTMT DBCLI DBCMD trace shows:
  
  >>
  
  [2787][tbrsql.c][1911][TraceMsg]:ANR0162W Supplemental database
  diagnostic information:  1:22003:-99999 ([IBM][CLI Driver]
  CLI0111E  Numeric value out of range. SQLSTATE=22003).~
  [7][tbcli.c][11409][TraceSetInputParameters]:col=3,
  name=MESSAGE, type=STRING, value=ANR0162W Supplemental database
  diagnostic information:  1:22003:-99999 ([IBM][CLI Driver]
  CLI0111E  Numeric value out of range. SQLSTATE=22003
  [2787][tbrsql.c][1911][TraceMsg]:ANR0162W Supplemental database
  diagnostic information:  -1:22003:-99999 ([IBM][CLI Driver]
  CLI0111E  Numeric value out of range. SQLSTATE=22003).~
  
  ...
  
  [tbcli.c][11593][TraceFetchAndGetNextResponse]:key=2,
  name=ACTIVITY_ID, type=INT32, value=250
  
  <<
  
  IBM Storage Protect Versions Affected:
  IBM Storage Protect Server versions 8.1.19 and above on all
  supported platforms
  
  
  Additional Keywords: TS016185097, COPY RETENTION SET, Storage
  Protect
  

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.25. Note that this is     *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

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

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

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels