<\/p>\n
Most of the cases we need to monitor the space of the FileSystem while data is growing in the database.<\/p>\n
And if there are any delete operations performed on a table then the table must be reorged and space should be reclaimed.<\/p>\n
It this case we need to reduce the free pages that are there in a tablespace.<\/p>\n
So to automate that we can use the below script.<\/p>\n
Here is the script.<\/p>\n
#!\/bin\/bash\r\n\r\n# Establishing database connection\r\n\r\ndb2 \"connect to itgdb\"\r\n\r\n# Gathering the tablespaces other than temporary and placing them in a file\r\n\r\ndb2 list tablespaces show detail | grep -i -A2 name | tac | sed '\/Temporary\/I,+2 d' | tac | grep -i name | awk '{print $3}' > \/tmp\/TablespaceList.out\r\n\r\n# Using for loop to get the tablespace name one by one\r\n\r\nfor i in `cat \/tmp\/TablespaceList.out`\r\n\r\ndo\r\n\r\n# Gathering free pages count for each tablespace\r\n\r\ndb2 list tablespaces show detail | grep -i -A9 $i | grep -i 'free pages' | awk '{print $4}' > \/tmp\/FreePages.out\r\n\r\nFreePages=`cat \/tmp\/FreePages.out`\r\n\r\n# Comparing whether the free pages are more than 1000 or not\r\n\r\nif [ $FreePages -gt 1000 ]\r\n\r\nthen\r\n\r\n# If the free pages are more than 1000 then reducing them\r\n\r\ndb2 \"alter tablespace $i reduce max\"\r\n\r\nfi\r\n\r\ndone<\/pre>\n\n<\/div>\n