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