Db2 for i Archives - Dawn May Consulting

Db2 for i

by Dawn May | Jan 4, 2019

This IBM Support web site is a great starting point for Db2 for i. It provides an introduction to Db2 for i and has many links to additional information.

Parallelism on IBM i

by Amy Lantz | Oct 11, 2018

IBM’s Mike Cain explains the importance of the introduction of parallelism for IBM i on Power.

SMP and How It Affects Batch Run Times

by Amy Lantz | Oct 11, 2018

This document describes how SMP affects batch run times.

Process Your Db2 for i Indexes in Parallel

by Amy Lantz | Oct 11, 2018

This technical paper by Kent Milligan explains the Db2 Symmetric MultiProcessing (Db2 SMP) licensed feature.

Introduction to Db2 Symmetric Multiprocessing for IBM i

by Amy Lantz | Oct 11, 2018

Mike Cain’s educational paper on Db2 for IBM i Symmetric Multiprocessing Database Parallelism.

« Older Entries

From the i Can Blog

Prestart Server Jobs and Exit Programs

April 2, 2019

Securing IBM i is essential and it’s important you understand how to control access to your system with prestart server jobs. Prestart server jobs allow users to connect over the network and you must … read more »

TE’s Pick ' n' Mix Client Edition

March 25, 2019

The integrated nature of IBM i has many advantages—but knowing what you need to know can be a challenge because there is so much to know! To complicate things further, there’s hardware, virtualization … read more »

IBM i Job Accounting and Prestart Server Jobs

March 7, 2019

Job accounting can be used to track the use of system resources, such as CPU time, transactions, printed output, and more, to a particular user or groups of users. read more »

QSQSRVR Job Considerations

February 20, 2019

The QSQSRVR jobs handle database requests for jobs with SQL Server Mode enabled. With SQL Server Mode, the SQL statements are not run directly in the requesting job, but rather by a QSQSRVR prestart s … read more »

Client Special Registers are Special

February 12, 2019

An early iCan blog, written by Scott Forstie in October 2009, reviewed Client Special Registers. I’m revisiting this topic since client special registers are very useful for understanding who request … read more »