DB2 V9.1 Range Partition

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
diamondabhi
Premium Member
Premium Member
Posts: 108
Joined: Sat Feb 05, 2005 6:52 pm
Location: US

DB2 V9.1 Range Partition

Post by diamondabhi »

I am using DB2 EE stage to write data into a DB2 V9.1 range partitioned table. The job aborts with main_program: Fatal Error: Table `ADW_SALES_ITEM' must exist before querying the node group.

The job runs fine if we remove the range partition on the table. Did anybody use the range partition feature of DB2 on V9.1. Please help.

Thanks,
Abhi.
Every great mistake has a halfway moment, a split second when it can be recalled and perhaps remedied.
stefanfrost1
Premium Member
Premium Member
Posts: 99
Joined: Mon Sep 03, 2007 7:49 am
Location: Stockholm, Sweden

Post by stefanfrost1 »

We had a similar problem (only difference is that we also are using DPF) and had to get a special patch from IBM to get it to work.
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
Post Reply