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
Basic Routines for Clean Resources and Clear Status file
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
>
>
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
>
>
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
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
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
>
>
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
>
>