Search found 154 matches

by dspxguy
Tue May 20, 2008 11:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: odbc stage
Replies: 2
Views: 1554

odbc stage

To extract data from source using odbc stage , what needs to be done to get a better performance, considering we are using both server and parallel jobs.

Thanks
by dspxguy
Thu May 01, 2008 3:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tmp space
Replies: 10
Views: 3419

Thanks for the info,
by dspxguy
Wed Apr 30, 2008 9:44 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tmp space
Replies: 10
Views: 3419

hi, thanks for the responses. another question, what is the purpose of defining the varaiable TMPDIR in adminsitrator when we already use UVTEMP in uvconfig? In some of our environments we have defined both and in some we are only using UVTEMP space. is TMPDIR a backup space, like when scratch will ...
by dspxguy
Mon Apr 21, 2008 5:02 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tmp space
Replies: 10
Views: 3419

Ray,
i totally agree with that statement.
i am just curious why did it run fine after the abort., maybe 1GB tmp space is not enough for the jobs..
by dspxguy
Mon Apr 21, 2008 3:20 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tmp space
Replies: 10
Views: 3419

kumar_s wrote:Have you selected "Enable Row Buffer" at job property level to Inter Process? ...
yes
by dspxguy
Mon Apr 21, 2008 1:56 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tmp space
Replies: 10
Views: 3419

SeqFile --- Hash | xfm -------->xfm ------>xfm------->LinkPartitioner | | | | Hash Seq File DB2 -------->Linkcoltr | DB2 -------->xfm using link collector and link partitioner stages,
by dspxguy
Mon Apr 21, 2008 1:22 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: tmp space
Replies: 10
Views: 3419

tmp space

hi, we got this error message in a server job chekstglink: ds_ipcopen() - Error in open(/tmp/ade.projecta.jobname.RecodeUnitCnts_tran-Combine.chekstglink) - No such file or directory later on the job finished successfully. I checked the /tmp space and it was not full and there were no permission iss...
by dspxguy
Wed Apr 16, 2008 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project deleted but still exists
Replies: 10
Views: 3334

Should we always delete a project from UV instead of Administrator?
I got this message after I deleted the project from admin.

Failed to delete all components .......
by dspxguy
Wed Apr 16, 2008 11:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project deleted but still exists
Replies: 10
Views: 3334

Gentlemen,

I ran these commands from UV prompt

Code: Select all

SELECT * FROM UV.ACCOUNT; 

SELECT * FROM UV_SCHEMA; 
didnt find the deleted project there, i dont even see it in the project down list in the client components. but it is still in Unix $DSHOME ../Projects/
by dspxguy
Tue Apr 15, 2008 1:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Project deleted but still exists
Replies: 10
Views: 3334

Project deleted but still exists

hi,
Project deleted from administrator, but still exists in datastage project path on Unix.

pls advise.
by dspxguy
Tue Apr 08, 2008 1:04 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile issue
Replies: 4
Views: 3416

compile issue

Getting this error when compiling a job

Code: Select all

Record J\1515\V0547 on file DS_JOBOBJECTS cannot be written
What is this refering to? What is J, V ?

Thanks
by dspxguy
Fri Apr 04, 2008 10:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Datastage
Replies: 10
Views: 6612

yea it does sound weird, but thats how i worked on my last project...i had to use my laptop and it had vista...
Beleive it or not but DataStage worked fine for me using Virtual PC..... 8)
by dspxguy
Fri Apr 04, 2008 10:19 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Installing Datastage
Replies: 10
Views: 6612

Re: Installing Datastage

Hi Friends, I wanted to install datastage 7.5x2. I have Windows Vista in my system.Any one can suggeest me can I install datastage on Vista and what and all are required before installing. Thanks in Advance Anju If you want to use DataStage on Vista, First install the Microsoft Virtual PC 2007 whic...
by dspxguy
Mon Dec 17, 2007 3:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot find job
Replies: 10
Views: 2670

the list_readu command does not show any locks associated with this job.
i dont see the job anywhere in the director therefore cant clear the status file.
by dspxguy
Mon Dec 17, 2007 12:02 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: cannot find job
Replies: 10
Views: 2670

ls -lrt *3122

ls: 0653-341 The file *3122* does not exist.