Tag Archives: shell script

DB2 inplace reorg

Reorg is a close friend of a DBA.  But who and what is a reorg ?  Why do we need him ? Reorg is an utility in DB2 that reorganizes the data is the clustering sequences and can free up … Continue reading

Posted in db2 | Tagged , , , , , , , | Leave a comment

A Shell script to get total space allocated in a database

Often I get asked how much space does the database take and I end up doing list tablespace and calculating total pages * page size .  I tried using the  GET_DBSIZE_INFO stored procedure , it doesn’t seem to give the … Continue reading

Posted in db2 | Tagged , , , | Leave a comment