Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Location
    Toronto
    Posts
    4

    Unanswered: How to reduce the size of my DB2 database?

    Hi

    I have a test DB2 in my VM, now my C:\DB2 folder has 19G, but I don't think I have this much of data in it. Can anyone tell me how to reduce the size this DB2 folder occupies? I am not an DBA don't know how to deal with it, but I need to free some spaces.

    Thanks
    Jirong

  2. #2
    Join Date
    Oct 2009
    Location
    221B Baker St.
    Posts
    486
    Suggest you determine how much database data IS IN the folder/database before attempting to reduce the space used.

  3. #3
    Join Date
    Dec 2004
    Location
    Toronto
    Posts
    4
    Quote Originally Posted by papadi View Post
    Suggest you determine how much database data IS IN the folder/database before attempting to reduce the space used.
    I find out I have three database, each file (C:\DB2\ccm\content_tablespace) has 4G. For sure, I don't have this much data in these database.
    How can I determine how much database data IS IN the folder/database? I know I can Alert Tablespace to reduce the size.

    Thanks
    Jirong
    Last edited by hujirong; 06-04-12 at 14:47.

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    For each db, get:
    db2pd -d <db name> -tab

Posting Permissions

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