Can I customize DB2 catalog with my own tables?

[Chris Gruber]

Hi,

Is there a way to create user tables when you do a CREATE DATABASE command
with DB2?
If so, how?

Thx
Chris

[Mark A]

"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7**********@newswest.sybase.com...

Hi,

Is there a way to create user tables when you do a CREATE DATABASE command
with DB2?
If so, how?

Thx
Chris

Not within the create database command, but you can create as script that
creates user tables after the create database.

[Chris Gruber]

Thanks

Some databases, install scripts that get run when a CREATE DATABASE command
is issued.
Am I correct to assume that DB2 does not have this type of setup with
scripts used by CREATE DATABASE command?

Thanks Again
Chris
"Mark A" <no****@nowhere.com> wrote in message
news:Hf********************@comcast.com...

"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7**********@newswest.sybase.com...

Hi,

Is there a way to create user tables when you do a CREATE DATABASE command with DB2?
If so, how?

Thx
Chris

Not within the create database command, but you can create as script that
creates user tables after the create database.

[Serge Rielau]

Mark A wrote:

"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7**********@newswest.sybase.com...

Hi,

Is there a way to create user tables when you do a CREATE DATABASE command
with DB2?
If so, how?

Thx
Chris

Not within the create database command, but you can create as script that
creates user tables after the create database.

"create database trigger" now that one I haven't heard yet....

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Serge Rielau]

Chris Gruber wrote:

Some databases, install scripts that get run when a CREATE DATABASE command
is issued.
Am I correct to assume that DB2 does not have this type of setup with
scripts used by CREATE DATABASE command?

There are stored procedures which are executed during CREATE DATABASE,
but they are not externalized.

Cheers
Serge

--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Mark A]

"Chris Gruber" <ch**********@ianywhere.com> wrote in message
news:d7*********@newswest.sybase.com...

Thanks

Some databases, install scripts that get run when a CREATE DATABASE
command
is issued.
Am I correct to assume that DB2 does not have this type of setup with
scripts used by CREATE DATABASE command?

Thanks Again
Chris

Not sure I know what you are talking about.

You can create a script which includes a create database command,
immediately followed by any other SQL that will create the objects you need.
So I don't see why you need anything else.

If you want to know about the create database command and all its options,
check the Command Reference Manual which can be downloaded for free from the
IBM website.

[Ian]

Chris Gruber wrote:

Thanks

Some databases, install scripts that get run when a CREATE DATABASE command
is issued.

Are you referring to Oracle, where, after you do 'create database' you
run separate scripts like 'catalog.sql', 'catproc.sql', 'catexp.sql',
etc?

If so, then the answer to your question is No. The CREATE DATABASE
command does all of this internally.