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


Chapter 4 Managing DB2 Data Definitions : Effects of DB2 Column Selection on DB2 Processing

Effects of DB2 Column Selection on DB2 Processing
Take the following effects into consideration when selecting DB2 columns for a TIBCO Object Service Broker DB2 table definition:
Only the DB2 columns you select in your TIBCO Object Service Broker DB2 table definition are requested from DB2. Consequently, if these columns reside in the DB2 index, DB2 could return results without having to read its data pages.
If you choose DB2 columns as parameters that correspond to a unique key of a DB2 table, you can insert only a single row using this definition. This is because the Gateway combines the parameter values with the TIBCO Object Service Broker primary key values, causing an attempt to insert a duplicate row to DB2.

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