auto resize

manikandank_1984 · #1 (**permalink**) 12-20-08, 02:16

Hi,

How to find out auto resize in enabled or not in my database (db2).

What is the command to increase the tablespace in db2.

Regards,
K.Mnaikandan,

przytula_guy · #2 (**permalink**) 12-20-08, 04:45

check the syntax :
http://publib.boulder.ibm.com/infoce...c/r0000890.htm

manikandank_1984 · #3 (**permalink**) 12-20-08, 04:57

please give the example

is easy to understand

nick.ncs · #4 (**permalink**) 12-20-08, 06:01

Quote:

Originally Posted by manikandank_1984

please give the example

or you can see please spoonfeed me....

check the tablespace snapshot fucntion
http://publib.boulder.ibm.com/infoce...c/r0012562.htm

In it check for the TBSP_AUTO_RESIZE_ENABLED parameter.... if 1 then auot-resize is enabled.

stolze · #5 (**permalink**) 12-21-08, 08:04

Quote:

Originally Posted by manikandank_1984

please give the example

is easy to understand

Now I'm being rude, I know...

You are asking lots of stupid questions like these, which only show that you are too lazy to do your own job. Please, do us all a favor and either use your own brains, RTFM first (you even got the direct links here!), or stop posting altogether. Thanks in advance!

DBFinder · #6 (**permalink**) 12-23-08, 09:42

Code:

ALTER TABLESPACE TSD_DATA EXTEND
            ( FILE 'e:\db2_space\db2tsd_acc_deposit_1\t_acc_deposit.0' 4428,
              FILE 'e:\db2_space\db2tsd_acc_deposit_2\t_acc_deposit.1' 4428,
              FILE 'e:\db2_space\db2tsd_acc_deposit_3\t_acc_deposit.2' 4428
            );

TSD_DATA is tablespace Name.
Three FILEs are container files
4428 are pages. ----You need to calculate pages as Bytes/bytes per page.

e.g. Need to extend 40mb

pages will be 40*1024*1024/4096 --- 4kb page size.

Ask more if you need. --- no problem.

DBFinder

DBFinder · #7 (**permalink**) 12-23-08, 10:05

Code:

SELECT substr(TBSP_NAME,1,20) as TABLESPACE_NAME,
                    TBSP_USING_AUTO_STORAGE as AUTO_STORAGE,
                    TBSP_AUTO_RESIZE_ENABLED as AUTO_RESIZE 

   FROM table(SNAP_GET_TBSP('GC_PROD',-1)) as SNAP_GET_TBSP ;

Remember 'GC_PROD' is database name.

DBFinder

Internet Services

Web Development

Digital Marketing

Consumer Tech