Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2011
    Posts
    12

    Unanswered: SQL00002.DAT file has occuping more spaces in filesystem in AIX

    Hello All,

    In my database SQL00002.DAT file is occuping 95% of the file system.

    The filesystem has been reached to 100%.

    Could you please suggest me what is the solution for this. Can i move this file to another location. Is creating any problem for my db.

    Regards,
    Dil.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You cannot just move the file. It contains the data for one of your tables. You can try reorg on the table to see if any space will be freed up. If not, you can use db2relocatedb to move the tablespace for the table to another file system with more space.

    Andy

  3. #3
    Join Date
    Apr 2011
    Posts
    12

    SQL00002.DAT file has occuping more spaces in filesystem in AIX

    Quote Originally Posted by ARWinner View Post
    You cannot just move the file. It contains the data for one of your tables. You can try reorg on the table to see if any space will be freed up. If not, you can use db2relocatedb to move the tablespace for the table to another file system with more space.

    Andy
    Hi Andy,

    Thanks for ur reply......

    I will try with db2relocatedb.............

Posting Permissions

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