Collection (Schema) Creation

A collection or library in DB2® for OS/400® is equivalent to a schema in DB2 for UNIX™.

  1. Launch "Interactive SQL"

    STRSQL COMMIT(*NONE)

  2. Create a Collection

    CREATE COLLECTION

    Press F4

    Enter field values:

    LIBRARY: name of the collection (Schema)

    ASP: 1

    WITH DATA DICTIONARY: Y

    Press ENTER

    Press F3 to quit ( choose Option 1 (save and exit) ).

Note: Avoid giving the first letter of the name of the schema the letter “Q”; libraries beginning with “Q” are system libraries.

This procedure creates:

  • A library for your new database,
  • A catalog with a data dictionary,
  • A journal (QSQJRN),
  • A journal receiver (QSQJRN0001).