UDB Commands

Raquel Rodriguez

UDB Commands
Ok...So there is a "CREATE DATABASE" command to create
a Database (as a "CLP" command), while there is a
"db2icrt" command (as a "System" Command) to create an
instance...why such variation? Why is there not a
"CREATE INSTANCE" command?

TIA Raquel.


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dave Stritzinger

Re: UDB Commands
(in response to Raquel Rodriguez)
Raquel,

To create an instance, you must have root authority on Unix and
administrator rights in a windows environment. When you create an instance a
lot of things get done that the normal user does not have authority to do.

Also, when you do a create database, from the command line you
prefix it with DB2 create database. At this time you already have the
instance created. You could not do a db2 create instance before you have an
instance created. The db2icrt updates many things and one of the things is
you .profile on the Unix platform which sets up your paths to point to the
DB2 executables.

I am not sure if this helps, but this is the way I look at it.

Dave S.

-----Original Message-----
From: Raquel Rodriguez [mailto:[login to unmask email]
Sent: Friday, December 05, 2003 10:53 AM
To: [login to unmask email]
Subject: UDB Commands


Ok...So there is a "CREATE DATABASE" command to create
a Database (as a "CLP" command), while there is a
"db2icrt" command (as a "System" Command) to create an
instance...why such variation? Why is there not a
"CREATE INSTANCE" command?

TIA Raquel.


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". If you will be out of the office, send the SET
DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins
can be reached at [login to unmask email] Find out the latest on
IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Elmer J. Valenzuela

Re: UDB Commands
(in response to Dave Stritzinger)
Hi
The reason is that the 'create' command is a db2
command and that means you already have an instance
running.
On the other hand creating an instance is actually setting
up a db2 system separate from an already defined one,
i.e. defining it on the system.

hth../elmer


> Ok...So there is a "CREATE DATABASE" command to create
> a Database (as a "CLP" command), while there is a
> "db2icrt" command (as a "System" Command) to create an
> instance...why such variation? Why is there not a
> "CREATE INSTANCE" command?
>
> TIA Raquel.
>
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm
>
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

tim malamphy

Re: UDB Commands
(in response to Elmer J. Valenzuela)
Raquel-

Because creating an instance requires root authority,
and REAL unix and windows SYSADMs(as opposed merely
being a DBA having DB2 SYSADM authority) don't want to
get bogged down with learning an application (like
DB2) to install software.

It's kind of like why there isn't a "CREATE DB2
SUBSYSTEM" command on OS/390 that DBA's can use to set
up a new DB2 region.

tim

--- Raquel Rodriguez <[login to unmask email]>
wrote:
> Ok...So there is a "CREATE DATABASE" command to
> create
> a Database (as a "CLP" command), while there is a
> "db2icrt" command (as a "System" Command) to create
> an
> instance...why such variation? Why is there not a
> "CREATE INSTANCE" command?
>
> TIA Raquel.
>
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
>
>
---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go
> to the archives and home page at
> http://www.idugdb2-l.org/archives/db2-l.html. From
> that page select "Join or Leave the list". If you
> will be out of the office, send the SET DB2-L NO
> MAIL command to [login to unmask email] The IDUG
> List Admins can be reached at
> [login to unmask email] Find out the latest
> on IDUG conferences at
http://conferences.idug.org/index.cfm


__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". If you will be out of the office, send the SET DB2-L NO MAIL command to [login to unmask email] The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm