![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
Refer to Appendix C, Null Handling for information on the method used by the unloads to preserve null values in the unload file. The unloads use specific field values to represent nulls in the unload file.Selecting the Correct Utility
TIBCO Object Service Broker condition… Condition of Pagestore segment containing data to be unloaded
S6BBRULH extracts all data in a table or selected table instances of a parameterized table. When unloading data from an online database, consider the effect on the resulting unloaded copy of any updating activity going on in the table being unloaded.Tables must not be empty. Parameterized table instances selected for inclusion in the unloaded file using the equals (=) relational operator must exist in the table at unload time.
The control card file specifies the definition of the table to be unloaded. The CNTRL file should be defined as fixed block, record length 80. The selection file is optional. It contains criteria for selecting table instances from a parameterized table set. If a SELECT file is required, it should be defined as fixed block, record length 530.
The unload file contains all the data extracted during the execution of the batch unload process. The layout of the text area within the file is reported in the AUDIT trail.The UNLOAD file should be defined as variable block, with a maximum record length of 4100. This SYSPRINT file contains the table definition, selection criteria, table instances unloaded, and summary information. Refer to the sample audit report in Review the Audit Trail Report.In addition to these files, the S6BBRULB utility (used when TIBCO Object Service Broker is down or the segment is offline) uses the following data set:
The Pagestore definition. DBDLIB is not referenced when you use S6BBRULH to unload from an active TIBCO Object Service Broker system.Define and submit JCL to run on offline or online segments, as shown in the following sections.The S6BBRULB member of the JCL data set distributed with TIBCO Object Service Broker contains sample JCL required to run a batch unload with TIBCO Object Service Broker shutdown or with the specified Pagestore segment offline.The S6BBRULH member of the JCL data set distributed with TIBCO Object Service Broker contains sample JCL required to run an unload with the TIBCO Object Service Broker system up and running.
•
• As parameters for S6BBRULH, you specify the Data Object Broker communications identifier and the pattern used for selecting the Execution Environment communications identifier. If required, you must also provide the user ID and password to obtain security clearance.
For compatibility with null handling techniques used in earlier TIBCO Object Service Broker releases, you can use the Execution Environment parameter setting OLDNULL=Y. For more information on this feature, refer to Appendix C, Null Handling.The audit trail report provides information about the execution of the batch unload process. The audit trail for the S6BBRULB and the S6BBRULH processes are identical except for the module name, which appears at the left margin of the page header line.
• If you use either of the batch unload utilities to unload data, you can reload the data by using the batch load utility or by treating the data as a TIBCO Object Service Broker import file. However, you cannot treat the data as an import file when binary or packed fields are to contain numeric syntax null values. Null values are preserved only by using the batch load and unload utilities. Refer to Appendix C, Null Handling for more information.
• If you are using FTP to transfer unloaded data between z/OS and Windows or Solaris, transfer the files in binary and specify the z/OS FTP LOCSITE subcommand with the RDW parameter.Security on S6BBRULHUnloading is not permitted under either of the following conditions:
• If the requestor is either the owner of the target table or the security administrator of the owner, the request is allowed.If the requestor is neither the owner of the target table nor the security administrator of the owner, and the requestor’s security classification is less than the security clearance required of the target table, the request is denied.
• If the requestor has READ ACCESS to the target table by virtue of direct permission granted to the user ID or the current group, for example, the request is allowed; otherwise, the request is denied.
• The USERID entered in the U=userid parameter in the EXEC statement.
• The USERID (owner) of the job step (JOB statement USER=), which is assumed secured by z/OS security. This USERID is used only if no USERID is provided in the EXEC statement PARM.If a USERID is supplied in the EXEC PARM statement and it differs from the job step’s USERID, a TIBCO Object Service Broker password must be provided in the EXEC parameter P=password.
Do not use password if U=uuuuuu is not included.
If this format is used, it is not necessary to include U=uuuuuu if the job step user ID is also the TIBCO Object Service Broker user ID.If the security check determines the request to be unauthorized, the utility writes the following error message to the audit report:
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |