Databases created on Windows
and UNIX
platforms store data in ANSI. To use these databases with EBCDIC-enabled subsystems such as IMS and CICS, you must have a
database created with an alternative collating sequence.
You can run the Create Database tool
from the HCO for DB2 LUW user interface (Windows only)
, or
using the
mfhco create (Windows) or
cobmfhco create (UNIX)
command.
Note: If you were to use any of the IBM tools to create the database, all data would be returned to your application in ANSI collating
sequence. IBM does provide some examples of how to create databases with alternative collating sequences, but the EBCDIC to
ANSI translation that IBM uses might be different from the translation used by
Enterprise Developer. Therefore, we strongly recommend that you use the Create Database tool to create the database.