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 12, 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.

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. (You can run it before or after activating function level 500 in Db2 12. 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. After Db2 12 function level 500 is activated, 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.