db2 tablespace increase

manikandank_1984 · #1 (**permalink**) 03-25-09, 04:00

Hi.

In orace using BR tools to incresing the tablespace.In DB2 i don't have any idea.
Please clarify me:-
what parameters need to be considered before increasing the tablespace?
Can you tell me what commands are used to increasing the tablespace?
How do i identify how much size has to be increased to tablespace?

Regards,
Mnaik

nick.ncs · #2 (**permalink**) 03-25-09, 12:31

Quote:

Originally Posted by manikandank_1984

what parameters need to be considered before increasing the tablespace?
Can you tell me what commands are used to increasing the tablespace?

check the ALTER DATABASE command in the DB2 Manual

Quote:

Originally Posted by manikandank_1984

How do i identify how much size has to be increased to tablespace?

Depends upon how much more data you want to store and what you want to store.....

n_i · #3 (**permalink**) 03-25-09, 12:43

Quote:

Originally Posted by nick.ncs

check the ALTER DATABASE command in the DB2 Manual

You probably meant ALTER TABLESPACE...

nick.ncs · #4 (**permalink**) 03-26-09, 00:33

Quote:

Originally Posted by n_i

You probably meant ALTER TABLESPACE...

LOL..... yes... that was a big goof-up

db2dummy1 · #5 (**permalink**) 03-26-09, 21:47

ALTER TABLESPACE was all the rage in the 20th century. Nowadays, we create DMS tablespaces with AUTORESIZE YES and they behave just like SMS from space management point of view.

n_i · #6 (**permalink**) 03-26-09, 22:39

You may be surprised to learn that some tablespaces were indeed created in the 20th century. I would not write off the ALTER TABLESPACE just yet (by the way, you can use it to set AUTORESIZE YES as well...)