![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Unloads definitions of valid TIBCO Object Service Broker object types from a source system to a z/OS data set or a Windows or Solaris file. Data from table object types could also be unloaded. (E)
Administrator’s workbench Developer’s workbench
After selecting all the definitions required, or in the case of tables, all the data or definitions, press PF3 to unload. This returns you to the workbench and a message appears indicating where the log of your activities is.After unloading the items, use LOAD from within your target system to load the items. If you want to cancel the unload, press PF12 from within the Unload screen.
Specifies the name of the file where the unloaded items are to be placed. It can be re-used at a later time with the contents being overwritten. Location (for all objects) If the objects to be unloaded are located on a remote node, type the name of the node where they are located. Default Library Enter the name of the default library from which rules are to be unloaded. Default Environment Specifies the destination where the messages are logged. Press PF1 for a list of valid values. A protected field that displays the number of objects that are selected to be unloaded.
• Press PF5 to display a selection screen. Refer to Object Selection Screen for more information.Use the bottom portion of the Unload screen to specify the objects to unload. This section contains the following fields:
Specifies the amount to scroll when you use the scroll keys PF7 and PF8. Valid entries are: P (page), H (half a page), M (maximum), nn (number of lines). The name of the object or objects to unload. Using the EOF key, you can also delete the name of objects you no longer require. You can also delete the name by pressing Delete, Backspace, space bar. The name of the object type for the object specified in the Object Name field. Press PF1 for a list of valid values. Library or Environment Enter the name of the rules library from which to unload individual rules.Because you can unload both the definition and the data for objects of type Table, use an additional section entitled “For Tables” for Table object types. Values are entered by default into the fields Type, #Prms, Defn?, and Data?. You can modify the fields Defn?, Data?, and All Inst as follows:Defn? – The default is N (no), do not unload the definition of the table. You can change this to Y (yes), unload the definition.Data? – The default is N (no), do not unload the data of the table. You can change this to Y (yes), unload the data. If you change it to Y, you can select the instances that you require or leave it as the default for all instances.To select the instances, position your cursor on the table name that you are selecting and press PF6. A screen similar to the one here appears.
A more indicator (-> or <-) shows if there is additional information to view to the left (PF10) or right (PF11) of the displayed screen. Use this field to narrow your search for parameter values to select. Specify one parameter, an operator, and a parameter value in the blank spaces to the right of this field and press PF23. Your cursor is positioned on the first instance that meets this minimal criteria. Press PF5 to find the next instance that meets this criteria.You can specify only up to 30 characters for the parameter value. You can use the LIKE operator with the wild card character asterisk (*) to assist you for values that are longer. You can specify the amount that you want to scroll when you use the scroll keys. Valid entries are: P (page), H (half a page), M (maximum), nn (number of lines).The lower portion of the screen displays the parameter names and parameter values for the table. You use this portion to select the instances that you require. To select table instances, type an S in the line command field of the instances that you require and press Enter.
Displays a list of the full parameter values for the table instance that your cursor is positioned on. Use this if the parameter values are greater than 30 display characters each, which is the limit for this screen. Selects the instances that meet the selection criteria specified in the FIND/SELECT field.Pressing PF5 from the Unload screen displays the screen shown below. You can use this screen to select the objects to be unloaded.
The name of the node where the selection criteria are applied. If you do not specify a value, your home location is used. Library (for RULES) If the selection list is to contain rules, type the name of the rules library to be searched. Press PF1 for a list of valid values. Presentation Environment Specifies whether all the items displayed based on the selection criteria should be copied into the Unload screen. You can specify the amount that you want to scroll when you use the scroll keys. Valid entries are: P (page), H (half a page), M (maximum), nn (number of lines). Specify if you want to list all the child objects that an object is composed of. Valid values are:The middle section of the screen can be used to select the items to be unloaded, or to narrow down the selection list. You can use more than one type of selection criteria for each object type and you can specify multiple object types within one session. For a list of valid values for each of these fields, press PF1. For more information, refer to “Selection Criteria” below.When you press Enter after specifying the selection criteria, the selected items appear in the bottom portion of the screen. You can select the objects displayed in this section by typing an S in the line command field beside the objects. For more information, refer to the following “Selection Criteria”.
If you know the name of the item, enter the logical operator to be used in the Op field. Type the name of the object in the Value field. The name of the object type. Press PF1 for a list of valid values. If you do not supply an object type, you must specify a value in at least one of the other selection fields. If you specify only an object type and no further selection values, a listing of the items for the object type defined in your TIBCO Object Service Broker database appears for further selection. In the Op field, type the logical operator to be used. In the Value field, type the name of the unit associated with the object. In the Op field, type the logical operator to be used. In the Value field, type the name of the author of the object.
You can specify the amount that you want to scroll when you use the scroll keys, using the Scroll field. Valid entries are: P (page), H (half a page), M (maximum), nn (number of lines).
• UNLOAD captures all the children of an object—these do not have to be explicitly specified.
• Definitions of all table types can be unloaded using the UNLOAD tool. However, data from only TDS and SES tables can be unloaded using the UNLOAD tool.
• On non-z/OS systems, set the DSBIFTYPE Execution Environment parameter according to the following:
From Windows to Windows,
or from Solaris to Solaris. LENGTH_PREFIXED_EBCDIC or LENGTH_PREFIXED_EBCDIC_NATIVE_ENDIAN. Windows to Solaris,
or from Solaris to Windows. This setting can affect the behavior of other tools. For more information on the DSBIFTYPE Execution Environment parameter, refer to TIBCO Object Service Broker Parameters.
• To unload large volumes of data quickly, consider using one of the batch Unload utilities (S6BBRULH /hrnbrulh or S6BBRULB/hrnbrulb). For more information on these utilities refer to TIBCO Object Service Broker for z/OS Utilities or TIBCO Object Service Broker for Open Systems Utilities.
• This tool should be run in Browse mode (that is, set the BROWSE field at the top of the workbench to Y).
• For unloading to a z/OS data set, it is recommended that you pre-allocate the data set as follows: RECORD FORMAT - VB, LRECL >=2250 (2250 is the minimum for unloading rules and that 250 is the minimum for table definitions). It can be a partitioned data set. To optimize LRECL when unloading data, use EXPOCC_SIZE. Depending on your environment, the data set could have to be authorized for you to use it.
• For unloading to a Solaris file only, specify a name that uses all uppercase letters. For Windows or Solaris, specify either the full path or only the filename. If you specify only the filename, the DSDIR Execution Environment parameter must be set to point to the directory to use. Refer to TIBCO Object Service Broker Parameters for more information about this parameter.
• To unload the table instances of a parameterized table, you must have a parameter value (PRM) table defined.
• If UNLOAD is executed using the EX option from the workbench, the search path used for event rules is local, installation, and then system. If UNLOAD is executed using the LO or UL options from the Administrator’s menu, the search path is the system library since the search path is indicated in @MENU_ITEMS(@ADMIN) as S.
• If you are using FTP to transfer unloaded data from z/OS to Open Systems, you must either issue FTP’s QUOTE SITE RDW command before sending the file from z/OS, or run the S6BBRFRU (Reformat TIBCO Object Service Broker Files Transferred with FTP) utility against the file on z/OS before using FTP. Refer to TIBCO Object Service Broker Parameters for more information about S6BBRFRU.
• To load on z/OS a file unloaded on Windows or Solaris, simply FTP the file, in binary format, from the platform of origin to z/OS.
• To UNLOAD a DB2 table definition from the current release in Release 5.0.0 format, set Library to S6B50DB2 and execute the UNLOAD tool. To verify that your definition is compatible with Release 5.0.0, set Library to S6B50DB2 and execute the rule CHK_COMPATDB2TBL(tablename).
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |