Informix Error -43061: BAR_MAX_BACKUP has been reduced to <size-value> to avoid </size-value> allocating more than SHMTOTAL KB.
Cause and resolution
BAR_MAX_BACKUP has been reduced to <size-value> to avoid </size-value> allocating more than SHMTOTAL KB.
The value of BAR_MAX_BACKUP multiplied by BAR_XFER_BUF_SIZE and BAR_NB_XPORT_COUNT will exceed the amount of shared memory reserved by the SHMTOTAL parameter in the ONCONFIG file. This ON-Bar process will use a lower BAR_MAX_BACKUP value to avoid exceeding this boundary.
Either raise the amount of shared memory the database server is allowed to use by increasing SHMTOTAL or lower the value of BAR_MAX_BACKUP, BAR_XFER_BUF_SIZE, or BAR_NB_XPORT_COUNT.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-43061 fires when BAR_MAX_BACKUP multiplied by BAR_XFER_BUF_SIZE and
BAR_NB_XPORT_COUNT would exceed the shared memory SHMTOTAL reserves — per the official
guidance, ON-Bar automatically uses a lower BAR_MAX_BACKUP value.
BAR_MAX_BACKUP×BAR_XFER_BUF_SIZE×BAR_NB_XPORT_COUNTexceedingSHMTOTAL, per the official guidance — the direct, only cause; informational, not a failure.
Solutions / Resolution
- Raise
SHMTOTAL, per the official guidance, or - Lower
BAR_MAX_BACKUP,BAR_XFER_BUF_SIZE, orBAR_NB_XPORT_COUNT, per the official guidance, if the automatic reduction isn't desired.
Examples
Checking the parameters involved
$ onstat -c | grep -E 'SHMTOTAL|BAR_MAX_BACKUP|BAR_XFER_BUF_SIZE|BAR_NB_XPORT_COUNT'
Diagnostic Checks
- Compute
BAR_MAX_BACKUP×BAR_XFER_BUF_SIZE×BAR_NB_XPORT_COUNTagainstSHMTOTAL, and adjust the parameters if the automatic reduction is unwanted.
Related Errors / Related Topics
- -43060 — "The buffer
exceeded maximum allowed limit. Changing buffer size to ." A related automatic-parameter-adjustment message, on the transport buffer size versus the X/Open spec's own maximum rather than SHMTOTAL.
BAR_MAX_BACKUP was automatically reduced to fit within SHMTOTAL — raise SHMTOTAL or
lower the ON-Bar parameters if a different value is wanted.