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