![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
If a segment is nearing its data capacity, you can use one of two procedures to add one or more page data sets to the segment:
1. Use backup and restore utilities along with segment balance. This is the recommended method especially if the segment has many tables.TIBCO Object Service Broker for Open Systems Utilities and TIBCO Object Service Broker for Open Systems Managing Backup and Recovery for specific information about the utilities mentioned in the following sections.Issue the following command, replacing nn with the segment number:Use hrntlbps (Backup Pagestore utility) to back up the segment. Issue the following command, replacing nn with the segment number:
1. Issue the following command, replacing nn with the segment number:hrnbrptr -s nn -h -A snnAudit.txt -H snnHeader.txt -E snnError.txt -R snnReflog.txt -O snnOrphan.txt segnn.bak
3. Save a copy of the backup to an alternative location in case it is needed for recovery at a later stage in the process.
1. Edit the dbdef file in the database folder under your TIBCO Object Service Broker install folder.
2. Locate the “DB TYPE=PAGE,ACBS=n,…” statement for the segment you want to expand.
3. Refer to TIBCO Object Service Broker for Open Systems Installing and Operating for information about the dbdef file.Use hrntlfps (Format Pagestore utility) to initialize the new page files. Issue the following command, replacing nn with the segment and page numbers:Use hrntlbps to backup the expanded segment. Issue the following command, replacing nn with the segment number:Task G Verify the expanded data set
1. Issue the following command, replacing nn with the segment number:hrnbrptr -s nn -h -A snnAudit.txt -H snnHeader.txt -E snnError.txt -R snnReflog.txt -O snnOrphan.txt segnn.bak
3. Save a copy of the backup to an alternative location in case it is needed for recovery at a later stage in the process
At this point the expanded segment can be used by the Data Object Broker by skipping to Shutdown the Data Object Broker; however, we recommend that hrnbrbal (Segment Balance utility) be used to balance the data across all the segment's page data sets. This will distribute I/O for new data across all page data sets, yielding better performance.hrnbrbal (Segment Balance utility) takes your backup and creates a new backup data file reflecting evenly populated page files. To use this utility issue a command similar to the following replacing nn with the segment number and xx with the number of files in the new segment definition:Refer to TIBCO Object Service Broker for Open Systems Utilities for detailed information about using this utility.Task I Verify the balanced segment
1. Issue the following command, replacing nn with the segment number:hrnbrptr -s nn -h -A snnAudit.txt -H snnHeader.txt -E snnError.txt -R snnReflog.txt -O snnOrphan.txt segnn.bak
3. Save a copy of the backup to an alternative location in case it is needed for recovery at a later stage in the process.Use hrntlfps to reallocate and format the new page files in the segment. Issue the following command, replacing nn with the segment and page numbers:Use hrntlrps (Restore Pagestore utility) to restore the data to the newly formatted page files, i.e., the backup created in Task H, Distribute the segment data across the page data sets. Issue the following command, replacing nn with the segment number:
1.
Make sure that you use new backup names so that previous backups are not overwritten. This is especially important for the backup created in Perform a backup of the segment which is the fallback backup for this entire procedure.From the system console, issue the command to start the Data Object Broker. You may need to bring the expanded segment online, using dbonline, which is included in the following example:Procedure 1: Using Backup and Restore Utilities is the recommended procedure but if your segment does not have many tables you may find it more convenient to use the unload and load utilities instead.Issue the following command, replacing nn with the segment number:Use hrntlbps (Backup Pagestore utility) to back up the segment. Issue the following command, replacing nn with the segment number:
1. Issue the following command, replacing nn with the segment number:hrnbrptr -s nn -h -A snnAudit.txt -H snnHeader.txt -E snnError.txt -R snnReflog.txt -O snnOrphan.txt segnn.bak
3. Save a copy of the backup to an alternative location in case it is needed for recovery at a later stage in the process.Use hrnbrulb (Batch Unload utility) to unload the table data. For details, see TIBCO Object Service Broker for Open Systems Utilities.For each table to be unloaded from the segment, you must prepare control statement information using the BATCHUNLD_CARDS tool. For details, see TIBCO Object Service Broker Shareable Tools.
1. Edit the dbdef file in the database folder under your TIBCO Object Service Broker install folder.
2. Locate the “DB TYPE=PAGE,ACBS=n,…” statement for the segment you want to expand.
3. Refer to TIBCO Object Service Broker for Open Systems Installing and Operating for information about the dbdef file.Use hrntlfps to initialize the new page files in the segment. Issue the following command, replacing nn with the segment and page numbers:Use hrnbrtbl (Batch Load utility) to load the table data. For details, see TIBCO Object Service Broker for Open Systems Utilities.For each table to be unloaded from the segment, you must prepare control statement information using the BATCHLOAD_CARDS tool. For detailed information about this tool refer to TIBCO Object Service Broker Shareable Tools.Use hrntlbps to backup the expanded segment. Issue the following command, replacing nn with the segment number:
1. Issue the following command, replacing nn with the segment number:hrnbrptr -s nn -h -A snnAudit.txt -H snnHeader.txt -E snnError.txt -R snnReflog.txt -O snnOrphan.txt segnn.bak
3. Save a copy of the backup to an alternative location in case it is needed for recovery at a later stage in the process.From the system console, issue the command to start the Data Object Broker. You may need to bring the expanded segment online, using dbonline, which is included in the following example:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |