var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to Know the DB size in Bytes/KB/MB/GB ?
Please explain to me for the outlined query give the result in bytes, kill byes, mega bytes or giga bytes.
db2 "select * from systools.stmg_dbsize_info"
On AIX version.
db2 "select db_size/1024/1024 as DB_SIZE,SNAPSHOT_TIMESTAMP,DB_CAPACITY/1024/1024 as CAPACITY from systools.stmg_dbsize_info"
like above u can get in kb/gb....
you can also get info from store procedure if you don't have "tools" installed:
db2 "CALL GET_DBSIZE_INFO(?, ?, ?, -1)"
Hope it helps,
You can although install db2mon and look at the "Tablespace" tab (sub-tab "Data")
To geek or not to geek !