RE: urgent request

RE: urgent request

 

  


When you increase the number of logs you will have to have all the
connections off and then the first new connection will make the change
happen. You sill need to take a backup to free your logs and get your
archiving setup.
Frank

-----Original Message-----
From: Sheuehua
[mailto:db2udbdba-ezmlmshield-x83523923.[Email address protected]
Sent: Monday, October 23, 2006 12:51 PM
To: LazyDBA Discussion
Subject: Fw: urgent request






Hi all,
Thanks for help!!
This is an old database still in v7.2 and archive did not turn
on:
Log retain for recovery enabled (LOGRETAIN) = OFF
User exit for logging enabled (USEREXIT) = OFF

If I increasing the log in db cfg ; should I do "force
application
all" first, before I do the command
" update db cfg for dpaf using logprimary 40".

Sue
----- Forwarded by Sheuehua Leufuh/NYC-NY/US/Marsh/MMC on 10/23/2006
01:50
PM -----


Sheuehua

Leufuh/NYC-NY/US/

Marsh/MMC
To
[Email address protected]
10/23/2006 01:31

PM
cc





Subject
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


To: [Email address protected]
cc:
From: Sheuehua Leufuh/NYC-NY/US/Marsh/MMC



**********************************************************************
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.

**********************************************************************


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


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