APAR status
Closed as program error.
Error description
Memory utilization issues with job imports causes slow imports and intermittent import failures
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Client systems using Designer, dscmdimport or dsimport to import DSX files **************************************************************** PROBLEM DESCRIPTION: Under certain circumstances DSX imports performed through the Designer, dscmdimport or dsimport can take a long time to complete, with the progress dialog remaining unchanged throughout that time. At this stage of the import, just before the end, DataStage tries to connect related repository objects together (ie column in a job related to a column in a table definition). This process will load the repository objects, connect them together and save them again, as necessary. The problem that can occur for certain objects, is that once one object has been loaded it is immediately free'd from memory and then loaded again, free'd again etc. This cycle repeats many times for the same object and hence causes a large unnecessary delay before the import finishes. **************************************************************** RECOMMENDATION: Install the patch. Note the patch is also included in the "8.1 Critical Performance Patch". This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The DSX import has been improved so that the cycle of loading and free'ing objects no longer occurs.
Temporary fix
Comments
APAR Information
APAR number
JR34269
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-15
Closed date
2009-09-24
Last modified date
2009-12-15
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
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 December 2009