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

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.