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

Last updated on JUNE 09, 2017

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***

Goal

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

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms