IBM's advice is not to mess with the default instance and database file and
directory permissions - see
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5//index.jsp?topic=/com.i
bm.db2.luw.admin.sec.doc/doc/c0050516.html

You could run this copy script as the instance owner; or chmod the bit
settings to 644 (can't see what harm that would do); however if you have log
archiving enabled, a simpler way of doing this copy automatically is to use
LOGARCHMETH2 to take a secondary copy to a disk location of your choice. I
assume you are not trying to copy active log files? Best practice is to have
those fully mirrored anyway.

Regards
Alex Levy
Sustainable Software Ltd

-----Original Message-----
From: Lee Teck Loong
[mailto:db2udbdba-ezmlmshield-x77295890.[Email address protected]
Sent: 11 April 2008 06:45
To: LazyDBA Discussion
Subject: Re: DB2 Log File Permission


Hi Guru,

Good day.

I had a issue that my DB2 Instance default created the log file as following
file permission:-

$ ls -l S0003550.LOG
-rw------- 1 db2inst1 db2iadm1 40968192 Apr 10 19:36 S0003550.LOG
$

It is -rw------- (600). I had write the script to copy ($ cp S0003550.LOG
/db2log) by using other Unix Id (edpopt). But it give error that file
permission denite......

cp: S0003550.LOG: The file access permissions do not allow the specified
action.

How can I set the DB2 can default auto create the log files S000xxxxxx.LOG
to (644) then the User Id (edpopt) cp this file as backup?

The following is the information may help you:-

$ id
uid=204(db2inst1) gid=101(db2iadm1)
groups=1(staff),103(db2asgrp),205(cardpro)
$
$ umask
022
$ ls -l S0003550.LOG
-rw------- 1 db2inst1 db2iadm1 40968192 Apr 10 19:36 S0003550.LOG
$

Do this change/setting in DB2 or AIX Unix?

Please advice and given the step on changes?

Thousand thanks.

Best regards,




---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



DB2 & UDB email list listserv db2-l LazyDBA home page