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


Chapter 10 Re-allocating the Segment Number : Procedure to Change a Segment Number

Procedure to Change a Segment Number
Changing the segment number consists of the following tasks:
1.
2.
3.
These tasks are described in the following sections.
 
Task A Unload or Clear the Data
If the table contains data, use the following table to determine the method you should use to unload or clear the data from the table:
S6BBRULH/hrnbrulh or S6BBRULB/hrnbrulb
Task B Change the segment number
The following methods are available to change the segment number:
The MOVTAB tool supplied by TIBCO Object Service Broker
Using the Define Table Option
To use the Define Table option, complete the following steps:
1.
A list of tables similar to the following illustration appears.

 
List of defined tables
Command ==> Scroll P
Enter one or more line commands or a primary command
NAME TYPE CREATOR CREATD UNIT MODIFIER MODIFD BI*
---------------- ---- -------- ---------- -------- -------- ---------- ---
_ ABC1 TDS USR40 2000-04-07 USR40 USR40 2000-04-07 N
_ DATA_SRCH_EX TDS RPSUSR 2000-04-06 SEARCH SEARCH 2000-04-06 N
_ DATA_SRCH_EXCLUD TDS RPSUSR 2000-04-06 SEARCH SEARCH 2000-04-06 N
_ FOOTA TDS ABC10 2000-04-03 ABC10 ABC10 2000-04-03 N
_ FOOTAS SUB ABC10 2000-04-03 ABC10 ABC10 2000-04-03 N
_ DATA_SRCH TDS RPSUSR 2000-03-28 SEARCH SEARCH 2000-03-28 Y
_ LOCTEST TDS RPSUSR 2000-03-09 RPSUSR RPSUSR 2000-03-09 N
_ LOCTESTS SUB RPSUSR 2000-03-09 RPSUSR RPSUSR 2000-03-09 N
_ DOC_TABLES TDS RBPADM 2000-03-09 RPSUSR RPSUSR 2000-03-09 N
_ SESSTST2 TDS RPSUSR 2000-03-06 RPSUSR RPSUSR 2000-03-06 N
_ DATA_SRCH_ERR SES RPSUSR 2000-03-06 SEARCH SEARCH 2000-03-06 N
_ DATA_SRCH_RESULT TDS RPSUSR 2000-03-06 SEARCH SEARCH 2000-03-06 Y
_ DATATEST TDS RPSUSR 2000-03-06 SEARCH SEARCH 2000-03-06 N
_ NRGTEST TDS USR40 2000-03-06 USR40 USR40 2000-03-06 N
_ USRWEB TDS USR00 2000-03-06 USR40 USR40 2000-03-06 N
_ @EMPLOYEE2 TDS USR50 1999-12-14 DOCEXMPL USR50 2000-03-05 N
B-Bind C-Clear D-Delete M-Move P-Prt R-Reset Bind S-Sel X-SIX Bld/Del
PFKEYS: 12=EXIT 13=PRINT 3=END 5=FIND NEXT 9=RECALL

 
2.
Type the line command M beside the required table.
3.
The following screen appears to enter a new segment number.

 
 
To complete this command:
NAME TYPE CREATOR CREATD UNIT MODIFIER MODIFD BI*
---------------- ---- -------- ---------- -------- -------- ---------- ---
M @EMPLOYEE2 TDS USR50 1999-12-14 DOCEXMPL USR50 2000-03-05 N
Enter parameter(s): Destination segment number
SEGMENT# ===>
 
PFKEYS: ENTER=PROCESS 3=PROCESS 12=CANCEL

 
4.
5.
Using MOVTAB
To use the TIBCO Object Service Broker supplied MOVTAB tool, execute it from a rule by specifying:
CALL MOVTAB(tablename, segmentID);
where
 
Task C Reload the table
If you unloaded the data from your table after changing the segment number of the table, use the LOAD tool to reload the data. For a large table, you can use the batch utility S6BBRTBL/hrnbrtbl.
See Also
TIBCO Object Service Broker Shareable Tools for more information about MOVTAB, UNLOAD and $CLRTAB.
Utilities for your operating environment for more information about the S6BBRTBL/hrnbrtbl, S6BBRULH/hrnbrulh, S6BBRULB/hrnbrulb, and S6BBRCLR/hrnbrclr batch utilities.
 

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