DB2 Coding & Development


Table Spaces and Locking Levels, Part 2 By Bonnie Baker

Version 8 For Developer's Only by Craig S. Mullins


Beyond Conventional Wisdom by Jonathan Sayles

Managing Application Binding for Performance and Availability by Keith Mullins

Table Spaces And Locking Levels, Part 1 by Bonnie Baker

Plans + DBRMS + Packages + Collections + Versions = Confusion by Bonnie Baker

IBM Strengthens the Mainframe as a Premier Data Platform With Plans for Breakthrough Processor

Some SQL Tricks for the DB2 Developer by Craig S. Mullins

DB2 for z/OS Application and SQL Performance Trade-Offs by Daniel L. Luksetich

DB2 for z/OS Application-Level Performance Reporting and Tuning by Daniel L. Luksetich

Executing a Batch Job as Part of CICS/DB2 Transaction by Abhiram Jayaram

Need a Date? Here's DB2's Answer- Using Chronological Data in DB2 Chronological Data Type Formats
by Tink Tysor

Developing DB2 Applications: The Platform Choice is Yours

A Roadmap to Access DB2 from Java by John Mallonee

Java and the Wild, Wild Web (Part 1) by Maria Sarikos

Inline COBOL Error Display Utility

Java Batch Jobs on z/OS and OS/390 by Steve Goetze and Kirk Wolf

DB2 for z/OS: DB2 Universal Database concurrency by Fred Whitlark

Subqueries in the SELECT Clause by Rick van der Lans

Java SDKs for DB2 Development Center on OS/390 and z/OS by Peggy Rader

DB2 for z/OS and OS/390 : Squeezing the Most Out of Dynamic SQL

Non-Correlated Subquery Using the IN Predicate
by Hong Tie

The Secret Texts of DB2 Connect, Part One and Part Two
by Leon Katsnelson and Paul C. Zikopoulos , eserver Magazine
The IBM IBM DB2 Connect*product allows distributed applications to access DB2 for z/OS data typically provide one or more standard database drivers for distributed applications to access DB2 for z/OS data.

Generating Random Numbers in DB2
by Robert Catterall , DB2 Magazine

Generating a random number to populate a column in a DB2 table with options in the categories of generating the value outside of DB2 or using a DB2 facility to generate the value.

Recursion in DB2 V8, V8, V8…
by Craig S. Mullins, craigmullins.com
One of the most intriguing new features of DB2 for z/OS V8 is the ability to code recursive SQL. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of recursion is to think about a mirror that is reflected into another mirror and when you look into it you get never-ending reflections of yourself. This is recursion in action.

Much Ado About Nulls
by Bonnie Baker
On your OS/390 system, you'll find nulls can really be something.

ODBC: DB2 for z/OS and OS/390
IBM Corp.
All about Open Database Connectivity (ODBC), an application programming interface defined by Microsoft that provides a standard interface for accessing a variety of databases using SQL.

Object-Relational Programming with DB2
by Susan Lawson, informIT
This book excerpt covers the more robust features of DB2's SQL language including extended programming features, User-Defined Functions ( UDFs ), table functions, triggers, and user-defined data types ( UDTs ).

SQL Under the Covers
by Pranav Sampat , DB2 Magazine
Having an understanding of what DB2 does and how it responds to an SQL query can help you write more efficient queries and applications.

by Craig S. Mullins, Search390.com
SAVEPOINT, a feature added to DB2 for OS/390 under Version 7, could be the answer to your problem.

IBM z/OS Application Connectivity to DB2 for z/OS and OS/390
IBM Corp .
z/OS Application Connectivity to DB2 for z/OS and OS/390 is a no-charge, optional feature of DB2 Universal Database Server for z/OS and OS/390, Version 7, designed to deliver high performance and scalable remote connectivity for Java-based enterprise applications on z/OS to a remote DB2 for z/OS database server.

Thinking Big - Java Development with LOBs in DB2 Universal Database
by Kulvir Singh Bhogal , IBM developerWorks
A case study to to show you how to use large object data types with DB2 Universal Database in your Java development.

DB2 for z/OS and OS/390: Ready for Java
IBM Redbook Abstract
Naysayers aside, Java and DB2 for z/OS and OS/390 can work together to run mission-critical enterprise applications. Here's how.

Know Your Isolation Levels
by Craig S. Mullins
Did you know that DB2 provides a way to change the way that a program or SQL statement acquires locks? That way is known as the isolation level and it can be set to specify the locking behavior for a transaction or statement.

DB2 Development Add-In Technical Preview - An Overview
by Abdul Al- Azzawe
A tech preview for the DB2 Development Add-in for Visual Studio .NET, introducing all the new features and functionality that are now available.

Meet the Experts: Connie Nelin on DB2 Application Development
Q&A with IBM's Connie Nelin , at the helm of overall application development tooling strategy, architecture and development for the DB2 family.

Join Syntax Options in DB2
by Craig S. Mullins
Does IBM have any plans to make enhancements that would apply only to the JOIN/ON syntax or to stop supporting join syntax using WHERE clause join predicates?

Developing DB2 for z/OS Projects in Visual Studio .Net
Check out this tutorial to learn how to use of the DB2 Database project template of the IBM DB2 Development Add-In to create tables, indexes, views, triggers, and stored procedures for a DB2 for z/OS database.

A Primer on Using DB2 with .NET
by Chip Irek
This article tells why developers will find using DB2 quite managable .

Optimal DB2 Performance with SQLJ and JDBC
by Tom Syroid
A tutorial introducing SQLJ and JDBC, explaining how to take advantage of the features of SQLJ when accessing DB2 to achieve the best overall performance in your Java programs.

DB2 Regular Expressions for the SQL-challenged
by Jim Keohane

Accessing Your DB2 Data from WebSphere ( pdf )
by Robert Moxham
Presentation covering JDBC access, connection pooling, WebSphere configuration GUIs examples, and more.

The Joys of Commitment
by Bonnie Baker
What's gained by COMMIT on the resources of an application running under DB2 for OS/390; some thoughts on deciding how often to COMMIT.

More Joys of Commitment
by Bonnie Baker
Good reasons why programs, including read-only programs, should issue COMMITs .

Go Ahead and COMMIT on a Read
by Pranav Sampat
The availability considerations of introducing a COMMIT in an application doing read-only access and the concepts of claims and drains.

Getting Started with Java and DB2 for OS/390 ( pdf )
by Christopher Farrar
A discussion covering topics from JDBC and SQLJ access to DB2 for OS/390 to OS/390 system setup for Java stored procedures (and possible cockpit errors), and more. A SHARE presentation.

Using Java with DB2 for OS/390
by Craig S. Mullins
Hype or hope: What Java means to the DB2 world.

Checking for Existence
by Joe Geller
It is often necessary for a program to see if there are any rows meeting a set of criteria. It doesn't matter whether there is only 1 row or more than 1. There are several ways to do this. Unfortunately, programmers often pick the least efficient (but simplest) way, and inefficient in this case can be very inefficient.

DB2 Existence Checking, Good Versus Bad
by Isaac Yassin

Existence Checking: The Real Story
by Richard Yevich and Susan Lawson
There is perhaps more misinformation about this topic floating around the DB2 world than any other.

The SQL Double Double
by Sheryl Larsen
Subselects , also known as subqueries or nested selects, are common statements in a developer's SQL portfolio. There are many types of subselects , but their main purpose is to subdivide sets of data to formulate business answers -- a process known as "relational division." Joins can also be used for relational division; however, in some circumstances, subselects are the more powerful alternative.

SQL: Building Block #1
by Sheryl Larsen
How SQL can be bundled inside other application blocks.

Meet the Experts: Sheryl Larsen on the Power of Table Expressions
by Sheryl M. Larsen
Find out why DB2 expert Sheryl Larsen believes that, on average, most DB2® developers are seven years behind in SQL skills.

An Irregular Sorting Requirement

by Craig S. Mullins

Program and Packages, Plans and Collections
by Rob Catterall
The ins and outs of DB2 program preparation and execution.

Dynamic SQL - A Survival Guide
by Suresh Sane
Coping with Dynamic SQL means learning some new tricks and revising some old ones.

Using Dynamic SQL and the SQLDA with Lobs
by IBM
An online tutorial by IBM.

Outer Joins: No More Worries
by Richard Yevich
Outer joins, while alleviating many performance difficulties with UNION implementations of outer joins, have caused a whole new set of performance problems. Here's how to get around these problems.

Migrating an Application from Oracle to DB2 for MVS/ESA
by Marina Greenstein
This document includes a number of tips and techniques for migration of applications from Oracle7 on SP2 to DB2 for MVS/ESA Version 4 on OS/390 OpenEdition , derived from practical experience accumulated during a migration project.

Just Like Magic
by Bonnie Baker
Occasionally, a simple REBIND can spirit performance problems away.

Let Cartesian Products be Your Friend-
But Proceed with Caution

by Bayard Lee “TINK” Tysor
If a Cartesian product's power is harnessed properly, it can be used to produce exceptionally useful result sets, just as a nuclear power plant can harness atomic energy to produce exceptionally useful electrical power.

Cursors! Foiled No More
by Willie Favero
They're necessary in nearly every DB2 program. But with their one-directional abilities, cursors could seem a formidable foe. Arriving to save the day? New, scrollable cursors in DB2 UDB for z/OS and OS/390.



Roger Miller
DB2® for z/OS® Version 9


Craig Mullins' DB2 BLOG >>


Soccer Blog

(c) 2005, Double Loop Marketing LLC and Mullins Consulting, Inc.
All Right Reserved

DB2 is a registered trademark of IBM Corporation.