472,796 Members | 1,381 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,796 software developers and data experts.

autostart YES or TRUE

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
2 7291
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Jeff Sandler | last post by:
I just started with a service provider who's giving me a server to put my scripts. I noticed when I copy scripts that work on my machine to this server, all things $_SESSION are null. I read some...
46
by: Scott Chapman | last post by:
There seems to be an inconsistency here: Python 2.3.2 (#1, Oct 3 2003, 19:04:58) on linux2 >>> 1 == True True >>> 3 == True False >>> if 1: print "true" ....
10
by: Bill Medland | last post by:
Can anyone tell me what I am doing wrong? I installed DB2 8.1 + FP5 on Red Hat Enterprise Linux 3 (Update 1), using the command line method (i.e. db2_install and vi and ....) The one bit that...
1
by: timtos | last post by:
How can I tell a setup project to put a file to the startup folder of a user only when he selected this option. To give the user the possibility to select this option I´ve inserted a two radio...
4
by: Dica | last post by:
based on a previous thread, i've been advised that using the system registry isn't always the best way to store user config details (due to portability issues). from my understanding, however,...
0
by: Leo | last post by:
Hi! is it possible to deploy .net 2 application using OneClick Deployment and add it to autostart?
4
by: Joh | last post by:
I've developed an application that is launched at system startup. Is there a way to detect when an application is started by autostart and when its launched by a user?
2
by: JayaseelanVaiyapuri | last post by:
Hi, Anybody please tell how to create a project with autostart future.. If i install the .CAB file in my device the application should automatically start after completing the installation.....
0
AmberJain
by: AmberJain | last post by:
Windows Autorun FAQs: List of autostart locations Linked from the Original article- "Windows Autorun FAQs: Description". Que: Can you list all the autostart locations for windows? Ans: Here is...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: Mushico | last post by:
How to calculate date of retirement from date of birth
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.