DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 31 matches
Author Message
 Topic: How to find when the DataStage Project was last used
moalik

Replies: 2
Views: 74

PostForum: General   Posted: Fri Apr 21, 2017 12:06 am   Subject: How to find when the DataStage Project was last used
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

I am performing cleanup activities on our server.

I want to know when was last time (anyone logged on to particular DataStage Project) the project was used or did anyone access that proj ...
Resolved
 Topic: Problem with Sequential File Stage - No Metadata Rejects
moalik

Replies: 3
Views: 548

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Jun 29, 2016 12:12 am   Subject: Problem with Sequential File Stage - No Metadata Rejects
Thanks Ray and qt_ky for the prompt replies.
Resolved
 Topic: Problem with Sequential File Stage - No Metadata Rejects
moalik

Replies: 3
Views: 548

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 27, 2016 10:04 pm   Subject: Problem with Sequential File Stage - No Metadata Rejects
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi All,

I am passing a Comma Separated File as my Input to a sequential file. In the properties, I am enabled the "Reject Property = Output".

My Input Data:
Col1(Not Nullable), Col2(Not Nullabl ...
Resolved
 Topic: IA Logs
moalik

Replies: 3
Views: 1067

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Thu Jun 23, 2016 10:11 pm   Subject: IA Logs
Thanks Ray for the quick tip.

Now i have enabled Retain Scripts as part of the project.
Resolved
 Topic: IA Logs
moalik

Replies: 3
Views: 1067

PostForum: Information Analyzer (formerly ProfileStage)   Posted: Wed Jun 22, 2016 6:43 am   Subject: IA Logs
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi All,

We are carrying out an Data Quality Profiling exercise using Information Analyzer, however facing below issues.

1) IA jobs failed with but nothing in the logs
2) IA jobs com ...
 Topic: Configuring MQ Connector stage in Request/Reply Mode
moalik

Replies: 3
Views: 694

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Nov 03, 2015 4:35 pm   Subject: Configuring MQ Connector stage in Request/Reply Mode
Hi All,

Any solutions please?

Thanks,
Mohsin Khan
 Topic: Configuring MQ Connector stage in Request/Reply Mode
moalik

Replies: 3
Views: 694

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Oct 28, 2015 5:15 pm   Subject: Configuring MQ Connector stage in Request/Reply Mode
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi All,

I am trying to configure MQConnector Stage in Request/Reply Mode. I am trying with the below scenario:

Job Design:
RowGen -> MQ Connector -> SeqFile

I have created the Queue Ma ...
Resolved
 Topic: Help in DataStage's XML and MQSeries capabilities
moalik

Replies: 8
Views: 1560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Sep 27, 2015 6:35 pm   Subject: Help in DataStage's XML and MQSeries capabilities
Hi All,

Our requirement has changed we are no longer looking for response from MQ.

I have got lot of help for the mentioned topic and had a good hands on experience with XML Transformations and ...
Resolved
 Topic: Help in DataStage's XML and MQSeries capabilities
moalik

Replies: 8
Views: 1560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 21, 2015 11:56 pm   Subject: Help in DataStage's XML and MQSeries capabilities
Hi Ernie,

Thanks for the quick reply Smile

I went through the MQConnector documentation and tried reading from the Queue with testdata. I was able to retrieve the data to Peak Stage.

I couldn't ...
 Topic: Selecting fields using Schema files
moalik

Replies: 7
Views: 1049

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 21, 2015 11:44 pm   Subject: Selecting fields using Schema files
Hi Samrat,

I hope the concept of Partial Schema's might come handy. I haven't tried a hand on this. You can have a look at the below link from IBM.

https://www-01.ibm.com/support/knowledgecenter ...
Resolved
 Topic: Datastage Job stalled
moalik

Replies: 7
Views: 965

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 21, 2015 11:28 pm   Subject: Datastage Job stalled
Are you doing a select on the Table or on the View? Are you doing any joins or exists conditions with in the query? If so try, to achieve the joining capability in datastage rather than on SQL. Try in ...
Resolved
 Topic: Help in DataStage's XML and MQSeries capabilities
moalik

Replies: 8
Views: 1560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Sep 21, 2015 12:46 am   Subject: Help in DataStage's XML and MQSeries capabilities
Hi Abhinav,

Sorry for the delayed reply.

Thanks for sharing the Links. It was really helpful.

I have generated the XML files and pass then on the queue and it was successful. But I am unable ...
Resolved
 Topic: Help in DataStage's XML and MQSeries capabilities
moalik

Replies: 8
Views: 1560

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Sep 17, 2015 9:07 pm   Subject: Help in DataStage's XML and MQSeries capabilities
DataStage® Release: 9x
Job Type: Parallel
OS: Unix
Hi All,

I am new to XML's and MQConnector's in Datastage.

We have a library of XML services. Our requirement is to map relational data into an XML structure, place it on a queue, then read the ...
 Topic: system variables @NUMPARTITIONS and @PARTITIONNUM : explain
moalik

Replies: 3
Views: 1191

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 22, 2015 3:41 am   Subject: system variables @NUMPARTITIONS and @PARTITIONNUM : explain
Hi Prasoon,

Do you mean the partitions as the no.of nodes used in the configuration file?
 Topic: system variables @NUMPARTITIONS and @PARTITIONNUM : explain
moalik

Replies: 3
Views: 1191

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jan 22, 2015 1:37 am   Subject: system variables @NUMPARTITIONS and @PARTITIONNUM : explain
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All,

Could you please explain me about the System Variables

1. @NUMPARTITIONS
2. @PARTITIONNUM

and want to know their behavior while generating a sequence number?
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours