Search found 41 matches
- Mon Jan 05, 2015 2:49 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGSEGV Error when trying to load LOB data
- Replies: 6
- Views: 3996
Re: SIGSEGV Error when trying to load LOB data
The Transformer is used to assign some constant values to few fields and for CurrentTimestamp() and DSJobName. There are no transformations/surrogate key generate. Only the source has CLOB fields - which might cause the memory issue? But not sure how to handle it. Btw, the job runs fine if only 10 r...
- Mon Jan 05, 2015 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGSEGV Error when trying to load LOB data
- Replies: 6
- Views: 3996
Re: SIGSEGV Error when trying to load LOB data
Yup, did that, it shows data and Connection is successful.
- Sun Jan 04, 2015 5:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGSEGV Error when trying to load LOB data
- Replies: 6
- Views: 3996
Here are the warnings: odbc__STAGE_QC_TEST__Ld,0: from /usr/lib/hpux64/libc.so.1 odbc__STAGE_QC_TEST__Ld,0: #1 0xc000000000560d70:0 in __nanosleep2+0xd0 () from /usr/lib/hpux64/libc.so.1 odbc__STAGE_QC_TEST__Ld,0: #2 0xc00000000040aa10:0 in sleep+0x3f0 () from /usr/lib/hpux64/libc.so.1 odbc__STAGE_Q...
- Wed Dec 31, 2014 11:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SIGSEGV Error when trying to load LOB data
- Replies: 6
- Views: 3996
SIGSEGV Error when trying to load LOB data
Hi, We have few jobs which reads SQL Server table and loads another SQL Server table. The source and target tables are in different databases. Job Design: ODBCStage_Sourcetable ->Transformer ->ODBCStage_Targettable ODBC Target stage - WriteMode: Insert; Table Action: Append; Generate SQL : Yes The s...
- Wed Dec 31, 2014 9:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error for Stored Proc stage
- Replies: 4
- Views: 4222
- Wed Dec 31, 2014 9:33 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: update/insert deadlock
- Replies: 7
- Views: 6702
- Tue Dec 23, 2014 9:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: update/insert deadlock
- Replies: 7
- Views: 6702
- Tue Dec 23, 2014 7:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: update/insert deadlock
- Replies: 7
- Views: 6702
- Tue Dec 23, 2014 6:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: update/insert deadlock
- Replies: 7
- Views: 6702
update/insert deadlock
Hi, I have a job which updates and inserts a table [Update if record exists else insert]. This table has no primary keys defined on it. This job worked fine in lower environments with fewer records (few hundreds), but failed in production with deadlock error on update statement, where the volume was...
- Tue Nov 25, 2014 9:54 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Fatal Error for Stored Proc stage
- Replies: 4
- Views: 4222
Fatal Error for Stored Proc stage
Hi, I have a parallel job in V 8.7. The design has a row generator, generating 1 dummy row followed by Stored Procedure stage. The DB is MSSQL Server Procedure type - Transform No parameters are being passed to SP and no values are returned from the SP. However even when the SP fails, the Datastage ...
- Thu Nov 20, 2014 11:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "View data" shows data but job aborts
- Replies: 6
- Views: 4240
- Wed Nov 19, 2014 8:54 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "View data" shows data but job aborts
- Replies: 6
- Views: 4240
- Wed Nov 19, 2014 4:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: "View data" shows data but job aborts
- Replies: 6
- Views: 4240
"View data" shows data but job aborts
Hi, The "view data" option in ODBC Connector stage of Datastage Designer connects and shows data, but the job aborts with the below error The connector could not establish a connection to data source <DSN_name> using user <user_id> I have checked the values passed to the db connection para...
- Wed Dec 18, 2013 7:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change data capture-comparison of 2 records in after dataset
- Replies: 3
- Views: 2842
- Tue Dec 17, 2013 6:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Change data capture-comparison of 2 records in after dataset
- Replies: 3
- Views: 2842
Change data capture-comparison of 2 records in after dataset
Hi, I have a job comparing 2 datasets - before and after and supposed to capture the edits and inserts. The after dataset has 2 records with same key column and the before dataset has 1 record with the key column. Before ds: K1,1,a After ds: K1,1,a K1,2,b Expected Result; K1,1,a,no change K1,2,b,edi...