SEG TS Dataset Size

Sangameswara Panchomarthi

SEG TS Dataset Size
I have a question. I hope below information makes se
Hi Group,

I have a question. I hope below information makes sense.

Maximum simple or segmented data set size - 2 GB
Largest simple or segmented data set size - 64 GB (32 data sets * 2 GB size limit)

Under what circumstances, segmented data set size can grow to 4GB (87360 tracks) instead of 2GB?

Thanks,
Rao


-----------------------------------------
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Nick Cianci

Re: SEG TS Dataset Size
(in response to Sangameswara Panchomarthi)
Rao,
I haven't seen any replies so I'll take a crack.

If you look in the V8 SQL Reference manual (Table 101 in "Appendix A" you'll see "Maximum simple or segmented data set size 2 gigabytes").

However, what you may be seeing is an over allocation. VSAM may have allocated a 4Gb dataset, but you may find that DB2 will only use up to 2Gb.

Run a LISTCAT against the dataset, and see what you've reached on High-Used rather than High-Alloc RBA, if High-Used-RBA is still over 2Gb and it's not Partitioned or a LOB, then I'm confused as well.


Regards,

Nick CIANCI
Infrastructure Specialist - DB2 DBA | EDS Australia |
Level 2 Allara House, 48-52 Allara St, Canberra, ACT 2601 |
t: +61-2-6275-5863 | f: +61-2-6275-6064 | e: [login to unmask email] |

IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390

This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by this transmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient.

> _____________________________________________
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf Of [login to unmask email]
> Sent: Thursday, 6 December 2007 3:47 AM
> To: [login to unmask email]
> Subject: [DB2-L] SEG TS Dataset Size
>
> I have a question. I hope below information makes se Hi Group,
>
> I have a question. I hope below information makes sense.
>
> Maximum simple or segmented data set size - 2 GB Largest simple or segmented data set size - 64 GB (32 data sets * 2 GB size limit)
>
> Under what circumstances, segmented data set size can grow to 4GB (87360 tracks) instead of 2GB?
>
> Thanks,
> Rao

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org

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

Sangameswara Panchomarthi

Re: SEG TS Dataset Size
(in response to Nick Cianci)
Nick,

Thanks for the reply. You are right on predicting about VSAM over allocation. VSAM DSN is allocated at 4GB but DB2 is using 2GB only, when it reaches 2GB it is allocating another DSN at 4GB size.

We load replace the table on weekly schedule. It looks like LOAD Replace is doing this.

Thanks,
Rao

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email]On Behalf Of Cianci, Nick
Sent: Wednesday, December 05, 2007 7:54 PM
To: [login to unmask email]
Subject: Re: [DB2-L] SEG TS Dataset Size



Rao,
I haven't seen any replies so I'll take a crack.

If you look in the V8 SQL Reference manual (Table 101 in "Appendix A" you'll see "Maximum simple or segmented data set size 2 gigabytes").

However, what you may be seeing is an over allocation. VSAM may have allocated a 4Gb dataset, but you may find that DB2 will only use up to 2Gb.

Run a LISTCAT against the dataset, and see what you've reached on High-Used rather than High-Alloc RBA, if High-Used-RBA is still over 2Gb and it's not Partitioned or a LOB, then I'm confused as well.


Regards,

Nick CIANCI
Infrastructure Specialist - DB2 DBA | EDS Australia |
Level 2 Allara House, 48-52 Allara St, Canberra, ACT 2601 |
t: +61-2-6275-5863 | f: +61-2-6275-6064 | e: <mailto:[login to unmask email]> [login to unmask email] |

IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390

This correspondence is for the named person's use only. It may contain confidential or legally privileged information or both. No confidentiality or privilege is waived or lost by this transmission. If you receive this correspondence in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or rely on any part of this correspondence if you are not the intended recipient.

_____________________________________________
From: DB2 Data Base Discussion List [ <mailto:[login to unmask email]> mailto:[login to unmask email] On Behalf Of [login to unmask email]
Sent: Thursday, 6 December 2007 3:47 AM
To: [login to unmask email]
Subject: [DB2-L] SEG TS Dataset Size

I have a question. I hope below information makes se Hi Group,

I have a question. I hope below information makes sense.

Maximum simple or segmented data set size - 2 GB Largest simple or segmented data set size - 64 GB (32 data sets * 2 GB size limit)

Under what circumstances, segmented data set size can grow to 4GB (87360 tracks) instead of 2GB?

Thanks,
Rao

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on November 30th. Details at http://www.idug.org


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




-----------------------------------------
This transmission may contain information that is privileged,
confidential, legally privileged, and/or exempt from disclosure
under applicable law. If you are not the intended recipient, you
are hereby notified that any disclosure, copying, distribution, or
use of the information contained herein (including any reliance
thereon) is STRICTLY PROHIBITED. Although this transmission and
any attachments are believed to be free of any virus or other
defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to
ensure that it is virus free and no responsibility is accepted by
JPMorgan Chase & Co., its subsidiaries and affiliates, as
applicable, for any loss or damage arising in any way from its use.
If you received this transmission in error, please immediately
contact the sender and destroy the material in its entirety,
whether in electronic or hard copy format. Thank you.

IMPORTANT NOTICE:

IDUG is pleased to announce a series of upgrades to the DB2-L discussion listserv that are being implemented to improve reliability and the overall user experience of DB2-L. These changes are coming on December 7th. Details at http://www.idug.org

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