DB2 9 for z/OS automatic deletion of archived logs

Daniel Luksetich

DB2 9 for z/OS automatic deletion of archived logs
Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do it,
but that's not the level of automation I was looking for since the REXX
would have to be somehow executed.

Thanks,
Dan

Jorg Lueke

RE: DB2 9 for z/OS automatic deletion of archived logs
(in response to Daniel Luksetich)

Is RETPD dependent on SMS?


In Reply to Daniel Luksetich:

Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do it,
but that's not the level of automation I was looking for since the REXX
would have to be somehow executed.

Thanks,
Dan

Daniel Luksetich

DB2 9 for z/OS automatic deletion of archived logs
(in response to Jorg Lueke)
no, but it doesn't delete the dataset on expiration it only makes it
available to be deleted. Usually something like SMS or a tape management
system will do the actual delete.

Dan

On Thu, 20 Jun 2013 08:40:13 -0700 (MST), Jorg Lueke
<[login to unmask email]> wrote:
> Is RETPD dependent on SMS?
>
> In Reply to Daniel Luksetich:
> Well, I'm not sure it's possible, or maybe I'm just overlooking the
> obvious. Here's the situation:
>
> -DB2 logs archived to DASD that is NOT SMS managed
> -archived log space limited so we must manually remove the logs
> -SMS is not an option and no tools available
>
> Is there anyway to automate the deletion of the oldest archived logs?
> Research has led me nowhere. I know I can write a REXX routine to do it,
> but that's not the level of automation I was looking for since the REXX
> would have to be somehow executed.
>
> Thanks,
> Dan
>
> -----End Original Message-----

Lizette Koehler

DB2 9 for z/OS automatic deletion of archived logs
(in response to Jorg Lueke)
I am not sure if the DB2 Template provide RETPD or EXPDT as an option. But
that would set a time limit.



However, is there a concern that you setup an archive log for a specific
expiration and then find you need it for a roll back? How will you
determine the length an archive log needs to be retained?



As for the rexx, you could have JES2 do an Auto submit thru the $VS command
at a specific time and that would run the TSO or REXX Batch functions.



Or you could go to the CBTTAPE.ORG and look for some automation tools there.
There are some simple easy to use ones there.



It will depend on if your shop allows for shareware on your system or not.



Lizette





From: Jorg Lueke [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 8:40 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



Is RETPD dependent on SMS?


In Reply to Daniel Luksetich:

Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do it,
but that's not the level of automation I was looking for since the REXX
would have to be somehow executed.

Thanks,
Dan



-----End Original Message-----

Carol Anne Sutfin

DB2 9 for z/OS automatic deletion of archived logs
(in response to Lizette Koehler)
Yes, It does.

I use this on my DASD image copies to get HSM to delete them.

It sets expiration date on the dataset.

Carol Sutfin
Corporate DBA
Regions Bank
(205)261-5214
[login to unmask email]



From: Lizette Koehler <[login to unmask email]>
To: [login to unmask email]
Date: 06/20/2013 10:52 AM
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived
logs



I am not sure if the DB2 Template provide RETPD or EXPDT as an option. But
that would set a time limit.

However, is there a concern that you setup an archive log for a specific
expiration and then find you need it for a roll back? How will you
determine the length an archive log needs to be retained?

As for the rexx, you could have JES2 do an Auto submit thru the $VS command
at a specific time and that would run the TSO or REXX Batch functions.

Or you could go to the CBTTAPE.ORG and look for some automation tools
there. There are some simple easy to use ones there.

It will depend on if your shop allows for shareware on your system or not.

Lizette


From: Jorg Lueke [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 8:40 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



Is RETPD dependent on SMS?



In Reply to Daniel Luksetich:
Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do
it,
but that's not the level of automation I was looking for since the
REXX
would have to be somehow executed.

Thanks,
Dan

-----End Original Message-----


Site Links: View post online View mailing list online Send new post via
email Unsubscribe from this mailing list Manage your subscription
** ** ** Attend the 2013 IDUG DB2 Tech Conference EMEA ** ** **
---> Princesa Sofia Gran Hotel, Barcelona, Spain, 13 - 18 October, 2013
<---
http://www.idug.org/p/cm/ld/fid=273

Use of this email content is governed by the terms of service at:
http://www.idug.org/p/cm/ld/fid=2

Daniel Luksetich

DB2 9 for z/OS automatic deletion of archived logs
(in response to Lizette Koehler)
I can set up the RETPD in DB2 no problem, but without automation I don't
believe the datasets will be deleted.

This REXX JES2 $VS thing sounds interesting, I'll explore that.

No concern about the usefulness of the archives. There is no use. We can
cold start if the S hits the F. Sandbox only.

I'll check out that site as well, thanks!

Dan


On Thu, 20 Jun 2013 08:52:09 -0700, Lizette Koehler
<[login to unmask email]> wrote:
> I am not sure if the DB2 Template provide RETPD or EXPDT as an option.
But
> that would set a time limit.
>
>
>
> However, is there a concern that you setup an archive log for a specific
> expiration and then find you need it for a roll back? How will you
> determine the length an archive log needs to be retained?
>
>
>
> As for the rexx, you could have JES2 do an Auto submit thru the $VS
command
> at a specific time and that would run the TSO or REXX Batch functions.
>
>
>
> Or you could go to the CBTTAPE.ORG and look for some automation tools
> there.
> There are some simple easy to use ones there.
>
>
>
> It will depend on if your shop allows for shareware on your system or
not.
>
>
>
> Lizette
>
>
>
>
>
> From: Jorg Lueke [mailto:[login to unmask email]
> Sent: Thursday, June 20, 2013 8:40 AM
> To: [login to unmask email]
> Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived
logs
>
>
>
> Is RETPD dependent on SMS?
>
>
> In Reply to Daniel Luksetich:
>
> Well, I'm not sure it's possible, or maybe I'm just overlooking the
> obvious. Here's the situation:
>
> -DB2 logs archived to DASD that is NOT SMS managed
> -archived log space limited so we must manually remove the logs
> -SMS is not an option and no tools available
>
> Is there anyway to automate the deletion of the oldest archived logs?
> Research has led me nowhere. I know I can write a REXX routine to do it,
> but that's not the level of automation I was looking for since the REXX
> would have to be somehow executed.
>
> Thanks,
> Dan
>
>
>
> -----End Original Message-----
>
>
> -----End Original Message-----

Max Scarpa

DB2 9 for z/OS automatic deletion of archived logs
(in response to Daniel Luksetich)
No automation ?

There's a way to schedule via JES2 a batch containing a REXX. We did it
in the good old days when no tool like control-M or other where
available (And no SMS as well).

Max Scarpa


Il 20/06/13 16:56, Daniel Luksetich ha scritto:
> Well, I'm not sure it's possible, or maybe I'm just overlooking the
> obvious. Here's the situation:
>
> -DB2 logs archived to DASD that is NOT SMS managed
> -archived log space limited so we must manually remove the logs
> -SMS is not an option and no tools available
>
> Is there anyway to automate the deletion of the oldest archived logs?
> Research has led me nowhere. I know I can write a REXX routine to do it,
> but that's not the level of automation I was looking for since the REXX
> would have to be somehow executed.
>
> Thanks,
> Dan
>
> -----End Original Message-----
>
>
>

Paul Ogborne

DB2 9 for z/OS automatic deletion of archived logs
(in response to Daniel Luksetich)
Hi Dan,
You say that you have limited space but hopefully you would not need to delete these old logs too often; say once per day at most?
In the absence of SMS or other tools I would be inclined to write a REXX to either look at ICF catalog entries or you could print the bootstrap and, by taking your archive retention period into consideration, produce output to delete the appropriate datasets.
Assuming that you copy your catalog and directory daily then I would tack the job on to that existing suite.
Regards,
Paul.

On 20 Jun 2013, at 15:56, Daniel Luksetich <[login to unmask email]> wrote:

> Well, I'm not sure it's possible, or maybe I'm just overlooking the
> obvious. Here's the situation:
>
> -DB2 logs archived to DASD that is NOT SMS managed
> -archived log space limited so we must manually remove the logs
> -SMS is not an option and no tools available
>
> Is there anyway to automate the deletion of the oldest archived logs?
> Research has led me nowhere. I know I can write a REXX routine to do it,
> but that's not the level of automation I was looking for since the REXX
> would have to be somehow executed.
>
> Thanks,
> Dan
>
> -----End Original Message-----
>

Ted MacNeil

DB2 9 for z/OS automatic deletion of archived logs
(in response to Paul Ogborne)
I have a simple question: why is SMS not an option?
-
Ted MacNEIL
[login to unmask email]
Twitter: @TedMacNEIL

-----Original Message-----
From: Paul Ogborne <[login to unmask email]>
Date: Thu, 20 Jun 2013 20:00:05
To: [login to unmask email]<[login to unmask email]>
Reply-To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs

Hi Dan,
You say that you have limited space but hopefully you would not need to delete these old logs too often; say once per day at most?
In the absence of SMS or other tools I would be inclined to write a REXX to either look at ICF catalog entries or you could print the bootstrap and, by taking your archive retention period into consideration, produce output to delete the appropriate datasets.
Assuming that you copy your catalog and directory daily then I would tack the job on to that existing suite.
Regards,
Paul.

On 20 Jun 2013, at 15:56, Daniel Luksetich <[login to unmask email]> wrote:

> Well, I'm not sure it's possible, or maybe I'm just overlooking the
> obvious. Here's the situation:
>
> -DB2 logs archived to DASD that is NOT SMS managed
> -archived log space limited so we must manually remove the logs
> -SMS is not an option and no tools available
>
> Is there anyway to automate the deletion of the oldest archived logs?
> Research has led me nowhere. I know I can write a REXX routine to do it,
> but that's not the level of automation I was looking for since the REXX
> would have to be somehow executed.
>
> Thanks,
> Dan
>
> -----End Original Message-----
>

-----End Original Message-----

Daniel Luksetich

DB2 9 for z/OS automatic deletion of archived logs
(in response to Ted MacNeil)
Sandbox system provided by outsourcer. Limited tools, limited features,
limited money, every change is a request and every request must be paid
for. So, no additions/changes made.

Dan

On Thu, 20 Jun 2013 19:31:56 +0000, Ted MacNeil <[login to unmask email]>
wrote:
> I have a simple question: why is SMS not an option?
> -
> Ted MacNEIL
> [login to unmask email]
> Twitter: @TedMacNEIL
>
> -----Original Message-----
> From: Paul Ogborne <[login to unmask email]>
> Date: Thu, 20 Jun 2013 20:00:05
> To: [login to unmask email]<[login to unmask email]>
> Reply-To: [login to unmask email]
> Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived
logs
>
> Hi Dan,
> You say that you have limited space but hopefully you would not need to
> delete these old logs too often; say once per day at most?
> In the absence of SMS or other tools I would be inclined to write a REXX
> to either look at ICF catalog entries or you could print the bootstrap
and,
> by taking your archive retention period into consideration, produce
output
> to delete the appropriate datasets.
> Assuming that you copy your catalog and directory daily then I would
tack
> the job on to that existing suite.
> Regards,
> Paul.
>
> On 20 Jun 2013, at 15:56, Daniel Luksetich <[login to unmask email]> wrote:
>
>> Well, I'm not sure it's possible, or maybe I'm just overlooking the
>> obvious. Here's the situation:
>>
>> -DB2 logs archived to DASD that is NOT SMS managed
>> -archived log space limited so we must manually remove the logs
>> -SMS is not an option and no tools available
>>
>> Is there anyway to automate the deletion of the oldest archived logs?
>> Research has led me nowhere. I know I can write a REXX routine to do
it,
>> but that's not the level of automation I was looking for since the REXX
>> would have to be somehow executed.
>>
>> Thanks,
>> Dan
>>
>> -----End Original Message-----
>>
>
> -----End Original Message-----
>
>
> -----End Original Message-----

Daniel Luksetich

DB2 9 for z/OS automatic deletion of archived logs
(in response to Lizette Koehler)
OK, This is good stuff and I think I can pull it off. All I need to know is
where to put my JCL for the JES2 submission. Any clue as to how I find that
out?

Thanks,

Dan



From: Lizette Koehler [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 10:52 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



I am not sure if the DB2 Template provide RETPD or EXPDT as an option. But
that would set a time limit.



However, is there a concern that you setup an archive log for a specific
expiration and then find you need it for a roll back? How will you
determine the length an archive log needs to be retained?



As for the rexx, you could have JES2 do an Auto submit thru the $VS command
at a specific time and that would run the TSO or REXX Batch functions.



Or you could go to the CBTTAPE.ORG and look for some automation tools there.
There are some simple easy to use ones there.



It will depend on if your shop allows for shareware on your system or not.



Lizette





From: Jorg Lueke [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 8:40 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



Is RETPD dependent on SMS?


In Reply to Daniel Luksetich:

Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do it,
but that's not the level of automation I was looking for since the REXX
would have to be somehow executed.

Thanks,
Dan



-----End Original Message-----



-----End Original Message-----

Lizette Koehler

DB2 9 for z/OS automatic deletion of archived logs
(in response to Daniel Luksetich)
To have JES2 submit the job I would do the following



1) Create an IEBGENER PROC
//SUBJOB PROC MEMBER=INVALID

//SUBJOB EXEC PGM=IEBGENER

//SYSPRINT DD SYSOUT=*

//SYSIN DD DUMMY

//SYSUT1 DD DISP=SHR,DSN=Input.dsn(&member) This points to the
data set containing the job you want to submit

//SYSUT2 DD SYSOUT=(B,INTRDR) Sends the SYSUT1 to the
Internal Reader



2) Place the IEBGENER in SYS1.PROCLIB or similar PROCLIB Concatenation

ISSUE $DPROCLIB command to see what you have. Or browse the JES2 PROC to
see if there are //PROCxx statements, or check the JES2 parmlib for PROCLIB
(TPROCLIB?) statements.



From the operator console run a check

S SUBJOB,MEMBER=xxx



See if it does what you want.



Or talk to your friendly z/OS System programmer.





Lizette



From: Daniel L Luksetich [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 6:40 PM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



OK, This is good stuff and I think I can pull it off. All I need to know is
where to put my JCL for the JES2 submission. Any clue as to how I find that
out?

Thanks,

Dan



From: Lizette Koehler [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 10:52 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



I am not sure if the DB2 Template provide RETPD or EXPDT as an option. But
that would set a time limit.



However, is there a concern that you setup an archive log for a specific
expiration and then find you need it for a roll back? How will you
determine the length an archive log needs to be retained?



As for the rexx, you could have JES2 do an Auto submit thru the $VS command
at a specific time and that would run the TSO or REXX Batch functions.



Or you could go to the CBTTAPE.ORG and look for some automation tools there.
There are some simple easy to use ones there.



It will depend on if your shop allows for shareware on your system or not.



Lizette





From: Jorg Lueke [mailto:[login to unmask email]
Sent: Thursday, June 20, 2013 8:40 AM
To: [login to unmask email]
Subject: [DB2-L] - RE: DB2 9 for z/OS automatic deletion of archived logs



Is RETPD dependent on SMS?


In Reply to Daniel Luksetich:

Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do it,
but that's not the level of automation I was looking for since the REXX
would have to be somehow executed.

Thanks,
Dan



-----End Original Message-----



-----End Original Message-----



-----End Original Message-----

James Campbell

DB2 9 for z/OS automatic deletion of archived logs
(in response to Daniel Luksetich)
You'll possibly find $TA also of use - it gets JES2 to issue a command either at a set time or
frequency. The command issued can, of course, be a $VS command to start a task to
submit a job.

You can put the $TA command into your JESPARMS, so it gets initiated when JES starts.

James Campbell

On 20 Jun 2013 at 8:58, Daniel Luksetich wrote:

>
> This REXX JES2 $VS thing sounds interesting, I'll explore that.
>

<rest snipped>

Daniel Luksetich

DB2 9 for z/OS automatic deletion of archived logs
(in response to James Campbell)
the idea is $TA plus REXX will do the trick. I'm still struggling to get a
job submitted. I'm going to do more testing over the weekend so we shall
see.

Thanks,
dan

On Fri, 21 Jun 2013 22:39:45 +1000, James Campbell
<[login to unmask email]> wrote:
> You'll possibly find $TA also of use - it gets JES2 to issue a command
> either at a set time or
> frequency. The command issued can, of course, be a $VS command to start
a
> task to
> submit a job.
>
> You can put the $TA command into your JESPARMS, so it gets initiated
when
> JES starts.
>
> James Campbell
>
> On 20 Jun 2013 at 8:58, Daniel Luksetich wrote:
>
>>
>> This REXX JES2 $VS thing sounds interesting, I'll explore that.
>>
>
> <rest snipped>
>
> -----End Original Message-----

Avram Friedman

RE: DB2 9 for z/OS automatic deletion of archived logs
(in response to Daniel Luksetich)

I have been in a shop that archived to DASD and used a storage management tool to archive the oldest logs.

THe idea was to

     a not run out of space in the log DASD pool

     b. make sure the max number of logs were online for recovery.

 

Needing the archived by storage management logs can be a big issue as volumes to do the restores may not be easy to come by.

 

Frequent Image Copies and space for all the logs between ICs may be the best option.

In Reply to Daniel Luksetich:

Well, I'm not sure it's possible, or maybe I'm just overlooking the
obvious. Here's the situation:

-DB2 logs archived to DASD that is NOT SMS managed
-archived log space limited so we must manually remove the logs
-SMS is not an option and no tools available

Is there anyway to automate the deletion of the oldest archived logs?
Research has led me nowhere. I know I can write a REXX routine to do it,
but that's not the level of automation I was looking for since the REXX
would have to be somehow executed.

Thanks,
Dan




Avram Friedman

IBM-sys-Prog.com