Migrating Db2 11 Unicode columns in EBCDIC tables to Db2 12 or later Unicode columns in EBCDIC tables

Db2 11 Unicode columns in EBCDIC tables can be used with Db2 13, subject to the restrictions that exist in Db2. However, Db2 12 or later Unicode columns in EBCDIC tables have enhanced support, so you might want to convert Db2 11 Unicode columns to Db2 12 or later Unicode columns.

Procedure

To migrate Db2 11 Unicode columns in EBCDIC tables to Db2 12 or later Unicode columns columns, complete the following steps:

  1. Run job DSNTIJPM. One of the reports that DSNTIJPM produces lists Db2 11 Unicode columns, the EBCDIC tables that contain them, and the indexes that are defined on the Db2 11 Unicode columns.
  2. Take one of the following actions:
    • Issue ALTER TABLE ALTER COLUMN to alter the Unicode column.
    • Issue ALTER TABLE DROP COLUMN and ALTER TABLE ADD COLUMN to drop and add the Unicode column.
    • Issue DROP TABLE AND CREATE TABLE to drop and recreate the table with the Unicode column.
  3. Repopulate the column or table.