auto starting DAS, DB2 UDB on AIX

Catherine McBride

auto starting DAS, DB2 UDB on AIX
Hi.
We have a new RS6000 running DB2 UDB release 8.1 Does anyone know
where in AIX we would add our start command for DAS so that the admin server
would start automatically when AIX starts up?
Thanks in advance,
Cathy McBride
AIX newbie



Paul Turpin

Re: auto starting DAS, DB2 UDB on AIX
(in response to Catherine McBride)
The command is db2iauto. The syntax is
db2iauto -on <instance name> to turn on auto-start

and

db2iauto -off <instance name> to turn off auto-start

You will need to do a db2iauto for each instance you want to auto-start.

To verify that it has been turned on, you will need to issue a
db2set -all

If you see something like:
[i] DB2AUTOSTART=YES

Then it is on.

You can find out additional information about db2iauto at the DB2
Information Center:
http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib.d2w/report

Just search on db2iauto.



Martin Flavell

Re: auto starting DAS, DB2 UDB on AIX
(in response to Paul Turpin)
The following is a quote from the operations doc I wrote for my current
site

2 Database Start-up

This should be a completely automatic process, requiring no user
intervention to set up or run.

AIX uses the script /etc/inittab to run its initialisation routines. One of
the lines in here refers to DB2, and causes the initialisation to run
/etc/rc.db2

/etc/rc.db2 is a script that sets the default DB2 installation directory
and runs $DB2DIR/instance/db2istrt (currently DB2DIR="/usr/lpp/db2_07_01")

db2istrt checks the user and password files and then runs dasilist and
db2ilist to get the names of the DB2 Administration Server and all the
instances known on that machine. It then starts the DB2 Administration
Server and all the instances listed.

The databases will become active when they are first used.




Regards,

Martin Flavell

-------------------------------------------------------------------------
IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
OS/390
-------------------------------------------------------------------------
Systems Support Specialist
Thesaurus Computer Services Ltd.
Technical Infrastructure and Professional Services

[login to unmask email]
Telephone:01908 246500. Fax:01908 246555.
WWW: www.i-tcs.com

------------------------------------------------------------------------
Thesaurus Computer Services (www.i-tcs.com)

This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
Thesaurus Computer Services. If you are not the intended recipient, be
advised that you have received this email in error and that any use,
dissemination, forwarding, printing, or copying of this email is
prohibited. If you have received this email in error please notify the
sender, or [login to unmask email], by e-mail or telephone +44 (0)1908-246500



-----DB2 Data Base Discussion List <[login to unmask email]> wrote:
-----

To: [login to unmask email]
From: "McBride, Catherine" <[login to unmask email]>