Search found 39 matches

by deepak.hsbc
Tue Nov 12, 2013 1:29 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Anyway to force job to run on all compute nodes on a grid?
Replies: 11
Views: 7350

Re: Anyway to force job to run on all compute nodes on a gri

I used peek stage to display result on each node and using ulimit -ah in job start subrutine,that should work for you.
by deepak.hsbc
Thu Aug 09, 2012 11:04 am
Forum: General
Topic: Project move to another server
Replies: 3
Views: 1567

Can you tell me the correct procedure ?

PS:I dont have premeium membership :)
by deepak.hsbc
Mon Aug 06, 2012 8:03 pm
Forum: General
Topic: Project move to another server
Replies: 3
Views: 1567

Project move to another server

Part of data center separation,We are moving everything from server_old to server_new and this is what I am doing - 1)Copying all file system from server_old to server_new. 2)Starting the engine on server_new 3)Verified everything okay and permissions are all good 4)I am able to log-in and run the j...
by deepak.hsbc
Mon Jun 25, 2012 10:50 am
Forum: General
Topic: AIX upgrage with Datastage
Replies: 2
Views: 1973

AIX upgrage with Datastage

we have migrated almost all DS 7.5.1 to 8.1 and running fine,however there are just 2 envionment which are still running on 7.5.1 and AIX 5.3. We recently upgraded to AIX6.1 and want to know that will it work for DS7.5 I know DS8.1 works well with AIX 6.1 but not sure about AIX7.5 on AIX 6.1. I trie...
by deepak.hsbc
Thu Jan 28, 2010 12:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variable information
Replies: 4
Views: 2237

Not user defined,But IBM has given this variable to use in our project with a value of 1.

The only thing I know about this variable is it helps while working with empty file processing in multi-instance jobs...

Just wondering if anybody else has been using this ??
by deepak.hsbc
Wed Jan 27, 2010 8:02 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Environment variable information
Replies: 4
Views: 2237

Environment variable information

has anybody ever heard about a environment variable APT_OUTPUTCURSOR_USES_DONE ??
by deepak.hsbc
Wed Jan 06, 2010 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to contact one or more Section Leaders
Replies: 1
Views: 5568

I think your ssh/rsh is not setup correctly.you should be able to connect all your servers/fastname defined in Configuration file without password.
by deepak.hsbc
Mon Dec 28, 2009 11:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever
Replies: 6
Views: 2788

@chulett,Job is still running while i ran the command,in that case intrim status should also be as Running.

Nagarjuna,This job is reading a flat file,doing a look-up and loading into a Db2 table.

I do not understand what is happening with the job !!
by deepak.hsbc
Mon Dec 28, 2009 7:13 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever
Replies: 6
Views: 2788

Job running forever

I have few multi-instance jobs which run for 1-2 min and finishes successfully. Smetime this jobs keeps on running for hours and then we have to kill them and rerun. Today again while job were running forever then I used dsjob command to get information of this job,I got below results - bin/dsjob -j...
by deepak.hsbc
Tue Dec 22, 2009 7:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Num of EE stages in a job
Replies: 1
Views: 1147

Num of EE stages in a job

How can i decide the num of db2 EE stage,to be use in a single job.Currently I am using 8 EE stages in a single job but I feel that it may be a performance issue in future because of large I/O connections.

am i right ?? Any thoguhts ??
by deepak.hsbc
Tue Oct 27, 2009 6:53 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsexport
Replies: 5
Views: 2739

Not possible via Citirx,I tired it sometime back...need to have client install on the local machine.
by deepak.hsbc
Tue Oct 27, 2009 12:03 am
Forum: General
Topic: Input tables in Join Stage
Replies: 3
Views: 1630

Make it right outer or change the link ordering...since your Old table is on left link and you are choosing left outer,Old table is coming in output.

Oh,I misunderstood the fact that you need all the columns from new and old table...
by deepak.hsbc
Thu Aug 06, 2009 3:31 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: dsjob error
Replies: 1
Views: 1320

dsjob error

I am using dsjob CLI to get the job report but it throws an error for all un-compiled jobs as -

ERROR: Failed to open job

Status code = -1004

Is there any way to hide this msg and skip uncompiled jobs while creating a report.
by deepak.hsbc
Thu Aug 06, 2009 3:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Routine
Replies: 7
Views: 3256

Ok,so it is clear now that I have only dsjob which can be used in shell scripts.
Thanks to everyone !!
by deepak.hsbc
Wed Aug 05, 2009 12:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Basic Routine
Replies: 7
Views: 3256

Certainly the post u mentioned is very informative but still it is all about Universe call in a unix script whereas I want is to run following Basic functions in a Unix script and store the output in a file - hDsJob = DSAttachJob(JobName, DSJ.ERRFATAL) Start_TS = DSGetJobInfo (hDsJob, DSJ.JOBSTARTTI...