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 number
IC66595
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61W
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-02-23
Closed date
2010-04-30
Last modified date
2010-04-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
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
30 April 2010