Hello list members,
We're running ADSM server version 3.1.2.0 on MVS OS 390. We recently changed
our recovery log mode from normal to roll forward. We set a database backup
trigger of 20%. When the log reached 20%, a full database backup is
triggered. This usually happens about every 24 hours. After the backup, the
recovery log percentage dropped to about 1%. This continued for about 4
days. However, during the weekend, the recovery log percentage did not drop
after a database backup causing database backups to be triggered immediately
after a successful backup. Here is an extract of the job log:
ANR4550I Full database backup (process 530) complete, 2666266 pages copied.
ANR0985I Process 530 for DATABASE BACKUP running in the BACKGROUND completed
ANR0985I with completion state SUCCESS at 07:51:23.
ANR4556W Warning: the database backup operation did not free sufficient
ANR4556W recovery log space to lower utilization below the database backup
ANR4556W trigger. The recovery log size may need to be increased.
We were eventually forced to bounce ADSM to get the recovery log back down
to 0.1 %. Here is the recovery log status:
Available Space (MB): 3,520
Assigned Capacity (MB): 3,520
Maximum Extension (MB): 0
Maximum Reduction (MB): 3,484
Page Size (bytes): 4,096
Total Usable Pages: 900,608
Used Pages: 8,420
Pct Util: 0.9
Max. Pct Util: 0.9
Physical Volumes: 4
Log Pool Pages: 512
Log Pool Pct. Util: 0.11
Log Pool Pct. Wait: 0.00
Cumulative Consumption (MB): 125,835.95
Consumption Reset Date/Time: 04/16/1998 09:07:19
Here is our database status:
Available Space (MB): 16,044
Assigned Capacity (MB): 15,004
Maximum Extension (MB): 1,040
Maximum Reduction (MB): 4,588
Page Size (bytes): 4,096
Total Usable Pages: 3,841,024
Used Pages: 2,666,346
Pct Util: 69.4
Max. Pct Util: 69.4
Physical Volumes: 11
Buffer Pool Pages: 8,192
Total Buffer Requests: 10,998,632
Cache Hit Pct.: 99.15
Cache Wait Pct.: 0.00
Backup in Progress?: No
Type of Backup In Progress:
Incrementals Since Last Full: 2
Changed Since Last Backup (MB): 39.00
Percentage Changed: 0.37
Last Complete Backup Date/Time: 11/30/1998 08:34:27
We are still running in roll forward mode. Can someone advise us as to
whether we should keep going in roll forward mode or revert to normal mode.
Also any advise as to how to manage roll forward mode will be appreciated.
Thanks.
Kind regards,
Desigan Moodley
* <mailto:DesiganM AT Transnet.co DOT za> DesiganM AT Transnet.co DOT za
|