JR30142: SYSSCHEMA IS NOT SHOWING AS AN AVAILABLE CLI SETTING IN CONFIGURATION ASSISTANT.

DB2 Version 9.5 Fix Pack 4  for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 4a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• Open CA --> Right click on host database,
  choose CLI Settings --> Click the 'Settings' tab --> Click on
  'Add'.
  'SYSSCHEMA' keyword is not listed in the available keywords.
  
  But gets updated through CLP.
  
  C:\Program Files\IBM\SQLLIB\BIN>db2 update cli cfg for section
  common using sysschema
  <schemaname>
  DB20000I  The UPDATE CLI CONFIGURATION command completed
  successfully.
  Under the 'Settings' tab, now the keyword, SYSSCHEMA, was set.
  

Local fix

• Update cli cfg from CLP.
  

Problem summary

• Users Affected:
  All users using V9.5 configuration assistant.
  
  Problem description:
  'SYSSCHEMA' keyword is not listed in the available CLI keywords
  in Configuration Assistant.
  
  Problem Summary:
  Open CA --> Right click on host database,
  choose CLI Settings --> Click the 'Settings' tab --> Click on
  'Add'.
  'SYSSCHEMA' keyword is not listed in the available keywords.
  
  But gets updated through CLP.
  
  C:\Program Files\IBM\SQLLIB\BIN>db2 update cli cfg for section
  common using sysschema
  <schemaname>
  DB20000I  The UPDATE CLI CONFIGURATION command completed
  successfully.
  Under the 'Settings' tab, now the keyword, SYSSCHEMA, was set.
  

Problem conclusion

• First fixed in V9.5 FP4.
  

Temporary fix

• Update cli cfg from CLP.
  

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  JR30140

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 CEE WINDOWS

• Fixed component ID

  5765F3001

Applicable component levels

• R810 PSN

     UP

• R820 PSN

     UP

• R910 PSN

     UP

• R950 PSN

     UP