Create Database Tool

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.