DSXchange

Hi All. I need to create a KPI to indicate the number of datastage jobs running every 10 minutes through unix command line. I got the number os jobs running the command "ps -ef|grep -i "phantom DSD.RUN"|grep -v grep|wc -l", but now I need to find out how much is server and how mu...

bostonian,


We have the same error, with exactly signals that you have. Can you teel us how this error was fixed?

Thanks

Hi all, I migrate the dstage version on last week and now I'm with problems to execute dsjob command from command line. My migration was doing using the same machine, maintend both versions in parallel, the 7.5.1 on 31538 port number and 8.1 in 31539 port number. It's ok and the clients are fine. Bu...

Hi all, I am new in dstage and in our company we cannot use tools client as the director in the production environment. Ahead of this, ours jobs run is executed through the command dsjob -run. We have one script standard for this, also to recover log of job. It would like, however, with the objectiv...

Ok Ray.

I will create all jobs and routines in all the projects(+/- 20) .

Don't be very beautiful, but...

Ray and Kim, thanks a lot.

[quote]EtlStats will not work across projects. So you need to install it in the other project. dsjob can list all jobs in any project. [/quote] Kim, ok to dsjobs. I'm tried to change function "GetLastRunLog" routine to work across projects, but the problem is in DSAttachJob function. This ...

Hi Kim, I download EtlStats and its very good but in my company the environment is much "closed". We don't can use send mail, generate html routines, by example. By this, i did create other jobs and use some routines yours. The problem now is, who list jobs of other project in job control....

I need list the log files of all the jobs in a particular project to a sequential file. This routine get job status and logs information too. This will be used to generate statistics about performance of jobs.

DSGuru,

Excuse-me but i have other stages before the hash table. I don't write about this to be more easy...

Hi to all, I have the job below: HASH ---> TRANSFORM ---> SEQFILE This hash have millions of rows, but i need stop the job after read the first only. In transform stage i put @INROWNUM in constraint, but the dstage read all rows in hash...It's take 6hours to finish... I try with @OUTRONNUM too, but ...

Hi to all, I have the job below: HASH ---> TRANSFORM ---> SEQFILE This hash have millions of rows, but i need stop the job after read the first only. In transform stage i put @INROWNUM in constraint, but the dstage read all rows in hash...It's take 6hours to finish... I try with @OUTRONNUM too, but ...

I'm tried create a shell script to list a generic hash file to a sequencial file and i have one problem... To create hash file we don't use account name, all the hashs are created by "use directory path" every. Then, add hash to VOC table by ED VOC comands(uvsh) with sucess. But... when i ...

After create new environments variables in administrator. Teh message is displayed:
DSR.ADMIN: Failed to set named security - /aplic/RDMH1/dstage/dpr_rdm00/.developer.adm

Any tips?

Regards,
Wagner

Arnd,

Coud you send your post to my mail, please???
I don't have access to "premium content..." I'm very poor!!!

Mail: wahil@ig.com.br



DSguru, don't worry!
Good coffee!!!

Thanks a lot!
Wagner

Ok DSguru2B.

Thanks a lot but the job need be generic, read diferent layouts of hashed file... :(