Table spaces that are not defined with LARGE

Jacek Surma

Table spaces that are not defined with LARGE
I have simple question. I use DB2 v6.1 for OS/390.
What is the limit of size for Simple Tablespace which is allocated on 3390-3
DASD (and how big on 3390-9 DASD).
I would like to have table space that is defined with LARGE. Is it any
simple way to change Simple Tablespace to "Large Tablespace" without
stopping production?
(this table must be available all the time).


Jacek Surma
BRE Bank SA


---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Ali OZTURK

Re: Table spaces that are not defined with LARGE
(in response to Jacek Surma)
Hi Jacek,
Limit of simple/segmented tablespace size is 64 GB. But simple or segmented tablespace dataset size is 2 GB. If dataset reach 2 GB, db2 allocates second dataset for the tablespace(If volumes are available.) db2 can allocate up to 32 dataset for a segmented/simple tablespace.
There isn't simple way to change simple tablespace to partition tablespace without stopping. You should,

- start tablespace with RO access
- unload data from table with ordering index key.
- drop / create large partition tablespace , table, indexes
- load unloaded data
- rebind all related packages...

Ali Ozturk
DB2-DBA
Pamukbank
Tel: 0212 275 24 24 / 3445
[login to unmask email]

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Tuesday, January 06, 2004 11:19 AM
To: [login to unmask email]
Subject: Table spaces that are not defined with LARGE



I have simple question. I use DB2 v6.1 for OS/390.

What is the limit of size for Simple Tablespace which is allocated on 3390-3 DASD (and how big on 3390-9 DASD).

I would like to have table space that is defined with LARGE. Is it any simple way to change Simple Tablespace to "Large Tablespace" without stopping production?

(this table must be available all the time).


Jacek Surma

BRE Bank SA



--------------------------------------------------------------------------------- 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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

Alice Frus

Re: Table spaces that are not defined with LARGE
(in response to Ali OZTURK)
I thought the limit was 4gb or 5,485 ish cylinders ?



[login to unmask email]
BANK.COM.PL To:
[login to unmask email]
Sent by: "DB2 Data cc:
Base Discussion Subject: Table spaces that
are not defined with LARGE
List"
<[login to unmask email]
>
01/06/2004 03:19 AM
Please respond to
"DB2 Database
Discussion list at
IDUG"




I have simple question. I use DB2 v6.1 for OS/390.


What is the limit of size for Simple Tablespace which is allocated on
3390-3 DASD (and how big on 3390-9 DASD).


I would like to have table space that is defined with LARGE. Is it any
simple way to change Simple Tablespace to "Large Tablespace" without
stopping production?


(this table must be available all the time).





Jacek Surma


BRE Bank SA


---------------------------------------------------------------------------------
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". If you will be out of the office, send the
SET DB2-L NO MAIL command to [login to unmask email] 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







**********
The information contained in this communication is confidential, private,
proprietary, or otherwise privileged and is intended only for the use of the
addressee. Unauthorized use, disclosure, distribution or copying is strictly
prohibited and may be unlawful. If you have received this communication in
error, please notify the sender immediately at (312)653-6000 in Illinois;
(972)766-6900 in Texas; or (800)835-8699 in New Mexico.
**********

---------------------------------------------------------------------------------
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". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] 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