DSXchange

These properties relate only to the Aggregator stage. The Help button for that stage type - or perhaps the stage type properties - provide more information. The first two relate to how frequently the status is updated (so the Monitor has something to show). The remainder relate to the initial size a...

Hi, One of my job updates data from sequential file to DB2 table and it updates .5m records and it takes 6 hours even though index is created in the key field, which is used in the where clause. Any improvement could be done by using Adjust job tunable properties? There are six properties available ...

Peter: There are two ways of doing this. If you are firing the job run from an active stage, the runjob function returns the job log summary...along with start/end times, number of records on various links, etc.... If you are using a control job to fire job runs, the best way is to use getlogsummary...

Thanks David. Used DS.TOOLS to logout the job. Regards Saravanan "David Barham" To: Subject: RE: Job keeps on running 26-Feb-2002 09:32 PM Please respond to datastage-use rs Sender Info: No Sender Info found in the address Book Telnet to the DataStage server, run DS.TOOLS and log out the process for...

DSGetJobInfo function can be used to get starting time of each job and end time can be derived by following. Keep on checking status of a job and when the job is completed then TimeDate function can be used to get the current time so that you can compare job start time and end time of each job. Hope...

Never tried it, but you should be able to build something using the following functions: DSGetLogEntry DSGetLogSummary DSGetNewestLogId Check out the online help for usage details. -craig Peter Oates cc: 02/26/02 02:35 PM Subject: Extract Job details from log Please respond to datastage-users Im loo...

Im looking to profile my datastage jobs to compare job duration. Is there a way of extracting these job start-time,end-time, duration details from the log and writing them to a file ? regards, Peter NOTICE This e-mail and any attachments are confidential and may contain copyright material of Macquar...

I would also suggest you add limits to the polling-for-a-file that you are doing. I have job parameters for things like: number of times to poll before giving up, time to sleep in-between polls and number of times to poll before notifying me of lateness. So for example: PollTimes = 60 SleepTime = 12...

Telnet to the DataStage server, run DS.TOOLS and log out the process for the run-away job. -----Original Message----- From: Saravanan_Thirugnanam@singaporeair.com.sg [mailto:Saravanan_Thirugnanam@singaporeair.com.sg] Sent: Tuesday, 26 February 2002 7:06 PM To: datastage-users@oliver.com Subject: Job...

Having access in NT to schedule a job and have administrator access to that particular project. Was able to schedule a job and that time the scheduled job used to work. Thanks Saravanan "David Barham" To: Subject: RE: Scheduler job not running 26-Feb-2002 05:00 PM Please respond to datastage-use rs ...

Hi, I am having a problem in DS that one of my job is running for ever. Let me explain what I am doing in this job that Im checking a file in a particular directory and I used Nap command to run the job till the file is arrived to that directory and Im doing this in the loop. Once I started running ...

Have you been to administrator to set the user for scheduled jobs and performed the test there to make sure it works? -----Original Message----- From: Saravanan_Thirugnanam@singaporeair.com.sg [mailto:Saravanan_Thirugnanam@singaporeair.com.sg] Sent: Tuesday, 26 February 2002 6:54 PM To: datastage-us...

Hi, We are having a problem in scheduling a job in DS Director. We are trying to schedule a job from DS director and we did schedule a job to run at 10:00 a.m. and the job is reset when the time reaches(10:00 a.m.). We heard from other project team that they are able to schedule a job and that job r...

Hi Wong, Have you tried using INTEGER or even VARCHAR? DataStage can handle numbers in a VARCHAR column and you can even perform arithmetic operations on it, as long as the data is numeric. Regards, Anthony Corrente. --- DS Wong wrote: > Hi, > > Im having trouble retrieving correct data from the Inf...

Hi, Im having trouble retrieving correct data from the Informix db that has a column with datatype Interval hour(4) to second, when I imported the metadata from manager through ODBC stage, the datatype for that column is "112" (Which is obviously not one of the standard datatype from the dropdown li...