JR38797: LOAD OF TABLE DEFINITIONS INTO A STAGE TAKING LONG TIME

IBM InfoSphere Information Server, Version 8.5 Fix Pack 2

APAR status

• Closed as program error.

Error description

• Steps to reproduce issue:
  1. Created parallel job in DataStage (DS) Designer client.
  2. Move sequential file stage to canvas
  3. Double-click stage to access properties.
  4. Click Columns tab
  5. Click Load button and table def to load.
  6. Select table definitions and click OK.
  

Local fix

Problem summary

• Use of multiple queries to determine whether table definition
  has an associated shared table definition performs poorly when
  project uses large numbers of shared table definitions.
  

Problem conclusion

• Refactored code to use a single query to gather details of all
  table definitions in project and their associated shared table
  definitions.
  Request patch JR41470 for this fix.
  

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

• Fixed component name

  WIS DATASTAGE

• Fixed component ID

  5724Q36DS

Applicable component levels

• R850 PSY

     UP