Setting up z/OS Unicode Services for Db2 for z/OS

Db2 for z/OS uses z/OS Unicode Services to perform character conversions and case conversions. You should set up z/OS Unicode Services specifically for Db2 for z/OS to ensure optimal Db2 performance.

About this task

z/OS Unicode Services uses a conversion image to determine how to handle various conversions. The conversion image tells z/OS Unicode Services which conversion tables to load and use for character and case conversions. This task explains how to set up such a conversion image. Starting in z/OS 1.7, if at any time Db2 needs a conversion that is not in your image, z/OS Unicode Services loads it on demand.

Tip: Even though you are not required to create your own conversion image, do so anyway by performing the steps in this task. Db2 for z/OS requires that certain conversions be available before it can start. When you define your own conversion image, as described in this task, those conversions are loaded when z/OS is IPLed and are available when Db2 starts. Otherwise, Db2 might be suspended by z/OS multiple times during startup as each of the required conversion tables is loaded by z/OS on demand.

Procedure

To set up z/OS Unicode Services:

Follow the instructions in these sections in the z/OS Unicode Services information:

What to do next

If you later need to alter your conversion image in any way, use the SETUNI command.