SV: Stacking tape datasets

Olle Brostrom

SV: Stacking tape datasets
Bob and others who use tape,
You should be aware of that the outage in the switch phase when the reorg drains the tablespace will be elongated due to the use of tape devices (or VTS). The reason is that the drain will not be released until the Image Copy datasets is secured and this will happen after the deallocation of the Image copy. My experience is that this will delay the unavailability for claimers with 10 - 30 seconds!
In our shop we now take all inline Image copies in reorgs to dasd and we have dramatically reduced the number of timeouts in applications during online reorg.
Does anyone have other experiences?

Olle

-----Ursprungligt meddelande-----
Från: IDUG DB2-L [mailto:[login to unmask email] För Robert Knight
Skickat: den 15 november 2010 19:04
Till: [login to unmask email]
Ämne: [DB2-L] Stacking tape datasets

I am coding a online reorg procedure for a partition table space.

Just setting up the code in a test environment Anyway I am receiving the following error and it has me stumped.

29 IEF645I INVALID REFERBACK IN THE AFF SUBPARAMETER OF THE UNIT FIELD


//STEP01 EXEC DSNUPROC,COND=(4,LT),
// SYSTEM=D2T2,
// UID='UMCT153.STEP01',UTPROC=''

//SYSCOP01 DD UNIT=CART,
// DISP=(NEW,KEEP),
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART1,
// LABEL=(1,SL,RETPD=1),
// BLKSIZE=0,
// VOL=(,RETAIN,,2)

//STEP02 EXEC DSNUPROC,COND=(4,LT),
// SYSTEM=D2T2,
// UID='UMCT153.STEP02',UTPROC=''

//SYSCOP02 DD UNIT=AFF=SYSCOP01,
// DISP=(NEW,KEEP),
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART2,
// LABEL=(2,SL,RETPD=1),
// BLKSIZE=0,
// VOL=(PRIVATE,RETAIN,,2,REF=*.STEP01.DSNUPROC.SYSCOP01)

Can't find the error, any ideas

Thanks

Bob Knight

_____________________________________________________________________
* 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
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
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

Robert Knight

Re: Stacking tape datasets
(in response to Olle Brostrom)
I want to thank all for your input, the final verdict was to use unit=cart on the second step.

Thanks for the tip Olle on the timing on the switch.

This is what happens when you become dependent on 3rd party products you forget how to do some basic things.

Thanks all for your responses.

Bob Knight


-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Olle Brostrom
Sent: Tuesday, November 16, 2010 2:04 AM
To: [login to unmask email]
Subject: [DB2-L] SV: Stacking tape datasets

Bob and others who use tape,
You should be aware of that the outage in the switch phase when the reorg drains the tablespace will be elongated due to the use of tape devices (or VTS). The reason is that the drain will not be released until the Image Copy datasets is secured and this will happen after the deallocation of the Image copy. My experience is that this will delay the unavailability for claimers with 10 - 30 seconds!
In our shop we now take all inline Image copies in reorgs to dasd and we have dramatically reduced the number of timeouts in applications during online reorg.
Does anyone have other experiences?

Olle

-----Ursprungligt meddelande-----
Från: IDUG DB2-L [mailto:[login to unmask email] För Robert Knight
Skickat: den 15 november 2010 19:04
Till: [login to unmask email]
Ämne: [DB2-L] Stacking tape datasets

I am coding a online reorg procedure for a partition table space.

Just setting up the code in a test environment Anyway I am receiving the following error and it has me stumped.

29 IEF645I INVALID REFERBACK IN THE AFF SUBPARAMETER OF THE UNIT FIELD


//STEP01 EXEC DSNUPROC,COND=(4,LT),
// SYSTEM=D2T2,
// UID='UMCT153.STEP01',UTPROC=''

//SYSCOP01 DD UNIT=CART,
// DISP=(NEW,KEEP),
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART1,
// LABEL=(1,SL,RETPD=1),
// BLKSIZE=0,
// VOL=(,RETAIN,,2)

//STEP02 EXEC DSNUPROC,COND=(4,LT),
// SYSTEM=D2T2,
// UID='UMCT153.STEP02',UTPROC=''

//SYSCOP02 DD UNIT=AFF=SYSCOP01,
// DISP=(NEW,KEEP),
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART2,
// LABEL=(2,SL,RETPD=1),
// BLKSIZE=0,
// VOL=(PRIVATE,RETAIN,,2,REF=*.STEP01.DSNUPROC.SYSCOP01)

Can't find the error, any ideas

Thanks

Bob Knight

_____________________________________________________________________
* 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
How can you expand your staff or do succession planning in this economy?
Mentoring is a proven, economical, way to train the next generation of DB2 Users!
_____________________________________________________________________

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

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
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

_____________________________________________________________________
* IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
* If you are going to attend only one conference this year, this is it! *
_____________________________________________________________________
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

James Campbell

Re: Stacking tape datasets
(in response to Robert Knight)
I think the official way of doing what you wanted is
//STEP01 EXEC ...
//SYSCOP01 DD UNIT=CART,
// DISP=(NEW,KEEP),
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART1,
// LABEL=(1,SL,RETPD=1),
// BLKSIZE=0,
// VOL=(,RETAIN,,2)
//STEP02 EXEC ...
//SYSCOP01 DD DISP=OLD, << this releases RETAIN
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART1
//SYSCOP02 DD UNIT=AFF=SYSCOP01,
// DISP=(NEW,KEEP),
// DSN=UMCT153.DSN8D71A.DSN8S71E.PART2,
// LABEL=(2,SL,RETPD=1),
// BLKSIZE=0,
// VOL=(PRIVATE,RETAIN,,2,REF=*.SYSCOP01) << REF is to DD in the same step

James Campbell


On 16 Nov 2010 at 8:29, Robert Knight wrote:

> I want to thank all for your input, the final verdict was to use unit=cart on the second step.
>
> Thanks for the tip Olle on the timing on the switch.
>
> This is what happens when you become dependent on 3rd party products you forget how to do some basic things.
>
> Thanks all for your responses.
>
> Bob Knight
>
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Olle Brostrom
> Sent: Tuesday, November 16, 2010 2:04 AM
> To: [login to unmask email]
> Subject: [DB2-L] SV: Stacking tape datasets
>
> Bob and others who use tape,
> You should be aware of that the outage in the switch phase when the reorg drains the tablespace will be elongated due to the use of tape devices (or VTS). The reason is that the drain will not be released until the Image Copy datasets is secured and this will happen after the deallocation of the Image copy. My experience is that this will delay the unavailability for claimers with 10 - 30 seconds!
> In our shop we now take all inline Image copies in reorgs to dasd and we have dramatically reduced the number of timeouts in applications during online reorg.
> Does anyone have other experiences?
>
> Olle
>
> -----Ursprungligt meddelande-----
> Från: IDUG DB2-L [mailto:[login to unmask email] För Robert Knight
> Skickat: den 15 november 2010 19:04
> Till: [login to unmask email]
> Ämne: [DB2-L] Stacking tape datasets
>
> I am coding a online reorg procedure for a partition table space.
>
> Just setting up the code in a test environment Anyway I am receiving the following error and it has me stumped.
>
> 29 IEF645I INVALID REFERBACK IN THE AFF SUBPARAMETER OF THE UNIT FIELD
>
>
> //STEP01 EXEC DSNUPROC,COND=(4,LT),
> // SYSTEM=D2T2,
> // UID='UMCT153.STEP01',UTPROC=''
>
> //SYSCOP01 DD UNIT=CART,
> // DISP=(NEW,KEEP),
> // DSN=UMCT153.DSN8D71A.DSN8S71E.PART1,
> // LABEL=(1,SL,RETPD=1),
> // BLKSIZE=0,
> // VOL=(,RETAIN,,2)
>
> //STEP02 EXEC DSNUPROC,COND=(4,LT),
> // SYSTEM=D2T2,
> // UID='UMCT153.STEP02',UTPROC=''
>
> //SYSCOP02 DD UNIT=AFF=SYSCOP01,
> // DISP=(NEW,KEEP),
> // DSN=UMCT153.DSN8D71A.DSN8S71E.PART2,
> // LABEL=(2,SL,RETPD=1),
> // BLKSIZE=0,
> // VOL=(PRIVATE,RETAIN,,2,REF=*.STEP01.DSNUPROC.SYSCOP01)
>
> Can't find the error, any ideas
>
> Thanks
>
> Bob Knight
>
> _____________________________________________________________________
> * 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
> How can you expand your staff or do succession planning in this economy?
> Mentoring is a proven, economical, way to train the next generation of DB2 Users!
> _____________________________________________________________________
>
> If you need to change settings, http://www.idug.org/cgi-bin/wa?A0=DB2-L is the home of IDUG's Listserv
>
> _____________________________________________________________________
> * IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
> * If you are going to attend only one conference this year, this is it! *
> _____________________________________________________________________
> 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
>
> _____________________________________________________________________
> * IDUG EMEA * Prague, Czech Republic * 14-18 November 2011 * http://IDUG.ORG/EMEA *
> * If you are going to attend only one conference this year, this is it! *
> _____________________________________________________________________
> 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
>

_____________________________________________________________________
* IDUG North America * Anaheim, California * May 2-6 2011 * http://IDUG.ORG/NA *
* Your only source for independent, unbiased, and trusted DB2 information. *
** 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