![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Administrator’s workbench 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.
The segment number of the Pagestore segment to which you want the number changed.
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.
• 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.
• MOVTAB ignores the location parameter of the input table. Minimal table definitions are not allowed.
• The input table cannot be a TIBCO Object Service Broker system table (for example, Table of Tables or Table of Fields).
• MOVTAB runs and updates are made even if it is called in a transaction that is running in browse mode.
Do not UNLOAD the table definition as well. This would cause the LOAD in step #4. to fail, because the table already exists.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.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.
Raised if the user is not authorized to change the definition of the table. Raised if the definition of the table is minimal or the table type is not TDS.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |