Forums & Discussions Home

    A place for members, communities, and committees to have discussions online and via e-mail.
    Click a category or topic to below to start the conversation...

    You are currently in view only mode for this forum. Please click the appropriate below to login as a member and participate. If you are not a member, please CLICK HERE for more information.


    Sep 26
    2003

    auto starting DAS, DB2 UDB on AIX

    Catherine McBride
    Hi.
    We have a new RS6000 running DB2 UDB release 8.1 Does anyone know
    where in AIX we would add our start command for DAS so that the admin server
    would start automatically when AIX starts up?
    Thanks in advance,
    Cathy McBride
    AIX newbie



    Paul Turpin
    The command is db2iauto. The syntax is
    db2iauto -on <instance name> to turn on auto-start

    and

    db2iauto -off <instance name> to turn off auto-start

    You will need to do a db2iauto for each instance you want to auto-start.

    To verify that it has been turned on, you will need to issue a
    db2set -all

    If you see something like:
    [i] DB2AUTOSTART=YES

    Then it is on.

    You can find out additional information about db2iauto at the DB2
    Information Center:
    http://www-3.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/techlib.d2w/report

    Just search on db2iauto.



    Martin Flavell
    The following is a quote from the operations doc I wrote for my current
    site

    2 Database Start-up

    This should be a completely automatic process, requiring no user
    intervention to set up or run.

    AIX uses the script /etc/inittab to run its initialisation routines. One of
    the lines in here refers to DB2, and causes the initialisation to run
    /etc/rc.db2

    /etc/rc.db2 is a script that sets the default DB2 installation directory
    and runs $DB2DIR/instance/db2istrt (currently DB2DIR="/usr/lpp/db2_07_01")

    db2istrt checks the user and password files and then runs dasilist and
    db2ilist to get the names of the DB2 Administration Server and all the
    instances known on that machine. It then starts the DB2 Administration
    Server and all the instances listed.

    The databases will become active when they are first used.




    Regards,

    Martin Flavell

    -------------------------------------------------------------------------
    IBM Certified Solutions Expert -- DB2 V7.1 Database Administration for
    OS/390
    -------------------------------------------------------------------------
    Systems Support Specialist
    Thesaurus Computer Services Ltd.
    Technical Infrastructure and Professional Services

    [login to unmask email]
    Telephone:01908 246500. Fax:01908 246555.
    WWW: www.i-tcs.com

    ------------------------------------------------------------------------
    Thesaurus Computer Services (www.i-tcs.com)

    This email is confidential and intended solely for the use of the
    individual to whom it is addressed. Any views or opinions presented are
    solely those of the author and do not necessarily represent those of
    Thesaurus Computer Services. If you are not the intended recipient, be
    advised that you have received this email in error and that any use,
    dissemination, forwarding, printing, or copying of this email is
    prohibited. If you have received this email in error please notify the
    sender, or [login to unmask email], by e-mail or telephone +44 (0)1908-246500



    -----DB2 Data Base Discussion List <[login to unmask email]> wrote:
    -----

    To: [login to unmask email]
    From: "McBride, Catherine" <[login to unmask email]>




    All Times America/New_York

    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact