modify recovery

Koen Vannisselroy

modify recovery
Hello,

At ourt system I introduced taking partlevel full image copies. For cleaning up old imagecopies I use de retain parameter to save the last 21 copies. Even when I use the dsnum all parameter DB2 ignores die partlevel imagecopies and is not cleaning up any partlevel copies. In the manual is statet that you have to specify the dsnum specifically. My table has 480 partitions, this means I have to create 480 statements. Has anyone experience with this en give me a solution for this problem?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Steen Rasmussen

Re: modify recovery
(in response to Koen Vannisselroy)
Hello Koen,
I believe you must be at DB2 V8 ?
In that case you can use LISTDEF instead of coding every statement.
If memory serves me well, DB2 9 changed this behavior and the recommendation is to use DSNUM ALL if you have image copies at both the partition level and tablespace level.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Koen Vannisselroy
Sent: Friday, January 07, 2011 12:37 AM
To: [login to unmask email]
Subject: [DB2-L] modify recovery

Hello,

At ourt system I introduced taking partlevel full image copies. For cleaning up old imagecopies I use de retain parameter to save the last 21 copies. Even when I use the dsnum all parameter DB2 ignores die partlevel imagecopies and is not cleaning up any partlevel copies. In the manual is statet that you have to specify the dsnum specifically. My table has 480 partitions, this means I have to create 480 statements. Has anyone experience with this en give me a solution for this problem?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

[login to unmask email]

Re: modify recovery
(in response to Steen Rasmussen)
Koen,

I bet it must be DB2 9, for the RETAIN keyword.

It sounds strange for this simple MODIFY utility. I would like to
ask for your COPY and related MODIFY RECOVERY control statements.





"Rasmussen, Steen" <[login to unmask email]>
·¢¼þÈË: IDUG DB2-L <[login to unmask email]>
2011-01-07 22:09
Çë´ð¸´ ¸ø
IDUG DB2-L <[login to unmask email]>


ÊÕ¼þÈË
[login to unmask email]
³­ËÍ

Ö÷Ìâ
Re: [DB2-L] modify recovery






Hello Koen,
I believe you must be at DB2 V8 ?
In that case you can use LISTDEF instead of coding every statement.
If memory serves me well, DB2 9 changed this behavior and the
recommendation is to use DSNUM ALL if you have image copies at both the
partition level and tablespace level.

Steen Rasmussen
CA Technologies
Sr Engineering Services Architect
IBM Certified Database Associate - DB2 9 Fundamentals
IBM Certified database Administrator - DB2 9 DBA for z/OS



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Koen
Vannisselroy
Sent: Friday, January 07, 2011 12:37 AM
To: [login to unmask email]
Subject: [DB2-L] modify recovery

Hello,

At ourt system I introduced taking partlevel full image copies. For
cleaning up old imagecopies I use de retain parameter to save the last 21
copies. Even when I use the dsnum all parameter DB2 ignores die partlevel
imagecopies and is not cleaning up any partlevel copies. In the manual is
statet that you have to specify the dsnum specifically. My table has 480
partitions, this means I have to create 480 statements. Has anyone
experience with this en give me a solution for this problem?

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 *
http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it!
*
** The best DB2 technical sessions in the world
** Independent, not-for-profit, User Run - the IDUG difference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is
the home of IDUG's Listserv



_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
_____________________________________________________________________
http://www.IDUG.org/mentor
Mentoring should be a rewarding experience for everyone...
IDUG is offering up to 80% off when you both come to the conference!
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv

Koen Vannisselroy

Re: modify recovery
(in response to hhuang@DCCSH.ICBC.COM.CN)
Hello,

Indeed we are on db2 9.
This is the statement:
TEMPLATE OCPKOP01
DSN 'IOCP.&DB..&TS..P&PA(2,4)..DB2&SS(4,1).IF.&UQ.'
EXPDL('1999000')
UNIT=VTSSALL VOLCNT 255 STACK YES

LISTDEF OCPFIC01 INCLUDE TABLESPACE OCPDB13.OCPTSHT PARTLEVEL

COPY LIST OCPFIC01
COPYDDN (OCPKOP01)
PARALLEL 5 TAPEUNITS 5
SHRLEVEL CHANGE

MODIFY RECOVERY LIST OCPFIC01
RETAIN LAST 1

It seems i forgot to use the parameter DSNUM ALL, but i still have tot do some testing

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* If you are going to attend only one conference this year, this is it! *
** The most DB2 technical sessions of any conference
** Access IBM experts and developers
_____________________________________________________________________

If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv