IC66595: QUERY DBSPACE RETURNS "ANS8001I RETURN CODE 2104"

APAR status

• Closed as program error.

Error description

• When issueing 'QUERY DBSPACE' the following is returned on the
  command line:
    ANS8001I Return code 2104.
  
  The server's activity log will report the following:
  01/15/2010 10:00:37 ANR2017I Administrator ADMIN issued command:
   QUERY DBSPACE (SESSION: 2412)
  01/15/2010 10:00:22  ANR1139E The QUERY DBSPACE command failed
   because no data was returned from the database manager.
  (SESSION: 2425, PROCESS: 8)
  To confirm that this APAR applies, the following select query
  can be executed:
  select db_storage_path,fs_total_size,fs_used_size,
  sto_path_free_size from sysibmadm.snapstorage_paths
  If the FS_USED_SIZE reported is blank for one or multiple
  entries, then this APAR applies.
  
  
  Versions Affected:  Server 6.1 all platforms
  Initial Impact:  low
  Additional Keywords: tsm zz61
  

Local fix

• Recycle the TSM Server and re-issue the command.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: The QUERY DBSPACE command issued from   *
  *                      the administrative client returns       *
  *                      "ANS8001I RETURN CODE 2104"             *
  *                      when the server fails to collect the    *
  *                      statistics of the file systems where    *
  *                      the database directories are located.   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  See Problem Description
  

Problem conclusion

• The server code has been updated so that it always displays
  the QUERY DBSPACE output even when some output fields do not
  have values. The error message has also been updated to
  inform customers of all the possible causes of this problem
  and how to respond to them.
  
  Here is the updated message:
  
  ANR1139E: The QUERY DBSPACE command failed because
  some data was missing
  
  Explanation
  An attempt to gather database statistics from the database
  manager failed. This failure can occur if either of these
  conditions is met:
  . The buffer pool monitor switch (DFT_MON_BUFPOOL) has been
  set to 'OFF.' The buffer pool monitor switch controls the
  collection of database statistics.
  . The file systems or drives are in a remote network. There
  might be a network problem causing the server fail to collect
  the statistics of those volumes.
  
  System action
  The command fails, and the server operation continues.
  
  User response
  Take one of the following actions, and then try running the
  QUERY DBSPACE command again:
   .  Stop and restart the server.
   .  Set the buffer pool monitor switch to 'ON' using this
       DB2 command:
      'db2 update db cfg using DFT_MON_BUFPOOL ON'.
   .  If you cannot obtain drive or file system statistics by
      running operating system commands, fix the problem, then
      try running the command again.
  

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

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP