I've tried to run ADSM v3.1.1.5 server (on AIX 421) in roll forward mode
and the server used to crash about once a week. Quite often
with OUT of MEMORY problem. It led me to believe that roll forward
mode is somehow related to out of memory problems.
Since I've changed to normal mode everything seems ok.
Although it may have been related to the fact we use shared memory
protocol not TCP/IP ,but I don't know.
My advice: don't use roll forward mode if you can afford it.
Greetings
Wojtek
>
> 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
>
|
