Browse by Tags

BizTalk Adapter for DB2 and the SQLCAMESSAGE DB2 Procedure
01 November 07 04:44 PM | ricardom | 0 Comments   
QUESTION: When there is a failure calling a Stored Procedure using the BizTalk Adapter for DB2, you may see that some other SP´s are also called. You can also see that there is no relationship between this extra calls and the one that fails. A trace can Read More...
DB2 Buffer Pools and the BizTalk Adapter for DB2
01 August 07 03:25 PM | ricardom | 0 Comments   
The most important factors that impacts buffer pool configuration are a) structure of the database and b) structure of the queries running against this database. These two factors will ultimately define what will be the I/O profile of these database operations. Read More...
Tracing a DB2 Connection using HIS 2006 Trace Tool
07 December 06 01:53 PM | ricardom | 0 Comments   
Below you find the steps needed to collect trace data from a DB2 connection using the data providers shipped with HIS 2006: Navigate to the Start menu, select Run , type snatrace and hit Enter ; On the SNA Trace Utility window, click Clear All Traces Read More...

Search

This Blog

Syndication

Page view tracker