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


Chapter 3 Using Static SQL : Task A: Log DB2 Accesses

Task A: Log DB2 Accesses
When you complete a TIBCO Object Service Broker application, you must log the TIBCO Object Service Broker DB2 access statements to generate Static SQL.
Procedure
Ensure that you have an Execution Environment available with the DB2LOG Execution Environment parameter set to Y. To collect TIBCO Object Service Broker DB2 access statements, run the application using this Execution Environment. Accesses are collected in session tables while the application is running, and written to TDS tables at logoff time. Refer to , Collecting TIBCO Object Service Broker DB2 Access Statements for more information.
Only one Static SQL handler is created for each TIBCO Object Service Broker DB2 table. If a table is accessed by more than one application, all these applications must be run. If you modify your application, you must rerun the application, or only the portion of the application that changed, to collect any new TIBCO Object Service Broker DB2 access statements.
 
See Also
TIBCO Object Service Broker Parameters for further information on parameters.

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