Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Jun 20
    2013

    DB2 9 for z/OS automatic deletion of archived logs

    Daniel Luksetich
    [DanL Database Consulting]
    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
    [Blue Cross Blue Shield]

    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
    [DanL Database Consulting]
    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
    [Scana Corporation]
    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
    [Refions Financial]
    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
    [DanL Database Consulting]
    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
    [Cx SpA]
    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
    [none]
    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
    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
    [DanL Database Consulting]
    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
    [DanL Database Consulting]
    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
    [Scana Corporation]
    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
    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
    [DanL Database Consulting]
    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

    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


    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact