DSXchange

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...

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....

Actually, the administer told me that those over 1000 processes were generated since May 27. I really have no idea which job caused it. there're four nodes.

Sorry, I killed all of them before I realized to make a copy. I was told it happens often to biginners. But I wonder where I did wrong.

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.

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...

By the way, forgot some info. The bulk load we would like to use is a Datastage job, table to table.

Thanks.

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 ...

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)...

thanks for the clarification.

A further question: MNS can only standardize address, not area, is that true?

Thanks ray.wurlod!

Can you shed some light on my second question - how to override MNS rule sets?

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...

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 ...

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...

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...