Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2008
    Posts
    70

    Unanswered: auto resizetable reaches 99.25%

    Hi,

    We are working in DB2 database.In this database we enabled the autoresize of tablespace.But some auto resize reaches 99.25%.Here i want the procedure how to increase the size of autoresize tablespace?Can you tell me the procedure?

    Regards,
    mani

  2. #2
    Join Date
    Feb 2009
    Posts
    14
    Use this:
    ALTER TABLESPACE "YourTBSP"
    MAXSIZE 2G;
    COMMIT;
    Best regrads,
    Danny Utro.

  3. #3
    Join Date
    Feb 2009
    Posts
    14
    MAXSIZE - the answer of your q.
    Best regrads,
    Danny Utro.

Posting Permissions

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