Creating a library




Search Tips   |   Advanced Search


A library is a system object that serves as a directory to other objects. A library groups related objects and allows you to find objects by name. To create a library, use iSeries™ Navigator or the Create Library (CRTLIB) command. The system-recognized identifier for the object type is *LIB. Before you can create a database file, create a library to store it. You can create a library in the following ways:

When creating a library, you can specify the auxiliary storage pool (ASP) where the library is to be stored. This allows you to create multiple, separate databases.


Creating a library (schema) using iSeries Navigator

To create a library (in SQL, called a schema) from iSeries Navigator, follow these steps:

  1. From iSeries Navigator, expand the system you want to use.

  2. Expand Databases and the database that you want to work with.

  3. Right-click Schemas and click New Schema.

  4. On the New Schema window, specify a schema name.

  5. To add this schema to the list of schemas displayed, select Add to displayed list of schemas.

  6. To create as a standard schema, select Create as a standard schema.

  7. To create a data dictionary, select Create a data dictionary.

  8. Specify a disk pool to contain the schema.

  9. Specify a description.

  10. Click OK.


Parent topic:

Creating and describing database files


Related reference

Create Library (CRTLIB) command