APAR status
Closed as program error.
Error description
The Oracle Enterprise Stage can read from the table at 24,000 rows/seconds while the Oracle Connector Stage can only achieve 6,000 rows/second. In both cases the bottleneck is the "osh" operator running at 100% on the server. The Oracle Connector Stage is 400% slower than the Oracle Enterprise Stage. Since, the other Connector stages have been faster.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: ALL **************************************************************** PROBLEM DESCRIPTION: Slow performance when executing jobs that used DataStage Date and Timestamp types with Scale and Extended attributes not set. The connector was importing Oracle DATE columns as DataStage Date types when using the MDI Wizard. This is incorrect since the Oracle DATE type can store date (year, month, day) and time (hour, minute, second) values, while the DataStage Date type only store date values. Oracle connector jobs would fail when selecting or inserting Oracle DATE and TIMESTAMP columns with the DataStage Time type. Oracle connector jobs would fail when loading Oracle DATE columns with the DataStage Timestamp type. When Table Action was set to Create, and the Oracle connector was generating the CREATE TABLE statement, the connector would generate INTERVAL data types in the table for DataStage Time and Timestamp types, which are not compatible. **************************************************************** RECOMMENDATION: Download latest Oracle connector patch. This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The code was fixed to increase performance when using DataStage Date and Timestamp types with Scale and Extended attributes not set. The code was fixed to import Oracle DATE columns as DataStage Timestamp with attributes Scale set to 0 and Extended not set. The code was fixed to allow using DataStage Time types when operating with Oracle DATE and TIMESTAMP data types. The code was fixed to allow bulk loading into Oracle DATE columns with the DataStage Timestamp type. The code was fixed to generate a CREATE TABLE statement with DATE columns for DataStage Time or Timestamp columns with Scale and Extended attributes not set. When Time or Timestamp columns have Scale or Extendedattributes set, the connector will generate TIMESTAMP columns.
Temporary fix
Comments
APAR Information
APAR number
JR34322
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-21
Closed date
2009-09-30
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
SERVER
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