Copyright © Cloud Software Group, Inc. All Rights Reserved

S6BBRCLR (Batch Table Clear)

S6BBRCLR deletes all data from a TDS table. This offline utility performs the same function as the $CLRTAB tool.

S6BBRCLR deletes all data in the table specified in the PSTABLE parameter. This batch utility operates in the same way as the online table clear; however, with this utility you can delete and load a table within a single job stream, provided that the segment containing the specified table is offline.

To ensure the integrity of your continuous backup after you run the S6BBRCLR utility, you must back up the segment containing the new data. For information about backing up a segment, refer to TIBCO Object Service Broker for z/OS Managing Backup and Recovery.

Invocation

The S6BBRCLR member of the JCL data set as distributed with TIBCO Object Service Broker contains sample JCL required to run this utility. This sample is provided as a reference only; modify the JCL for your needs.

Constraints

•	The segment containing the specified table must be offline.

•	S6BBRCLR cannot be used to delete data from a selected table instance of a parameterized table. To delete data from a selected table instance, you should use the $CLRTAB tool.

Online transactions are often subject to your site’s chosen transaction limits. If you exceed your online transaction limit, you must use S6BBRCLR to clear the table while it is offline.

Sample Report

The following illustrates the S6BBRCLR report:

---

 

S6BBRCLR BATCH CLEAR MONTHLY_SALES DATE 2009 APR 23 TIME 11:49

TABLE CLEAR SUMMARY

TOTAL PAGES FREED 4

TOTAL PAGES UPDATED 1

START TIME 11:49:05 END TIME 11:49:05

---

 

See Also

TIBCO Object Service Broker Messages With Identifiers for messages associated with this utility and TIBCO Object Service Broker Shareable Tools for details on $CLRTAB.

Copyright © Cloud Software Group, Inc. All Rights Reserved