Running a script after db2start

Running a script after db2start

Post by Odd Bj?rn Anderse » Thu, 05 Sep 2002 16:02:15



Is there a way to force a script to be run automatically after a db2start or
after a reboot ?

Windows NT - DB2 EE 7.2 fix 5.

--
Odd Bj?rn Andersen

ErgoSolutions AS
Postboks 4364 Nydalen, 0402 Oslo
Telefon 23 14 50 00, Telefaks 23 14 50 01
Direkte tlf.nr. 23 14 46 73, Mobilnr 970 84597
www.ergogroup.no

 
 
 

Running a script after db2start

Post by Gert van der Kooi » Fri, 06 Sep 2002 02:28:59




Quote:> Is there a way to force a script to be run automatically after a db2start or
> after a reboot ?

You could create a script with the name db2start (.bat/.cmd) in a
directory which is the first one in path (at least before
%DB2PATH%\bin). It should execute the 'real' db2start specifying the
full name (%DB2PATH%\bin\db2start) and run the script you need when
the instance is succesfully started.
Caution: offcourse this will not work when booting your server unless
you set the instance start option to manual and use the db2start
script to start it.

 
 
 

1. Script runs at prompt, does not run from script

Hello,

I have a very long INSERT to perform in a table (159 columns!!).

This insert, put in a script and run from the SQL prompt, works OK,
without any error.

The same insert, put in a CGI script and run with prepare/execute, gives
an ORA-00911 Invalid Character error (shown on the web page).

I have checked again and again and there are exactly the same params in
the two places.

Maybe it's a DBI issue? Or something else?

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Attaching Large Scripts to Distribution Agent

3. DTS - Running a script from within a script

4. I'm a begginer!

5. How to run a SQL script from within a SQL script

6. Possible unrelated problems but...

7. Running Scripts from within Scripts

8. OAS 4.0.8.1 - Problem with applications

9. Running Scripts from Scripts?

10. SP3 script error (Error running script 80sp3-tools.sql)

11. How do I create a script that runs other scripts

12. Script does not run as Sub-script