(Craig Mullins) What is the difference between DB2 and Oracle in the OS/390 environment? And which one is better? I couldn’t find a clear and fair answer to this question. (R)
Other News
Bridge the Gap Between Development and Operations with Whitehorse
(Brian A. Randell and Rockford Lhotka) Whenever you want to use a modeling tool to describe software systems, you’re frequently faced with a serious investment of time and money. Often the diagrams that result look great, but are quickly forgotten as development gets into full swing. While there are
IBM DB2 Partitioned Install Across Multiple Nodes
This installation was done on Red Hat Enterprise Linux AS with IBM DB2 Ver.8.1. The installation was across four nodes.
Web services Programming Tips and Tricks: WSDL file imports
(Russell Butek) This tip explains the nuances of the two types of import statements found in a Web Services Description Language (WSDL) file.
Show Us Your ID
(Tod Newcombe) For years, counties have struggled to automate one of government’s most paper-intensive transactions. The recording of land documents leapt forward in the mid-1990s when imaging technology first turned paper deeds, titles and releases into digital images that could be electronically c
mod_auth_ibmdb2: A novel authentication method for Apache
(Helmut K. C. Tessarek) This article shows you step by step how to compile and configure mod_auth_ibmdb2 (an Apache authentication module) using IBM DB2 Universal Database (UDB) as the database for storing user and group information. It explains the creation and use of the User Defined Functions
Global variable diagnostic script
(Darren Green) There is often some confusion about the real value of a global variable at run-time, or the current execution location and security context. This simple script will illustrate what is really going on. When trying to debug a package and isolate the problem, it is not always practic
Securing Passwords in Your Database
(Zak Ruvalcaba) If you’re building an Intranet application within your organization, for instance, you might choose to use Windows authentication. Configuring Windows authentication within IIS is fairly straight forward and involves only two steps.
Watching SQL Execute on Oracle – Part II
(James Koopmann) In the first of this series we looked at how to determine if sessions were running SQL from the V$SESSION & V$SESS_IO views and then how to extract the particular SQL from the V$SQLAREA & V$SQL_TEXT views. This article will take us a bit further and look deeper into SQL statemen
SQL Server 2000 Driver for JDBC Service Pack 3
Since its release in early 2002, the Microsoft SQL Server 2000 Driver for JDBC has been very well received by the Java developer community and Service Pack 3 addresses issues discovered since the release of Service Pack 2. Enhancements added to this driver since its original release include: support