customize CREATE DATABASE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

gruber - 27 May 2005 16:04 GMT

Hi,

I was wondering if the CREATE DATABASE command uses scripts to create the
catalog so that I can customize my database creation on DB2?

Thanks
Chris

Reply to this Message

Ian - 27 May 2005 17:48 GMT

> Hi,
>
> I was wondering if the CREATE DATABASE command uses scripts to create the
> catalog so that I can customize my database creation on DB2?

See the manual for the CREATE DATABASE command. There are a LOT of
options.

Reply to this Message

Mark A - 27 May 2005 18:39 GMT

> Hi,
>
[quoted text clipped - 3 lines]
> Thanks
> Chris

One easy way to build a script is to use the Control Center and do a show
SQL right before you submit the command.

Reply to this Message

Pierre Saint-Jacques - 30 May 2005 01:12 GMT

The CREATE db command alows you to override the default location of your
catalog tablespace.
The command itself is an executable that cannot (AFAIK) be modified.
HTH, Pierre.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>> Hi,
>>
[quoted text clipped - 6 lines]
> One easy way to build a script is to use the Control Center and do a show
> SQL right before you submit the command.

Reply to this Message