Defining and Generating the Database Name Table

Defining a Database Name Table › Defining and Generating the Database Name Table

Defining and Generating the Database Name Table

Steps to Follow

Define and generate the database name table using the steps listed as follows.

The database name table must exist as a module in a load library in order to be usable by the runtime system. The name of the load module assigned in the link-edit must match the name specified in the DMCL.

Action	Statement
Create the database name table, adding DBTABLE mappings to define a default dictionary and for non-SQL applications binding without a DBNAME	CREATE DBTABLE
Create the database names, adding the segments and subschema mappings required by your applications	CREATE DBNAME
Generate the database name table	GENERATE DBTABLE
Associate the database name table with a DMCL	ALTER DMCL
Punch the database name table load module and link-edit it to a load library	PUNCH DBTABLE LOAD MODULE

Example

The example below defines a basic database name table that is suitable if all non-dictionary segments in your runtime environment are in the same page group and have unique area names.

It has the following characteristics:

A database name for each of the following dictionaries: an application dictionary called DEFDICT, the system dictionary called SYSTEM and the SYSDIRL dictionary containing report definitions and dictionary schemas.
A DBTABLE mapping rule identifying DEFDICT as the default dictionary
A database name called DEFDB that includes all non-SQL defined segments (other than those related to a dictionary)

A DBTABLE mapping rule identifying DEFDB as the database to be accessed by all non-SQL applications that do not specify a DBNAME

       create dbtable alldbs
        subschema idmsnwk? maps to idmsnwk? dbname defdict
        subschema ???????? maps to ???????? dbname defdb;

       create dbname system
        segment catsys
        segment system
        segment sysmsg;
       create dbname defdict
        segment defdict
        segment defcat    ◄-- for SQL users
        segment sysmsg;
       create dbname defdb
        segment user-segment1
        segment user-segment2
 .
 .
 .
       generate dbtable alldbs;