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:

• You can use iSeries Navigator to create a library (in SQL, called a schema).

• You can use the Create Library (CRTLIB) command to create the library.

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