JR30694: INFORMATION SERVICES DIRECTOR BROWSE DATABASE FEATURE IN THE SELECT AN INFORMATION PROIVIDER WINDOW PERFORMS POORLY.

APAR status

• Closed as program error.

Error description

• In IBM InfoSphere Information Services Director, the browse
  database feature of the Select an Information Provider window
  performs poorly as the number of tables and columns increases in
  a given database connection.
  
  This problem is present only the 8.1 Windows and Linux release.
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  ISD users attempting to expose Oracle queries as services
  ****************************************************************
  PROBLEM DESCRIPTION:
  In IBM InfoSphere Information Services Director, the browse
  
  database feature of the Select an Information Provider window
  performs poorly as the number of tables and columns increases in
  a given database connection.
  
  This problem is present only the 8.1 Windows and Linux release.
  ****************************************************************
  RECOMMENDATION:
  Install Information Server 8.1.0 FP1 (8.1.0.1)
  ****************************************************************
  

Problem conclusion

• The code in ISD scanning the Oracle catalog for table metadata
  performed inefficient calculations. The algorithms were changed
  to offer better performance
  

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:

Modules/Macros

• SERVER
  

Fix information

• Fixed component name

  WS INFORM. SRVC

• Fixed component ID

  5724Q3600

Applicable component levels

• R810 PSY

     UP