Search found 299 matches

by swades
Fri Oct 05, 2007 2:07 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Do I need, can I have SID=Oracle SID in Oracle odbc defintio
Replies: 3
Views: 1636

Sample Entry in .odbc.ini [DSN] Driver=/apps/dstage/Ascential/DataStage/branded_odbc/lib/VMora20.so Description=DataDirect Oracle Wire Protocol ApplicationUsingThreads=1 ArraySize=60000 CachedCursorLimit=32 CachedDescLimit=0 CatalogIncludesSynonyms=1 CatalogOptions=0 DefaultLongDataBuffLen=1024 Desc...
by swades
Wed Sep 19, 2007 12:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile jobs in command prompt
Replies: 7
Views: 2496

Re: compile jobs in command prompt

kavuri wrote: how to compile a job from command prompt?
What is the NEED?
by swades
Wed Sep 19, 2007 12:30 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: compile jobs in command prompt
Replies: 7
Views: 2496

Re: compile jobs in command prompt

kavuri wrote: how to compile a job from command prompt?
Check here
by swades
Wed Sep 19, 2007 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to handle multi delimiter (flat file) in DataStage ?
Replies: 4
Views: 4894

How to handle multi delimiter (flat file) in DataStage ?

Hello,
I am getting multi delimiter separated flat file.
Delimiter is : <|>
Can anyone have idea how to handle these type of file ?

Thanks in advance for your time.
by swades
Fri Sep 07, 2007 1:00 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error on dual installation(DS 7.5.1 & 8.0V) with dshome
Replies: 4
Views: 2056

Simar wrote:Hi,


I restarted the DS 8.0.1 server again..... but again the result was same....
Did you run following commands

$DSHOME/bin/uv -admin -stop
$DSHOME/bin/uv -admin -start

If so execute
"set" command -- and check what it shows for DSHOME???
by swades
Fri Sep 07, 2007 8:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error on dual installation(DS 7.5.1 & 8.0V) with dshome
Replies: 4
Views: 2056

I got question here "What is shows under .dshome?"
Or "is there exists two different files for two different version?" :?:
by swades
Tue Sep 04, 2007 8:46 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Shell script not kicking off
Replies: 1
Views: 920

Shell script not kicking off

Hello,
We are scheduling DataStage jobs from Crontab (Shell Script ).I have made entry in crontab to run script at perticular time but It is not executing.
what can be the reason ?
However I can execute the same manually.

Thanks for your time.
by swades
Tue Aug 21, 2007 8:32 am
Forum: General
Topic: Delete Job Difference
Replies: 7
Views: 2499

Thanks ArndW and Ray,

We delete jobs from manager.
by swades
Tue Aug 21, 2007 8:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error - for dsadm user
Replies: 6
Views: 1346

Its Done :D

Thanks ArndW
by swades
Thu Aug 16, 2007 4:00 pm
Forum: General
Topic: Delete Job Difference
Replies: 7
Views: 2499

I execute this command in my dev. environment

Code: Select all

DELETE FROM DS_JOBS
thats how that counter set to 1. And its just overwrite that orphaned files for new jobs.
what is risk factor to overwrite this orphaned files ?(just for knowledge)
by swades
Thu Aug 16, 2007 3:23 pm
Forum: General
Topic: Delete Job Difference
Replies: 7
Views: 2499

I also notice here that, when i create new job ,its just overwrite the orphaned files -starting from 1 JOBNO. and i do see here new things, as i created only 3 new jobs, SELECT NAME FROM DS_JOBS WHERE JOBNO = '4'; Job name............ \\NextNumber 1 records listed. so its save next job no some where...
by swades
Thu Aug 16, 2007 2:39 pm
Forum: General
Topic: Delete Job Difference
Replies: 7
Views: 2499

Delete Job Difference

Hi, What is difference between -Delete a job from manager and -Delete a job from Admin command line DELETE FROM DS_JOBS WHERE NAME = 'JOB_NAME'; I notice that if i delete job from command line it leaves DS_TEMP,RT_BP,RT_CONFIG,RT_LOG,RT_STATUS - Files under that project directory. so if i have to de...
by swades
Mon Aug 13, 2007 9:28 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error - for dsadm user
Replies: 6
Views: 1346

ArndW wrote:What about the UNIX access rights to the directory RT_CONFIGxxxx and the files in that directory?
For RT_CONFIGxxxx - 0777
and files in that directory - 0664, i have changed this permission to 0777, now its not throwing me any error ,but it still fail to compile.

Thanks
by swades
Sun Aug 12, 2007 4:18 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error - for dsadm user
Replies: 6
Views: 1346

ArndW wrote:can you 'touch' or 'mkdir' using your dsadm id in the project directory?
Yes i can run 'mkdir' command using my dsadm id.
by swades
Fri Aug 10, 2007 3:52 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Compilation Error - for dsadm user
Replies: 6
Views: 1346

Compilation Error - for dsadm user

While i am compiling any job , its throw me error, Error writing to RT_CONFIGXXX(Job Name) weird thing is that i can compile same job with other user ID. id uid=22116(ID) gid=10(staff), groups staff dsadmn for dsadm id uid=22111(dsadm) gid=400(dsadmn) groups dsadmn I checked all files under that pro...