Page 2 of 2
Posted: Thu Oct 09, 2008 12:12 am
by lstsaur
Please try one more test to see whether you are able to import the table definitions using Oracle's Plug-in.
Posted: Fri Oct 10, 2008 8:25 am
by vasa_dxx
The job hangs only when I try to Load Oracle.
But i succeeds when i do an Upsert/insert.
I need to configure sqlloader????
Posted: Fri Oct 10, 2008 9:30 am
by ArndW
Excellent job of narrowing down the problem. So now you actually can get a data file and the SQL script and could reproduce the problem outside of DataStage so I would suggest you involve the DBA so that he or she can monitor what happens when you run it.
Posted: Mon Oct 13, 2008 2:38 am
by vasa_dxx
Thanks ArndW.
I can't see your suggestions after third line.
I set APT_ORA_WRITE_FILES =' (DIRECT=TRUE, PARALLEL=FALSE) '
Inspired by the success of Oraupsert , I tried Upsert on a table using a sort Stage whose Output is 918553 records. Now the same Porblem of hang is reproduced.
Does DS use sqllloader when the records cross a certain limit?
Posted: Mon Oct 13, 2008 11:41 am
by srividya
DBA should be able to help you.
from tuning perspective ths might help you
Creating indexes on the table you are trying to load
Partitioning the table
increasing the intial table size
Thanks
Srividya
Posted: Wed Oct 15, 2008 6:03 am
by vasa_dxx
Thanks everybody for the Technical guidance.
The issue isn't resolved yet, but hope it soon due to diligence efforts by the members of this forum.
Although not complete resolution, but narrowing down the possibilty of cause gave me a good knowledge of the basics required.
Thanks Folks,