The Db2 Portal Blog

News, views, and items of interest on IBM's Db2 database management system and mainframes.

Sunday, June 19, 2011

The PIECESIZE Clause

›
One of the more troubling aspects of DB2 database design and creation is the non-partitioning index (NPI). Creating NPIs on tables in a par...
Wednesday, June 01, 2011

Mainframe Specialty Processors

›
Anyone who uses an IBM z Series mainframe has probably heard about zIIPs and zAAPs and other specialty processors. But maybe you haven'...
1 comment:

What is an Enclave?

›
If you are a DB2 professional dealing with distributed workload… or if you are enabling zIIP specialty processors… chances are you’ve heard ...
1 comment:
Wednesday, May 25, 2011

A Quick SQL Trick: Find The Number of Commas

›
Today's blog post is a short one. I was recently asked how to return a count of specific characters in a text string column. For examp...
3 comments:
Friday, May 13, 2011

DB2 -- What's in a Name?

›
Versions of DB2 exist for a large array of platforms, of which the mainframe (z/OS) is only one. Of course, it is my favorite one since I’v...
6 comments:
‹
›
Home
View web version

About Me

My photo
Craig S. Mullins
Sugar Land, Texas, United States
Craig S. Mullins is a data management strategist, researcher, and consultant. He is president and principal consultant of Mullins Consulting, Inc. and the publisher/editor for The Database Site.

Craig has been named by IBM as a Gold Consultant and an IBM Champion for Analytics. He has been named as one of the Top 200 Thought Leaders in Big Data and Analytics by AnalyticsWeek magazine.

Craig has over three decades of experience in all facets of database systems development and has worked with Db2 since V1. You may know Craig from his popular books: Db2 Developer's Guide (covering IBM's mainframe RDBMS)... A Guide to Db2 Performance for Application Developers (how to write efficient Db2 programs) and... Database Administration: The Complete Guide to DBA Practices and Procedures (a guide to heterogenous DBA).
View my complete profile
Powered by Blogger.