Extent limit - DB2 for OS/390 v7.1

Paolo Borghesi

Extent limit - DB2 for OS/390 v7.1
Hello,
I'm currently using DB2 for OS/390 7.1.0, and I have a question about the
extent limit.

In the "DB2 Universal Database for OS/390 - Administration Guide
Version 6" I can read the following:

-----------------------------------------------------
For table spaces, you can reach the 119-extent limit for the data set
before reaching the 2-GB limit for a nonpartitioned table space or
the 4-GB limit for a partitioned table space. If this happens, DB2
does not extend the data set.
-----------------------------------------------------

In the guide "DB2 Universal Database for OS/390 - Administration Guide
Version 7", instead, I can read:

-----------------------------------------------------
You can reach the extent limit for a data set before you reach the limit
for a partitioned or a nonpartitioned table space. If this happens, DB2
does not extend the data set.
For detailed information about limits in DB2 for OS/390 and z/OS, see
Appendix A of DB2 Utility Guide and Reference.
-----------------------------------------------------

I've searched in Appendix A of "DB2 Utility Guide and Reference v7", but I
haven't found any reference to "extent limit".
Then I have to suppose that this limit doesn't exist no more in release 7
or that it is changed? And, if it is changed, what is the new limit for
release 7.1.0?

Thanks in advance.

Best regards,


Paolo Borghesi

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

Sushanta K Dash

Re: Extent limit - DB2 for OS/390 v7.1
(in response to Paolo Borghesi)
No in Db2 V6 also the extent limit on Multiple volume is 251 and 4 extents
reserved for internal VSAM use. The same with V7 also.

With thanks

Dash

DB2 / IMS Database Administration Tel: 91 ( 44 )
28113801. X-2366.
India Solution Center Fax: 91 (44 )
28113790.
Chennai.
E-mail : [login to unmask email] Dash
____________________________________________________________________________
_____________
"The views expressed are my own and do not necessarily represent the views
or policy of my employer"

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Paolo Borghesi
Sent: Wednesday, 14 January 2004 4:39 PM
To: [login to unmask email]
Subject: Extent limit - DB2 for OS/390 v7.1

Hello,
I'm currently using DB2 for OS/390 7.1.0, and I have a question about the
extent limit.

In the "DB2 Universal Database for OS/390 - Administration Guide
Version 6" I can read the following:

-----------------------------------------------------
For table spaces, you can reach the 119-extent limit for the data set
before reaching the 2-GB limit for a nonpartitioned table space or
the 4-GB limit for a partitioned table space. If this happens, DB2
does not extend the data set.
-----------------------------------------------------

In the guide "DB2 Universal Database for OS/390 - Administration Guide
Version 7", instead, I can read:

-----------------------------------------------------
You can reach the extent limit for a data set before you reach the limit
for a partitioned or a nonpartitioned table space. If this happens, DB2
does not extend the data set.
For detailed information about limits in DB2 for OS/390 and z/OS, see
Appendix A of DB2 Utility Guide and Reference.
-----------------------------------------------------

I've searched in Appendix A of "DB2 Utility Guide and Reference v7", but I
haven't found any reference to "extent limit".
Then I have to suppose that this limit doesn't exist no more in release 7
or that it is changed? And, if it is changed, what is the new limit for
release 7.1.0?

Thanks in advance.

Best regards,


Paolo Borghesi

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

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

Paolo Borghesi

Re: Extent limit - DB2 for OS/390 v7.1
(in response to Sushanta K Dash)
Hello Dash,
thank you for your reply.

I have a question: the 251-limit is applicable to multiple volumes only?
Besides, what is the 119 limit mentioned in the manual?

Thanks in advance, Paolo

-----------------------------------------------------------

On Wed, 14 Jan 2004 05:49:39 -0600, Dash, Sushanta <[login to unmask email]>
wrote:

>No in Db2 V6 also the extent limit on Multiple volume is 251 and 4 extents
>reserved for internal VSAM use. The same with V7 also.
>
>With thanks
>
>Dash
>
>DB2 / IMS Database Administration Tel: 91 ( 44 )
>28113801. X-2366.
>India Solution Center Fax: 91 (44 )
>28113790.
>Chennai.
>E-mail : [login to unmask email] Dash
>___________________________________________________________________________
_
>_____________
>"The views expressed are my own and do not necessarily represent the views
>or policy of my employer"
>
> -----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
>Behalf Of Paolo Borghesi
>Sent: Wednesday, 14 January 2004 4:39 PM
>To: [login to unmask email]
>Subject: Extent limit - DB2 for OS/390 v7.1
>
>Hello,
> I'm currently using DB2 for OS/390 7.1.0, and I have a question about the
>extent limit.
>
>In the "DB2 Universal Database for OS/390 - Administration Guide
>Version 6" I can read the following:
>
>-----------------------------------------------------
>For table spaces, you can reach the 119-extent limit for the data set
>before reaching the 2-GB limit for a nonpartitioned table space or
>the 4-GB limit for a partitioned table space. If this happens, DB2
>does not extend the data set.
>-----------------------------------------------------
>
>In the guide "DB2 Universal Database for OS/390 - Administration Guide
>Version 7", instead, I can read:
>
>-----------------------------------------------------
>You can reach the extent limit for a data set before you reach the limit
>for a partitioned or a nonpartitioned table space. If this happens, DB2
>does not extend the data set.
>For detailed information about limits in DB2 for OS/390 and z/OS, see
>Appendix A of DB2 Utility Guide and Reference.
>-----------------------------------------------------
>
>I've searched in Appendix A of "DB2 Utility Guide and Reference v7", but I
>haven't found any reference to "extent limit".
>Then I have to suppose that this limit doesn't exist no more in release 7
>or that it is changed? And, if it is changed, what is the new limit for
>release 7.1.0?
>
>Thanks in advance.
>
>Best regards,
>
>
>Paolo Borghesi
>
>---------------------------------------------------------------------------
-
>-----
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
>"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-
l.org.
>The IDUG List Admins can be reached at [login to unmask email]
Find
>out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>
>---------------------------------------------------------------------------
------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm

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

craig patton

Re: Extent limit - DB2 for OS/390 v7.1
(in response to Paolo Borghesi)
Paolo,

The extents limit depends on the type of DASD being used to store your VSAM
datasets. If using the 3390 technology, your extents limit is either 119 or
123, depending on how the primary allocation was performed(it can be in up
to 5 extents which make the limit 123, if all in 1 extent, then it is 119).

On the newer 'RAID' DASD, the extents can go as high as 255, this is due to
how the 'RAID' DASD allocates the VSAM files.

HTH

Craig Patton
Senior DBA III
Office Depot, Inc.





>From: Paolo Borghesi <[login to unmask email]>
>Reply-To: DB2 Database Discussion list at IDUG <[login to unmask email]>
>To: [login to unmask email]
>Subject: Extent limit - DB2 for OS/390 v7.1
>Date: Wed, 14 Jan 2004 05:08:59 -0600
>
>Hello,
> I'm currently using DB2 for OS/390 7.1.0, and I have a question about
>the
>extent limit.
>
>In the "DB2 Universal Database for OS/390 - Administration Guide
>Version 6" I can read the following:
>
>-----------------------------------------------------
>For table spaces, you can reach the 119-extent limit for the data set
>before reaching the 2-GB limit for a nonpartitioned table space or
>the 4-GB limit for a partitioned table space. If this happens, DB2
>does not extend the data set.
>-----------------------------------------------------
>
>In the guide "DB2 Universal Database for OS/390 - Administration Guide
>Version 7", instead, I can read:
>
>-----------------------------------------------------
>You can reach the extent limit for a data set before you reach the limit
>for a partitioned or a nonpartitioned table space. If this happens, DB2
>does not extend the data set.
>For detailed information about limits in DB2 for OS/390 and z/OS, see
>Appendix A of DB2 Utility Guide and Reference.
>-----------------------------------------------------
>
>I've searched in Appendix A of "DB2 Utility Guide and Reference v7", but I
>haven't found any reference to "extent limit".
>Then I have to suppose that this limit doesn't exist no more in release 7
>or that it is changed? And, if it is changed, what is the new limit for
>release 7.1.0?
>
>Thanks in advance.
>
>Best regards,
>
>
>Paolo Borghesi
>
>---------------------------------------------------------------------------------
>Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
>page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
>"Join or Leave the list". The IDUG DB2-L FAQ is at
>http://www.idugdb2-l.org. The IDUG List Admins can be reached at
>[login to unmask email] Find out the latest on IDUG conferences at
>http://conferences.idug.org/index.cfm

_________________________________________________________________
Rethink your business approach for the new year with the helpful tips here.
http://special.msn.com/bcentral/prep04.armx

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

James Campbell

Re: Extent limit - DB2 for OS/390 v7.1
(in response to craig patton)
"A VSAM data set can be expanded to 123 extents per volume. If this is a multi-volume VSAM data set, then the VSAM component can be extended to a maximum of 255 extents combined over all volumes." (AMS for Catalogs, DEFINE CLUSTER, secondary parameter)

However VSAM's algorithm used to enforce these limits is "allow allocations until an allocation might exceed the limits." If there is currently 118 extents on a volume, then another allocation can be made - which can be in up to 5 extents giving the full 123 extents. If there are 119 extents another allocation exceed the 123 extent limit (119+5=124) and rather than trying and sometimes failing, VSAM just fails the request.

James Campbell

On 14 Jan 2004 at 6:29, Paolo Borghesi wrote:

> Hello Dash,
> thank you for your reply.
>
> I have a question: the 251-limit is applicable to multiple volumes only?
> Besides, what is the 119 limit mentioned in the manual?
>
> Thanks in advance, Paolo
>
> -----------------------------------------------------------
>
> On Wed, 14 Jan 2004 05:49:39 -0600, Dash, Sushanta <[login to unmask email]>
> wrote:
>
> >No in Db2 V6 also the extent limit on Multiple volume is 251 and 4 extents
> >reserved for internal VSAM use. The same with V7 also.
> >
> >With thanks
> >
> >Dash
> >
> >DB2 / IMS Database Administration Tel: 91 ( 44 )
> >28113801. X-2366.
> >India Solution Center Fax: 91 (44 )
> >28113790.
> >Chennai.
> >E-mail : [login to unmask email] Dash
> >___________________________________________________________________________
> _
> >_____________
> >"The views expressed are my own and do not necessarily represent the views
> >or policy of my employer"
> >
> > -----Original Message-----
> >From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> >Behalf Of Paolo Borghesi
> >Sent: Wednesday, 14 January 2004 4:39 PM
> >To: [login to unmask email]
> >Subject: Extent limit - DB2 for OS/390 v7.1
> >
> >Hello,
> > I'm currently using DB2 for OS/390 7.1.0, and I have a question about the
> >extent limit.
> >
> >In the "DB2 Universal Database for OS/390 - Administration Guide
> >Version 6" I can read the following:
> >
> >-----------------------------------------------------
> >For table spaces, you can reach the 119-extent limit for the data set
> >before reaching the 2-GB limit for a nonpartitioned table space or
> >the 4-GB limit for a partitioned table space. If this happens, DB2
> >does not extend the data set.
> >-----------------------------------------------------
> >
> >In the guide "DB2 Universal Database for OS/390 - Administration Guide
> >Version 7", instead, I can read:
> >
> >-----------------------------------------------------
> >You can reach the extent limit for a data set before you reach the limit
> >for a partitioned or a nonpartitioned table space. If this happens, DB2
> >does not extend the data set.
> >For detailed information about limits in DB2 for OS/390 and z/OS, see
> >Appendix A of DB2 Utility Guide and Reference.
> >-----------------------------------------------------
> >
> >I've searched in Appendix A of "DB2 Utility Guide and Reference v7", but I
> >haven't found any reference to "extent limit".
> >Then I have to suppose that this limit doesn't exist no more in release 7
> >or that it is changed? And, if it is changed, what is the new limit for
> >release 7.1.0?
> >
> >Thanks in advance.
> >
> >Best regards,
> >
> >
> >Paolo Borghesi
> >
> >---------------------------------------------------------------------------
> -
> >-----
> >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
> >page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
> >"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-
> l.org.
> >The IDUG List Admins can be reached at [login to unmask email]
> Find
> >out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
> >
> >---------------------------------------------------------------------------
> ------
> >Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at DB2-L-
> [login to unmask email] Find out the latest on IDUG conferences at
> http://conferences.idug.org/index.cfm
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

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

Max Scarpa

Re: Extent limit - DB2 for OS/390 v7.1
(in response to James Campbell)
Paolo

since SMS v 1.4 (and above) space allocation failures are reduced with the
support of a maximum number of 255 extents per component of VSAM data set
** for multivolume data sets ** (the limit is 123 extents for a single
volume allocation). But you've to check with your DASD guy SMS DataClass
definitions about storage constraint relief/multivolume definition.

HTH
Max Scarpa
DB2 sysprog

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

Ulf Heinrich

AW: Extent limit - DB2 for OS/390 v7.1
(in response to Max Scarpa)
Hello Paolo,
if you are tired of these restrictions and exceptions, just follow this
link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php and
you'll find a trial of our RT-ExtentManager.

It's a smart tool that will progressively increase the secondary
allocation of a DB2 cluster if it reaches a defined number of extents.
It's fully automated, based on IFCID technology and even works with a
parallel load! This ensures that no more space explodes due to overlooked
extent restrictions.


Any questions, just contact me

Ulf Heinrich
SOFTWARE ENGINEERING
-Technical Consultant-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-32
E-mail [login to unmask email]
Homepage www.seg.de

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

Roger Miller

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Ulf Heinrich)
How similar is this tool to what is done in DB2 for z/OS V8? Ours is
described in the redbook, SG24-7088, chapter 6.1.

Roger Miller

On Wed, 14 Jan 2004 16:06:00 +0100, [login to unmask email] wrote:

>Hello Paolo,
>if you are tired of these restrictions and exceptions, just follow this
>link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php and
>you'll find a trial of our RT-ExtentManager.
>
>It's a smart tool that will progressively increase the secondary
>allocation of a DB2 cluster if it reaches a defined number of extents.
>It's fully automated, based on IFCID technology and even works with a
>parallel load! This ensures that no more space explodes due to overlooked
>extent restrictions.
>
>
>Any questions, just contact me
>
>Ulf Heinrich
>SOFTWARE ENGINEERING
>-Technical Consultant-
>Robert-Stolz-Strasse 5
>40470 Duesseldorf/Germany
>Tel. +49 (0)211 96149-0
>Fax +49 (0)211 96149-32
>E-mail [login to unmask email]
>Homepage www.seg.de

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

John Higgins

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Roger Miller)
Roger, That Redbook has S A P in the title.

Only us Sapista's would look at a book like that !!

John

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Roger Miller
Sent: Wednesday, January 14, 2004 10:19 AM
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


How similar is this tool to what is done in DB2 for z/OS V8? Ours is
described in the redbook, SG24-7088, chapter 6.1.

Roger Miller

On Wed, 14 Jan 2004 16:06:00 +0100, [login to unmask email] wrote:

>Hello Paolo,
>if you are tired of these restrictions and exceptions, just follow this
>link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php and
>you'll find a trial of our RT-ExtentManager.
>
>It's a smart tool that will progressively increase the secondary
>allocation of a DB2 cluster if it reaches a defined number of extents.
>It's fully automated, based on IFCID technology and even works with a
>parallel load! This ensures that no more space explodes due to overlooked
>extent restrictions.
>
>
>Any questions, just contact me
>
>Ulf Heinrich
>SOFTWARE ENGINEERING
>-Technical Consultant-
>Robert-Stolz-Strasse 5
>40470 Duesseldorf/Germany
>Tel. +49 (0)211 96149-0
>Fax +49 (0)211 96149-32
>E-mail [login to unmask email]
>Homepage www.seg.de

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

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

Roger Miller

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to John Higgins)
That's not Zapatista? Until we get the really huge redbook with the
really long name on V8 done, this one is the best we have. Watch for
DB2 for z/OS V8 Everything you ever wanted to know & more, SG24-6079

Roger Miller

On Wed, 14 Jan 2004 11:10:17 -0600, Higgins John
<[login to unmask email]> wrote:

>Roger, That Redbook has S A P in the title.
>
>Only us Sapista's would look at a book like that !!
>
>John
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Roger Miller
>Sent: Wednesday, January 14, 2004 10:19 AM
>To: [login to unmask email]
>Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1
>
>
>How similar is this tool to what is done in DB2 for z/OS V8? Ours is
>described in the redbook, SG24-7088, chapter 6.1.
>
>Roger Miller
>
>On Wed, 14 Jan 2004 16:06:00 +0100, [login to unmask email] wrote:
>
>>Hello Paolo,
>>if you are tired of these restrictions and exceptions, just follow this
>>link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php and
>>you'll find a trial of our RT-ExtentManager.
>>
>>It's a smart tool that will progressively increase the secondary
>>allocation of a DB2 cluster if it reaches a defined number of extents.
>>It's fully automated, based on IFCID technology and even works with a
>>parallel load! This ensures that no more space explodes due to overlooked
>>extent restrictions.
>>
>>
>>Any questions, just contact me
>>
>>Ulf Heinrich
>>SOFTWARE ENGINEERING
>>-Technical Consultant-
>>Robert-Stolz-Strasse 5
>>40470 Duesseldorf/Germany
>>Tel. +49 (0)211 96149-0
>>Fax +49 (0)211 96149-32
>>E-mail [login to unmask email]
>>Homepage www.seg.de

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

Max Scarpa

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Roger Miller)
When SG24-6079 will be available in RedBooks site ?

Regards
Max Scarpa

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

Phil Grainger

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Max Scarpa)
and when the book is available you most defiantly want the softcopy not the VERY hard copy!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Roger Miller
Sent: 15 January 2004 05:02
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


That's not Zapatista? Until we get the really huge redbook with the
really long name on V8 done, this one is the best we have. Watch for
DB2 for z/OS V8 Everything you ever wanted to know & more, SG24-6079

Roger Miller

On Wed, 14 Jan 2004 11:10:17 -0600, Higgins John
<[login to unmask email]> wrote:

>Roger, That Redbook has S A P in the title.
>
>Only us Sapista's would look at a book like that !!
>
>John
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Roger Miller
>Sent: Wednesday, January 14, 2004 10:19 AM
>To: [login to unmask email]
>Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1
>
>
>How similar is this tool to what is done in DB2 for z/OS V8? Ours is
>described in the redbook, SG24-7088, chapter 6.1.
>
>Roger Miller
>
>On Wed, 14 Jan 2004 16:06:00 +0100, [login to unmask email] wrote:
>
>>Hello Paolo,
>>if you are tired of these restrictions and exceptions, just follow this
>>link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php and
>>you'll find a trial of our RT-ExtentManager.
>>
>>It's a smart tool that will progressively increase the secondary
>>allocation of a DB2 cluster if it reaches a defined number of extents.
>>It's fully automated, based on IFCID technology and even works with a
>>parallel load! This ensures that no more space explodes due to overlooked
>>extent restrictions.
>>
>>
>>Any questions, just contact me
>>
>>Ulf Heinrich
>>SOFTWARE ENGINEERING
>>-Technical Consultant-
>>Robert-Stolz-Strasse 5
>>40470 Duesseldorf/Germany
>>Tel. +49 (0)211 96149-0
>>Fax +49 (0)211 96149-32
>>E-mail [login to unmask email]
>>Homepage www.seg.de

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

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

Phil Grainger

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Phil Grainger)
after V8 goes GA or possibly after the GA announcement

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of [login to unmask email]
Sent: 15 January 2004 08:52
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


When SG24-6079 will be available in RedBooks site ?

Regards
Max Scarpa

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

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

Max Scarpa

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Phil Grainger)
Hi Phil

Does it means 'when it'll be ready' ? From Roger's words it appeared to be
avalaible now. I'd like to read it before my retirement. Or before we move
to ORACLE.

Regards
Max Scarpa

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

Phil Grainger

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Max Scarpa)
The "everything you wanted to know" etc etc red book (which I hope is what we are talking about) CANNOT be released until Version 8 has been finalised. This effectively means that the redbook will be out at about the same time as V8 itself

The good news is that the book is mostly written - I guess they'll just have to make sure that the features described in the book are the same features as exist in the product!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of [login to unmask email]
Sent: 15 January 2004 10:08
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


Hi Phil

Does it means 'when it'll be ready' ? From Roger's words it appeared to be
avalaible now. I'd like to read it before my retirement. Or before we move
to ORACLE.

Regards
Max Scarpa

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

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

Max Scarpa

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Phil Grainger)
<snip>
The good news is that the book is mostly written - I guess they'll just
have to make sure that the features described in the book are the same
features as exist in the product!
<end snip>

Yes, I'd be indecorous if any new feature described in the book would be
missing in the real product (or the contrary).

BTW I'd like to have a 'stable' DB2 with well-know features and not a
product implemented via an orgy of PTFs (sometimes not working or working
very badly), you can easily miss some function you might need. I'd like to
have a DB2 'versioning' with well know and fixed implementations, with some
milestones.

But who cares about Max Scarpa's wishes (from a very small company) ?
There's always a WAD or 'no customer requested this implementation' reply
ready to be shot.

Best regards
Max Scarpa

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

Ulf Heinrich

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Max Scarpa)
Hi Roger,
Thanks for your questions concerning RT-ExtentManager. The main benefit
is; it already runs stand-alone in large V5(APAR), V6, V7 installations.
Additionally, it works as an integral part of SOFTWARE ENGINEERING's
RealTimeMaintain for DB2 z/OS, which is an additional component to
traditional maintenance concepts and tools in the marketplace.

A few details about RT-ExtentManager features:
A simulation mode familiarizes you with the process
Monitors the DB2 cluster extent processing via IFCID 259
Automatically alters the secondary space allocation based on DSSIZE,
LARGE and PIECESIZE
Progressively increases the secondary quantity to insure space
efficiency

The tool guarantees that every DB2 object will reach its maximum data set
size without fragmentation or wasting space.

For more information, visit our both at Madrid IBM-Technical Conference in
March.


Ulf Heinrich
SOFTWARE ENGINEERING
VERTRIEBSGESELLSCHAFT MBH
-Technical Consultant-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-32
E-mail [login to unmask email]
Homepage www.seg.de

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

Tim R - CNF Ohling

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Ulf Heinrich)
Defiantly or definitely (or maybe both)???

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Grainger, Phil
Sent: Thursday, January 15, 2004 1:54 AM
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


and when the book is available you most defiantly want the softcopy not
the VERY hard copy!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Roger Miller
Sent: 15 January 2004 05:02
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


That's not Zapatista? Until we get the really huge redbook with the
really long name on V8 done, this one is the best we have. Watch for
DB2 for z/OS V8 Everything you ever wanted to know & more, SG24-6079

Roger Miller

On Wed, 14 Jan 2004 11:10:17 -0600, Higgins John
<[login to unmask email]> wrote:

>Roger, That Redbook has S A P in the title.
>
>Only us Sapista's would look at a book like that !!
>
>John
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Roger Miller
>Sent: Wednesday, January 14, 2004 10:19 AM
>To: [login to unmask email]
>Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1
>
>
>How similar is this tool to what is done in DB2 for z/OS V8? Ours is
>described in the redbook, SG24-7088, chapter 6.1.
>
>Roger Miller
>
>On Wed, 14 Jan 2004 16:06:00 +0100, [login to unmask email] wrote:
>
>>Hello Paolo,
>>if you are tired of these restrictions and exceptions, just follow
this
>>link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php
and
>>you'll find a trial of our RT-ExtentManager.
>>
>>It's a smart tool that will progressively increase the secondary
>>allocation of a DB2 cluster if it reaches a defined number of extents.
>>It's fully automated, based on IFCID technology and even works with a
>>parallel load! This ensures that no more space explodes due to
overlooked
>>extent restrictions.
>>
>>
>>Any questions, just contact me
>>
>>Ulf Heinrich
>>SOFTWARE ENGINEERING
>>-Technical Consultant-
>>Robert-Stolz-Strasse 5
>>40470 Duesseldorf/Germany
>>Tel. +49 (0)211 96149-0
>>Fax +49 (0)211 96149-32
>>E-mail [login to unmask email]
>>Homepage www.seg.de

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

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

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

Phil Grainger

Re: AW: Extent limit - DB2 for OS/390 v7.1
(in response to Tim R - CNF Ohling)
Whoops

I need a semantics checker!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Ohling, Tim R - CNF
Sent: 15 January 2004 15:15
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


Defiantly or definitely (or maybe both)???

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Grainger, Phil
Sent: Thursday, January 15, 2004 1:54 AM
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


and when the book is available you most defiantly want the softcopy not
the VERY hard copy!

Phil Grainger
Computer Associates
Product Manager, DB2
Tel: +44 (0)161 928 9334
Fax: +44 (0)161 941 3775
Mobile: +44 (0)7970 125 752
[login to unmask email]



-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
Behalf Of Roger Miller
Sent: 15 January 2004 05:02
To: [login to unmask email]
Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1


That's not Zapatista? Until we get the really huge redbook with the
really long name on V8 done, this one is the best we have. Watch for
DB2 for z/OS V8 Everything you ever wanted to know & more, SG24-6079

Roger Miller

On Wed, 14 Jan 2004 11:10:17 -0600, Higgins John
<[login to unmask email]> wrote:

>Roger, That Redbook has S A P in the title.
>
>Only us Sapista's would look at a book like that !!
>
>John
>
>-----Original Message-----
>From: DB2 Data Base Discussion List [mailto:[login to unmask email]On
>Behalf Of Roger Miller
>Sent: Wednesday, January 14, 2004 10:19 AM
>To: [login to unmask email]
>Subject: Re: AW: Extent limit - DB2 for OS/390 v7.1
>
>
>How similar is this tool to what is done in DB2 for z/OS V8? Ours is
>described in the redbook, SG24-7088, chapter 6.1.
>
>Roger Miller
>
>On Wed, 14 Jan 2004 16:06:00 +0100, [login to unmask email] wrote:
>
>>Hello Paolo,
>>if you are tired of these restrictions and exceptions, just follow
this
>>link: http://www.seg.de/englisch/products/db2/rt-maintain/rtmem.php
and
>>you'll find a trial of our RT-ExtentManager.
>>
>>It's a smart tool that will progressively increase the secondary
>>allocation of a DB2 cluster if it reaches a defined number of extents.
>>It's fully automated, based on IFCID technology and even works with a
>>parallel load! This ensures that no more space explodes due to
overlooked
>>extent restrictions.
>>
>>
>>Any questions, just contact me
>>
>>Ulf Heinrich
>>SOFTWARE ENGINEERING
>>-Technical Consultant-
>>Robert-Stolz-Strasse 5
>>40470 Duesseldorf/Germany
>>Tel. +49 (0)211 96149-0
>>Fax +49 (0)211 96149-32
>>E-mail [login to unmask email]
>>Homepage www.seg.de

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

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

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

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