Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2003
    Posts
    6

    Question Unanswered: Auto Extend a tablespace

    How do I auto extend a tablespace in DB2?

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Auto Extend a tablespace

    Not possible, AFAIK ...

    Cheers

    Sathyaram

    Originally posted by rebecca_lingam
    How do I auto extend a tablespace in DB2?

  3. #3
    Join Date
    Apr 2003
    Posts
    6

    Re: Auto Extend a tablespace

    Originally posted by sathyaram_s
    Not possible, AFAIK ...

    Cheers

    Sathyaram
    How can I go about this issue? I have bulk dataloads going on and I cant monitor the tablespace size late at night! is there some way?

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Auto Extend a tablespace

    I would assume that you know how much of data you would expect every night , even if not accurate .... So make sure you have atleast that amount of space free and have a script to check through the tablespace usage and give an alert(may be an email) and when necessary increase the size ...

    HTH

    Cheers

    Sathyaram

    Originally posted by rebecca_lingam
    How can I go about this issue? I have bulk dataloads going on and I cant monitor the tablespace size late at night! is there some way?

  5. #5
    Join Date
    Mar 2003
    Posts
    343

    Autoextending tablespaces

    Use SMS tablespaces. Then you can have your sysadmin monitor space usage and add space to the file system as needed.

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Autoextending tablespaces

    IMHO, use DMS tablespace for larger workloads(as it sounds) ... Do not compromise performance for the sake of having ease of extending tablespaces ...

    Cheers

    Sathyaram

    Originally posted by cchattoraj
    Use SMS tablespaces. Then you can have your sysadmin monitor space usage and add space to the file system as needed.

Posting Permissions

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