DSXchange

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. Should we hit the UV and search for it? If so, may I know the exact table and the column to look into t...

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 see few options here but all provide for only Jobs. I would like to get it for all the components, includi...

As JR mentioned, export -preview with datastage component as '"proj/*/*.*"' helped!!

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 and every component individually.

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 using istool export command. dsjob -ljobs gives me just the list of jobs and not the other component. H...

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)? Range lookup options in the stage gives me only Main stream fields for the Begin and End value. Let me kn...

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.

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 key Gen stage. This is what I did. I created a job with a Row Gen and Surroage Key stage and created a Surrog...

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 list. That particular message handler is getting applied to all the jobs project wide. But I wanted to a...

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 can 'Clear' the Preserver Partition of the Lookup. But other stages that are connected to Lookup, would need t...

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.

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 Datastage repository too? Or the Vice versa?

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 Webconsole. May I know why is there two different places the metadata is been maintained? Or what is maitain...

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. Server1 is a ETL resourse node, Server2 is a Database server. The ID used is part of dstage group. O...

BUMPing it up... just in case.. if it went unnoticed to few users.