APAR status
Closed as program error.
Error description
After importing an Erwin model with 450 table definition into XMETA, the 'create table from shared metadata' function is taking far too long to create the definitions within DataStage. In my example, I select 450 tables and the import/creation only managed to create 140 tables in over 6 hours.
Local fix
The work-around is to select fewer tables for table creation. This means more manual steps, but the tables will be created much quicker.
Problem summary
**************************************************************** USERS AFFECTED: Create table from shared metadata. **************************************************************** PROBLEM DESCRIPTION: Performance issue with creating many tables from shared metadata. **************************************************************** RECOMMENDATION: See Local Fix field for workaround. No patch is available for this issue. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
Performance issue has been resolved.
Temporary fix
Comments
APAR Information
APAR number
JR30806
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
801
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2008-10-17
Closed date
2009-12-15
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:
Modules/Macros
CLIENT
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R801 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.0.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 December 2009