JR52312: WHEN EXPORTING DATA FROM MWB QUERY RETURNING LARGE NUMBER OF REC(>10,000), PROCESS TAKING MORE THAN AN HOUR IF NOT PRE-SORTED

IBM InfoSphere Information Server, Version 11.3.1.2 (Fix Pack 2)
Download IGC roll-up 16 for Information Server Version 11.3
Download IGC roll-up 18 for Information Server Version 11.3

APAR status

• Closed as program error.

Error description

• When exporting data from MWB Query returning large number of rec
  (>10,000), process taking more than an hour if not pre-sorted.
  
  
  
  Sometimes due to the query running for a long time (couple of
  hours) WAS Session and Transaction also timesout.
  
  However if the data is pre-sorted in GUI, it takes only few
  minutes.
  

Local fix

• Use CLI (istool) command instead of IGC GUI if possible.
  

Problem summary

• Improve performance when exporting a large number of query
  results
  

Problem conclusion

• install patch
  

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

  IS GOVCATLOG

• Fixed component ID

  5724Q36GC

Applicable component levels

• RB30 PSY

     UP