When calls to retrieve schema information from DB2 on the OS/400 V4R4 are issued with IDBSchemaRowset using the Microsoft OLE DB Provider for DB2 or with SQLTables using the Microsoft ODBC Driver for DB2, 100 percent CPU utilization occurs for that process.
Tag: IBM
DB2 Interview Questions
Needs description
Build asynchronous apps using WebSphere MQ and DB2 UDFs
This tutorial shows you how to build asynchronous applications using DB2, WebSphere MQ and WebSphere Application Developer. (R)
Taming the Wild West, Part 2
(Michael Dougherty) Part 1 of this series explained how corporate portals and intranet sites sprang up in a fairly lawless environment. Corporate overseers rode into town in the late 1990s, but governed mostly at the local (departmental) level. Today, Web content management (WCM) systems provide
Taming DB2 Performance Issues
(Craig S. Mullins) One of the biggest problems faced by companies today is keeping applications running at peak efficiency. It can be a never-ending task to diligently keep collecting, examining, and reacting to performance-oriented statistics. This is certainly the case for DBAs charged with mainta
INFO: MTS/IIS Interoperability with IBM DB2, Using Two-Phase Commit Through MSDTC/XA
Any transactional Microsoft Transaction Server (MTS) activity (in other words, a transactional MTS component or Internet Information Server [IIS] Active Server Page) calls upon Microsoft Distributed Transaction Coordinator (MSDTC) to initiate an OLE TX transaction, which is a two-phase commit protoc
Create a Lotus Notes application to access DB2 using Domino Designer
(Long Fong Yee and Suita Gupta) This article will show you how easy it is to create an IBM Lotus Notes application, using Domino Designer, to access enterprise data stored in an IBM DB2 Universal Database (UDB). You will learn how to create an application to select, update, delete and insert data. Y
Exception handling
(Paul Yip, Drew Bradstock and Hana Curtis) Anticipating and handling conditions is part and parcel of good, robust programming style. With DB2 SQL procedures, this is accomplished through the use of condition handlers. In fact, it is also desirable to be able to check for and act on warnings that ma
Records management: Step-by-step programming IBM DB2 Records Manager V3.1 with WebSphere Studio Application Developer
(Naga Ayachitula) This is an introductory article on programming for IBM DB2 Records Manager. In this article we will walk step-by-step through an example showing how to create a program for IBM DB2 Records Manager using WebSphere Studio Application Developer.
INFO: Permissions Needed to Create Packages Using DB2OLEDB on DB2 and DB2/400
The Microsoft ODBC Driver for DB2 and the Microsoft OLE DB Provider for DB2, each of which are implemented as an IBM Distributed Relational Database Architecture (DRDA) Application Requester, use packages to issue dynamic SQL statements after connecting to DB2 running on supported platforms. This
