Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2011
    Posts
    1

    Unanswered: I can't attach a local node

    Hello,
    I have several db2-instances (DB2 9.7 LUW) on the same workstation and I want to attach instance b on instance a.
    I tried the following on instance a as user a, who is sysadm for instance a and instance b:

    db2 catalog local node nodeb instance b
    ->Node 1 entry: NODEB | LOCAL | LOCAL | b (as expected)
    db2 attach to nodeb
    ->SQL1032N No start database manager command was issued. SQLSTATE=57019

    DAS is started. Only after I switch to another user (su b), whose home directory is the directory of instance b (and who is also
    sysadm for instance b), the attachment works. Whereas "db2 attach to nodeb user b" doesn't work (SQL1032N).

    Can anybody help me or which details do you need? thank you
    Last edited by diana90; 10-14-11 at 19:03.

  2. #2
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,369
    It worked for me.

    I have two v9.7 instances on the same server - db2inst1 and db2inst2

    From db2inst1:

    db2inst1@ /home/db2inst1 > db2 catalog local node db2inst2 instance db2inst2
    DB20000I The CATALOG LOCAL NODE command completed successfully.
    DB21056W Directory changes may not be effective until the directory cache is
    refreshed.

    db2inst1@ /home/db2inst1 > db2 attach to db2inst2

    Instance Attachment Information

    Instance server = DB2/AIX64 9.7.3
    Authorization ID = DB2INST1
    Local instance alias = DB2INST2



    If I stop db2inst2, then attach will return sql1032n:

    # su - db2inst2
    $ db2stop
    10/14/2011 21:25:45 0 0 SQL1064N DB2STOP processing was successful.
    SQL1064N DB2STOP processing was successful.

    db2inst1@ /home/db2inst1 > db2 attach to db2inst2
    SQL1032N No start database manager command was issued. SQLSTATE=57019


    I'm not sure if this is related or not (most likely not), but both db2inst1 and db2inst2 belong to group staff.

    SYSADM_GROUP is not set.
    Last edited by db2girl; 10-14-11 at 22:39.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •