By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,024 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,024 IT Pros & Developers. It's quick & easy.

V8.2 FP1 automatic startup

P: n/a
I have been reviewing manuals and it appears that version 8 does not
support the registry variable DB2AUTOSTART. From what I can tell you
should use the db2fm command to start the instances which allows for
fault monitoring of the instance.

Does anyone have a better solution to automatically restarting all DB2
instances on an IBM AIX server after a reboot than writing a script to
list the instances installed on the server and then issuing the db2fm
command for each instance?

I have attempted to find recommedations in the DB2 manuals, Info
Center, and this group but haven't really found anything.

Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a

ad_man...@yahoo.com wrote:
I have been reviewing manuals and it appears that version 8 does not
support the registry variable DB2AUTOSTART. From what I can tell you
should use the db2fm command to start the instances which allows for
fault monitoring of the instance.

Does anyone have a better solution to automatically restarting all DB2 instances on an IBM AIX server after a reboot than writing a script to list the instances installed on the server and then issuing the db2fm
command for each instance?

I have attempted to find recommedations in the DB2 manuals, Info
Center, and this group but haven't really found anything.


I never used it, but look into "db2iauto -on <instance>" and see if it
works.

Keith Ponnapalli
IBM Certified Advanced Database Administrator - DB2 UDB V8.1 for Linux,
UNIX, and Windows
INFORMIX Certified Database Administrator

Nov 12 '05 #2

P: n/a
ad*******@yahoo.com wrote:
I have been reviewing manuals and it appears that version 8 does not
support the registry variable DB2AUTOSTART. From what I can tell you
should use the db2fm command to start the instances which allows for
fault monitoring of the instance.

Does anyone have a better solution to automatically restarting all DB2
instances on an IBM AIX server after a reboot than writing a script to
list the instances installed on the server and then issuing the db2fm
command for each instance?

I have attempted to find recommedations in the DB2 manuals, Info
Center, and this group but haven't really found anything.


DB2AUTOSTART=YES works perfectly happily.

You just need to ensure that db2fmcd is running. On Linux the standard
install puts the following into /etc/inittab -

# end of /etc/inittab
fmc:2345:respawn:/opt/IBM/db2/V8.1/bin/db2fmcd #DB2 Fault Monitor
Coordinator

DB2 on my laptop starts happily every day with that.

Phil
Nov 12 '05 #3

P: n/a

Philip Nelson wrote:
ad*******@yahoo.com wrote:
I have been reviewing manuals and it appears that version 8 does not support the registry variable DB2AUTOSTART. From what I can tell you should use the db2fm command to start the instances which allows for fault monitoring of the instance.

Does anyone have a better solution to automatically restarting all DB2 instances on an IBM AIX server after a reboot than writing a script to list the instances installed on the server and then issuing the db2fm command for each instance?

I have attempted to find recommedations in the DB2 manuals, Info
Center, and this group but haven't really found anything.
DB2AUTOSTART=YES works perfectly happily.

You just need to ensure that db2fmcd is running. On Linux the

standard install puts the following into /etc/inittab -

# end of /etc/inittab
fmc:2345:respawn:/opt/IBM/db2/V8.1/bin/db2fmcd #DB2 Fault Monitor
Coordinator

DB2 on my laptop starts happily every day with that.

Phil


Phil,

Thanks for the response. I am running DB2 on an IBM AIX server running
AIX 5.3 64-bit. I have the DB2AUTOSTART set to YES as you can see
below.

$ db2set -all
[i] DB2_EVALUNCOMMITTED=ON
[i] DB2COMM=tcpip
[i] DB2AUTOSTART=YES
[g] DB2SYSTEM=dalpdi6
[g] DB2ADMINSERVER=dasusr

I have verified that the db2fmcd is running but the instances did
start. Here is a link to the IBM website that states V8 does not
support DB2AUTOSTART.

http://www-1.ibm.com/support/docview...=utf-8&lang=en

The DB2AUTOSTART appears to work correctly on my servers running V8.1
in 32-bit mode. I noticed an APAR for the SUN OS in 64-bit mode where
the instances would not start automatically and wonder if I am seeing a
bug or the option has been desupported with V8.2. Thanks for your
reply and I post any updates.

Nov 12 '05 #4

P: n/a
Keith,

Thanks for the response. I read up on this command and it looks like
it may work. Appears it is only available on UNIX from the
documentation. I will give it a try and let you know. Thanks again.

Nov 12 '05 #5

P: n/a

ad*******@yahoo.com wrote:
Keith,

Thanks for the response. I read up on this command and it looks like
it may work. Appears it is only available on UNIX from the
documentation. I will give it a try and let you know. Thanks again.


I set this parameter on all instances without error and rebooted the
server. Unfortunately none of the instances started. Only the DAS
instance and the db2fmcd process started. Don't know where to go from
here.

Does anyone else have a suggestion?

Nov 12 '05 #6

P: n/a
Ian
ad*******@yahoo.com wrote:
ad*******@yahoo.com wrote:
Keith,

Thanks for the response. I read up on this command and it looks like
it may work. Appears it is only available on UNIX from the
documentation. I will give it a try and let you know. Thanks again.

I set this parameter on all instances without error and rebooted the
server. Unfortunately none of the instances started. Only the DAS
instance and the db2fmcd process started. Don't know where to go from
here.

Does anyone else have a suggestion?


Did you use db2iauto or just set DB2AUTOSTART?

Nov 12 '05 #7

P: n/a
I used db2iauto on all instances according to the documentation. The
command appeared to run correctly with no errors reported. I rebooted
the server and none of the instances restarted except for the DAS.

Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.