autostart YES or TRUE

[Ultrak The DBA]

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.r eg_list_variabl es())
as registryinfo;

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

ADB1291.autosta rt:DB2AUTOSTART TRUE I
ADB1541.autosta rt:DB2AUTOSTART TRUE I
ADB2283A.autost art:DB2AUTOSTAR T TRUE I
ADB3011.autosta rt:DB2AUTOSTART TRUE I
ADB3045A.autost art:DB2AUTOSTAR T YES I
ADB3045B.autost art:DB2AUTOSTAR T YES I
ADB40091.autost art:DB2AUTOSTAR T TRUE I
ADB4467D.autost art:DB2AUTOSTAR T TRUE I
ADB4467E.autost art:DB2AUTOSTAR T TRUE I
ADB4467F.autost art:DB2AUTOSTAR T TRUE I
ADB4560.autosta rt:DB2AUTOSTART TRUE I
ADB70039.autost art:DB2AUTOSTAR T TRUE I
ADB81019.autost art:DB2AUTOSTAR T TRUE I
ADB81082.autost art:DB2AUTOSTAR T TRUE I
ADB81108.autost art:DB2AUTOSTAR T TRUE I
DB1134.autostar t:DB2AUTOSTART TRUE I
DB1327.autostar t:DB2AUTOSTART YES I
DB1392.autostar t:DB2AUTOSTART TRUE I
DB1630.autostar t:DB2AUTOSTART YES I
DB81084.autosta rt:DB2AUTOSTART YES I
DBPRIN.autostar t:DB2AUTOSTART yes I
DBSUNT.autostar t: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

[kavallin@hotmail.com]

Re: autostart YES or TRUE

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

[kavallin@hotmail.com]

Re: autostart YES or TRUE

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