Hi Daniel,
/etc/services file has identical entries on both nodes.
db2c_muk8mm32 50002/tcp
DB2_muk8mm32 60004/tcp
DB2_muk8mm32_1 60005/tcp
DB2_muk8mm32_2 60006/tcp
DB2_muk8mm32_END 60007/tcp
Infact, I have successfully created multi-partitioned instances for both
V7.2 and V8.x on almost all UNIX/Windows operating systems. But I am
unable to do it on Redhat AS 4.0. Are there RHEL 4.0 specific issues?
On Redhat AS 4.0 IA64, db2start does not start the instances on other
node; giving SQL6048N - A communication error. And if db2start is
executed from other node, I get " SQL1042C An unexpected system
error..." Hardware in this case is HP Rx-2600(Itanium)
On Redhat AS 4.0 IA32 architecture, db2start successfully starts
instances on all physical nodes, but fails to create database with
SQL1229N error.
Logically partitioned instances / databases are working without any
problems individually on all these boxes.
Thanks
Rajesh
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x11394225.[Email address protected]
Sent: Thursday, July 28, 2005 5:43 PM
To: LazyDBA Discussion
Subject: Re: SQL1229N while creating database on multi-partitioned
instance
Make sure that the /etc/services file is identical on the two nodes with
respect to the FCM ports. (DB2_db2inst1 - DB2_db2inst1_end)
"Jaswal Rajesh "
<db2udbdba-ezmlms
hield-x50866053.x
To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
07/28/2005 07:00
AM
Subject
SQL1229N while creating database
on
multi-partitioned instance
Hi All,
Am getting SQL1229N error while creating a database on a
multi-partitioned instance (two physical nodes). The DB2 V8 is at
fixpack 7 and the OS is Redhat AS 4.
$ db2start
07/28/2005 16:24:00 0 0 SQL1063N DB2START processing was
successful.
07/28/2005 16:24:31 1 0 SQL1063N DB2START processing was
successful.
SQL1063N DB2START processing was successful.
$ db2 create db sam
SQL1229N The current transaction has been rolled back because of a
system error. SQLSTATE=3D40504 $
Please help!
Thanks
Rajesh
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page