PI42593: INVALID COLLATION WHEN CONFIGURING CCMDB FOR RATOINAL ASSET MANAGER

Rational Asset Manager Fix Pack 3 (7.5.2.3) for 7.5.2
Rational Asset Manager Fix Pack 4 (7.5.2.4) for 7.5.2
Rational Asset Manager 7.5.3
Rational Asset Manager 7.5.3.1
Rational Asset Manager 7.5.3.2
Rational Asset Manager 7.5.3.3
Rational Asset Manager 7.5.4
Rational Asset Manager 7.5.4.1
Rational Asset Manager 7.5.4.2
Rational Asset Manager 7.5.4.3
Rational Asset Manager 7.5.4.4
Rational Asset Manager 7.5.4.5
Rational Asset Manager 7.5.4.6
Rational Asset Manager 7.5.4.7
Rational Asset Manager 7.5.4.9
Rational Asset Manager 7.5.4.8
Rational Asset Manager 7.5.4.10

APAR status

• Closed as fixed if next.

Error description

• The following article in Rational Asset Manager Knowledge Center
  has an incorrect value for CCMDB's Collation:
  http://www-01.ibm.com/support/knowledgecenter/SSUS84_7.5.1/com.i
  bm.ram.installguide.doc/topics/t_database_RTC_lifecycle_MsSQL.ht
  ml
  
  
  The value of Collation is: Latin1_General_CP437_CS_AS
  But it must be:  SQL_Latin1_General_CP1_CS_AS
  

Local fix

• You must use SQL_Latin1_General_CP1_CS_AS instead of
  Latin1_General_CP437_CS_AS.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Document                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * In                                                           *
  * http://www-01.ibm.com/support/knowledgecenter/SSUS84_7.5.1/c *
  * om.ibm.ram.installguide.doc/topics/t_database_RTC_lifecycle_ *
  * MsSQL.html                                                   *
  * The step 4 which is saying "ALTER DATABASE ccmdb COLLATE     *
  * Latin1_General_CP437_CS_AS GO", while we need to correct it  *
  * to "SQL_Latin1_General_CP1_CS_AS"                            *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R752 PSY

     UP