Copyright © Cloud Software Group, Inc. All Rights Reserved

hrnbrset (Batch Segment Re-initialization)

Syntax

hrnbrset -A auditfile -s segment_number

Platforms

Windows, Solaris

Description

The hrnbrset (Batch Segment Re-initialization) utility re-registers empty TDS tables into any specified segment on the Pagestore (except segment 0).

This utility is useful in situations where specific data is periodically purged and reloaded into TIBCO Object Service Broker in its entirety, for example, daily sales data. The transient data is normally stored in a separate Pagestore segment. This utility can be used to:

•	Rebuild the resident table index (RTIX)

•	Create the empty tables

•	Rebuild the secondary index structures for the deleted tables (TDS tables only)

Having used the hrnbrset utility to build the empty table and index structures, you can load/reload the data using either the LOAD tool or the hrnbrtbl (Batch Load) utility.

Prerequisite

The target segment must be reformatted using the (hrntlfps (Format Pagestore) utility before invoking the hrnbrset utility.

Arguments

 

Argument	Description
-A auditreport	The file to which the audit report is written. If this argument is omitted, the report defaults to stdout.
-s segment_number	The offline segment number. This is a mandatory argument and can be any segment other than segment 0.

Constraints

The following constraints apply:

•	The target can be any segment except segment 0 (the MetaStor).

•	The TIBCO Object Service Broker system must be active.

•	The target segment (the one to be re-initialized) must be offline.

Since this utility updates the segment offline and does not perform journaling, you must back up any changes you make to the target segment. For information about backing up a segment, refer to TIBCO Object Service Broker for Open Systems Managing Backup and Recovery.

Invocation

The steps to analyze, clear, and re-initialize the segment are as follows:

1.	Format the segment (or re-format it if it already exists) using the hrntlfps (Format Pagestore) utility.

If you are employing the continuous backup method, be aware that your current backup contains page images for the segment you plan to re-initialize. As a precaution, after re-initializing the segment, consider filtering out any pages associated with that segment from your latest backup. For information about filtering your backup, refer to TIBCO Object Service Broker for Open Systems Managing Backup and Recovery.

2.	Run the hrnbrset utility.

Environment Variables

OS_ROOT

Set this environment variable to indicate the directory under which TIBCO Object Service Broker is installed.

HURONDIR

Set this environment variable if the TIBCO Object Service Broker directory is not located in the default location of %OS_ROOT%\database\huron.dir on Windows or ${OS_ROOT}/database/huron.dir on Solaris.

Example

Windows

hrnbrset -A d:\audit\auditreport -s 1

Solaris

hrnbrset -A /usr1/audit/auditreport -s l

In these examples:

•	The audit report is written to the file auditreport in the directory d:\audit (Windows) or /usr1/audit (Solaris).

•	The target segment is segment 1.

•	The hrnbrset utility connects to the Data Object Broker specified in crparm, which is located in the database directory indicated by the OS_ROOT environment variable.

•	The hrnbrset utility builds any missing RTIX entries on segment 1. Segment 1 is located in the database directory, which is located in the directory indicated by the OS_ROOT environment variable.

Sample Audit Log

The following illustrates a sample audit log for the hrnbrset utility:

---

 

*batchsrv OFFLINE BATCH UTILITY SERVER DATE 2007 MAR 19 TIME 01 28

Requested Utility: hrnbrset

 

HOST = REGULUS

 

 

PAGESTORE SEGMENT NAME SEG01 SEGMENT # 1 TYPE TDS - OPENED

 

 

 

*hrnbrset SET UP SEGMENT RTIX Date 2007 MAR 19 Time 01:28

 

Table @RULESLIBRARY - KEPT

Table ACCESSLOG - INSERTED

Table EVENTRULES - KEPT

Table FIELDS - KEPT

Table ORDERING - KEPT

Table PARMS - KEPT

Table PROJ3278 - INSERTED

Table PR23936 - INSERTED

Table PR24936 - INSERTED

Table SCREENFIELDS - KEPT

Table SCREENS - KEPT

Table SCREENTABLES - KEPT

Table SELECTION - KEPT

Table TABLES - KEPT

 

 

PAGE I/O SUMMARY

 

TOTAL PAGES FREED 00000000050

 

TOTAL PAGES READ 00000000029

 

TOTAL PAGES UPDATED 00000000006

 

* START TIME 01:28:27 END TIME 01:28:28

 

 

PAGESTORE SEGMENT NAME SEG01 SEGMENT # 1 TYPE TDS - CLOSED

 

Connection with Host terminated

---

 

If an error condition exists, execution of the hrnbrset utility is terminated. You should investigate the cause of the error, correct it, and execute the hrnbrset utility again. Messages generated by this utility are explained in TIBCO Object Service Broker Messages With Identifiers.

Copyright © Cloud Software Group, Inc. All Rights Reserved