Stacking tape datasets

Robert Knight

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

Sam Baugh

Re: Stacking tape datasets
(in response to Robert Knight)
I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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 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

Philip Sevetson

Re: Stacking tape datasets
(in response to Sam Baugh)
Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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 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 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

Philip Sevetson

Re: Stacking tape datasets
(in response to Philip Sevetson)
Try STEP01.SYSCOP01 -- if memory serves, you have to qualify the DDname if you're not referring to a DDname in the same step.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 1:04 PM
To: [login to unmask email]
Subject: [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 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

Lynne Flatley

Re: Stacking tape datasets
(in response to Philip Sevetson)
What about using a template for the image copy?

//SYSTEMPL DD *
TEMPLATE OLREORT
DSN='XXXX.YYYY.&DB..&TS..OLR(+1)'
MODELDCB BC.MODLDSCB
DISP(NEW,CATLG,CATLG)
EXPDL '1999000'
VOLCNT 99
* STACK YES*
GDGLIMIT(3)
UNIT TAPEC

This example is from DB2 V9, by the way...


On Mon, Nov 15, 2010 at 1:37 PM, Sevetson, Phil <[login to unmask email]>wrote:

> Disagree. UNIT=AFF works within multiple steps in the same job.
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
> Sent: Monday, November 15, 2010 1:29 PM
> To: [login to unmask email]
> Subject: Re: [DB2-L] Stacking tape datasets
>
> I think UNIT=AFF is only for within the same step, just use UNIT=CART.
>
> -----Original Message-----
> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
> Sent: Monday, November 15, 2010 12:04 PM
> To: [login to unmask email]
> Subject: [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 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 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 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

Carol Anne Sutfin

Re: Stacking tape datasets
(in response to Lynne Flatley)
UNIT=AFF= .....

is only for the same STEP (from the JCL Guide).

Requests that the system allocate different data sets residing on
different, removable volumes to the same device during execution of
the step. This request is called unit affinity, where "ddname" is
the
ddname of an earlier DD statement in the same step. Use unit affinity
to reduce the number of devices used in a job step; request that an
existing data set be assigned to the same device(s) as another
existing data set.

Use UNIT=CART (same as Step01)

The Referback from the VOL parameter will insure it goes on the same tape
and the RETAIN keeps it mounted.

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



From: Robert Knight <[login to unmask email]>
To: [login to unmask email]
Date: 11/15/2010 12:26 PM
Subject: [DB2-L] Stacking tape datasets
Sent by: IDUG DB2-L <[login to unmask email]>



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 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

Lynne Flatley

Re: Stacking tape datasets
(in response to Carol Anne Sutfin)
and the use of TEMPLATE implies that you're using a LISTDEF...

//SYSLISTD DD *
LISTDEF *REORGL*
INCLUDE TABLESPACES TABLESPACE PXPD00.ITS0007D
INCLUDE TABLESPACES TABLESPACE PXPD00.ITS0013D
INCLUDE TABLESPACES TABLESPACE PXPD00.ITS0020D
INCLUDE TABLESPACES TABLESPACE PXPD00.ITS0066D
INCLUDE TABLESPACES TABLESPACE PXPD00.ITS0071D
INCLUDE TABLESPACES TABLESPACE PXPD00.ITS0077D

//SYSIN DD *
REORG TABLESPACE LIST *REORGL*

On Mon, Nov 15, 2010 at 1:41 PM, Lynne Flatley <[login to unmask email]> wrote:

> What about using a template for the image copy?
>
> //SYSTEMPL DD *
> TEMPLATE OLREORT
> DSN='XXXX.YYYY.&DB..&TS..OLR(+1)'
> MODELDCB BC.MODLDSCB
> DISP(NEW,CATLG,CATLG)
> EXPDL '1999000'
> VOLCNT 99
> * STACK YES*
> GDGLIMIT(3)
> UNIT TAPEC
>
> This example is from DB2 V9, by the way...
>
>
>
> On Mon, Nov 15, 2010 at 1:37 PM, Sevetson, Phil <[login to unmask email]>wrote:
>
>> Disagree. UNIT=AFF works within multiple steps in the same job.
>>
>> -----Original Message-----
>> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
>> Sent: Monday, November 15, 2010 1:29 PM
>> To: [login to unmask email]
>> Subject: Re: [DB2-L] Stacking tape datasets
>>
>> I think UNIT=AFF is only for within the same step, just use UNIT=CART.
>>
>> -----Original Message-----
>> From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
>> Sent: Monday, November 15, 2010 12:04 PM
>> To: [login to unmask email]
>> Subject: [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-Lis 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
>> 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-Lis 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
>> 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-Lis 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
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

Robert Knight

Re: Stacking tape datasets
(in response to Lynne Flatley)
I had the manual up and as I shot this out I spotted it.

Thanks

Bob

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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 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 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

Lockwood Lyon

Re: Stacking tape datasets
(in response to Robert Knight)
Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF
on the DD stmt:

AFF=ddname
Requests that the system allocate different data sets residing
on different, removable volumes
to the same device during execution of the step.

Nothing about prior steps (otherwise I'd expect syntax something like
UNIT=AFF=stepname.procstepname.ddname).

Possible that some of us are confusing the UNIT parameter with the DCB
subparameter syntax:
DCB=*.stepname.procstepname.ddname

Allowing DD stmts to referback to those subparameters in DD statments in
prior steps.

Lock Lyon
Fifth Third Bancorp

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Monday, November 15, 2010 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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

This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

_____________________________________________________________________
* 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

Sam Orner

Re: Stacking tape datasets
(in response to Lockwood Lyon)
You have a secure email message waiting for you from Sam Orner at AES/PHEAA with the subject: Re: [DB2-L] Stacking tape datasets.

How to Retrieve Your Message

To retrieve your message from Sam Orner with the subject: Re: [DB2-L] Stacking tape datasets, go to:
https://securemail.aessuccess.org/messenger/msg?x=d-35350828-iKZN8OBIBhUQFOyb

This message will be available until 01/14/2011.

Why You Are Receiving this Email

AES/PHEAA has sent you a message that may include sensitive information or personal data, as defined by federal law. To protect the privacy of this information, the email has been encrypted.


Personal data protected by federal law includes:
Social Security numbers
Driver's license numbers
credit reports/scores


If you have questions regarding the authenticity of this message, please
visit us online at www.aesSuccess.org/securemail, or contact us:

Phone: 1-800-233-0557
Email: [login to unmask email]
Postal mail: AES/PHEAA
1200 N 7th St
Harrisburg, PA 17102


=====
This message contains privileged and confidential information intended for the
above addressees only. If you receive this message in error please delete or
destroy this message and/or attachments.

The sender of this message will fully cooperate in the civil and criminal
prosecution of any individual engaging in the unauthorized use of this message.
=====

_____________________________________________________________________
* 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

Raymond Bell

Re: Stacking tape datasets
(in response to Sam Orner)
I could be wrong, but I've a vague memory it's done via the VOLume parm - something like VOL=SER=*.ddname i.e. the volume referenced by the previous step's DD.

Like I said, I could be wrong...

Cheers,


Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom

----- Original Message -----
From: Lyon, Lockwood [mailto:[login to unmask email]
Sent: Monday, November 15, 2010 01:00 PM
To: [login to unmask email] <[login to unmask email]>
Subject: Re: [DB2-L] Stacking tape datasets

Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF
on the DD stmt:

AFF=ddname
Requests that the system allocate different data sets residing
on different, removable volumes
to the same device during execution of the step.

Nothing about prior steps (otherwise I'd expect syntax something like
UNIT=AFF=stepname.procstepname.ddname).

Possible that some of us are confusing the UNIT parameter with the DCB
subparameter syntax:
DCB=*.stepname.procstepname.ddname

Allowing DD stmts to referback to those subparameters in DD statments in
prior steps.

Lock Lyon
Fifth Third Bancorp

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Monday, November 15, 2010 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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

This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

_____________________________________________________________________
* 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 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

Philip Sevetson

Re: Stacking tape datasets
(in response to Raymond Bell)
Lock, Sam, you're right. I must have confused a single-step, multistatement COPY from a previous job, with a multi-step COPY.

Sorry, Sam.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lyon, Lockwood
Sent: Monday, November 15, 2010 2:00 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF
on the DD stmt:

AFF=ddname
Requests that the system allocate different data sets residing
on different, removable volumes
to the same device during execution of the step.

Nothing about prior steps (otherwise I'd expect syntax something like
UNIT=AFF=stepname.procstepname.ddname).

Possible that some of us are confusing the UNIT parameter with the DCB
subparameter syntax:
DCB=*.stepname.procstepname.ddname

Allowing DD stmts to referback to those subparameters in DD statments in
prior steps.

Lock Lyon
Fifth Third Bancorp

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Monday, November 15, 2010 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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

This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

_____________________________________________________________________
* 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 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

Sam Baugh

Re: Stacking tape datasets
(in response to Philip Sevetson)
Not a problem, although I was tempted to "redouble".

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson, Phil
Sent: Monday, November 15, 2010 1:26 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Lock, Sam, you're right. I must have confused a single-step, multistatement COPY from a previous job, with a multi-step COPY.

Sorry, Sam.

--Phil Sevetson

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Lyon, Lockwood
Sent: Monday, November 15, 2010 2:00 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF
on the DD stmt:

AFF=ddname
Requests that the system allocate different data sets residing
on different, removable volumes
to the same device during execution of the step.

Nothing about prior steps (otherwise I'd expect syntax something like
UNIT=AFF=stepname.procstepname.ddname).

Possible that some of us are confusing the UNIT parameter with the DCB
subparameter syntax:
DCB=*.stepname.procstepname.ddname

Allowing DD stmts to referback to those subparameters in DD statments in
prior steps.

Lock Lyon
Fifth Third Bancorp

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Monday, November 15, 2010 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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

This e-mail transmission contains information that is confidential and may be privileged. It is intended only for the addressee(s) named above. If you receive this e-mail in error, please do not read, copy or disseminate it in any manner. If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of this information is prohibited. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please erase it from your computer system. Your assistance in correcting this error is appreciated.

_____________________________________________________________________
* 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 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 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

Philip Sevetson

Re: Stacking tape datasets
(in response to Sam Baugh)
DeWard Brown 4th Ed., says "VOL=REF=*.stepname.ddname"

--Phil Sevetson



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Monday, November 15, 2010 2:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets



I could be wrong, but I've a vague memory it's done via the VOLume parm - something like VOL=SER=*.ddname i.e. the volume referenced by the previous step's DD.



Like I said, I could be wrong...



Cheers,





Raymond



________________________________________

Raymond Bell

Senior Software Consultant

BMC Software



Phone: +44 (0) 1784 478 558

Mobile: +44 (0) 7894 608 214

Fax: +44 (0) 1784 478 753



Assurance House

Vicarage Road, Egham

Surrey TW20 9JY, United Kingdom



----- Original Message -----

From: Lyon, Lockwood [mailto:[login to unmask email]

Sent: Monday, November 15, 2010 01:00 PM

To: [login to unmask email] <[login to unmask email]>

Subject: Re: [DB2-L] Stacking tape datasets



Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF

on the DD stmt:



AFF=ddname

Requests that the system allocate different data sets residing

on different, removable volumes

to the same device during execution of the step.



Nothing about prior steps (otherwise I'd expect syntax something like

UNIT=AFF=stepname.procstepname.ddname).



Possible that some of us are confusing the UNIT parameter with the DCB

subparameter syntax:

DCB=*.stepname.procstepname.ddname



Allowing DD stmts to referback to those subparameters in DD statments in

prior steps.



Lock Lyon

Fifth Third Bancorp



_____________________________________________________________________
* 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

Tony Moore

Re: Stacking tape datasets
(in response to Philip Sevetson)
If this helps, here's a couple steps of a daily job I use to copy my
archive logs to another tape (for DR purposes) as an example of stacking
tape datasets...

//* ===================
//* COPY ARCHIVE LOG TAPES TO OFFSITE COPIES
//* ===================
//* -------------------------------------------------------------------
//STEP1 EXEC PGM=IEBGENER,COND=(0,NE)
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY,DCB=BLKSIZE=800
//SYSUT1 DD DSN=DB2P.ARCHLOG1.D10317.T2228095.B0027263,
// DISP=SHR,UNIT=3590,VOL=(,RETAIN,SER=014498)
//SYSUT2 DD DSN=DB2P.BACKLOG1.D10317.T2228095.B0027263,
// DISP=(NEW,KEEP,DELETE),UNIT=CARTE,
// VOL=(,RETAIN,),
// DCB=(LRECL=4093,BLKSIZE=28672,RECFM=VB,TRTCH=NOCOMP),
// LABEL=(1,SL,,,RETPD=07)
//* -------------------------------------------------------------------
//STEP2 EXEC PGM=IEBGENER,COND=(0,NE)
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY,DCB=BLKSIZE=800
//SYSUT1 DD DSN=DB2P.ARCHLOG1.D10317.T2228095.A0027263,
// DISP=SHR,UNIT=3590,VOL=REF=*.STEP1.SYSUT1,
// LABEL=(2,SL)
//SYSUT2 DD DSN=DB2P.BACKLOG1.D10317.T2228095.A0027263,
// DISP=(NEW,KEEP,DELETE),UNIT=CARTE,
// VOL=REF=*.STEP1.SYSUT2,
// DCB=(LRECL=4096,BLKSIZE=28672,RECFM=FB,TRTCH=NOCOMP),
// LABEL=(2,SL,,,RETPD=07)


Tony Moore
DB2 Database Administrator
Mainframe Dinosaur





From: "Bell, Raymond" <[login to unmask email]>
To: [login to unmask email]
Date: 11/15/2010 03:13 PM
Subject: Re: [DB2-L] Stacking tape datasets
Sent by: IDUG DB2-L <[login to unmask email]>



I could be wrong, but I've a vague memory it's done via the VOLume parm -
something like VOL=SER=*.ddname i.e. the volume referenced by the previous
step's DD.

Like I said, I could be wrong...

Cheers,


Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom

----- Original Message -----
From: Lyon, Lockwood [mailto:[login to unmask email]
Sent: Monday, November 15, 2010 01:00 PM
To: [login to unmask email] <[login to unmask email]>
Subject: Re: [DB2-L] Stacking tape datasets

Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF
on the DD stmt:

AFF=ddname
Requests that the system allocate different data sets
residing
on different, removable volumes
to the same device during execution of the step.

Nothing about prior steps (otherwise I'd expect syntax something like
UNIT=AFF=stepname.procstepname.ddname).

Possible that some of us are confusing the UNIT parameter with the DCB
subparameter syntax:
DCB=*.stepname.procstepname.ddname

Allowing DD stmts to referback to those subparameters in DD statments in
prior steps.

Lock Lyon
Fifth Third Bancorp

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Monday, November 15, 2010 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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

This e-mail transmission contains information that is confidential and may
be privileged. It is intended only for the addressee(s) named above. If
you receive this e-mail in error, please do not read, copy or disseminate
it in any manner. If you are not the intended recipient, any disclosure,
copying, distribution or use of the contents of this information is
prohibited. Please reply to the message immediately by informing the
sender that the message was misdirected. After replying, please erase it
from your computer system. Your assistance in correcting this error is
appreciated.

_____________________________________________________________________
* 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 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 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

Raymond Bell

Re: Stacking tape datasets
(in response to Tony Moore)
A-ha, I was close. REF, not SER.

Bit easier with the manual in front of you, eh? :o)

Cheers,


Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom

From: Sevetson, Phil [mailto:[login to unmask email]
Sent: Monday, November 15, 2010 02:20 PM
To: [login to unmask email] <[login to unmask email]>
Subject: Re: [DB2-L] Stacking tape datasets


DeWard Brown 4th Ed., says “VOL=REF=*.stepname.ddname”

--Phil Sevetson



-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Bell, Raymond
Sent: Monday, November 15, 2010 2:19 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets



I could be wrong, but I've a vague memory it's done via the VOLume parm - something like VOL=SER=*.ddname i.e. the volume referenced by the previous step's DD.



Like I said, I could be wrong...



Cheers,





Raymond



________________________________________

Raymond Bell

Senior Software Consultant

BMC Software



Phone: +44 (0) 1784 478 558

Mobile: +44 (0) 7894 608 214

Fax: +44 (0) 1784 478 753



Assurance House

Vicarage Road, Egham

Surrey TW20 9JY, United Kingdom



----- Original Message -----

From: Lyon, Lockwood [mailto:[login to unmask email]

Sent: Monday, November 15, 2010 01:00 PM

To: [login to unmask email] <[login to unmask email]>

Subject: Re: [DB2-L] Stacking tape datasets



Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF

on the DD stmt:



AFF=ddname

Requests that the system allocate different data sets residing

on different, removable volumes

to the same device during execution of the step.



Nothing about prior steps (otherwise I'd expect syntax something like

UNIT=AFF=stepname.procstepname.ddname).



Possible that some of us are confusing the UNIT parameter with the DCB

subparameter syntax:

DCB=*.stepname.procstepname.ddname



Allowing DD stmts to referback to those subparameters in DD statments in

prior steps.



Lock Lyon

Fifth Third Bancorp



________________________________

[ http://www.idug.org/images/stories/IDUG_Corporate/idug_conf_728.gif ] < http://www.idug.org/db2-conferences-list.html >

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. < http://www.idug.org/register >

_____________________________________________________________________
* 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

Tony Moore

Re: Stacking tape datasets
(in response to Raymond Bell)
And just to be thorough, here is a snipet/example of a another job I use
to stack unload datasets to tape. However in this one, the refer backs are
to DD statements in the same step. Note that IN001 is from one tape, but
IN002 and IN003 are from another tape. The input datasets are from several
different tapes, but the output datasets are stacked onto a single tape. I
use the UNIT=AFF for the input files (IN002, IN003, etc.) to force JES to
use the same tape drive for each input dataset. The RETAIN and REF= on the
output DD statements forces the output files to the same output tape (and
tape drive)...

//* -------------------------------------------------------------------
//* DATA UNLOADED BY PRDUNLD1
//* -------------------------------------------------------------------
//STEP01 EXEC PGM=IDCAMS
//SYSPRINT DD SYSOUT=*
//IN001 DD DSN=ACRP1.TS1922P.UNLOAD.CURRME,DISP=SHR
//OT001 DD DSN=ACRP1.TS1922P.UNLOAD.OCT2010,
// DISP=(NEW,CATLG,DELETE),UNIT=3592,
// VOL=(,RETAIN,),
// DCB=(LRECL=136,BLKSIZE=32760,RECFM=VB),
// LABEL=(1,SL,EXPDT=99366)
//* -------------------------------------------------------------------
//* DATA UNLOADED BY PRDUNLD2
//* -------------------------------------------------------------------
//IN002 DD DSN=ACRP1.TS4016P.UNLOAD.CURRME,DISP=SHR,
// VOL=(,RETAIN,),UNIT=AFF=IN001
//OT002 DD DSN=ACRP1.TS4016P.UNLOAD.OCT2010,
// DISP=(NEW,CATLG,DELETE),UNIT=3592,
// VOL=(,RETAIN,,REF=*.STEP01.OT001),
// DCB=(LRECL=139,BLKSIZE=32665,RECFM=FB),
// LABEL=(2,SL,EXPDT=99366)
//IN003 DD DSN=ACRP1.TS4212P.UNLOAD.CURRME,DISP=SHR,
// VOL=(,RETAIN,),UNIT=AFF=IN001
//OT003 DD DSN=ACRP1.TS4212P.UNLOAD.OCT2010,
// DISP=(NEW,CATLG,DELETE),UNIT=3592,
// VOL=(,RETAIN,,REF=*.STEP01.OT002),
// DCB=(LRECL=123,BLKSIZE=32718,RECFM=FB),
// LABEL=(3,SL,EXPDT=99366)
...

Tony Moore
DB2 Database Administrator and Mainframe Dinosaur




From: Tony A Moore/GA/RCUS
To: IDUG DB2-L <[login to unmask email]>
Date: 11/15/2010 03:36 PM
Subject: Re: [DB2-L] Stacking tape datasets


If this helps, here's a couple steps of a daily job I use to copy my
archive logs to another tape (for DR purposes) as an example of stacking
tape datasets...

//* ===================
//* COPY ARCHIVE LOG TAPES TO OFFSITE COPIES
//* ===================
//* -------------------------------------------------------------------
//STEP1 EXEC PGM=IEBGENER,COND=(0,NE)
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY,DCB=BLKSIZE=800
//SYSUT1 DD DSN=DB2P.ARCHLOG1.D10317.T2228095.B0027263,
// DISP=SHR,UNIT=3590,VOL=(,RETAIN,SER=014498)
//SYSUT2 DD DSN=DB2P.BACKLOG1.D10317.T2228095.B0027263,
// DISP=(NEW,KEEP,DELETE),UNIT=CARTE,
// VOL=(,RETAIN,),
// DCB=(LRECL=4093,BLKSIZE=28672,RECFM=VB,TRTCH=NOCOMP),
// LABEL=(1,SL,,,RETPD=07)
//* -------------------------------------------------------------------
//STEP2 EXEC PGM=IEBGENER,COND=(0,NE)
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY,DCB=BLKSIZE=800
//SYSUT1 DD DSN=DB2P.ARCHLOG1.D10317.T2228095.A0027263,
// DISP=SHR,UNIT=3590,VOL=REF=*.STEP1.SYSUT1,
// LABEL=(2,SL)
//SYSUT2 DD DSN=DB2P.BACKLOG1.D10317.T2228095.A0027263,
// DISP=(NEW,KEEP,DELETE),UNIT=CARTE,
// VOL=REF=*.STEP1.SYSUT2,
// DCB=(LRECL=4096,BLKSIZE=28672,RECFM=FB,TRTCH=NOCOMP),
// LABEL=(2,SL,,,RETPD=07)


Tony Moore
DB2 Database Administrator
Mainframe Dinosaur






From: "Bell, Raymond" <[login to unmask email]>
To: [login to unmask email]
Date: 11/15/2010 03:13 PM
Subject: Re: [DB2-L] Stacking tape datasets
Sent by: IDUG DB2-L <[login to unmask email]>



I could be wrong, but I've a vague memory it's done via the VOLume parm -
something like VOL=SER=*.ddname i.e. the volume referenced by the previous
step's DD.

Like I said, I could be wrong...

Cheers,


Raymond

________________________________________
Raymond Bell
Senior Software Consultant
BMC Software

Phone: +44 (0) 1784 478 558
Mobile: +44 (0) 7894 608 214
Fax: +44 (0) 1784 478 753

Assurance House
Vicarage Road, Egham
Surrey TW20 9JY, United Kingdom

----- Original Message -----
From: Lyon, Lockwood [mailto:[login to unmask email]
Sent: Monday, November 15, 2010 01:00 PM
To: [login to unmask email] <[login to unmask email]>
Subject: Re: [DB2-L] Stacking tape datasets

Hmmm. Interestingly, MVS JCL manual for z 1.10 says this for UNIT=AFF
on the DD stmt:

AFF=ddname
Requests that the system allocate different data sets
residing
on different, removable volumes
to the same device during execution of the step.

Nothing about prior steps (otherwise I'd expect syntax something like
UNIT=AFF=stepname.procstepname.ddname).

Possible that some of us are confusing the UNIT parameter with the DCB
subparameter syntax:
DCB=*.stepname.procstepname.ddname

Allowing DD stmts to referback to those subparameters in DD statments in
prior steps.

Lock Lyon
Fifth Third Bancorp

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sevetson,
Phil
Sent: Monday, November 15, 2010 1:37 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

Disagree. UNIT=AFF works within multiple steps in the same job.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Sam Baugh
Sent: Monday, November 15, 2010 1:29 PM
To: [login to unmask email]
Subject: Re: [DB2-L] Stacking tape datasets

I think UNIT=AFF is only for within the same step, just use UNIT=CART.

-----Original Message-----
From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Robert Knight
Sent: Monday, November 15, 2010 12:04 PM
To: [login to unmask email]
Subject: [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

This e-mail transmission contains information that is confidential and may
be privileged. It is intended only for the addressee(s) named above. If
you receive this e-mail in error, please do not read, copy or disseminate
it in any manner. If you are not the intended recipient, any disclosure,
copying, distribution or use of the contents of this information is
prohibited. Please reply to the message immediately by informing the
sender that the message was misdirected. After replying, please erase it
from your computer system. Your assistance in correcting this error is
appreciated.

_____________________________________________________________________
* 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 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 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

Ted MacNEIL

Re: Stacking tape datasets
(in response to Tony Moore)
>I think UNIT=AFF is only for within the same step, just use UNIT=CART.


Not so.
According to the z/OS MVS JCL User's Guide (SA22-7598-06 -- z/OS V1R12 -- and
it was true in earlier releases), pn page 162 (logical -- 184 physical), under
samples:

VOLUME=REF=*.stepname.procstepname.ddname

is valid.

Ted MacNEIL
[login to unmask email]


_____________________________________________________________________
* 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