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,



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