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,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
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,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
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
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
60,908 60,908 0 7,648
4,096 15,592,44 8 13,635,960 87.5 87.5
tsm: ADSM3>
|
