Very large DB2 database sizes for new empty databases
When I setup a typical set of 8 databases on DB2 to support a DOORS deployment they are about 4GB each in size (after running create tables) making a startup database size of about 32GB which is a sizeable chunk of disk for an empty DOORS database array.
The same databases on Derby and also on MS SQL Server are negligible in size by comparison
Does anybody know why DB2 has such large database sizes for empty databases compared to other DB providers?
It makes backup process configuration a bit of an overhead
Are empty new Oracle databases large or small? I have never setup using Oracle.
I see this was asked a while ago but there was no definitive answer.
https://jazz.net/forum/questions/247973/huge-db2-database-size-normal
https://jazz.net/forum/questions/247973/huge-db2-database-size-normal
One answer
Hi Sean
This is a question for DB2 really, because ELM just creates emptyish tables and leaves it entirely to DB2 to manage how that translates into disk utilisation. I imagine they don't take so much space just for the heck of it, there will be a reason such as optimising read activity and updates or something like that.
HTH
Ian