Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    1

    Question Unanswered: Control size of table space C0000000.LRG

    Hello,
    I have a db2 9.5 database where the table space C0000000.LRG is over 100GB and growing. This path to this file is C:\DB2\NODE0000\CMSLOG\T0000002\.

    As you can already tell I am not very DB2 literate.

    I am trying to understand what this file is and then why it is so large and finally how I can either reduce the size of the file or move the file to a larger drive.

    Any suggestions would be appreciated.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by msddcb View Post
    what this file is
    It is a tablespace container.


    Quote Originally Posted by msddcb View Post
    why it is so large
    At least one of the tables in that tablespace has grown. May be someone has loaded data into it.
    Quote Originally Posted by msddcb View Post
    how I can either reduce the size of the file or move the file to a larger drive.
    You could drop the table in question or delete some of its rows. To move the table to another tablespace in DB2 9.5 you'd need to unload its data, re-create the table, then reload the data. You can also move the entire tablespace by a redirected restore.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    Quote Originally Posted by msddcb View Post
    C0000000.LRG
    This belongs to the default tablespace USERSPACE1. Use "db2pd -d <db name> -tab" command to get information about all tablespaces in your db.

Tags for this Thread

Posting Permissions

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