way to speed-up/tune database creation?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hans Horn - 30 May 2005 15:59 GMT

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.

Reply to this Message

JoKlassen@email.com - 31 May 2005 09:11 GMT

> 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.

Reply to this Message

Anton Versteeg - 31 May 2005 09:30 GMT

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

Reply to this Message

Serge Rielau - 31 May 2005 11:49 GMT

> Howdy,
>
[quoted text clipped - 4 lines]
>
> 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

Signature

Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

Reply to this Message