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

cooldil · #1 (**permalink**) 05-12-11, 08:22

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.

ARWinner · #2 (**permalink**) 05-12-11, 09:10

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

cooldil · #3 (**permalink**) 05-13-11, 10:54

Quote:

Originally Posted by ARWinner

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.............

Internet Services

Web Development

Digital Marketing

Consumer Tech