Search found 23 matches
- Mon Feb 02, 2009 11:36 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: XML messages lost while reading using MQ Connector & XML
- Replies: 2
- Views: 2636
XML messages lost while reading using MQ Connector & XML
Hi, we are using DS MQ Connector stage to read xml messages from Websphere MQ. Then using XML i/p stage, the message is split into individual xml elements and then inserted into Target DB2 table. 'Message Read Mode' read mode property is set to 'Delete Under Transacton'. In case of Incorrect message...
- Tue Apr 29, 2008 9:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Passing Erroneous msgs from Src Queue to Error Queue- How?
- Replies: 1
- Views: 1206
Passing Erroneous msgs from Src Queue to Error Queue- How?
Hi, I have a job to read xml messages from Queue(Msg Read Mode: Delete(Under Transaction)) and write it to a Tgt table. It has a MQ Connector stage which reads the messages and gives it to XML i/p stage for interpreting. XML i/p stage interprets(based on the XML table definition loaded) and breaks t...
- Wed Apr 16, 2008 5:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error in Information Analyzer while executng Column analysis
- Replies: 0
- Views: 992
Error in Information Analyzer while executng Column analysis
Hi, When i submit column analysis in Information Analyzer, it shows "Executing" status for some time and then it fails with the status "Error Encountered". The error is: "SorcererServiceLogging.java:-3 executeBaseProfile: Exception in process: Fail to create session for user...
- Mon Apr 07, 2008 11:18 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to make a DS job a Web service?
- Replies: 1
- Views: 951
How to make a DS job a Web service?
Hi, I want to design a DS job(parallel/server). I want it to behave as Web service. It should be able to receive the input from a web page(html) and should process that input and then should send the response back to the web page. Is this possible in Datastage V8 ? Are there any inbuilt stages that ...
- Thu Mar 20, 2008 4:17 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Attaching Parameter Set to DB Connection
- Replies: 0
- Views: 749
Attaching Parameter Set to DB Connection
Hi, I have created 3 environment variables to hold the values of ServerName, UserID and Password respectively. Then i define a parameter set 'Param_Set_A' by adding these 3 environment variables. Now i want to attach 'Param_Set_A' to a DB2API Connection (call it 'DB2API_Conn_X'), but when i try to d...
- Thu Mar 20, 2008 2:44 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using same DB Connection by more than 1 users at same time
- Replies: 2
- Views: 1232
- Thu Mar 20, 2008 1:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using same DB Connection by more than 1 users at same time
- Replies: 2
- Views: 1232
Using same DB Connection by more than 1 users at same time
Hi, I have created a DB2API connection(Let's call it 'Sample_Db_Connection') and want it to be used by more than one users in their jobs for re-usability. User1 logs in first, and loads 'Sample_Db_Connection' in DB2API stage in his Job A. Then User2 logs in, wants to load 'Sample_Db_Connection' in D...
- Mon Mar 10, 2008 1:24 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Updating Dimension Table using SCD stage
- Replies: 4
- Views: 1711
Updating Dimension Table using SCD stage
Hi,
When we have only Dimesion source data,
Can we update only dimensional table without updating the fact table using Slowly Changing Dimension Stage?
Or is it mandatory to load fact table too?
When we have only Dimesion source data,
Can we update only dimensional table without updating the fact table using Slowly Changing Dimension Stage?
Or is it mandatory to load fact table too?
- Fri Mar 07, 2008 8:11 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ stage- Server Vs Parallel job - issue
- Replies: 3
- Views: 2115
MQ stage- Server Vs Parallel job - issue
Hi, I have built two identical jobs consisting of MQ stage, one is Server job and other one is Parallel. The job consists of, MQ stage which reads xml msgs from Q for infinite period(Wait time=-1). Then these are inputted to XML i/p stage where it breaks down the XML into data elements and inserts t...
- Thu Mar 06, 2008 1:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Connector- Selective reading- Aborted with error
- Replies: 8
- Views: 5940
Hi, If i turn off the waves, records are not getting inserted into table. As suggested by Ernie, i tried other filter property 'Priority'. In this case also i am getting the same error. Another clarification: Error comes only when i put new msg (which satisfies Filter condition) on to Q when job is ...
- Tue Mar 04, 2008 11:15 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Connector- Selective reading- Aborted with error
- Replies: 8
- Views: 5940
- Tue Mar 04, 2008 10:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while taking export of Datastage project
- Replies: 3
- Views: 2051
- Tue Mar 04, 2008 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while taking export of Datastage project
- Replies: 3
- Views: 2051
Error while taking export of Datastage project
Hi,
When exporting a DS project, the following error occurs:
"Failed to attach to job 'ROOT'.The job 'ROOT' cannot be found in the repository."
Plz suggest the solution.
Thank You.
When exporting a DS project, the following error occurs:
"Failed to attach to job 'ROOT'.The job 'ROOT' cannot be found in the repository."
Plz suggest the solution.
Thank You.
- Tue Mar 04, 2008 8:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: MQ Connector- Selective reading- Aborted with error
- Replies: 8
- Views: 5940
MQ Connector- Selective reading- Aborted with error
Hi, I am using MQ connector stage as source.I am reading the messages(Msg Read Mode=Delete, so that only the read msgs are deleted from the Q) selectively based on the Filter property 'Application ID Data'(i.e when Application ID Data=1).Wait Time is set to -1, so that MQ connectr keeps on reading m...
- Tue Mar 04, 2008 8:06 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while using MQ Connector stage
- Replies: 8
- Views: 3853