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


Chapter 3 Tools : UNLOAD

UNLOAD
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)
Invocation
Do one of the following:
UNLOAD of Definitions and Data Screen
Pressing Enter displays the screen shown here:

 
UNLOAD of Definitions and Data
File Name: Log msgs to: SCR
Location (for all objects): Object Count: 0
Default Library : USR40
Default Environment: 3270
 
Scroll Amount: P
 
|-------- For Tables -------|
Object Object Library or All
Name Type Environment Type #Prms Defn? Data? Inst
---------------- ---------------- ---------------- --- - - - -
 
 
 
 
 
 
 
 
 
 
PFKEYS: 5=SELECT OBJECTS 6=INSTANCE SELECT 3=UNLOAD 12=CANCEL

 
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.
Top Section
The following describes the fields of the UNLOAD of Definitions and Data 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
Default Environment
You can do one or both of the following to specify objects to be unloaded:
Bottom Section
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
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.
Instance Selection Screen
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.

 
Place an "S" beside the parameter values for instances to be unloaded;
if NO values are selected, occurrences for ALL instances are unloaded.
 
TABLE: ( #parameters: ) ...more ->
 
-> FIND/SELECT ________________ ____ ______________________________
(parm name) (op) (unquoted value or pattern)
 
 
------------------------------ ------------------------------ Scroll:
_
 
 
 
 
 
 
 
 
 
 
 
 
PFKEYS: 10=LEFT 11=RIGHT 5=FIND 23=SELECT 6=DETAIL 16=UNSELECT 3=SAVE 12=CANCE

 
Fields
 
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.
PF Keys
You can use the following PF keys in this screen:
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.
Object Selection Screen
Pressing PF5 from the Unload screen displays the screen shown below. You can use this screen to select the objects to be unloaded.

 
O b j e c t S e l e c t i o n
COMMAND ==>
Location: Select All: N
Library (for RULES): List Children: N
Presentation Environment:
+-------------------- Selection Specification -----------------+
| Attr Op Value |
| ------ ---- ---------------- |
| NAME ____ ________________ AND unspecified |
| TYPE = ________________ AND attributes will |
| UNIT ____ ________ AND be ignored |
| AUTHOR ____ ________ |
+--------------------------------------------------------------+
Scroll:
Name Type Library Environment Unit
---------------- ---------------- ---------------- ---------------- --------
 
 
 
 
 
 
PFKEYS: ENTER=UPDATE 3=SAVE SELECTION 12=CANCEL

 
Specify the following information in the fields:
Top Section
 
The name of the node where the selection criteria are applied. If you do not specify a value, your home location is used.
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).
Middle Section
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.
Bottom Section
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”.
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.
PF Keys
You can use the following PF keys in this screen:
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).
Usage Notes
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.
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.
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 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).
Example
Sample UNLOAD of Definitions and Data Screen
The figure below shows a sample screen for unloading the definitions of several tables:

 
UNLOAD of Definitions and Data
File Name: DOC01.UNLOAD.EXAMPLE(EMPTABLE) Log msgs to: SCR
Location (for all objects): Object Count: 4
Default Library : DOCTOOLS
Default Environment: 3270
Scroll Amount:
|-------- For Tables --------|
Object Object All
Name Type Library Type #Prms Defn? Data? Inst
---------------- --------------- -------- --- - - -
EMPLOYEES_0DPARM TABLE TDS 0 Y N
EMPLOYEES_1DPARM TABLE TDS 1 Y N
EMPLOYEES_2DPARM TABLE TDS 2 Y N
EMPLOYEES_3DPARM TABLE TDS 3 Y N
 
 
 
 
 
 
 
 
 PFKEYS: 5=SELECT OBJECTS 6=INSTANCE SELECT 3=UNLOAD 12=CANCEL

 
Sample Object Selection Screen
The figure below shows a sample screen used to select objects:

 
O b j e c t S e l e c t i o n
COMMAND ==>
 
Location: Select All: N
Library (for RULES): DOCTOOLS List Children: N
Presentation Environment: 3270
 
+-------------------- Selection Specification -----------------+
| Attr Op Value |
| ------ ---- ---------------- |
| NAME LIKE EMPLO*__________ AND unspecified |
| TYPE = ________________ AND attributes will |
| UNIT ____ ________ AND be ignored |
| AUTHOR ____ ________ |
+--------------------------------------------------------------+
Scroll: P
Name Type Library Environment Unit
----------------- ---------------- ---------------- ---------------- --------
_ EMPLOYEEIDM TABLE USR40
_ EMPLOYEES TABLE ACC
s EMPLOYEES_0DPARM TABLE ACC
s EMPLOYEES_1DPARM TABLE ACC
s EMPLOYEES_2DPARM TABLE ACC
s EMPLOYEES_3DPARM TABLE ACC
 
 
 PFKEYS: ENTER=UPDATE 3=SAVE SELECTION 12=CANCEL

 
Sample Message Log
The figure below shows the message log summarizing the results of the unload.

 
-------------------------- INFORMATIONAL MESSAGE LOG --------------------------
COMMAND ===> SCROLL ===> P
H U R O N MESSAGES
Date: March 14, 2000
Report on UNLOAD Status of Obje
 
Tally of objects UNLOADED
 
OBJECT COUNT
 
TABLE DEFN 4
 
-------------------------------------------------------------------------------
 
Unloading definitions of TABLEs
 
NAME NAME NAME NAME
 
EMPLOYEES_0DPARM EMPLOYEES_1DPARM EMPLOYEES_2DPARM EMPLOYEES_
 
Above message occurred 4 times
 
 PFKEYS: 2=NEXT LOG 3=EXIT 5=REPEAT 12=EXIT 13=PRINT

 

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