I am student presently working as a trainee in one of the consulting company . I have been monitoring some system(Daily health check) . Today I observed in one of the system that the table space is 99.34% used . Then I thought of checking file system where DB resides and I can see 13 % is free .
1:) So my question is it a problem to system if tables space is almost consumed ?
2:) Checking the file system in this scenario is it necessary ?
3:) I have heard about some term called "Auto-Extend on/off" . what is it and where can i check it?
We are using DB2 database .