Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 1 Using TIBCO Object Service Broker Utilities : hrnbrbal (Segment Balance)

hrnbrbal (Segment Balance)
Syntax
hrnbrbal [-A auditreport] [-p #pages] [-s segment#][-v]-f #files -N new_archive old_archive
Platforms
Windows, Solaris
Description
The hrnbrbal (Segment Balance) utility reads a TIBCO Object Service Broker segment archive and creates a new archive that matches the new specifications provided for the segment. This utility works at the page level only. The utility accepts archives from any of the supported TIBCO Object Service Broker platforms and is release independent.
Purpose
hrnbrbal automates the redistribution of the used pages of a specified segment into a redefined space. This redistribution makes changing space allocation for a segment easier and in some cases also leads to improved performance.
We strongly recommend that the procedures described here be performed by an experienced TIBCO Object Service Broker system administrator who is familiar with the site backup and recovery environment. All the steps in these procedures should be read and understood before proceeding with this activity. All aspects of this topic should be considered, such as:
Arguments
 
-A auditreport
-p #pages
-s segment#
Produce a verbose audit trail report that gives complete details of all modifications made to the segment, for example, the old and new numbers of all pages. Default: verbose not required
-f #files
-N new_archive
Tasks to Complete Before Executing hrnbrbal
 
Task A Take a Journal Spin
1.
This segments is referred to as the target segment.
2.
OR, if all segments are to be balanced:
3.
4.
5.
Task B Take a Backup
1.
If you are using continuous backup, run a spin merge and create a new continuous backup file for the target segments.
OR
If you do not use continuous backup, run hrntlbps (Backup Pagestore) to take a backup of each target segments.
2.
3.
Check that the resulting audit report contains no errors or orphan pages. Fix the errors and recover all orphan pages before proceeding.
Steps to Run hrnbrbal
1.
Ensure you are using the appropriate archive file for each segment.
2.
Ensure you are using the appropriate newly balanced archive for each segment.
3.
Steps to Take After Successfully Executing hrnbrbal
When the new archive is created:
1.
If the number of files in a target segment changed, modify the ACBS statement for that segment in your dbdef file to equal the new number of files in the segment.
2.
3.
4.
Run hrntlrps (Restore Pagestore) to restore the newly balanced archive to the segment, using the output from hrnbrbal as input to hrntlrps.
5.
If you are using continuous backup, restart it from this point for each target segment using the output of hrnbrbal to create a base backup for each segment. Alternatively, you can run hrntlbps (Backup Pagestore) to create the base backup.
OR
If you are not using continuous backup, run hrntlbps (Backup Pagestore) to take a full backup of each target segment.
6.
7.
See Also
TIBCO Object Service Broker for Open Systems Managing Backup and Recovery for additional information about the backup and restore procedures.
Return Code Settings
 
 
Example
The example command that follows reads the segment archive s0f1.bak and creates the new archive s0f3.bak, whose pages are balanced over three files:
hrnbrbal -A s0f3bal.aud -f 3 -N s0f3.bk s0f1.bak
This example creates the following audit report (s0f3bal.aud):

 
hrnbrbal Balance Segment number: 001 2007 April 17 15:25 v1.0
 
Balance Archive s0f1.bak into Redefined Archive s0f3.bak
Number of files in redefined segment: 003
 
PHASE 1 - Analyze Old Archive:
 
Segment: 0000; Old File: 0; Extent: 0; Page# 00000000
# pages available: 19767; Bit map size: 09A7
 
File 0 High Used Page (not including BITMAP pages): 00004D36; # Used Pages: 19766; # Pages Ignored: 1
 
OLD ARCHIVE - Read: 19767; Processed: 19767; Used: 19766; Ignored: 1
 
 
PHASE 2 - Re-assign Page Numbers:
Pages to be assigned to each of 003 files: 6589
Additional pages to be assigned to the 1st file: 2
 
New File #: 0; Extent: 0
High Used Page (not including BITMAP pages): 000019BE; # Assigned Pages: 6590; # Control Pages 1
 
 
New File #: 1; Extent: 0
High Used Page (not including BITMAP pages): 010019BC; # Assigned Pages: 6588; # Control Pages 1
 
New File 2 Summary;
High Used Page (not including BITMAP pages): 020019BC; # Assigned Pages: 6588; # Control Pages 1
 
 
 
PHASE 3 - Create New Archive:
 
New Control Page: 00000000
Prev: FFFFFFFF; Next: FFFFFFFF; Type: x'F0'
Number of Pages: 6591; Bit Map Size: 0338; File High Page: 000019BE
 
New Control Page: 01000000
Prev: FFFFFFFF; Next: FFFFFFFF; Type: x'F0'
Number of Pages: 6589; Bit Map Size: 0338; File High Page: 010019BC
 
New Control Page: 02000000
Prev: FFFFFFFF; Next: FFFFFFFF; Type: x'F0'
Number of Pages: 6589; Bit Map Size: 0338; File High Page: 020019BC
 
Bytes: Input 15335528; Output - Old 15331464; New 12192
 
 
OLD Pages - Read: 19767; Processed: 19767; Used: 19766; Ignored: 1

 

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved