Select Page

Blog

Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.

Author: Craig Mullins
Browse Blog Categories

How and When to Use DB2 Scrollable Cursors

If you are using DB2 V7 or higher, consider using scrollable cursors. With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor.

Craig Mullins | May 19, 2015

Using Nulls in DB2

If a column “value” can be null, it can mean one of two things: the attribute is not applicable for certain occurrences of the entity, or the attribute applies to all entity occurrences, but the information may not always be known.

Craig Mullins | April 6, 2015

DSNTEP2 aka Batch SPUFI

DSNTEP2 is an application program that can be used to issue DB2 dynamic SQL statements.

Craig Mullins | February 19, 2015

VSAM Demystified

VSAM is used “under the covers” of every DB2 for z/OS page set. VSAM is also used as the storage mechanism by some IMS databases.

Craig Mullins | February 2, 2015

Minimizing Lock Contention Issues

I frequently get e-mails with DB2 questions and I plan to start posting answers to some of the more common ones up here.

Craig Mullins | December 30, 2014

No Black Boxes!

First of all, before I go any further, let’s first define what I mean by a “black box.” If I plan to recommend that you prohibit them we better both understand what it is we are talking about prescribing.

Craig Mullins | December 23, 2014

DB2 Compression: z/OS versus LUW

Data compression for non-mainframe DB2 is quite a bit different than it is for DB2 for z/OS.

Craig Mullins | December 16, 2014

The Aging Mainframer

A continuing, lingering perception that the mainframe is dead continues on in some parts of the IT industry.

Craig Mullins | December 4, 2014

Webinar: Building a Performance Centric Organization

Database performance problems are not caused by magic. Indeed, all performance problems are always caused by change.

Craig Mullins | November 11, 2013
1 2 5 6

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

CONTACT US

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.

EXPLORE JOBS