Thanks a lot Bernie will try it and let u know how it goes.
-----Original Message-----
From: Schwanbeck, Bernie [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 6:46 AM
To: Sinha, Amit; [EMAIL PROTECTED]
Subject: RE: [DB2EUG] db2diag.log files is getting created with owner as
Root ?
It sounds like root started the instance.
When you installed your instance connecting to the mainframe, did you
specify to auto-start the instance at reboot? This puts an entry in
"/etc/inittab" and the instance is started as root. The instance needs to
be started as the instance owner (for example db2inst2). Remove the entry
from "/etc/inittab" and add a line to "/etc/rc.local" to start the instance
as the instance owner.
Here is the entry we have added to /etc/rc.local:
#Start db2 instance
echo "\nStarting db2 instance.\n"
su - db2inst2 -c "/apps/DB2/inst2/scripts/startdb2.sh >
/tmp/startdb2.out 2>&1 &"
sleep 5
Here is what the entry in /etc/inittab would look like. remove this as the
instance starts as root.
db:2:once:/etc/rc.db2 > /dev/console 2>&1 # Autostart DB2 Services
Stop the instance, move the db2daig file (as root) - tack the date to the
end of the file if you wish to save it. Then start the instance as the
instance owner.
-----Original Message-----
From: Sinha, Amit [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 4:41 PM
To: [EMAIL PROTECTED]
Subject: [DB2EUG] db2diag.log files is getting created with owner as
Root ?
Hi,
We have two db2 instance on a AIX, one for the local AIX database and one
for connecting to DB2 database on Mainframe.
We keep our diaglevel set to level 4. And, every midnight there is a job
which runs which move the db2diag.log to another
directory. That way we maintain each day db2diag.log file.
We just noticed that one of the instance(connecting to Mainframe) is
creating db2diag.log file under root, and the move has been failing as the
instance under which this file gets moved does not have privilege to move a
file created under root.
Help me please if any of u know why the file is getting created under root.
We just moved our AIX server to another server
what may have changed ? We are at db2connect version 6.1.0.50.
Thanks.
Amit
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
