Help,
I am sure this is a simple request:
I have a DataStage Job in Director that generated a Massive Log file of Warning Messages. I have since fixed the problem but am unable to get into this Screen to see any new runs or even Clear Log. I think the Log File is so big that DataStage is having a problem importing it to my PC. I dont care about the old logs I just want to clean it up.
Any suggestions?
Thanks in advance,
Lorry
Datastage Log file
Telnet to the DS server account.
At TCL (the >) promopt, do
LIST DS_JOBS
to find the job number of the job in question. (For THIS EXAMPLE ONLY, pretend it is job number 55.)
CLEAR.FILE RT_LOG55
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLIFTON OLIVER & ASSOCIATES
Information Technology Consultants ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
P.O. Box 712470, Santee, CA 92072-2470 USA
Telephone: (619) 596-0454
Website: www.oliver.com (includes PGP key)
Tuesday, February 20, 2001, 11:05:24 AM, you wrote:
> Help,
> I am sure this is a simple request:
> I have a DataStage Job in Director that generated a Massive Log
> file of Warning Messages. I have since fixed the problem but am
> unable to get into this Screen to see any new runs or even Clear Log.
> I think the Log File is so big that DataStage is having a problem
> importing it to my PC. I dont care about the old logs I just want to clean it up.
> Any suggestions?
> Thanks in advance,
> Lorry
At TCL (the >) promopt, do
LIST DS_JOBS
to find the job number of the job in question. (For THIS EXAMPLE ONLY, pretend it is job number 55.)
CLEAR.FILE RT_LOG55
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLIFTON OLIVER & ASSOCIATES
Information Technology Consultants ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
P.O. Box 712470, Santee, CA 92072-2470 USA
Telephone: (619) 596-0454
Website: www.oliver.com (includes PGP key)
Tuesday, February 20, 2001, 11:05:24 AM, you wrote:
> Help,
> I am sure this is a simple request:
> I have a DataStage Job in Director that generated a Massive Log
> file of Warning Messages. I have since fixed the problem but am
> unable to get into this Screen to see any new runs or even Clear Log.
> I think the Log File is so big that DataStage is having a problem
> importing it to my PC. I dont care about the old logs I just want to clean it up.
> Any suggestions?
> Thanks in advance,
> Lorry
NO!!!!!
There are upto three control records in the RT_LOGmm file that need to be left in place. CLEAR.FILE destroys these too.
The control records have keys beginning with "//".
Better is a command such as
DELETE FROM RT_LOGmm WHERE @ID NOT LIKE //%;
After this, //PURGE.SETTINGS should be left alone, //JOB.STARTED.NO should be left alone, but //SEQUENCE.NO could have its counter set back to zero. UPDATE RT_LOGmm SET TYPE = 0 WHERE @ID = //SEQUENCE.NO;
-----Original Message-----
From: Moderator [mailto:moderator@oliver.com]
Sent: Wednesday, 21 February 2001 08:39
To: informix-datastage@oliver.com
Subject: Re: Datastage Log file
Telnet to the DS server account.
At TCL (the >) promopt, do
LIST DS_JOBS
to find the job number of the job in question. (For THIS EXAMPLE ONLY, pretend it is job number 55.)
CLEAR.FILE RT_LOG55
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLIFTON OLIVER & ASSOCIATES
Information Technology Consultants ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
P.O. Box 712470, Santee, CA 92072-2470 USA
Telephone: (619) 596-0454
Website: www.oliver.com (includes PGP key)
Tuesday, February 20, 2001, 11:05:24 AM, you wrote:
> Help,
> I am sure this is a simple request:
> I have a DataStage Job in Director that generated a Massive Log
> file of Warning Messages. I have since fixed the problem but am
> unable to get into this Screen to see any new runs or even Clear Log.
> I think the Log File is so big that DataStage is having a problem
> importing it to my PC.
I
> dont care about the old logs I just want to clean it up.
> Any suggestions?
> Thanks in advance,
> Lorry
There are upto three control records in the RT_LOGmm file that need to be left in place. CLEAR.FILE destroys these too.
The control records have keys beginning with "//".
Better is a command such as
DELETE FROM RT_LOGmm WHERE @ID NOT LIKE //%;
After this, //PURGE.SETTINGS should be left alone, //JOB.STARTED.NO should be left alone, but //SEQUENCE.NO could have its counter set back to zero. UPDATE RT_LOGmm SET TYPE = 0 WHERE @ID = //SEQUENCE.NO;
-----Original Message-----
From: Moderator [mailto:moderator@oliver.com]
Sent: Wednesday, 21 February 2001 08:39
To: informix-datastage@oliver.com
Subject: Re: Datastage Log file
Telnet to the DS server account.
At TCL (the >) promopt, do
LIST DS_JOBS
to find the job number of the job in question. (For THIS EXAMPLE ONLY, pretend it is job number 55.)
CLEAR.FILE RT_LOG55
Regards,
Clif
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLIFTON OLIVER & ASSOCIATES
Information Technology Consultants ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
W. Clifton Oliver, CCP
P.O. Box 712470, Santee, CA 92072-2470 USA
Telephone: (619) 596-0454
Website: www.oliver.com (includes PGP key)
Tuesday, February 20, 2001, 11:05:24 AM, you wrote:
> Help,
> I am sure this is a simple request:
> I have a DataStage Job in Director that generated a Massive Log
> file of Warning Messages. I have since fixed the problem but am
> unable to get into this Screen to see any new runs or even Clear Log.
> I think the Log File is so big that DataStage is having a problem
> importing it to my PC.
I
> dont care about the old logs I just want to clean it up.
> Any suggestions?
> Thanks in advance,
> Lorry
Hi Lorry,
In DataStage Director select "View|Status" and then highlight the job. Choose "Job|Clear Log..." and choose "Immediate Purge" and "Clear All Entries" Click OK.
Note: You do not need to be viewing the log in order to clear it.
Regards,
Anthony.
--- lorry.siro@pharma.Novartis.com wrote: > Help,
> I am sure this is a simple request:
>
> I have a DataStage Job in Director that generated a Massive Log
> file of Warning Messages. I have since fixed the problem but am
> unable to get into this Screen to see any new runs or even Clear Log.
> I think the Log File is so big that DataStage is having a problem
> importing it to my PC. I dont care about the old logs I just want to clean it up.
> Any suggestions?
> Thanks in advance,
> Lorry
>
_____________________________________________________________________________
http://invites.yahoo.com.au - Yahoo! Invites
- Organise your Mardi Gras party online!
In DataStage Director select "View|Status" and then highlight the job. Choose "Job|Clear Log..." and choose "Immediate Purge" and "Clear All Entries" Click OK.
Note: You do not need to be viewing the log in order to clear it.
Regards,
Anthony.
--- lorry.siro@pharma.Novartis.com wrote: > Help,
> I am sure this is a simple request:
>
> I have a DataStage Job in Director that generated a Massive Log
> file of Warning Messages. I have since fixed the problem but am
> unable to get into this Screen to see any new runs or even Clear Log.
> I think the Log File is so big that DataStage is having a problem
> importing it to my PC. I dont care about the old logs I just want to clean it up.
> Any suggestions?
> Thanks in advance,
> Lorry
>
_____________________________________________________________________________
http://invites.yahoo.com.au - Yahoo! Invites
- Organise your Mardi Gras party online!
oops.
(Smack across the knuckles. Bad Clif!)
Thanks for jumping in and correcting me, Ray.
Tuesday, February 20, 2001, 1:53:55 PM, you wrote:
> NO!!!!!
> There are upto three control records in the RT_LOGmm file that need to
> be left in place. CLEAR.FILE destroys these too.
> The control records have keys beginning with "//".
> Better is a command such as
> DELETE FROM RT_LOGmm WHERE @ID NOT LIKE //%;
> After this, //PURGE.SETTINGS should be left alone, //JOB.STARTED.NO
> should be left alone, but //SEQUENCE.NO could have its counter set
> back to zero. UPDATE RT_LOGmm SET TYPE = 0 WHERE @ID =
> //SEQUENCE.NO;
> -----Original Message-----
> From: Moderator [mailto:moderator@oliver.com]
> Sent: Wednesday, 21 February 2001 08:39
> To: informix-datastage@oliver.com
> Subject: Re: Datastage Log file
> Telnet to the DS server account.
At TCL (the >>) promopt, do
> LIST DS_JOBS
> to find the job number of the job in question. (For THIS EXAMPLE
> ONLY, pretend it is job number 55.)
> CLEAR.FILE RT_LOG55
> Regards,
> Clif
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> CLIFTON OLIVER & ASSOCIATES
> Information Technology Consultants
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> W. Clifton Oliver, CCP
> P.O. Box 712470, Santee, CA 92072-2470 USA
> Telephone: (619) 596-0454
> Website: www.oliver.com (includes PGP key)
> Tuesday, February 20, 2001, 11:05:24 AM, you wrote:
>> Help,
>> I am sure this is a simple request:
>> I have a DataStage Job in Director that generated a Massive Log
>> file of Warning Messages. I have since fixed the problem but am
>> unable to get into this Screen to see any new runs or even Clear Log.
>> I think the Log File is so big that DataStage is having a problem
>> importing it to my PC.
> I
>> dont care about the old logs I just want to clean it up.
>> Any suggestions?
>> Thanks in advance,
>> Lorry
(Smack across the knuckles. Bad Clif!)
Thanks for jumping in and correcting me, Ray.
Tuesday, February 20, 2001, 1:53:55 PM, you wrote:
> NO!!!!!
> There are upto three control records in the RT_LOGmm file that need to
> be left in place. CLEAR.FILE destroys these too.
> The control records have keys beginning with "//".
> Better is a command such as
> DELETE FROM RT_LOGmm WHERE @ID NOT LIKE //%;
> After this, //PURGE.SETTINGS should be left alone, //JOB.STARTED.NO
> should be left alone, but //SEQUENCE.NO could have its counter set
> back to zero. UPDATE RT_LOGmm SET TYPE = 0 WHERE @ID =
> //SEQUENCE.NO;
> -----Original Message-----
> From: Moderator [mailto:moderator@oliver.com]
> Sent: Wednesday, 21 February 2001 08:39
> To: informix-datastage@oliver.com
> Subject: Re: Datastage Log file
> Telnet to the DS server account.
At TCL (the >>) promopt, do
> LIST DS_JOBS
> to find the job number of the job in question. (For THIS EXAMPLE
> ONLY, pretend it is job number 55.)
> CLEAR.FILE RT_LOG55
> Regards,
> Clif
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> CLIFTON OLIVER & ASSOCIATES
> Information Technology Consultants
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> W. Clifton Oliver, CCP
> P.O. Box 712470, Santee, CA 92072-2470 USA
> Telephone: (619) 596-0454
> Website: www.oliver.com (includes PGP key)
> Tuesday, February 20, 2001, 11:05:24 AM, you wrote:
>> Help,
>> I am sure this is a simple request:
>> I have a DataStage Job in Director that generated a Massive Log
>> file of Warning Messages. I have since fixed the problem but am
>> unable to get into this Screen to see any new runs or even Clear Log.
>> I think the Log File is so big that DataStage is having a problem
>> importing it to my PC.
> I
>> dont care about the old logs I just want to clean it up.
>> Any suggestions?
>> Thanks in advance,
>> Lorry