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