DSXchange

kduke

Write your count in one job to a sequetial file. Read the sequential file in a routine. Feed the parameter from an argument in the routine.

kduke

Ken Bland has a routine to set these in all jobs.

kduke

Ray, you forgot sequencers are a part of job sequences.

kduke

I am not sure what the maximum value is but I bet you are getting duplicates because your SDKSequeces hashed file is out of sync with the database. I think you should always reseed these values from the target database. I included a job to do this in EtlStats. Select max(#jpColumnName#) from #jpTabl...

kduke

Code: Select all

Select
   NAME as StageName
From
   DS_JOBOBJECTS
Where
   OLETYPE LILE '%Stage'
;

Should get you close.

kduke

There is a shell script below the project with schedule in the name. Permissions on this script sometimes mess up this scheduling process. If I remember correctly you do not want the set uid bit set.

ls -la *sched*

-rwsrwsr-x

Should not be a s in any of these on this script.

kduke

There is a routine included with EtlStats which will calculate the elapsed time because of this bug.

kduke

If you edit your VOC entry for this hashed file then there should 3 lines. ED VOC DS_AUDIT 3 lines long. ----: P 0001: F Ardent DataStage Repository file 0002: DS_AUDIT 0003: D_DS_AUDIT Bottom at line 3. ----: EX Line 1 says it is a F-pointer or file pointer. Line 2 is the DATA side of this hashed f...

kduke

Nice.

kduke

There are lots of jobs in EtlStats which extract job metadata from DS_JOBS and DS_JOBOBJECTS. The row counts are stored in hashed files as well as tables. I have created restartable code based on whats in the hashed files. If you look for a successful completion on today then skip the job that type ...

kduke

Dynamic hashed files resize themselves as they grow in records or decrease the number of records. So the modulo grows from 1 to 2 to 3 and so on. Where static you tell it the modulo and separation at create time or when you manualy resize it.

kduke

It is possible to send multiple lines in a parameter. It might be hard in a script to quote it correctly but in job control it is possible.

kduke

Walter, we love you.

kduke

The issue is Microsoft is always late in drivers for UNIX if any at all. All other databases support UNIX out of the box.

kduke

He is telling you 32 is large. Are your records 3,000 chars long? That is 5 or 6 records in 16KB. There are lots of posts on HASH.HELP and the other one for dynamic files. The name slipped my mind right now. Sizing hashed files is a lot of extra work most of us do not want to add because the next pe...

Search found 4605 matches