To create the database using the CLP

  1. Log in with SYSADM or SYSCTRL authority to create the database.
  2. At the command prompt, type db2 and the CREATE DATABASE command. For example, type:

    db2 CREATE DATABASE database_name AUTOMATIC STORAGE YES ON path USING CODESET IBM-1252 TERRITORY US COLLATE USING IDENTITY PAGESIZE 4096

    Note: The CREATE DATABASE command must be issued using the IDENTITY collating sequence, where strings are compared byte by byte.
  3. Press Enter.