hi:
what is the db2 boot order?
db2start is the first step,what is the next step? What tables involved?
thank.

On 8/9/2010 3:36 PM, ninth wrote:
When you have done db2start you;re done...
When you first connect to a dormant database then some db level
initialization needs to be performed (i.e. ACTIVATE database).

There are no tables involved, mostly it's about allocating memory and
getting information from the DB CFG

That's actually how far my own knowledge goes.. Not clear why a user
would need to know more...
Cheers
Serge

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

1. start instance
2. mount database
3. open database

in db2 just starting instance is all what is required from user, rest
is done by db2 itself no user action required

On Aug 10, 7:35*pm, hsn_ <kolar.ra... (AT) gmail (DOT) com> wrote:
i will try to compare what oracle and DB2 boot steps are
1)
DB2 => db2start -- Bring DB2 instance only and strat only DB2
Instance process and memory structure needed for instance only.
Oracle => STARTUP NOMOUNT -- Bring Oracle instance only. This
acutally start the background process and allocate memory

2)
DB2 => ACTIVATE DB <dbname> -- Start the DB2 database with all
database process. They are log writer, log reader, etc. If not given,
if applicatio try to connect to database <dbname> it automatically
starts up and will terminate automatically when all application
disconnects. Using ACTIVATE command is recommended approach.
Oracle => ALTER DATABASE <dbname> open -- Make the database
available to users.


Comparing DB2 with Oracle, DB2 is very simple and handy in starting
up. Even creating DB under DB2 is very very simple as apposed to
Oracle. For example,
CREATE DATABASE <dbname> will create you the database. Thats
it!!!.... Nothing more than that.

Below URL will help you out with more details
http://www.ibm.com/developerworks/da...0301chong.html
http://www.ibm.com/developerworks/da.../dm-0401gupta/