Skip to Content
0
Former Member
Dec 04, 2011 at 12:43 PM

log_dir became full after enabling the archive

766 Views

Hello Experts,

I have set the archive logging by setting the parameter LOGARCHMETH1 to DISK:/db2/ECD/log_archive/, but permission on the directory /db2/ECD/log_archive/ was not set correctly so all archives were not transfered and the filesystem /db2/ECD/log_dir/ became full and we can not allocate the space dynamically (although I am checking the possibilities with Storage and UNIX team), Below is the Platform-

SAP ECC EHP 5

Linux

DB2 9.7 FP4

And now we are not able to stop the SAP as the command stopsap get hung and also not able to login to the SAP level.

Kindly assist and provide the solution as after changing the permission it is not moving the log file from log_dir to log_archive.

drwxr-xr-x 3 db2ecd dbecdadm  4096 Sep 13 17:06 log_archive

Below are the parameters set -

HADR log write synchronization mode     (HADR_SYNCMODE) = NEARSYNC
 First log archive method                 (LOGARCHMETH1) = DISK:/db2/ECD/log_archive/
 Options for logarchmeth1                  (LOGARCHOPT1) =
 Second log archive method                (LOGARCHMETH2) = OFF
 Log retain for recovery enabled             (LOGRETAIN) = OFF
 User exit for logging enabled                (USEREXIT) = OFF
 Changed path to log files                  (NEWLOGPATH) =
 Path to log files                                       = /db2/ECD/log_dir/NODE0000/
 Overflow log path                     (OVERFLOWLOGPATH) =
 Mirror log path                         (MIRRORLOGPATH) =
 First active log file                                   = S0000114.LOG

1) Can we move files from /db2/ECD/log_dir/ to /db2/ECD/log_archive/ manually or by any other method (I read somewhere that we can not remove the log files directly from log_dir directory).

2) Currently the log_dir contains the log files from S0000000.LOG to S0000117.LOG and the parameter "First active log file " shows the active log to S0000114.LOG, does that mean I can move the file from S0000000.LOG to S0000113.LOG manually to log_archive ?

Kindly assist.

Regards

Saurabh Mishra