Segment balance utility (S6BBRBAL) fails with "Page: ddnnnnnn -S6BSB026E Page List overflow; -p option error"

Segment balance utility (S6BBRBAL) fails with "Page: ddnnnnnn -S6BSB026E Page List overflow; -p option error"

book

Article ID: KB0084893

calendar_today

Updated On:

Products Versions
TIBCO Object Service Broker for z/OS -
Not Applicable -

Description

Resolution:
Description:
============
While trying to reorder data within a database segment backup the segment balance utility, S6BBRBAL, can fail with the error "Page: ddnnnnnn -  S6BSB026E Page List overflow; -p option error"

Environment:
============
o All z/OS versions of Object Service Broker.

Symptoms:
=========
The S6BBRBAL utility fails with a U0200 abend and the above error in the log file.

Cause:
======
The root cause of this problem is that the pointer checker utility, S6BBRPTR, is not correctly flagging orphan pages of type "F".
S6BBRBAL requires orphan pages to be removed before the balance can be performed.

To confirm this is the problem in a particular case
1) The offending record(s) are listed as ignored in the record summary in the pointer checker report -

"BACKUP  RECORDS READ   nnnnnnnnnn; nnnnnnnnnn ACCEPTED;       nnnn UNUSED PAGES IGNORED "

Inspection of the backup file show there are records with an "F" in column 15.

Resolution:
===========
The long term solution for this issue is to have S6BBRPTR correctly report orphan F pages so these can be removed using the orphan page recovery process.

In the short term the solution is to remove these type F records from the input to S6BBRBAL. This can be done using SORT to exclude record with an F in column 15, actually column 19 in SORT as the dataset is variable blocked, or any other in house dataset manipulation utility.


References:
===========
TIBCO® Object Service Broker for z/OS - Utilities
TIBCO® Object Service Broker for z/OS - Managing Backup and Recovery

Issue/Introduction

Segment balance utility (S6BBRBAL) fails with "Page: ddnnnnnn -S6BSB026E Page List overflow; -p option error"