Personal tools
You are here: Home DB2 Problem Resolution Storage File System Full
Navigation
Log in


Forgot your password?
 
Document Actions

File System Full

When the File System is Full, which are the procedures that a DBA have to do



Possible Causes:

-    Tablespace Full
-    The db2diag.log too big
-    Transaction log full
-    User’s file too big

Investigation:


Step 1: Check File System Utilization:

df –k | grep -i <fsname>
Filesystem    1024-blocks      Free %Used    Iused %Iused Mounted on
/dev/hd4           229376    115676   90%     9211     9% /home/db2inst1



Step 2: on file system path, List the biggest files

du –k | sort +10



Resolution:


Compress files:

compress <filename> 

or


gzip <filename>



Send files to TSM :

dsmc incremental <filename>


Remove files:

rm –rf filename


Please make sure you are not touching files that are being used like, file containers, primary and secondary log files.

Usually we work with db2 dump files ( db2diag.log and etc), if you don’t have TSM on the server try to move the files to other file system, you can also involve aix and app team to discuss what is the best solution for the problem.

Security Awareness
Would you like your company to implement gamification into your security awareness program?





Polls