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

autostart YES or TRUE

P: n/a
Using the following query:
select substr(reg_var_name,1,24) as reg_var_name, substr(reg_var_value,
1,12) as reg_var_value, level from table(sysproc.reg_list_variables())
as registryinfo;

I am receiving this information from hitting several of our prod
databases:

ADB1291.autostart:DB2AUTOSTART TRUE I
ADB1541.autostart:DB2AUTOSTART TRUE I
ADB2283A.autostart:DB2AUTOSTART TRUE I
ADB3011.autostart:DB2AUTOSTART TRUE I
ADB3045A.autostart:DB2AUTOSTART YES I
ADB3045B.autostart:DB2AUTOSTART YES I
ADB40091.autostart:DB2AUTOSTART TRUE I
ADB4467D.autostart:DB2AUTOSTART TRUE I
ADB4467E.autostart:DB2AUTOSTART TRUE I
ADB4467F.autostart:DB2AUTOSTART TRUE I
ADB4560.autostart:DB2AUTOSTART TRUE I
ADB70039.autostart:DB2AUTOSTART TRUE I
ADB81019.autostart:DB2AUTOSTART TRUE I
ADB81082.autostart:DB2AUTOSTART TRUE I
ADB81108.autostart:DB2AUTOSTART TRUE I
DB1134.autostart:DB2AUTOSTART TRUE I
DB1327.autostart:DB2AUTOSTART YES I
DB1392.autostart:DB2AUTOSTART TRUE I
DB1630.autostart:DB2AUTOSTART YES I
DB81084.autostart:DB2AUTOSTART YES I
DBPRIN.autostart:DB2AUTOSTART yes I
DBSUNT.autostart:DB2AUTOSTART YES I

I read in several old posts in this group that TRUE is not a correct
status/option for this parameter. Is this true, and what else must be
present on the box in order for the instance to restart after a
reboot?

Thank you,

Kermit Lowry
S1 Corporation

Mar 12 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Depending on the version of DB2 and if you are on linux/unix use
db2iauto to autostart instances. Run db2iauto -on instancename to
enable it.....I think that DB2AUTOSTART was removed from DB2 UDB v8,
read this http://www-1.ibm.com/support/docview...id=swg21127548
/roger

Mar 13 '07 #2

P: n/a
Depending on the version of DB2 and the envm use db2iauto to autostart
instances at reboot, run db2iauto -on instancename to enable it. I
think that DB2AUTOSTART was removed from v8 of DB2.
/roger
Mar 13 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.