urgent request

urgent request

 

  





Hi all,
I got a call said they can not do update in production now; due
log files are full
checked db settings:
Log file size (4KB) (LOGFILSIZ) = 32761
Number of primary log files (LOGPRIMARY) = 35
Number of secondary log files (LOGSECOND) = 25

all those logs happened today; how can I reset the log for user to run
update again ?
we are doing cold backup nightly, but now still at day time can I remove
LOG files from 13 to 59 in below.
Thanks in advance for your help!!

Sue

-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:15 S0000013.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:15 S0000014.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:16 S0000015.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:16 S0000016.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:16 S0000017.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:17 S0000018.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:17 S0000019.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:18 S0000020.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:18 S0000021.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:18 S0000022.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:19 S0000023.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:19 S0000024.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:20 S0000025.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:20 S0000026.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:20 S0000027.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:21 S0000028.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:21 S0000029.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:22 S0000030.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:22 S0000031.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:23 S0000032.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:23 S0000033.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:24 S0000034.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:24 S0000000.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:26 S0000001.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:27 S0000002.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:28 S0000003.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:29 S0000004.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:30 S0000005.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:31 S0000006.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:32 S0000007.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:33 S0000008.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:34 S0000009.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:36 S0000010.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:37 S0000011.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:38 S0000035.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:39 S0000036.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:40 S0000037.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:41 S0000038.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:42 S0000039.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:46 S0000040.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:52 S0000041.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 08:59 S0000042.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:05 S0000043.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:12 S0000044.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:18 S0000045.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:24 S0000046.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:29 S0000047.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:35 S0000048.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:40 S0000049.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:46 S0000050.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:52 S0000051.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 09:58 S0000052.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 10:04 S0000053.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 10:11 S0000054.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 10:17 S0000055.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 10:23 S0000056.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 10:28 S0000057.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 10:34 S0000058.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 11:40 S0000059.LOG
-rw------- 1 db2pam db2pgam 134197248 Oct 23 11:41 S0000012.LOG


**********************************************************************
This e-mail transmission and any attachments that accompany it may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law and is intended solely for the use of the individual(s) to whom it was intended to be addressed. If you have received this e-mail by mistake, or you are not the intended recipient, any disclosure, dissemination, distribution, copying or other use or retention of this communication or its substance is prohibited. If you have received this communication in error, please immediately reply to the author via e-mail that you received this message by mistake and also permanently delete the original and all copies of this e-mail and any attachments from your computer. Thank you.
**********************************************************************

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