Yes. ulimit is set to unlimited on both servers.
user/group ids/ passwords are also 100% identical:
cha8mm64:x:30000003:30000001:UDB
Instance:/data1/db2/databases/cha8mm64:/bin/ksh
cha8mm64:x:30000003:30000001:UDB
Instance:/data1/db2/databases/cha8mm64:/bin/ksh
db2admin:x:30000001:
db2admin:x:30000001:
rsh, db2_all work well.
64 bit one starts but only brings up instances on the first node as per
entries in the db2nodes.cfg. For other node's entries it gives "SQL6048N
Communication error..."
Thanks
Rajesh
-----Original Message-----
From: DANIEL CALLAHAN
[mailto:db2udbdba-ezmlmshield-x32659106.[Email address protected]
Sent: Friday, July 29, 2005 5:36 PM
To: LazyDBA Discussion
Subject: RE: SQL1229N while creating database on multi-partitioned
instance
What about ulimits for the instance id? and are the two userids 100%
equal
across both nodes down to the numeric id and groupid of each one?
So the 64 bit one doesnt start at all ?
"Satya"
<db2udbdba-ezmlms
hield-x54048967.x
To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
07/28/2005 09:42
PM
Subject
RE: SQL1229N while creating
database on multi-partitioned
instance
Have you made correct entry in .rhosts in the home directory of instance
owner and enabled rsh if multiple server.
"Jaswal Rajesh " <db2udbdba-ezmlmshield-x53282189.[Email address
protected]
07/28/05 09:23 PM
To: "LazyDBA Discussion" <[Email address protected]
cc:
Subject: RE: SQL1229N while creating database on
multi-partitioned instance
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
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay,
interception
and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do
not
accept liability for damage caused by this email and may monitor email
traffic.
This email is confidential. If you are not the addressee tell the sender
immediately and destroy this email without using, sending or storing it.
Emails are not secure and may suffer errors, viruses, delay,
interception
and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do
not
accept liability for damage caused by this email and may monitor email
traffic.
---------------------------------------------------------------------
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