If you run a database backup, does the log go down?
If it does not, you probably have a long transaction in the database. A
certain client is "pinning" the log.
Jeff Bach
Home Office Open Systems Engineering
Wal-Mart Stores, Inc.
WAL-MART CONFIDENTIAL
-----Original Message-----
From: Joshua S. Bassi [SMTP:jbassi AT IHWY DOT COM]
Sent: Thursday, October 04, 2001 9:48 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Recovery log space spikes
Are you using "roll forward recovery"? From what you are saying it
appears so. I would recommend turning it off and using a
logmode=normal
which will commit recovery log transactions to the DB as they
complete
instead of every time the DB fills up.
--
Joshua S. Bassi
Independent IT Consultant
IBM Certified - AIX/HACMP, SAN, Shark
Tivoli Certified Consultant- ADSM/TSM
Cell (408)&(831) 332-4006
jbassi AT ihwy DOT com
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On
Behalf Of
David Browne.
Sent: Thursday, October 04, 2001 6:46 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Recovery log space spikes
The maximum size of the recovery log is 5.5GB, my recovery log is
4.5 GB
now and I have just recently increased it 1GB from 3.5GB. It filled
up
again last night. My database is 59.5 GB. Could I have a problem
that
is
causing my recovery log to fill up or is this normal for this size
of
database?
I am running TSM 3.7.4 on OS390 R 2.10.
I have been testing TSM 4.1.4 and am planning to go to the new
release
in
the next few weeks, could this help the situation?
Below shows the past three days monitoring.
*********************
October 4, 2001
************************************************************************
*
tsm: ADSM3>q log
Available Assigned Maximum Maximum Page
Total
Used Pct Max.
Space Capacity Extension Reduction Size
Usable Pages Util Pct
(MB) (MB) (MB) (MB)
(bytes) Pages
Util
--------- -------- ---------
---------
------- --------- --------- -----
-----
4,620 4,620 0 4,264
4,096 1,182,208 89,762 7.6 100.0
Available Assigned Maximum Maximum Page
Total Used Pct Max.
Space Capacity Extension Reduction
Size
Usable Pages Util Pct
(MB) (MB) (MB) (MB)
(bytes) Pages
Util
--------- -------- ---------
--------- ------- ---------------
---------------- ------ ------
60,908 60,908 0
6,852
4,096 15,592,448 13,839,066 88.8 88.8
tsm: ADSM3>
********************************
October 3, 2001
************************************************************************
******************************************
tsm: ADSM3>q log
Available Assigned Maximum Maximum Page
Total Used Pct Max.
Space Capacity Extension Reduction
Size
Usable Pages Util Pct
(MB) (MB) (MB) (MB)
(bytes) Pages Util
--------- -------- ---------
--------- ------- -------------
------------
----- -----
----- -----
4,620 4,620 0
2,480
4,096 1,182,208 546,313 46.2 88.6
tsm: ADSM3>q db
Available Assigned Maximum Maximum Page
Total Used Pct Max.
Space Capacity Extension Reduction Size
Usable Pages Util Pct
(MB) (MB) (MB) (MB)
(bytes) Pages
Util
--------- -- -------- ---------
--------- ------- --------------
---------------
----- -----
----- -----
60,908 60,908 0 7,208
4,096 15,592,448 13,748,751 88.2 88.2
tsm: ADSM3>
************************************************************************
*****************************************
October 2, 2001
tsm: ADSM3>q log
Available Assigned Maximum Maximum
Page
Total Used Pct Max.
Space Capacity Extension Reduction
Size Usable Pages Util Pct
(MB) (MB) (MB)
(MB)
(bytes) Pages Util
--------- -------- ---------
--------- ------- --------------
-----------
----- -----
4,620 4,620 0
988 4,096 1,182,208 928,830
78.6
78.6
tsm: ADSM3>q db
Available Assigned Maximum Maximum Page
Total
Used Pct Max.
Space Capacity Extension Reduction Size
Usable Pages Util Pct
(MB) (MB) (MB) (MB)
(bytes) Pages
Util
--------- -------- --------- ---------
------- --------- --------------- -----
-----
60,908 60,908 0 7,648
4,096 15,592,44 8 13,635,960 87.5 87.5
tsm: ADSM3>
**********************************************************************
This email and any files transmitted with it are confidential
and intended solely for the individual or entity to
whom they are addressed. If you have received this email
in error destroy it immediately.
**********************************************************************
|