DSXchange

:cry: Ok, I've obviously not communicated properly. The job LOGS are cleared out fine after 5 days. The job entries in director are building up and up. those over 5 days ago are empty. The base job (xxx) shows 5 days of log. The logs xxx.111, xxx.112 etc for 5 days show data. More than 5 days ago th...

We are running our jobs with job instance that is an increasing number (EG: loadhash.1234, loadhash.1235 etc). The properties of the project is set to clear the log after 5 days, but the director has entries in it going back to day dot. Apart from deleting via director, is there anyway to empty thes...

Just a little off topic, but related: Can I use a 7.5 client against a 7.0.1 server/PX? Client is WIn$, servers are Solaris.

We are going to upgrade, but I want to load the client to my machine to play with for a while.

Will it impact the direcor/manager/administrator as I am also dsadm.

Andrew

Just got onto this thread, hope I'm not too late :). We are using teradata backend (NCR unix) from a solaris box. We mix multiload (mload) and direct data/stage writes depending on volume. Multiload has a 20 second startup time, if the time to load the number of records is < 20 secionds on direct lo...

"Whoosh" is the sound Willi E makes when falling off a cliff. Bugs has always had more personality the Daffy so there :). Managers would have to be the martian (the one erroneously referred to as Marvin) who would blow up a planet because it blocks his view of Venus and throws 10's of '000...

BMP-> JPEG used Easy Image Converter from http://www.homeplansoftware.com. I've got the Unix/win32 suite of programs so I could: ls *.bmp > a | sed s/.bmp// > a then gawk -f a.awk a > aa.bat where a.awk is: { print "\"C:\\Program Files\\Home Plan Software\\Easy Image Convertor\\imgconv.exe...

We recently down loaded the Duke's doco suite. Now we can view our jobs without loading data stage. I had to do a few tweaks to the bat files and html as the BMP's are too "steenkin'" big. Ran them through a batch BMP > JPEG, sed'd all the html s/bmp/jpg/ and now what was 700MB doco is 200...

Thanx for that Vincent. I've been poking about a bit for routines to dump logs to files.

I'll see what happens after the compile.

Well I've got a full system compile coming up Friday because of a shared container that is used by all jobs (error handler) but normally no. Also I would like to keep the 5 days of jobs that do have log entries availble. Oh well. Looks like I'll have to dump the log to a text file and run a compile ...

G'day all, When our jobs run, they are running with an invocation ID of a sequential numbered JOBID. This means that Director is getting a little crowded. We have the log deletion set to 5 days, but the jobs are not removed from Director. I tried a clean up from Admin, but that didn't rid me of the ...

Ray, Thanx for all your help. One of our enterprising developers wrots a DS Basic routine using the October/March mandate for Victoria. We'll see how the PTB's accept this. If this fails, we'll go to the C program that we have cobbled together. We are on a Solaris box, so the Australia/Victoria is t...

It's a single Server handling multiple timezones to multiple timezones and GMT and some data with or without daylight savings even if that TZ should have DST ... real fun. I don't have the C code on me, but it is calling the C cdae function and overriding the TZ as required to get a seconds since ep...

Hey I'm not proud, if someone can show how to BASIC the TZ and day light savings problem, remembering in Australia the start and end times differ from year toyear and state to state, I'll use it. If three po0ple post it I won't even have to plgerise, that makes it research ;-)

The problem with writing it in it in basic is that it has to deal with three times: Australia/Victoria - including DST - > GMT, GMT+10 -> GMT and GMT+10 -> Australia/Victoria. We have since hacked the SO version apart, created a C program and doing final testing. It is a trivial program. We'll call ...

Thanx Ray. I;m going to get the C shared library function wrutten as a standalone C program and call it from inside of a routine via a Unix call.,