A fix is available
APAR status
Closed as program error.
Error description
An SQL query performed against the PROF_ASSOCIATIONS table view does not display all profile associations as expected. Only those associations that were defined with a wild card ('*') will be returned from this query. For example, the SQL query would return information for an association that was defined as: DEFINE PROFASSOCIATION MYPROFILE DOMAINS=* However, the same query would not return information for an association that had been defined as: DEFINE PROFASSOCIATION MYPROFILE DOMAINS=MYDOMAIN This problem only affects SQL queries issued against the PROF_ASSOCIATIONS table view within TSM, there is no problem with the information in the underlying DB2 table. In addition, the 'QUERY PROFILE F=D' command will accurately show all of the associations for a given profile. Platforms affected: All TSM 6.1.x and 6.2.x Servers Additional Keywords: SELECT profassoc
Local fix
Use the 'QUERY PROFILE F=D' command to display all profile associations.
Problem summary
**************************************************************** * USERS AFFECTED: All Tivoli Storage Manager server users of * * configuration management. * **************************************************************** * PROBLEM DESCRIPTION: See error description. * **************************************************************** * RECOMMENDATION: Apply fixing level when available. This * * problem is currently projected to be fixed * * in levels 6.1.3.4, 6.1.4 and 6.2.2. Note * * that this is subject to change at the * * discretion of IBM. * **************************************************************** *
Problem conclusion
This problem was fixed. Affected platforms: AIX, HP-UX, Sun Solaris, Linux, and Windows.
Temporary fix
Comments
APAR Information
APAR number
IC67677
Reported component name
TSM SERVER
Reported component ID
5698ISMSV
Reported release
61A
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-04-06
Closed date
2010-04-09
Last modified date
2010-04-09
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
[{"Line of Business":{"code":"LOB26","label":"Storage"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"61A"}]
Document Information
Modified date:
16 September 2021