DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 106 matches
Author Message
Resolved
 Topic: Finding jobs that uses particular Transformer funtion
dsdoubt

Replies: 2
Views: 1231

PostForum: General   Posted: Thu Mar 23, 2017 4:30 pm   Subject: Finding jobs that uses particular Transformer funtion
DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hi,

How do I find the list of jobs that's uses particular Transformer function. EG: AsInteger()
I don't see Transformer function being part of the object type in the standard or the advanced find ...
 Topic: Xmeta query to get list of all assets changed or modifed
dsdoubt

Replies: 2
Views: 1325

PostForum: General   Posted: Mon May 16, 2016 12:28 pm   Subject: Xmeta query to get list of all assets changed or modifed
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Greetings DSxcians!

I wanted to collect the list of all components including (*.pjb, *.qjb, *.sjb, *.prt, *. srt, *.tbd etc) which got Created or Modified within the last 24 hours.
I am able to se ...
Resolved
 Topic: How to list the component using istool?
dsdoubt

Replies: 7
Views: 2189

PostForum: General   Posted: Thu May 05, 2016 4:53 pm   Subject: How to list the component using istool?
As JR mentioned, export -preview with datastage component as '"proj/*/*.*"' helped!!
Resolved
 Topic: How to list the component using istool?
dsdoubt

Replies: 7
Views: 2189

PostForum: General   Posted: Wed May 04, 2016 5:31 pm   Subject: How to list the component using istool?
Thanks all for your replies.

May be I should ask this.

I want to list all the components from a project.

*.pjb, *.qjb, *.prt etc

How do I do it using istool.

So that I can export each ...
Resolved
 Topic: How to list the component using istool?
dsdoubt

Replies: 7
Views: 2189

PostForum: General   Posted: Thu Apr 28, 2016 1:14 pm   Subject: How to list the component using istool?
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I wanted to export all Jobs / Table definitions / Routines / Shared containers individually to its corresponding folder in Unix. So that I can do the version control.
If get the list, I can export ...
 Topic: Range Lookup in Main Stream Flow
dsdoubt

Replies: 1
Views: 1184

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Jul 23, 2015 1:01 am   Subject: Range Lookup in Main Stream Flow
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have Main date field in Main stream of the lookup and I have Begin_DT and END_DT field in reference table.
How do I do range lookup based on the these date field (Begin_DT < Main_Dt < END_DT ...
 Topic: Preserver Partion - Clear + Same partition
dsdoubt

Replies: 2
Views: 2148

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 08, 2015 11:51 pm   Subject: Preserver Partion - Clear + Same partition
Adding copy stage is always an option. But I was actually of 'Clear' the Preserver Partition option, if that would work to avoid an extra stage.
 Topic: Surrogate Key Generation
dsdoubt

Replies: 2
Views: 1791

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Jun 08, 2015 11:48 pm   Subject: Surrogate Key Generation
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

This is very basic question. I know, this must have been discussed already. I tried searching the forum, but couldnt find the right link.

I need to generate Surrogate key using Surrogate ke ...
Resolved
 Topic: Multiple messages at project level Message handler
dsdoubt

Replies: 3
Views: 1559

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed Apr 15, 2015 12:14 pm   Subject: Multiple messages at project level Message handler
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Perhaps Iam missing something here.

In Admistrator Client, under Prallel tab, under under Message handler for parallel jobs, Iam able to select one of the named Message handler from the drop down l ...
 Topic: Preserver Partion - Clear + Same partition
dsdoubt

Replies: 2
Views: 2148

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 02, 2015 12:37 pm   Subject: Preserver Partion - Clear + Same partition
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
I have the Looup stage with Reject to a Sequential file stage.

I get the follwing warning.

A sequential operator cannot preserve the partitioning
of the parallel data set on input port 0.

I ...
 Topic: Xmeta vs Hashed files
dsdoubt

Replies: 6
Views: 2617

PostForum: General   Posted: Tue Nov 15, 2011 11:55 am   Subject: Xmeta vs Hashed files
Thanks Ray! When do it get commited to Xmeta? After Compiling or Running a job first time?

Thanks Kim, Looks like there is some script available from IBM to force sync the both Xmeta and the UV.
 Topic: Xmeta vs Hashed files
dsdoubt

Replies: 6
Views: 2617

PostForum: General   Posted: Tue Nov 08, 2011 10:24 am   Subject: Xmeta vs Hashed files
Thanks for the Reply Kim!
May I know the actual purpose of Xmeta in today's world?
Apart from reporting and Auditing.

If we delete a record in Xmeta (Eg: Delete a job), will it relfect in Data ...
 Topic: Xmeta vs Hashed files
dsdoubt

Replies: 6
Views: 2617

PostForum: General   Posted: Mon Nov 07, 2011 11:31 pm   Subject: Xmeta vs Hashed files
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
In Datastage 8.5, There is Xmeta in Database and the Repository (DS_JOBS / DS_JOBOBJECTS etc) in hashed files also.
Locks can be still cleared using DS.TOOLS. And aswell using Datastage Admin Webcons ...
 Topic: rsh issued, no response received
dsdoubt

Replies: 3
Views: 6001

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 07, 2011 1:59 pm   Subject: rsh issued, no response received
DataStage® Release: 7x
Job Type: Parallel
OS: Unix
I have alredy set up SSH for Server1 and Server2 from Engine node. Iam able to do the SSH for the servers manaully. Where as not run the jobs from Datastage. Which gives me Section Leader died error. ...
 Topic: DB2 API vs Enterprise based on Authentication?
dsdoubt

Replies: 1
Views: 972

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Feb 14, 2011 10:02 am   Subject: DB2 API vs Enterprise based on Authentication?
BUMPing it up... just in case.. if it went unnoticed to few users.
 

 Jump to:   



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