IT18104: "QUERY OCC" CAN FAIL WITH ANR0162W, "CLI0111E NUMERIC VALUE OUT OF RANGE" WHEN DATA IS IN CONTAINER POOLS

8.1.1.100-IBM-SPOC-WindowsX64
8.1.1.100-IBM-SPOC-Linuxx86_64
8.1.1.100-IBM-SPOC-Linuxs390x
8.1.1.100-IBM-SPOC-AIX
8.1.1.000-IBM-SPSRV-WindowsX64
8.1.1.000-IBM-SPSRV-Linuxs390x
8.1.1.000-IBM-SPSRV-AIX
8.1.1.000-IBM-SPSRV-Linuxx86_64
IBM Spectrum Protect Server V8.1 Fix Pack 1 (V8.1.1) Downloads
IBM Spectrum Protect Server V7.1 Fix Pack 8 (7.1.8.000) Downloads

APAR status

• Closed as program error.

Error description

• In a directory-container pool environment, "query occupancy" can
  fail with:
  
  
  ANR0162W Supplemental database diagnostic
  information:  1:22003:-99999 ([IBM][CLI Driver] CLI0111E
  Numeric value
  out of range. SQLSTATE=22003).
  
  ANR2034E QUERY OCCUPANCY: No match found using this criteria.
  
  The occupancyT view is using "NUMFILES" and "NUMCHUNKS" from
  "SD_POOL_CLUSTERS" table, which are 64-bit numbers.  But the
  view has them declared as 32-bit numbers.
  Therefore if  "NUMFILES" and/or "NUMCHUNKS"  has a value greater
  than  the 32bit maximum of 2,147,483,647, the error will occur
  when issuing "query occupancy". <=== period
  
  This APAR is to document that 64-bit numbers are required here.
  
  Note:
  NUMFILES is unlikely to be the cause as it would need a
  filespace to have over 2,147,483,647 files stored on the server.
  
  IBM Spectrum Protect versions affected:
  Server 7.1.3.x and higher on all supported platforms
  
  
  
  Initial Impact: Low
  
  Additional Keywords:  TSM IBM Spectrum Protect query occ
  occupancy numeric sd
  

Local fix

• If NUMCHUNKS is the cause, upgrade to 7.1.7.001 or higher server
   and run "repair occupancy stgpool_name node_name fix=yes"
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Tivoli Storage Manager and IBM Spectrum Protect server   *
  * users                                                        *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in levels 7.1.8 and 8.1.1. 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 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