Search found 57 matches

by sun rays
Mon Mar 15, 2010 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: DB2z stage
Replies: 6
Views: 3347

This stage is a mess if used with batchpipes option for loading data. It's way too compicated and many things go wrong while loading. Some of these issues don't even have any fixes as of now. As an example, if you have any RI constraints or FK violation during the build index phase of your load, the...
by sun rays
Sun Dec 27, 2009 4:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: datasets in grid environment
Replies: 2
Views: 2123

datasets in grid environment

Can someone help me in finding how DataStage manages to access datasets created in a grid environment, since the config file used to create may be different from the one that is used to access the dataset( in a different job, or in a different run) and it may or may not include the original nodes us...
by sun rays
Wed May 20, 2009 4:58 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: KeyMgtGetNextValueConcurrent generating duplicates
Replies: 6
Views: 2976

Re: KeyMgtGetNextValueConcurrent generating duplicates

I think the initial calls to the function should not be parallel, even though your jobs run in parallel at a later stage. I mean, may be giving some delay between the start ups of the jobs might solve this.
by sun rays
Thu Apr 30, 2009 2:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Allow multiple instance impact on job
Replies: 5
Views: 2602

Does "hai" at the beginning of your question mean that you understand? The operating system only allows one writer at a time to a file. Given that fact, you can figure out the answer to your question. Use "DSJobInvocationId" as part of the file name, that way your job can run in...
by sun rays
Thu Apr 30, 2009 2:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Scheduling Error
Replies: 1
Views: 1180

Re: Scheduling Error

Test button is enabled only if you logged in as an administrator.
The user -id to schedule the jobs must belong to a local adminstrators group.
by sun rays
Thu Apr 30, 2009 1:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Scheduling In Server Edition
Replies: 7
Views: 3705

Log on to the DataStage server. Choose Start --> Settings-->
Control Panel-->Services-->Schedule.
by sun rays
Thu Apr 30, 2009 1:37 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: compile jobs on a specific category
Replies: 7
Views: 4279

Go to Manager--> Tools-->Run Multiple JobCompile
by sun rays
Mon Jun 18, 2007 12:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic installation vs complete installation
Replies: 4
Views: 2211

Thanks a lot. That's all I needed.
by sun rays
Fri Jun 15, 2007 2:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: job sequence
Replies: 16
Views: 5120

If you are not going to do any iterations then do nothing. The sequence automaticaly stops after the last activity.
by sun rays
Fri Jun 15, 2007 2:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic installation vs complete installation
Replies: 4
Views: 2211

I think you are better off exporting all your DataStage components, uninstalling version 7 and performing an 8.0.1 install and importing. This will be easier to rollback and restart if the install fails. You can put your Metadata Server (domain layer and repository) on a separate machine to your Da...
by sun rays
Wed Jun 13, 2007 10:59 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic installation vs complete installation
Replies: 4
Views: 2211

Basic installation vs complete installation

We are planning to upgrade to information server 8.0.1 from DataStage server 7.5.2. I was wondering what is the main difference between basic installtion and a Complete installation. I know that the basic installation just upgrades all the components in the currrent location, so that we don't have t...
by sun rays
Wed Jun 06, 2007 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to get Hashed File row count?
Replies: 6
Views: 4325

Re: Hashed File problem.

Check if both your source and hashed file have the same set of keys.
by sun rays
Wed Jun 06, 2007 12:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How do i find a Job by target?
Replies: 9
Views: 4321

Usage analysis of table definitions could also be helpful if you have used the table definitions to load the columns in your files / tables.
by sun rays
Wed Jun 06, 2007 10:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Dependencies page in batch job.
Replies: 6
Views: 2415

You cannot do that . Use wait for file stage instead.