Basic Routines for Clean Resources and Clear Status file

Post by **admin** » Tue Nov 14, 2000 8:08 am

Hi All
When a job is hanged and it showing running for a long time
We have to do Cleanup Resources and Clear Status File from Datastage Director. Is there any script/Basic routine which can be run to perform these two steps.

thanks and regards
Sudhir Mahendru
GTS/APHO-ITA/CA$H/IDMS-Datawarehouse
(65) 423-7449

Post by **admin** » Tue Nov 14, 2000 9:06 pm

From the operating system command line, No.
Within UniVerse, most of the functionality of Cleanup Resources is on the DS.TOOLS menu, option 5. There is no BASIC routine.

> ----------
> From: sudhir.mahendru@db.com[SMTP:sudhir.mahendru@db.com]
> Reply To: informix-datastage@oliver.com
> Sent: Tuesday, 14 November 2000 19:08
> To: informix-datastage@oliver.com
> Subject: Basic Routines for Clean Resources and Clear Status file
>
> Hi All
> When a job is hanged and it showing running for a long time We have to
> do Cleanup Resources and Clear Status File from Datastage Director.
> Is there any script/Basic routine which can be run to perform these two
> steps.
>
>
> thanks and regards
> Sudhir Mahendru
> GTS/APHO-ITA/CA$H/IDMS-Datawarehouse
> (65) 423-7449
>
>

Post by **admin** » Wed Nov 15, 2000 6:30 am

Ray
One question this if I enable the tracing how can we benifit from that. like from DS.TOOLS menu if i do Set up server-side tracing --> turn on

what could be the possible implication of turning the tracing on

thanks and regards
Sudhir Mahendru
GTS/APHO-ITA/CA$H/IDMS-Datawarehouse
(65) 423-7449

Post by **admin** » Fri Nov 17, 2000 1:17 am

Ray,

A while ago there was some stuff posted which archived logs to text files.

I combined it & code from cleanup.job to produce a Job "AdminCleanup" which I am happy to share.

It Selects the Job/Jobs according to Naming Convention then For Eack Job:
- Archives the Log File
- Clears the Log Status file.

Parameters are:
- Archive Directory (File name is JobName.LOG)
- Job Pattern (ie PCCI... => Sellect all jobs starting with PCCI
- Archive Flag (Y => Write the log files)
- Clear Flag (Y => Clear the log after writing).

I was not sure it is appropiate to post it this List. Your advice on distribution would be appreciated.

Thanks Jack

Post by **admin** » Sat Nov 18, 2000 11:07 am

Jack/Cherie,

Its not appreciated to post things with attachments to the list. The best thing to do would be to export the routine(s) to a DSX file, attach this to a note explaining how to use it, and send it to Clif Oliver
(moderator@oliver.com) who can include it in the growing archive of useful bits.

Regards,
Ray

> ----------
> From: Cherie.Shepherd@nt.gov.au[SMTP:Cherie.Shepherd@nt.gov.au]
> Reply To: informix-datastage@oliver.com
> Sent: Friday, 17 November 2000 12:17
> To: informix-datastage@oliver.com
> Subject: Fw: Basic Routines for Clean Resources and Clear Status file
>
>
> Ray,
>
> A while ago there was some stuff posted which archived logs to text
> files.
>
> I combined it & code from cleanup.job to produce a Job "AdminCleanup"
> which I am happy to share.
>
> It Selects the Job/Jobs according to Naming Convention then For Each Job:
> - Archives the Log File
> - Clears the Log Status file.
>
> Parameters are:
> - Archive Directory (File name is JobName.LOG)
> - Job Pattern (ie PCCI... => Sellect all jobs starting with PCCI
> - Archive Flag (Y => Write the log files)
> - Clear Flag (Y => Clear the log after writing).
>
> I was not sure it is appropiate to post it this List. Your advice on
> distribution would be appreciated.
>
>
> Thanks Jack
>
>