db starts automatically at or after server startup

Posted on 2005-04-29
Last Modified: 2008-03-17
My env is:  DB2 UDB 8.1.5 in AIX 5.1 system

Can I run a db2 command as user of the instance xxxxxxx to have the db start automatically at system startup?  In other words, is there is a command/or set of commands that will cause the db2 instance to automatically start db2 for users to connect and use the database, without manual intervention?  

What auth would I need?  How can I set it up, could anyone give step by step instruction?  Any help will be greatly appreciated.  

200 pts.
Question by:dbruk
    LVL 13

    Accepted Solution

    to stop the instance you issue:
    to start the instance you use
    therefore, use a script with these commands
    LVL 7

    Expert Comment


    Issue these commands to autostart DB2 when the system starts up!!

    db2iauto -on <instance name>

    dasauto -on <das instance name>

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now