IT25618: SELECT RUN AGAINST "STGPOOL_DIRS" CAN SHOW A NEGATIVE VALUE FOR "FREE_SPACE_MB" OR "TOTAL_SPACE_MB"

8.1.7.000-IBM-SPSRV-Linuxppc64le
8.1.7.000-IBM-SPCMS-WindowsX64
8.1.7.000-IBM-SPCMS-WindowsI32
8.1.7.000-IBM-SPCMS-Linuxx86_64
8.1.7.000-IBM-SPOC-WindowsX64
8.1.7.000-IBM-SPOC-Linuxx86_64
8.1.7.000-IBM-SPOC-Linuxs390x
8.1.7.000-IBM-SPOC-LinuxPPC64le
8.1.7.000-IBM-SPOC-AIX
8.1.7.000-IBM-SPSRV-WindowsX64
8.1.7.000-IBM-SPSRV-Linuxx86_64
8.1.7.000-IBM-SPSRV-Linuxs390x
8.1.7.000-IBM-SPSRV-AIX
IBM Spectrum Protect Server V8.1 Fix Pack 7 (V8.1.7) Downloads

APAR status

• Closed as program error.

Error description

• Running a select against "stgpool_dirs" can display a negative
  value for FREE_SPACE_MB or TOTAL_SPACE_MB
  if the value exceeds 2147483647 MB
  
  ie.
  select * from stgpool_dirs
  
  STGPOOL_NAME: POOLA
  DIR_NAME: /filesystem_name/directory_name
  DIRID: 1
  ACCESS: READWRITE
  FREE_SPACE_MB: -2082198952      <-- displayed as negative value
  
  
  Initial Impact: Low
  
  Spectrum Protect versions affected:
  Server  7.1.3.x and 8.1.x on all supported platforms
  
  
  
  Keywords:
  
  TS001105977   TSM stgpooldir free space total space overflow
  integer
  

Local fix

• Use 'q stgpooldir f=d' to check free space or total space, as it
  will not
  display free space nor total space as a negative value
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All IBM Spectrum Protect server users of SELECT FROM         *
  * STGPOOL_DIRS                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in level 8.1.7. Note that this is      *
  * subject to change at the discretion of IBM.                  *
  ****************************************************************
  

Problem conclusion

• This problem was fixed.
  Affected platforms for reported release:  AIX, Linux, and
  Windows.
  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