Leslie,
We've encountered this error on occasion, and it usually turned out to be
an inode conflict. The best way to determine if it is an inode conflict is
to shut down both instances, then start each instance individually (i.e.
start instance 1, stop instance 1, start instance 2, stop instance 2). If
both instances start OK when they are the only instance running, but trying
to start both instances (in either order) results in the second one failing
with the SQL1072C, then you've got an inode conflict.
Refer to the messages manual for SQL1072C for information on how to fix
inode conflicts. It's pretty straight forward.
Hope this helps,
Bill Gallagher, DBA
Phoenix Life Insurance
Enfield, CT 06083
IBM Certified Solutions Expert - DB2 UDB v7.1 Database Administration for
OS/390
IBM Certified Solutions Expert - DB2 UDB v7.1 Database Administration for
UNIX, Windows, and OS/2
"Pendlebury-Bowe, Leslie"
<Leslie.Pendlebury-Bowe@eu To: "'Napolitano, Fabrizio'"
<[EMAIL PROTECTED]>,
.sony.com> "'[EMAIL PROTECTED] '"
<[EMAIL PROTECTED]>
Sent by: cc: "Pendlebury-Bowe, Leslie"
<[EMAIL PROTECTED]>
[EMAIL PROTECTED] Subject: RE: [DB2EUG]
Creating a second instance on an AIX box
03/11/02 04:58 AM
Please respond to
"Pendlebury-Bowe, Leslie"
hi
thanks for the prompt reply.
I created the second instance using db2icrt and had a new id for the
instance along with a new fenc id and sysadm group for it.
Things look ok when you attach to the new instance ... i.e if you issue a
db2 get dbm cfg you get all the ne instance information cfg data ... but
the
second you do an attach to the instance or a db2start you get :
----
SQL1072C The database manager resources are in an inconsistent state. DB2
may have been incorrectly terminated, or another application may be using
system resources in a way which conflicts with DB2's use of system
resources.
System resource cleanup may be required.
----
And now when you issue a db2 get dbm cfg you seem to be pointing at the
other instance on the box (the one first created when db2 was installed).
I then tried to drop the instance and we find a db2bp process is hanging
around and this stops the drop .. we have to kill this process and then
drop
and recreate the instance.
any thoughts?
Leslie
-----Original Message-----
From: Napolitano, Fabrizio [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 9:43 AM
To: '[EMAIL PROTECTED] '
Cc: 'Pendlebury-Bowe, Leslie '
Subject: RE: [DB2EUG] Creating a second instance on an AIX box
Hi Leslie,
it does be fairly straight forward at least if it's a second istance from
the same version, otherwise (inst1 v.6 , inst2 v7) you can have some
problems with links... what are your strange messages?
Maybe this can help getting an idea of problem...
Fabrizio
-----Original Message-----
From: Pendlebury-Bowe, Leslie
To: [EMAIL PROTECTED]
Sent: 11/03/02 7.16
Subject: [DB2EUG] Creating a second instance on an AIX box
Guys
Can anybody point us to some documentation on how to create & start a
second
instance on a single AIX box? I thought this was fairly straight forward
however we seem to be getting some strange messages when we try to start
the
second instance.
If you have a defined procedure or know of an IBM book that may contain
the
detailed docs on this it would be greatly appreciated.
Kindest regards
Leslie
************************************************************************
***********************
The information contained in this message or any of its attachments may
be confidential and is intended for the exclusive use of the
addressee(s). Any disclosure, reproduction, distribution or other
dissemination or use of this communication is strictly prohibited
without the express permission of the sender. The views expressed in
this email are those of the individual and not necessarily those of Sony
or Sony affiliated companies. Sony email is for business use only.
This email and any response may be monitored by Sony United Kingdom
Limited.
(6)
************************************************************************
***********************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
***********************************************************************************************
The information contained in this message or any of its attachments may be
confidential and is intended for the exclusive use of the addressee(s). Any
disclosure, reproduction, distribution or other dissemination or use of
this communication is strictly prohibited without the express permission of
the sender. The views expressed in this email are those of the individual
and not necessarily those of Sony or Sony affiliated companies. Sony email
is for business use only.
This email and any response may be monitored by Sony United Kingdom
Limited.
(6)
***********************************************************************************************
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** You are subscribed to [EMAIL PROTECTED]
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
