Search found 64 matches
- Fri Jul 01, 2016 9:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Basic Transformer with Mutex Error Then Unable to Run Job
- Replies: 0
- Views: 2355
Basic Transformer with Mutex Error Then Unable to Run Job
Hi All, Two of the PX jobs running in parallel from my sequencer in Datastage 11.5, are failing with error "ds_ipcgetnext() - timeout waiting for mutex" (They both are using Basic Transofrmer in parallel). After the first failure, if I resubmit the sequencer again, they are failing with er...
- Fri Nov 06, 2015 8:43 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential Execution on Db2 Causing Deadlock
- Replies: 2
- Views: 2284
- Thu Nov 05, 2015 9:42 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sequential Execution on Db2 Causing Deadlock
- Replies: 2
- Views: 2284
Sequential Execution on Db2 Causing Deadlock
Hi All, I am trying to delete records from a mainframe DB2 table based on a key. I am using sequential execution on DB2 stage so I should see only one session on Db side from ETL. But somehow, Datastage creating two sessions with same Autogenerated DELETE statement and causing the deadlock on DB2 en...
- Thu Apr 02, 2015 5:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Oracle Enterprise stage in parallel mode?
- Replies: 4
- Views: 4195
Here are the answers. 1. Yes. By default READ method is sequential unless your table is partitioned and you are enforcing stage to read in parallel from partitions. Write always in parallel bydefault. 2. Bydefault stage will try to read in sequential while extraction and in parallel while loading. I...
- Thu Apr 02, 2015 5:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Preserver Partion - Clear + Same partition
- Replies: 2
- Views: 3280
- Tue Mar 24, 2015 4:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating non partitioned table in Parallel with ODBC Stage
- Replies: 5
- Views: 3240
Hi Craig and qt_ky, Thanks for your replies. We tried with proper partitioning but not useful. We are getting the same issue with hash and modulus partitioning too. And also we collected the data from peek by partition wise and verified it. Datastage writing the data properly in partitions but someh...
- Sat Dec 27, 2014 7:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating non partitioned table in Parallel with ODBC Stage
- Replies: 5
- Views: 3240
- Tue Oct 21, 2014 7:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating non partitioned table in Parallel with ODBC Stage
- Replies: 5
- Views: 3240
Updating non partitioned table in Parallel with ODBC Stage
Hi All, We are trying to update a table in SQLServer2008 using ODBC Connector/Enterprise stages using 4 node config file. Job is aborting with message "Deadlock". Table is having a Clustered Unique index on key combination that I am using in Update statement in Job. My Database is not part...
- Fri May 02, 2014 12:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Internals
- Replies: 6
- Views: 4026
Thank you Ray for the Information. I verified the ODBC API's code. It looks like we are calling Java classes on backend from connector stages. So If I have 4 node configuration file, then each session will create a separate java class instance and that java instance process the data row by row it re...
- Wed Apr 30, 2014 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Internals
- Replies: 6
- Views: 4026
- Tue Apr 29, 2014 4:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Does Before-SQL works only for DML ?
- Replies: 11
- Views: 4964
- Tue Apr 29, 2014 4:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Internals
- Replies: 6
- Views: 4026
DB2 Connector Internals
Hi All, Can any one help me how DB2 or Oracle Connector stages work on Backend? Manual is saying it is using APIs but not mentioned what APIs it is really calling for DB2? I see on DB side, it is triggering some packages/procedures when I run the job but any one having the list of all procedures it ...
- Wed Jan 08, 2014 9:58 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Internal partitioning Issue
- Replies: 2
- Views: 3496
- Fri Jan 03, 2014 6:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Internal partitioning Issue
- Replies: 2
- Views: 3496
Internal partitioning Issue
Hi All, I have a job to join data from two different streams. On first stream I am reading data from file , doing sort in ETL, removing duplicates then passing it to join stage. Sorting data on Key-1, partition on Key-1 with Case Insensitive option. On join right link, reading data from DB and sorti...
- Fri Dec 13, 2013 3:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Partitioning Issue with Dataset
- Replies: 13
- Views: 5075