Search found 23 matches

by basav_ds
Mon Mar 03, 2008 10:55 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while using MQ Connector stage
Replies: 8
Views: 3847

No.. I am not using QS in the job
by basav_ds
Mon Mar 03, 2008 7:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while using MQ Connector stage
Replies: 8
Views: 3847

Hi,
i tried running the job, got error 'Unable to create QS run file directory, RT_QS773'. I have provided Mode=Server. Q mngr and Q name are provided. What should be the Username and Password field values?
by basav_ds
Mon Mar 03, 2008 4:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error while using MQ Connector stage
Replies: 8
Views: 3847

Error while using MQ Connector stage

Hi, i am reading xml messages from MQ(Normal) stage in job. The credentials i am giving here is Q Manager Name and Q Name. I can see the message content by clicking View Data in MQ satge(normal) successfully. But when i use 'MQ Connector stage' instaed of 'MQ stage', and click View Data, its giving ...
by basav_ds
Fri Feb 29, 2008 1:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Gaps(Holes) in surr_key generated by Surr_Key_Gen stage
Replies: 5
Views: 1891

Gaps(Holes) in surr_key generated by Surr_Key_Gen stage

Hi, I have 3 jobs.... 2 parallel and 1 sequence job. In First parallel job, It reads Employee data from I/P Source file Emp1.txt which has 3940 records. These are inputted to Surr_Key_Gen stage where Surrogate key Emp_ID is generated starting from value 1. Then o/p of Surr_Key_Gen stage is inserted ...
by basav_ds
Tue Feb 12, 2008 4:27 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Destructive Reading of selective messages from Datastage MQ
Replies: 1
Views: 761

Destructive Reading of selective messages from Datastage MQ

I am having many XML messages on i/p Queue. The sample XML data format is as shown below: <xml> <order Type="SOH"> <Typenumber>"100"</Typenumber> <order_date>"03-11-2007"</order_date> </order> </xml> Each of the messages have attribute value Type="SOH" or &quo...
by basav_ds
Wed Jan 30, 2008 2:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parallel Vs Server Performance Test - Unexpected Results
Replies: 4
Views: 1659

Aggt stage is working in Parallel execution mode, Partition type is 'SAME'.

I tried with removing 'Perform sort' option in target sequential file stage and Used sorted merge collection method but not getting sorted o/p.

Server load is zero during tests.
by basav_ds
Wed Jan 02, 2008 5:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue when 'Execution Mode' set to 'Parallel' for DB2-API
Replies: 1
Views: 1190

Issue when 'Execution Mode' set to 'Parallel' for DB2-API

My job contains a DB2-API stage which reads data from a table containing 10,000 records and passes it to Sort stage. Then the sorted data is input to Aggregator stage and the output of Aggregator is written to Sequential Fille. I want this job to be run on multiple nodes (Here i am simulating it on ...
by basav_ds
Fri Nov 30, 2007 1:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: UTF Data Format Exception while handling XML i/p
Replies: 2
Views: 3034

UTF Data Format Exception while handling XML i/p

UTF Data Format Exception, while trying to move xml data from XML i/p stage to sequential file stage. The xml tags are appearing as strange encoded symbols in sequential output file. The exact error msg is : Xalan fatal error (publicId: , systemId: , line: 1, column: 1): An exception occurred! Type:...