cancel
Showing results for 
Search instead for 
Did you mean: 

Table space 99.4% used.

Former Member
0 Kudos

Hi all,

     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 .

Regards

Deepesh

Accepted Solutions (1)

Accepted Solutions (1)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Q-1 Yes, if tablesapce is fully used then it will create problem because it would not be able extend for new data.

Q-2 Yes, you should check file system as well. Because if autoextend is on but file system is full then it will not be able to extend. Also, if file system is full then you would not be able to add new data file in tablespace in same file system.

Q-3 Autoextend- It means that when you add data file then you can specify whether you want data file to extend automatically to is maximum limit or not. If you have selected autoextend on then you have to specify maximum file size upto which it can grow and also increment size.

Thanks

Sunny

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

1 Q:If table space is reached to 100% then their is no space to add any entry in Tspace at that time ABAP Dumps happens in ur system.

2 Q.1 Scenario: Yaa file system have to be checked because to add the datafile in table space u have to check which filesystem has more free memory accordingly u have to add the datafile in that file system.

     2 Scenario:Check in DB02 whether auto extend is on or off for that Tspce if it is on then Tspace automatically extended to certain amount for this u require free space in ur filesystem if their is no space then errors will come.

3Q: Auto Extend means table automatically extends it's size if it reaches to certain level.

Thanks