By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,347 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

way to speed-up/tune database creation?

P: n/a
Howdy,

is there a way to speed-up or tune the database creation?
On my laptop (DB2-UDB PE) it takes 2 minutes to create a virgin database.
This virgin, btw. is 30MBytes heavy.
Is there a way to reduce its size?

H.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hans Horn wrote:
Howdy,

is there a way to speed-up or tune the database creation? Use faster disk and cpu(s) :-) On my laptop (DB2-UDB PE) it takes 2 minutes to create a virgin database.
This virgin, btw. is 30MBytes heavy.
Is there a way to reduce its size? Not that I'm aware of. The system catalog for an empty database needs
approx. 18 MB and per default there are 3 log files each 4 MB. You
might want to decrease the LOGFILSIZ aftre database creation to save
some of the 12 MB for log files.
H.


Nov 12 '05 #2

P: n/a
I don't think you can speed it up much.
The space is taken by log files (12MB) and the catalog tables (20 MB)

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums....m-db2/200505/1
Nov 12 '05 #3

P: n/a
Hans Horn wrote:
Howdy,

is there a way to speed-up or tune the database creation?
On my laptop (DB2-UDB PE) it takes 2 minutes to create a virgin database.
This virgin, btw. is 30MBytes heavy.
Is there a way to reduce its size?

H.

Aside from the size, may I ask why the time is an issue?
This reminds me on a certain competitive report where DBA's allegedly
spent more tim ecreating DBs than managing loads and backups....
Ths assumption by us developers is that CREATE DB is the odd one, thus
it is not exactly tuned for speed.
Time to creat a DB increased a lot with V8 btw because CREATE DB now
includes binding all sorts of packages for the clients.
The result is that FAQ about NULLID. packages have pretty much
disapeared..

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.