Search found 22 matches
- Thu Dec 20, 2018 10:27 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Connector error while putting message on the queue
- Replies: 1
- Views: 3019
MQ Connector error while putting message on the queue
Hi , I am getting the fallowing warning and then error when I try to write a message to the MQ stage. Warning : WebSphere_MQ_Connector,0: MQPUT call executed with completion code 2 (MQCC_FAILED), reason code 2010 (MQRC_DATA_LENGTH_ERROR) And then the Error ( which is the next item in the log) : WebS...
- Thu Nov 27, 2014 9:10 am
- Forum: Site/Forum
- Topic: Failed to email membership.director for renewing membership
- Replies: 1
- Views: 19116
Failed to email membership.director for renewing membership
HI, Sorry for posting this message here as I do not know who I am supposed to contact other than you. Thanks in advance! I am trying to renewing my premium membership as it expired. But failed to send email membership.director@dsxchange.com. The email kept bouncing back with the error message below....
- Tue Jun 17, 2014 11:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Huge amount of processes generated
- Replies: 6
- Views: 4401
- Tue Jun 17, 2014 7:09 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Huge amount of processes generated
- Replies: 6
- Views: 4401
- Tue Jun 17, 2014 6:46 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Huge amount of processes generated
- Replies: 6
- Views: 4401
Huge amount of processes generated
I was told that over 1000 bash processes owned by me are running on server. I believe they were generated by dataStage jobs. Can anybody tell me why they didn't die after my jobs finished running.
- Tue Feb 04, 2014 7:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parameterized values getting hard coded
- Replies: 10
- Views: 7117
Iknow this thread is from quite some time ago, but we are experiencing the same issues with DB2 Connector stage in DS 8.5. It is intermittent but may be related to viewing the data. It isn't always reproducible and the only way to catch it prior to migrating from one environment to the next seems to...
- Tue Jan 15, 2013 9:56 am
- Forum: General
- Topic: Setup Datastage Change Data Capture after bulk load
- Replies: 1
- Views: 2254
- Tue Jan 15, 2013 9:36 am
- Forum: General
- Topic: Setup Datastage Change Data Capture after bulk load
- Replies: 1
- Views: 2254
Setup Datastage Change Data Capture after bulk load
Hi everyone, how can I setup a Change Data Capture job in Datastage to run right after my initial bulk load of a table has finished in DB2? I've already created all the components and jobs for mirroring the logs from the mainframe Z/OS to our DB2 database on Solaris UNIX. The problem is, we want to ...
- Thu Dec 06, 2012 2:29 pm
- Forum: IBM QualityStage
- Topic: survive by priority of source system
- Replies: 2
- Views: 4268
survive by priority of source system
Basiclly, I need to survive data by priority of source systems. Here is the sample data: qsMatchSetID qsMatchDataID qsMatchType Sourc_System Name 1 1 MP S1 name1 1 2 DA S2 name2 2 3 MP S1 name3 2 4 DA S1 name4 The business rule is "S2 has higher priority over S1, in other words, survive S1 (MP)...
- Wed Oct 17, 2012 8:17 am
- Forum: IBM QualityStage
- Topic: MNS and international data
- Replies: 4
- Views: 5762
- Mon Oct 15, 2012 9:11 am
- Forum: IBM QualityStage
- Topic: MNS and international data
- Replies: 4
- Views: 5762
my second question - how to override MNS rule sets?
Thanks ray.wurlod!
Can you shed some light on my second question - how to override MNS rule sets?
Can you shed some light on my second question - how to override MNS rule sets?
- Tue Aug 07, 2012 2:50 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Remove Leading Zeros for Decimal field
- Replies: 3
- Views: 5237
Remove Leading Zeros for Decimal field
I think there should be some posts for this type topic. But I could not find them. If anyone of you knows this, please let me know. Thank you very much in advance. General speaking this issue is: When a dataset file with a decimal field is created, it will formate leading zeros if necessay. My quest...
- Thu Jun 28, 2012 7:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Seeking a best solution in DataStage
- Replies: 28
- Views: 28817
Here are the details: Please note for output row 102, it should be Re-hied for Decs column, but it has appeared some additional text which it should not have. Input: -------------------------------------------- Emp_ID Name Seq_Num Desc(Varchar(10) ------ -------- ------- ----------------- 100 Tiger ...
- Thu Jun 28, 2012 5:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Seeking a best solution in DataStage
- Replies: 28
- Views: 28817
Run a problem
Hi Everyone, I have to bring it back since I have run a problem. I would like to share this with all of you and also want to get a solution for the problem. The problem is: If the key has more than 1 rows in the source, then result of the concatenation of multiple rows is good. But it is not good wh...
- Wed Jun 06, 2012 12:38 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Seeking a best solution in DataStage
- Replies: 28
- Views: 28817
Hi You need to create 5 stage variables as: (1). NumSavedRows SaveInputRecord() (2). IsBreak LastRowInGroup(Input_Lnk.ETL_KEY) (3). LastRowConcat IF IsBreak Then '' ELSE LastRowConcat : Input_Lnk.DESCRIPTION (4). ConcatDesc IF IsBreak Then ConcatDesc : Input_Lnk.DESCRIPTION Else LastRowConcat (5). N...