My Oracle Support Banner

IBMIS 8.5: DataStage Incremental Load Performance Decreases Over Time (Doc ID 1523335.1)

Last updated on FEBRUARY 07, 2019

Applies to:

PeopleSoft Enterprise EPM Foundation - Version 9.1 and later
Information in this document applies to any platform.
***Checked for relevance on 14-Aug-2014***


PeopleSoft Enterprise EPM Performance Management Warehouse 9.1 / IBMIS 8.5
Microsoft Windows Server 2008 R2 x64 (64-bit)

IBMIS 8.5 DataStage incremental load performance degrades over time on MicroSoft Windows 2008 Server. Investigated IBMIS 8.5 DataStage processing time. CSW incremental ETL Jobs run overnight, starting at 9 PM. Original processing time for these ETL Jobs took about 8 hours. The last 2 runs, on Friday and Monday, took more than 15 hours. Last night’s run is still processing after 18 hours. Current troubleshooting shows it is not a specific job that is running too long, it appears to be across the board.

Each of these ETL Jobs are a full daily incremental Master Sequence job that contain the following for a specific pillar:

1. All OWS jobs
2. All Global Dimension jobs
3. All Local Dimension jobs
4. All Data Mart Dimensions
5. All Data Mart Facts
 ODM Question


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.