Creating the basic structure of a SESAM/SQL database

The basic structure of a SESAM/SQL database is created with the utility statement CREATE CATALOG. When this statement is executed, SESAM/SQL creates the database's catalog space.

The table below presents an overview of the necessary activities and lists the associated utility statements. The right-most column indicates which main function to choose in the utility monitor.

Activity	Statement and function	Main function in the utility monitor
Create a catalog space for the database	CREATE CATALOG Defines the BS2000 password for the database DB identifier Character set (code table) the attributes of the catalog space the storage group for the catalog space the storage group for the CAT-REC file and the first CAT-LOG file the universal user	Main function CREATE CATALOG (CRC) and continuation forms
Back up the catalog space	COPY Saves the database (catalog space); not absolutely necessary

Table 66: Utility statements and the main utility monitor function used to create the basic database structure