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


Chapter 3 Tools : MOVTAB

MOVTAB
Changes the segment number of a table. (CE)
Invocation
Do one of the following:
Press Enter. A listing of tables for your TIBCO Object Service Broker database appears.
Type the line command M beside the table whose segment number is being changed and press Enter. A screen similar to the one below appears.
Type CALL MOVTAB (tablename, segmentid)
Where:
 

 
To complete this command:
 
NAME TYPE CREATOR CREATD UNIT MODIFIER MODIFD BI*
--------------- ---- ------- ---------- ------- ----------- -------- ----
M EMPLOYEE_EXPENSE TDS USR50 1999-12-13 JZH USR50 2000-03-16
Enter parameter(s): Destination segment number
 
 
SEGMENT# ===>
 
 
 
 
 
PFKEYS: ENTER=PROCESS 3=PROCESS 12=CANCEL

 
In the field SEGMENT #, type the new segment number and press Enter or PF3 to process the change. Press PF12 to cancel the change.
MOVTAB does not take part in the TIBCO Object Service Broker two-phase commit/intent list protocol. We strongly recommend that you do not use this tool in a transaction that accesses or updates data within the same table. It should also normally be the only logical unit of work within a transaction.
Usage Notes
MOVTAB is used to change the segment number of a table. This number is stored in the Resident Table Index (RTIX). The change occurs at the physical level and does not affect the logical view of that table.
Tables Containing Data
If the table contains data, complete the following steps:
1.
Use UNLOAD to export a copy of only the data to a temporary file.
If the table is large, consider using one of the batch unload utilities to unload the data to a file. For more information on the batch unload, refer to TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities.
2.
Use $CLRTAB to clear all data from the table.
3.
4.
Use LOAD to reload the data.
To load large volumes of data quickly, consider using the batch load utilities. For more information on the batch load, refer to TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities.

Exceptions
 
 

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