Yes. Entires are made into .rhosts as well as /etc/hosts.equiv.
rsh, db2_all work fine from both servers.
-----Original Message-----
From: Satya
[mailto:db2udbdba-ezmlmshield-x54048967.[Email address protected]
Sent: Friday, July 29, 2005 7:12 AM
To: LazyDBA Discussion
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
DB2 & UDB email list listserv db2-l LazyDBA home page