Search found 86 matches

by madhukar
Wed Aug 08, 2007 7:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: setting display for queries on UV db
Replies: 2
Views: 895

setting display for queries on UV db

Hi All,

how can achieve the linesize/pagesize oracle functionalities in UV db.


Thanks in advance
by madhukar
Tue Jul 17, 2007 12:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SORT STAGE BEFORE JOIN STAGE
Replies: 7
Views: 3942

Check the sort keys and the join keys...it should be same
by madhukar
Sat May 05, 2007 12:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever....
Replies: 10
Views: 3690

after a lot of research what we found is

if the job is compiled by other than the user, used to start it, job hangs.
now after compiling the jobs with user used to start it, jobs are running fine.

Any thoughts on this?
by madhukar
Thu May 03, 2007 6:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever....
Replies: 10
Views: 3690

if i see the process in Unix, the job's process is in in SLEEP state with last column (COMMAND) as phantom...
i used unix top command.
by madhukar
Thu May 03, 2007 12:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever....
Replies: 10
Views: 3690

problem is recurring now...
can somebody help in this regard??
by madhukar
Fri Apr 27, 2007 9:52 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever....
Replies: 10
Views: 3690

this happened for first time.
auto purge of log has been set for one day.
by madhukar
Fri Apr 27, 2007 9:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Job running forever....
Replies: 10
Views: 3690

Job running forever....

in one of the run, a job stayed in running mode for ever and eventually it had to be killed. series of activities happened: Job sequences triggered through control-m. first job sequence completed successfully, second sequence started the first job in the second sequence stayed in running mode foreve...
by madhukar
Fri Apr 27, 2007 2:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: RT_SCTEMP/jobname.fifo locked
Replies: 6
Views: 5942

RT_SCTEMP/jobname.fifo locked

job was running for long time with no activity. i tried to stop from director. I could not. i was not the owner of process so i could not use either dsjob -stop or kill finally i used clear status file from director. Job status changed to compiled. then i restarted the job, but with the error below ...
by madhukar
Fri Apr 20, 2007 2:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: newline delimter in Start loop activity
Replies: 3
Views: 1882

could not succeed in getting the value for a newline character :(
i had to create a comma delimited file and run
by madhukar
Fri Apr 20, 2007 2:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: passing values to start loop activity
Replies: 4
Views: 1819

job sequence design looks like this command activity -->start loop-->job1-->end loop i have a filelist.txt --> file1.txt,file2.txt,file3.txt\n in command activity ---> cat filelist.txt start loop activity mapped to command output job1 input is mapped ---> start loop counter file1, file2 processes fi...
by madhukar
Thu Apr 19, 2007 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: passing values to start loop activity
Replies: 4
Views: 1819

passing values to start loop activity

i am passing values to start loop from a comma delimited file.
it runs well till the last value and aborts while processing last value.

any thought on this
by madhukar
Thu Apr 19, 2007 7:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: newline delimter in Start loop activity
Replies: 3
Views: 1882

newline delimter in Start loop activity

how to give newline character in delimter property of Start loop activity
by madhukar
Mon Mar 26, 2007 12:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: refersh user defined environment variables
Replies: 4
Views: 1353

i have added the user defined environment variable in the job which fetches values defined (default value) in the variable.

What exactly i need to do is, if i change the value of environment variable, then that value has to refreshed in the job parameter.
by madhukar
Mon Mar 26, 2007 12:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: refersh user defined environment variables
Replies: 4
Views: 1353

refersh user defined environment variables

Hi All, i have a user defined environment variable in a Job. it is working fine with the value defined at the time of creation. if i change the value and run the job again its taking the old value which is present as default value in the job if i remove the environment variable and add it again then...