|
NEW:
Table
Spaces and Locking Levels, Part 2 By
Bonnie Baker
Version 8 For Developer's
Only by Craig S. Mullins
ARCHIVED:
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.
Using
SAVEPOINTs
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.
|
