Abend E37-08

Horacio Villa

Abend E37-08
Hi,

this may be pretty easy, but I can't find the answer.
I'm running an online REORG INDEX with SYSIN like this:

TEMPLATE SUX1 UNIT(SYSDA)
MAXPRIME(4369) DATACLAS(MULTI) VOLCNT(10)
DISP(NEW,DELETE,DELETE) DSN(BKDSPG.&DB..&SN..SUX1)

REORG INDEX LIST LISTATS
SHRLEVEL CHANGE MAXRO 10
STATISTICS KEYCARD UPDATE ALL
SORTDEVT DBATMP SORTNUM 8
WORKDDN (SUX1)

Then I get the abend:

IEC614I EXTEND FAILED - RC 216, DIAGNOSTIC INFORMATION IS (044E0097)
|----------+--------+-----------+----------+----------------------------------|
| X'04' | X'4E' | X'00' | X'97' | Requested space exceeds 65535 |
| | | | | tracks for a data set type that |
| | | | | is limited to 65535 tracks per |
| | | | | volume. Striped (extended |
| | | | | format), PDSE, VSAM, and HFS |
| | | | | data sets can exceed 65535 |
| | | | | tracks. |
|----------+--------+-----------+----------+----------------------------------|



Is it trying to extend to the same volume, in which it already has 65535
tracks allocated ( in the primary extent), or is it trying to allocate more
than 65535 tracks on another volume?
Is it possible to make it work?

TIA

Horacio Villa



Rama [IBM GSA] Naidoo

Re: Abend E37-08
(in response to Horacio Villa)


Isaac Yassin

Re: Abend E37-08
(in response to Rama [IBM GSA] Naidoo)
Hi,
Are you using type 3 disks (e.g. 3390-3)?
If YES - then you can allocate only 3339*15 = 50085 trks on each.
Either change primary allocation, or use 3390-9 disks.


Isaac Yassin


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Saturday, October 04, 2003 9:34 PM
To: [login to unmask email]
Subject: Abend E37-08

Hi,

this may be pretty easy, but I can't find the answer.
I'm running an online REORG INDEX with SYSIN like this:

TEMPLATE SUX1 UNIT(SYSDA)
MAXPRIME(4369) DATACLAS(MULTI) VOLCNT(10)
DISP(NEW,DELETE,DELETE) DSN(BKDSPG.&DB..&SN..SUX1)

REORG INDEX LIST LISTATS
SHRLEVEL CHANGE MAXRO 10
STATISTICS KEYCARD UPDATE ALL
SORTDEVT DBATMP SORTNUM 8
WORKDDN (SUX1)

Then I get the abend:

IEC614I EXTEND FAILED - RC 216, DIAGNOSTIC INFORMATION IS (044E0097)
|----------+--------+-----------+----------+----------------------------------|
| X'04' | X'4E' | X'00' | X'97' | Requested space exceeds 65535 |
| | | | | tracks for a data set type that |
| | | | | is limited to 65535 tracks per |
| | | | | volume. Striped (extended |
| | | | | format), PDSE, VSAM, and HFS |
| | | | | data sets can exceed 65535 |
| | | | | tracks. |
|----------+--------+-----------+----------+----------------------------------|



Is it trying to extend to the same volume, in which it already has 65535
tracks allocated ( in the primary extent), or is it trying to allocate more
than 65535 tracks on another volume?
Is it possible to make it work?

TIA

Horacio Villa








Horacio Villa

Re: Abend E37-08
(in response to Isaac Yassin)
Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



Isaac Yassin
<[login to unmask email] To: [login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


10/16/03 04:13 PM
Please respond to
DB2 Data Base
Discussion List






Hi,
Are you using type 3 disks (e.g. 3390-3)?
If YES - then you can allocate only 3339*15 = 50085 trks on each.
Either change primary allocation, or use 3390-9 disks.


Isaac Yassin


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Saturday, October 04, 2003 9:34 PM
To: [login to unmask email]
Subject: Abend E37-08

Hi,

this may be pretty easy, but I can't find the answer.
I'm running an online REORG INDEX with SYSIN like this:

TEMPLATE SUX1 UNIT(SYSDA)
MAXPRIME(4369) DATACLAS(MULTI) VOLCNT(10)
DISP(NEW,DELETE,DELETE) DSN(BKDSPG.&DB..&SN..SUX1)

REORG INDEX LIST LISTATS
SHRLEVEL CHANGE MAXRO 10
STATISTICS KEYCARD UPDATE ALL
SORTDEVT DBATMP SORTNUM 8
WORKDDN (SUX1)

Then I get the abend:

IEC614I EXTEND FAILED - RC 216, DIAGNOSTIC INFORMATION IS (044E0097)
|----------+--------+-----------+----------+----------------------------------|

| X'04' | X'4E' | X'00' | X'97' | Requested space exceeds 65535
|
| | | | | tracks for a data set type
that |
| | | | | is limited to 65535 tracks
per |
| | | | | volume. Striped (extended
|
| | | | | format), PDSE, VSAM, and HFS
|
| | | | | data sets can exceed 65535
|
| | | | | tracks.
|
|----------+--------+-----------+----------+----------------------------------|




Is it trying to extend to the same volume, in which it already has 65535
tracks allocated ( in the primary extent), or is it trying to allocate more
than 65535 tracks on another volume?
Is it possible to make it work?

TIA

Horacio Villa



the





the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



Isaac Yassin

Re: Abend E37-08
(in response to Horacio Villa)
Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



Horacio Villa

Re: Abend E37-08
(in response to Isaac Yassin)
Hi Isaac,

may be I inverted the numbers. I'm really using MAXPRIME(4369), which is
65535 tracks.
My goal is (was?) to have just one TEMPLATE usefull for all tablespaces
(which, of course, may be impossible).

Horacio Villa




Isaac Yassin
<[login to unmask email] To: [login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


10/17/03 04:59 AM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



Burgess Evans

Re: Abend E37-08
(in response to Horacio Villa)
Hi Horacio,

Your error code looks like the same error I received when trying to allocate large amounts of DASD for a DFSORT job. I eventually found that I was trying to allocate more space than z/OS would allow. It appeared to be a system ceiling.

I solved my problem by lowering my primary and secondary allocation to a lower level and I changed my JCL UNIT parameter to include a unit-count; like this //ddname DD UNIT=(SYSDA,3). SYSDA in our shop is the device name for our DASD. You can read more about unit count in the z/OS MVS JCL User's Guide section 4.4.1.2.

I found something that might be similar in the TEMPLATE syntax diagram. You might try the UNCNT integer TEMPLATE option. This is listed as a tape option but might work with DASD. You might also want to check NBRSECND integer. I found these options in the DB2 Universal Database for OS/390 and z/OS Utility Guide and Reference for Version 7. Section 2.26.1.2 Option descriptions.

I hope this helps,




Burgess Evans
Database Administrator
Information Technology Division
Auditor of State of Ohio
Phone: 614-466-7906
>>> [login to unmask email] 10/17/03 18:36 PM >>>
Hi Isaac,

may be I inverted the numbers. I'm really using MAXPRIME(4369), which is
65535 tracks.
My goal is (was?) to have just one TEMPLATE usefull for all tablespaces
(which, of course, may be impossible).

Horacio Villa




Isaac Yassin
<[login to unmask email] To: [login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]<~!B*+R^&> LASSOC.COM>


10/17/03 04:59 AM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can






Isaac Yassin

Re: Abend E37-08
(in response to Burgess Evans)
Hi Horacio,

I suggest to use the SPACE(pri,sec) parameter of template instead of the
MAXPRIME.

Isaac Yassin


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Saturday, October 18, 2003 12:26 AM
To: [login to unmask email]
Subject: Re: Abend E37-08

Hi Isaac,

may be I inverted the numbers. I'm really using MAXPRIME(4369), which is
65535 tracks.
My goal is (was?) to have just one TEMPLATE usefull for all tablespaces
(which, of course, may be impossible).

Horacio Villa




Isaac Yassin
<[login to unmask email] To:
[login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]
LASSOC.COM>


10/17/03 04:59 AM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can








Horacio Villa

Re: Abend E37-08
(in response to Isaac Yassin)
Hi Burgess & Isaac,

Thanks for your input.
I want to understand fully how this works, before going to SPACE(primary,
secondary), which works OK, but needs to be adjusted for each tablespace
(yeah, not really each one).
I've tried UNCNT & NBRSECND with no success. Also tried PCTPRIME 50.
I'm testing with a tablespace not compressed which has 1205756 nactive
pages.
Whatever I try I get this allocation:
1st extent cylinders: 4369
Secondary cylinders : 5268
The secondary allocation is the problem. When it fills the primary it tries
to allocate a secondary which is impossible.
Is this a "not working as designed" problem or "not working as I should"?

Thanks in advance,

Horacio Villa



Burgess Evans
<[login to unmask email] To: [login to unmask email]
TATE.OH.US> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]
ASSOC.COM>


10/17/03 11:07 PM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

Your error code looks like the same error I received when trying to
allocate large amounts of DASD for a DFSORT job. I eventually found that I
was trying to allocate more space than z/OS would allow. It appeared to be
a system ceiling.

I solved my problem by lowering my primary and secondary allocation to a
lower level and I changed my JCL UNIT parameter to include a unit-count;
like this //ddname DD UNIT=(SYSDA,3). SYSDA in our shop is the device name
for our DASD. You can read more about unit count in the z/OS MVS JCL User's
Guide section 4.4.1.2.

I found something that might be similar in the TEMPLATE syntax diagram. You
might try the UNCNT integer TEMPLATE option. This is listed as a tape
option but might work with DASD. You might also want to check NBRSECND
integer. I found these options in the DB2 Universal Database for OS/390 and
z/OS Utility Guide and Reference for Version 7. Section 2.26.1.2 Option
descriptions.

I hope this helps,




Burgess Evans
Database Administrator
Information Technology Division
Auditor of State of Ohio
Phone: 614-466-7906
>>> [login to unmask email] 10/17/03 18:36 PM >>>
Hi Isaac,

may be I inverted the numbers. I'm really using MAXPRIME(4369), which is
65535 tracks.
My goal is (was?) to have just one TEMPLATE usefull for all tablespaces
(which, of course, may be impossible).

Horacio Villa




Isaac Yassin
<[login to unmask email] To:
[login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]<~!B*+R^&>
LASSOC.COM>


10/17/03 04:59 AM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



Horacio Villa

Re: Abend E37-08
(in response to Horacio Villa)
Forgot to tell that the allocated file goes to a 10 3390-9 volumes SMS
pool and is multi-volume.
May be this is SMS-related.

Horacio Villa



Hi Burgess & Isaac,

Thanks for your input.
I want to understand fully how this works, before going to SPACE(primary,
secondary), which works OK, but needs to be adjusted for each tablespace
(yeah, not really each one).
I've tried UNCNT & NBRSECND with no success. Also tried PCTPRIME 50.
I'm testing with a tablespace not compressed which has 1205756 nactive
pages.
Whatever I try I get this allocation:
1st extent cylinders: 4369
Secondary cylinders : 5268
The secondary allocation is the problem. When it fills the primary it tries
to allocate a secondary which is impossible.
Is this a "not working as designed" problem or "not working as I should"?

Thanks in advance,

Horacio Villa



Burgess Evans
<[login to unmask email] To: [login to unmask email]
TATE.OH.US> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]
ASSOC.COM>


10/17/03 11:07 PM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

Your error code looks like the same error I received when trying to
allocate large amounts of DASD for a DFSORT job. I eventually found that I
was trying to allocate more space than z/OS would allow. It appeared to be
a system ceiling.

I solved my problem by lowering my primary and secondary allocation to a
lower level and I changed my JCL UNIT parameter to include a unit-count;
like this //ddname DD UNIT=(SYSDA,3). SYSDA in our shop is the device name
for our DASD. You can read more about unit count in the z/OS MVS JCL User's
Guide section 4.4.1.2.

I found something that might be similar in the TEMPLATE syntax diagram. You
might try the UNCNT integer TEMPLATE option. This is listed as a tape
option but might work with DASD. You might also want to check NBRSECND
integer. I found these options in the DB2 Universal Database for OS/390 and
z/OS Utility Guide and Reference for Version 7. Section 2.26.1.2 Option
descriptions.

I hope this helps,




Burgess Evans
Database Administrator
Information Technology Division
Auditor of State of Ohio
Phone: 614-466-7906
>>> [login to unmask email] 10/17/03 18:36 PM >>>
Hi Isaac,

may be I inverted the numbers. I'm really using MAXPRIME(4369), which is
65535 tracks.
My goal is (was?) to have just one TEMPLATE usefull for all tablespaces
(which, of course, may be impossible).

Horacio Villa




Isaac Yassin
<[login to unmask email] To:
[login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]<~!B*+R^&>
LASSOC.COM>


10/17/03 04:59 AM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



Burgess Evans

Re: Abend E37-08
(in response to Horacio Villa)
Hi Horacio,

It sounds like your assumption might be correct, you probably need more DASD in your pool.

We don't use SMS pools and I send any large volumes of data to vtape so I can't give you any more insight.

Sorry and good luck.

Burgess

>>> [login to unmask email] 10/18/03 05:05PM >>>
Forgot to tell that the allocated file goes to a 10 3390-9 volumes SMS
pool and is multi-volume.
May be this is SMS-related.

Horacio Villa



Hi Burgess & Isaac,

Thanks for your input.
I want to understand fully how this works, before going to SPACE(primary,
secondary), which works OK, but needs to be adjusted for each tablespace
(yeah, not really each one).
I've tried UNCNT & NBRSECND with no success. Also tried PCTPRIME 50.
I'm testing with a tablespace not compressed which has 1205756 nactive
pages.
Whatever I try I get this allocation:
1st extent cylinders: 4369
Secondary cylinders : 5268
The secondary allocation is the problem. When it fills the primary it tries
to allocate a secondary which is impossible.
Is this a "not working as designed" problem or "not working as I should"?

Thanks in advance,

Horacio Villa



Burgess Evans
<[login to unmask email] To: [login to unmask email]
TATE.OH.US> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]
ASSOC.COM>


10/17/03 11:07 PM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

Your error code looks like the same error I received when trying to
allocate large amounts of DASD for a DFSORT job. I eventually found that I
was trying to allocate more space than z/OS would allow. It appeared to be
a system ceiling.

I solved my problem by lowering my primary and secondary allocation to a
lower level and I changed my JCL UNIT parameter to include a unit-count;
like this //ddname DD UNIT=(SYSDA,3). SYSDA in our shop is the device name
for our DASD. You can read more about unit count in the z/OS MVS JCL User's
Guide section 4.4.1.2.

I found something that might be similar in the TEMPLATE syntax diagram. You
might try the UNCNT integer TEMPLATE option. This is listed as a tape
option but might work with DASD. You might also want to check NBRSECND
integer. I found these options in the DB2 Universal Database for OS/390 and
z/OS Utility Guide and Reference for Version 7. Section 2.26.1.2 Option
descriptions.

I hope this helps,




Burgess Evans
Database Administrator
Information Technology Division
Auditor of State of Ohio
Phone: 614-466-7906
>>> [login to unmask email] 10/17/03 18:36 PM >>>
Hi Isaac,

may be I inverted the numbers. I'm really using MAXPRIME(4369), which is
65535 tracks.
My goal is (was?) to have just one TEMPLATE usefull for all tablespaces
(which, of course, may be impossible).

Horacio Villa




Isaac Yassin
<[login to unmask email] To:
[login to unmask email]
.NET> cc:
Sent by: DB2 Data Subject: Re: Abend E37-08
Base Discussion
List
<[login to unmask email]<~!B*+R^&>
LASSOC.COM>


10/17/03 04:59 AM
Please respond to
DB2 Data Base
Discussion List






Hi Horacio,

1. Did you try to use SPACE(priqty,secqty) instead of MAXPRIME?
2. You used MAXPRIME(4639), the default of SPACE is CYLINDERS.
So: 4639*15 = 69585 > 65535 tracks allowed.

Isaac Yassin

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Horacio Villa
Sent: Thursday, October 16, 2003 11:26 PM
To: [login to unmask email]
Subject: Re: Abend E37-08

Isaac,

I'm using 3390-9. But I get the abend when it fills the primary and tries
to allocate a secondary extent. I thought it would go to another volume,
but it's not the case.
Horacio Villa



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can



the DB2-L webpage at http://listserv.ylassoc.com. The owners of the list
can