Search found 4 matches

by vpatel
Thu May 03, 2007 10:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Index in Unusable state
Replies: 2
Views: 1152

Index in Unusable state

Hi, when I use Oracle Stage with option LOAD/APPEND to load 2 lac records in a table its indexes become in unusable state. Moreover I made oracle stage "Sequential". Also, I tried with option "Index Rebuild" in Oracle Stage. But it also didn't help. One solution whcih i see is ju...
by vpatel
Sat Mar 03, 2007 6:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: help in partitioning the stages
Replies: 5
Views: 2690

No, log is not indicating any stage name
following is the warning log :

[img]APT_ParallelSortMergeOperator(1),0: Unbalanced input from partition 0: 10000 records buffered

APT_ParallelSortMergeOperator(1),0: (no further unbalance warnings will be issued for this partition)[/img][/list]
by vpatel
Sat Mar 03, 2007 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: help in partitioning the stages
Replies: 5
Views: 2690

Thanx Kumar for replying...

As job is having so many stages. it would be difficult to explain complete flow here.

Can somehow i know at which stage it is giving such errors?
So I can explain you that part.

But i used "HASH" partitioning in most of the stages in my job.
by vpatel
Sat Mar 03, 2007 3:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: help in partitioning the stages
Replies: 5
Views: 2690

help in partitioning the stages

Hi,
I m encountering the error "Unbalanced input from partition 0 ".

What could be all possible causes for the same.