Results 1 to 7 of 7

Thread: auto resize

  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: auto resize

    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,

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    Oct 2008
    Posts
    70
    please give the example

    is easy to understand

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    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.
    IBM Certified Database Associate, DB2 9 for LUW

  5. #5
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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!
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  6. #6
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Extend Tablesapce

    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
    Last edited by DBFinder; 12-23-08 at 12:45.

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Auto Resize

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •