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