Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
Implementing Siebel Business Applications on DB2 for z/OS > Maintaining Siebel Business Applications on DB2 for z/OS > Dynamic SQL in the Siebel Application > About Spooling SQL in the Siebel ApplicationUsing spooling with the Siebel application can be useful for several reasons:
You can then run the SQL manually, either from the midtier computer, for example using the DB2 Command Center, or on the DB2 for z/OS host, for example using tools such as SPUFI, to see what data is being returned. To minimize the amount of SQL tracing produced, and, therefore, the size of the log files, limit the tests to the minimum number of screen changes needed to allow the issue to be reproduced. If possible, spool SQL on a Developer Web Client as you have more control over the testing which makes it easier to minimize the amount of SQL traced. NOTE: The z/OS-specific parameters of SQL statements are not displayed in the spool files. Add appropriate values for the z/OS parameters to the spooled SQL to ensure that the output of any Explain statements you run on the spooled SQL is not misleading. Turning on SQL Spooling for the Application Object Manager and the Database ConnectorYou can turn on component event logging for the Developer and Mobile Web Clients and the server component. You can spool the SQL generated by the Siebel Application Object Manager and by the database connector but do not turn on spooling for both. If you do, the amount of data returned will be confusing. To turn on SQL spooling for the Application Object Manager
To turn on SQL spooling for the database connector
For some components, the SQL Profiling event can be used to identify the most poorly performing queries. For Developer Web Clients, you can also set these component events as environment variables. They work in addition to the spooling options. |
![]() ![]() |
Implementing Siebel Business Applications on DB2 for z/OS | Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |