DB2 Template for Tape GDG

allan smith

DB2 Template for Tape GDG
We have a job that has been creating tape full image copy GDG's. The
GDG is defined with a limit of 30. Since using the template, the GDG
have been expiring after 5 days (system default), instead of rolling off
after the 30th generation. Does anyone have a sample Template so that
the GDG will roll off after 30 generations? We have tried the EXPDL
'9999000' and got a dynamic allocation error. We have no problem with
GDG's on DASD. Any ideas will be appreciated.

Thanks


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Susan A Allen

Re: DB2 Template for Tape GDG
(in response to allan smith)
the tape retention is for 5 days; increase it to 31 Or 30 or some number
closer to the frequency of generations to days -- if you create 6
generations per week; then you require
30/6 = 5 weeks leading to 5*7 = 35 days

Susan

I love comparing generations to retention periods; messes folks up all
of the time

________________________________

From: Smith, Allan [mailto:[login to unmask email]
Sent: Thursday, January 05, 2006 1:57 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 Template for Tape GDG



We have a job that has been creating tape full image copy GDG's. The
GDG is defined with a limit of 30. Since using the template, the GDG
have been expiring after 5 days (system default), instead of rolling off
after the 30th generation. Does anyone have a sample Template so that
the GDG will roll off after 30 generations? We have tried the EXPDL
'9999000' and got a dynamic allocation error. We have no problem with
GDG's on DASD. Any ideas will be appreciated.

Thanks

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Marcia Crisp

Re: DB2 Template for Tape GDG
(in response to Susan A Allen)
Allan,



Do you have GDGLIMIT(30) specified in your TEMPLATE?

Here is a sample of what I use. It works for me here!



TEMPLATE ICDAILY

UNIT TAPE

DSN 'XXX.YY.&DB..&TS..D&PA(2)..DB2(+1)'

DISP (NEW,CATLG,CATLG)

STACK YES

MODELDCB SYST.MODEL.DSCB

GDGLIMIT(30)



Regards,

Marcia Crisp



_____

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Smith, Allan
Sent: Thursday, January 05, 2006 3:57 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 Template for Tape GDG



We have a job that has been creating tape full image copy GDG's. The GDG is
defined with a limit of 30. Since using the template, the GDG have been
expiring after 5 days (system default), instead of rolling off after the
30th generation. Does anyone have a sample Template so that the GDG will
roll off after 30 generations? We have tried the EXPDL '9999000' and got a
dynamic allocation error. We have no problem with GDG's on DASD. Any ideas
will be appreciated.

Thanks

----------------------------------------------------------------------------
----- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Cristian Molaro

Re: DB2 Template for Tape GDG
(in response to Marcia Crisp)
Hi Allan,

We have an automatic process that generates SYSIN for Full or Incremental
copies based on RTS. Here you have an extract showing our Template where
copies are going to tape.
We don't use a GDG, but we control the retention period with the RETPD
parameter...

"RETPD integer Specifies the retention period in days for the data set. The
# integer value must be between 0 to 9999"

--LIST DEFINITION FOR INCREMENTAL COPY/IES
LISTDEF ICPYLIST
INCLUDE TABLESPACE DBNAM1.TSNAME01 PARTLEVEL 1
INCLUDE TABLESPACE DBNAMX.TSNAME02 PARTLEVEL 5
......

TEMPLATE ICOPYL DSN(&SSID..&DB..&TS..P&PA..D&JD..T&HO.&MI.A)
UNIT TAP1 STACK YES DISP (NEW,CATLG,CATLG) RETPD 25

TEMPLATE ICOPYR DSN(&SSID..&DB..&TS..P&PA..D&JD..T&HO.&MI.B)
UNIT TAP2 STACK YES DISP (NEW,CATLG,CATLG) RETPD 15

COPY LIST ICPYLIST FULL NO
PARALLEL SHRLEVEL CHANGE
COPYDDN(ICOPYL) RECOVERYDDN(ICOPYR)

Hope it helps!

Best regards and happy 2006,

Cristian Molaro
MConsulting.be
Belgium

On Thu, 5 Jan 2006 16:57:18 -0500, Smith, Allan <[login to unmask email]> wrote:

>We have a job that has been creating tape full image copy GDG's. The
>GDG is defined with a limit of 30. Since using the template, the GDG
>have been expiring after 5 days (system default), instead of rolling off
>after the 30th generation. Does anyone have a sample Template so that
>the GDG will roll off after 30 generations? We have tried the EXPDL
>'9999000' and got a dynamic allocation error. We have no problem with
>GDG's on DASD. Any ideas will be appreciated.
>
>Thanks
>
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

[login to unmask email]

Re: DB2 Template for Tape GDG
(in response to Cristian Molaro)
Allan

There are some parameters, inside or outside of DB2, can impact your
retain period, including your GDG base definition, DB2 TEMPLATE
RETPD/EXPDL, GDGLIMIT, and your tape management software config, ...
The first arrival one takes effect, so you may check all.

HTH

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Larry Jardine

Re: DB2 Template for Tape GDG
(in response to hhuang@DCCSH.ICBC.COM.CN)
Try...

EXPDL '1999000'
GDGLIMIT(30)

Larry Jardine
Production DBA


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Smith, Allan
Sent: Thursday, January 05, 2006 4:57 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 Template for Tape GDG



We have a job that has been creating tape full image copy GDG's. The
GDG is defined with a limit of 30. Since using the template, the GDG
have been expiring after 5 days (system default), instead of rolling off
after the 30th generation. Does anyone have a sample Template so that
the GDG will roll off after 30 generations? We have tried the EXPDL
'9999000' and got a dynamic allocation error. We have no problem with
GDG's on DASD. Any ideas will be appreciated.

Thanks

------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm



-----------------------------------------
This e-mail may contain confidential or privileged information. If you
think you have received this e-mail in error, please advise the sender
by
reply e-mail and then delete this e-mail immediately. Thank you.
Aetna


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

allan smith

Re: DB2 Template for Tape GDG
(in response to Larry Jardine)
We just tried that on our test system; it appears to be working.

Thanks


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Jardine, Lawrence J
Sent: Friday, January 06, 2006 9:05 AM
To: [login to unmask email]
Subject: Re: [DB2-L] DB2 Template for Tape GDG


Try...

EXPDL '1999000'
GDGLIMIT(30)

Larry Jardine
Production DBA


________________________________

From: DB2 Data Base Discussion List [mailto:[login to unmask email]
On Behalf Of Smith, Allan
Sent: Thursday, January 05, 2006 4:57 PM
To: [login to unmask email]
Subject: [DB2-L] DB2 Template for Tape GDG



We have a job that has been creating tape full image copy GDG's.
The GDG is defined with a limit of 30. Since using the template, the
GDG have been expiring after 5 days (system default), instead of rolling
off after the 30th generation. Does anyone have a sample Template so
that the GDG will roll off after 30 generations? We have tried the
EXPDL '9999000' and got a dynamic allocation error. We have no problem
with GDG's on DASD. Any ideas will be appreciated.

Thanks


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


________________________________




This e-mail may contain confidential or privileged information.
If you
think you have received this e-mail in error, please advise the
sender
by
reply e-mail and then delete this e-mail immediately. Thank you.
Aetna


------------------------------------------------------------------------
--------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the
archives and home page at http://www.idugdb2-l.org/archives/db2-l.html.
From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm