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
-
shalini11
- Participant
- Posts: 74
- Joined: Thu Jan 22, 2009 3:00 am
Post
by shalini11 »
Hi All,
I have to load data from oracle to db2.Its a direct load without any transformations except TimestampToDate().
Data is getting loaded using DB2 API stage. It is taking around 5:30 hrs to load approx 1 billion records.
So i thought of using Dynamic RDBMS to speed up the process. But this stage is throwing the below error:
Assignment of a NULL value to a NOT NULL column "TBSPACEID=5, TABLEID=24, COLNO=0" is not allowed.
I checked in the oracle database, there are no nulls in not null columns.
What can be the cause of this warning?
Please advice.
Thanks
-
miwinter
- Participant
- Posts: 396
- Joined: Thu Jun 22, 2006 7:00 am
- Location: England, UK
Post
by miwinter »
Can you post the metadata of your target table please?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
ps. DRS stage <> speed up the process.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
miwinter
- Participant
- Posts: 396
- Joined: Thu Jun 22, 2006 7:00 am
- Location: England, UK
Post
by miwinter »
Switch to using the (Starship) Enterprise stage instead
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
-
chulett
- Charter Member
- Posts: 43085
- Joined: Tue Nov 12, 2002 4:34 pm
- Location: Denver, CO
Post
by chulett »
Or some sort of
bulk load process, unless that is what the DB2 API stage is already doing for you.
-craig
"You can never have too many knives" -- Logan Nine Fingers
-
miwinter
- Participant
- Posts: 396
- Joined: Thu Jun 22, 2006 7:00 am
- Location: England, UK
Post
by miwinter »
Absolutely :D
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
-
shalini11
- Participant
- Posts: 74
- Joined: Thu Jan 22, 2009 3:00 am
Post
by shalini11 »
The Enterprise stage is not working. It is giving some error like:
db2nodes.cfg file is not present
Is this an installation error?
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
-
Contact:
Post
by ray.wurlod »
Yes. Further, it's a DB2 installation/configuration error, not a DataStage installation error.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
shalini11
- Participant
- Posts: 74
- Joined: Thu Jan 22, 2009 3:00 am
Post
by shalini11 »
Thanks for your response.
But why DRS stage is not working and throwing error. It should be able to load to any database.
-
miwinter
- Participant
- Posts: 396
- Joined: Thu Jun 22, 2006 7:00 am
- Location: England, UK
Post
by miwinter »
I'll try again...
miwinter wrote:Can you post the metadata of your target table please?
As per Craig's comment too, what makes you think the DRS stage will be quicker than the API stage that took 5 1/2 hours?
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>