Results 1 to 2 of 2

Thread: Space Issues

  1. #1
    Join Date
    Jul 2005
    Posts
    47

    Unanswered: Space Issues

    Hi,

    I am working on AIX platform and DB2 V8.2.2 version.

    I have 5 instances on a server and 7 databases which amount to 100GB. But when I use df -k it shows that it consumes 168 GB. I would like to know which Instance consumes how much space and why is the total space used 168GB. I would like to free up the 68 GB. Any suggestions please.

    Thanks
    Venky

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    For each of the databases find out the location where the datafiles are residing. run -->
    du -k /datafilelocation
    this will tell you the space consumed by each datafile. Just add up and find out the total. Do the same for database log files too.
    There are many other ways to find out the space consumed by each database. Above mentioned is the one of them.

    Thanks,
    Jayanta Datta
    New Delhi

Posting Permissions

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