Archive logs not getting Archived

alwayssathya · #1 (**permalink**) 10-05-11, 06:40

I have mentioned a specific path for Archive logs LOGARCHMETH1: But i see logs are getting stored in Active logs rather than moving to Archive log path.

Also when i see diaglog I see this error.

2011-10-05-16.03.35.281364+330 I4155814768G488 LEVEL: Warning
PID : 9740 TID : 3086788288 PROC : db2logmgr (MAXDB71) 0
INSTANCE: ctginst1 NODE : 000
FUNCTION: DB2 UDB, data protection services, sqlpgRetryFailedArchive, probe:4780
MESSAGE : Still unable to archive log file 1199 due to rc -2029060079 for
LOGARCHMETH1 using method 1 and target
/MAX_DATA/ctginst1/Archive_Log_Maximo/ctginst1/MAXDB71/NODE0000/C00000
01/.

I just understand it is unable to archive the log... But please suggest how to over come this..

thanks !

przytula_guy · #2 (**permalink**) 10-05-11, 06:47

is the path existing ? owned by instance owner ? write access ?
what is the real value of LOGARCHMETH1

alwayssathya · #3 (**permalink**) 10-05-11, 07:44

Path is : /MAX_DATA/ctginst1/Archive_Log_Maximo/

it is existing , owned by root, But full access to instance owner.

przytula_guy · #4 (**permalink**) 10-05-11, 10:05

what is the real value of LOGARCHMETH1 : not answered

chown instanceowner:group /MAX....
chmod 6.. for the same path
in that case you have all authorization

alwayssathya · #5 (**permalink**) 10-05-11, 23:02

Now ownership also changed to instance owner...

And LOGARCHMETH1
(LOGARCHMETH1) = DISK:/MAX_DATA/ctginst1/Archive_Log_Maximo/

...

i have a doubt ...

if i take a backup of the DB then i can move the logs from Active logs to Archive log. will it work ?

db2girl · #6 (**permalink**) 10-06-11, 20:27

Quote:

Originally Posted by alwayssathya

if i take a backup of the DB then i can move the logs from Active logs to Archive log. will it work ?

Which logs? Old logs that still remain in the active log dir because of the above error?

alwayssathya · #7 (**permalink**) 10-06-11, 23:53

Yes .. i still find the logs in Active log directory even after backup and they are not moved to Archive log directory.

przytula_guy · #8 (**permalink**) 10-07-11, 02:55

you have to find the origin of the error
execute the command db2 archive log for db xxx
check diaglog if done
if error - investigate what is wrong with this filesystem/mount

alwayssathya · #9 (**permalink**) 10-07-11, 03:12

I ve executed the command it was successful,

[ctginst1@WESSPMDB02 ~]$ db2 archive log for db maxdb71
DB20000I The ARCHIVE LOG command completed successfully.
[ctginst1@WESSPMDB02 ~]$

Thanks it worked,

przytula_guy · #10 (**permalink**) 10-07-11, 03:16

the answer is always as indicated : The ARCHIVE LOG command completed successfully.
I indicated : check diaglog if done .. please do some debugging before.. and read the posts ..instead of coming back to the forum with each reply..
I presume you are the dba and we are remote volunteers

alwayssathya · #11 (**permalink**) 10-07-11, 04:53

I got your point correctly,

once i gave the command...it showed same error,
Jus to confirm my permision i once again gave the ownership to instance owner. Then it worked... diaglog show archival was successfull....

Internet Services

Web Development

Digital Marketing

Consumer Tech