DSXchange

Hi Create a job with parameter as the date to which 25 months are to be added to. Inside the job have DB2 stage or similar database stages. Define metadata with one field and type date. In the sql you write Select #Parameter# + 25 Months from sysdummy1. Or if you are using oracle select add_months(#...

Hi You can alter the table using command so that the table will not write to rollback segment. I am not sure about the commands. Its some thing like ALTER TABLE table_name ACTIVATE NOT LOGGED INITIALLY; DELETE FROM table_name... COMMIT; This will help you delete from the table faster. Thanks Manoj

Hi

I think this can be due to the log file size only.

You can try renaming the job, It may take time but still leave it. I feel renaming the job is faster than clearing the logs. After this you can try running the job for one row and check the warning, Correct the error and try again.

Regards
Manoj

Hi

Try a dummy job to select count(*) from some table .In the before / after SQL write the index dropping SQL.

Thanks
Manoj

HI

Can you please do a DSLogInfo and see if the parameter is read from the file correctly or not.

Regards
Manoj.

Hi

I think the routine you have given is not complete.
Pls give the complete routine to infer something from it.

Regards
Manoj.

Hi

Try using unix sort instead of datastage sorting.
Unix sort works in great speed compared to datastage sort stage.

Thanks
Manoj.

Hi

The view hangs because there are too many logs.
You try renaming the job. This will clear the logs for this job.
Later you run the job with less number of rows( may be 10 or 100) and find out the log that is created by the job.
Correct the error that run the job again.

Thanks
Manoj

Hi

Thanks a Lot.
I am able to find out the time of last change by your support, Thanks again.

Is there any way to know the user id which modifed the job.

Best Regards
Manoj.

Hi

No, The Job is not compiled.
I want to know the last saved time of the job.

Thanks
Manoj.

Hi

Find the log file that has the maximum size in the projects directory.
It will start with name as RT_LOG(I think)
Open the file to see the first line in the file.
The jobname will be in there in that line.

Thanks and Regards
Manoj

Hi

Is there a way to know the last modified date of a Server Job.

Thanks and Regards
Manoj

Hi

Can anyone tell what is the maximum number of records that can be kept in a Hash File.

Thanks in Advance

Manoj

Hi
I was under an impression that you are using a batch job to call individual jobs in sequence.

You can use a batch job to call the individual jobs instead of using the sequencer. While calling the individual jobs you can set the limit for each jobs using this command.

Thanks
Manoj

Hi

Use the following
ErrCode = DSSetJobLimit(hJob1, DSJ.LIMITWARN, 50)
before running the job in the Batch which call individual jobs.
Pls set the warnings accordingly for each jobs.

Regards
Manoj