DSXchange

Setup another stage to check if condition is satisfied in the trigger then send to end stage.

JavaPack is the general term for the JavaTransformer and JavaClient Stages. This "is" the way to connect to JMS. Look in the real-time category of stages. They are installed automatically in 8.1. Then spend some time with http://dsrealtime.wordpress.com/2008/03/14/incorporating-java-class...

Look again... you should find a variety of entries on using JavaPack to do this. Look also at my blog below...I illustrate a few ways to use JavaPack, and others have entered great info into this forum on JavaPack also. There are lots of considerations, but the first is "how to use a java clas...

Please let me know if we can write to JMS queue, I have no knowledge of queue services.
The requirement is to read 4M rows from Oracle table and write to JMS Queue.

I did searched in this forum, I didn't find direct answer.

Thanks
Kumar

Kumar Please try $APT_ORACLE_LOAD_OPTIONS=OPTIONS(SKIP_INDEX_MAINTENANCE = TRUE,bindsize=8250000,readsize=8250000,rows=2000) u can can insert in parallel from datastage based on configuration file Thanks Sanjay Sanjay, I tried the job with this change but no difference. I planned a workaround to br...

ray.wurlod wrote:Is the table partitioned?

Does any one has similar situation, how to achieve parallel inserts in oracle enterprise for range partitioned on date and unique index table.

Thanks
Kumar

ray.wurlod wrote:Is the table partitioned?

Thanks Ray, yes it is range partition on date column with 6 months of data daily.

-Kumar

Keshav,
8 nodes. please let me know if we can change/update the options to load/insert in parallel.

dsuser_cai wrote:Hi
did you try changing the execution mode to parallel.

That's the default mode, I didn't change that. The explain plan in DB shows 1 row at a time.

dsuser_cai wrote:try using upsert method. Insert/Update.

Thanks Karthick, This is also loading in sequential only ( 1 row at a time).

Hi I tried multiple options to use Enterprise Oracle load with append to do inserts in parallel. 1.OPTIONS(DIRECT=FALSE, PARALLEL=TRUE) with out rebuild index 2.OPTIONS(DIRECT=TRUE, PARALLEL=TRUE,SKIP_INDEX_MAINTENANCE=YES) with rebuild index The table has unique index and range partition on date wi...

Works fine with patch provided by IBM.

Yes I verified the Scratch has drwxrwxrwx, is there any work around to extract from DB2 Enterprise to DB2 API for 6 million rows.

Thanks
Kumar

Thanks Ray, Does this error message any use after making $APT_DISABLE_COMBINATION as true. DB2_UDB_Enterprise_15,2: Failed opening fifo /projects81/Scratch/ordb211839622c7d2562_.003 after 360 seconds: No such device or address. DB2_UDB_Enterprise_15,2: The runLocally() of the operator failed. DB2_UD...

Hi All, Error loading from DB2 API Source with 9.1 from prod to DB2 Enterprise dev box with version 9.5. DB2 API -> XFM -> DB2 ENT Err logs: APT_CombinedOperatorController,0: Fatal Error: Fatal: SQLAllocHandle: Failed to allocate environment handle 'ENV'. node_node1: Player 1 terminated unexpectedly...