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.

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.

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

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