Variables in the database driver configuration file

These topics describe the variables in the IBM database driver configuration file:

Parameters that Specify Your Database Implementation

The parameters in this table configure the database.

Parameter Description
LAWGATENAME

ibmdb

The name of the database driver executable, used between the Lawson applications and the IBM DB2 database.

DBNAME

Required.

The database name.

Enter the name as catalogued on the local system of the IBM DB2 database used to store Lawson tables and indexes for the data area.

If the database resides on the OS/390, you might also need to specify the DB390NAME.

The DBNAME variable in IBM DB2 uses only 8 characters.

DB2INSTANCE

The name of the IBM DB2 instance to be used for a specific data area.

The suggested entry is DBINSTANCE=db2.

This parameter defaults to DBINSTANCE=db2.

PASSWORD

Required.

Enter this parameter when using the USE_CFG_FILE login procedure―. Do not use the PASSWORD parameter for any other login procedure.

This is the password for LOGINNAME, which the database driver uses when it connects to IBM DB2. The default is lawson.

SERVICENAME

This parameter is required when Lawson Security and Resource Management are implemented to manage users and secure data.

This parameter specifies the name of the database service for this data area. If you do not enter a database service, the login procedure defaults to USE_CFG_FILE. You can either specify a LOGINNAME and PASSWORD in the IBM file, or configure the system so that each individual user accesses the database with a unique user name.

SCHEMA

Required.

This parameter is the database owner. If the tables were not created by the user named in LOGINNAME, set SCHEMA to the name of the user who created the tables.

If SCHEMA is not specified in the IBM file, the database driver (ibmdb) uses these methods to determine a value for the table owner:

  • If defined in the IBM file, the LOGINNAME value from the IBM database driver configuration file defaults for the SCHEMA value.

  • If the LOGINNAME parameter is not defined, the database login name specified for the database service defaults to the SCHEMA value when using the USE_PRIVILEGED_ID or USE_USER_AND_PRIVILEGED_ID database authentication options.

  • If your system uses the USE_USER_ID database authentication option for Lawson Security or your system does not implement Lawson Security, the lawson user defaults for the SCHEMA value.

If SCHEMA is not specified in the IBM file, the database utilities (bldibmddl, bldibmsec, verifyibm, or ibmdu) use these methods to determine a value for the table owner:

  • If defined in the IBM file, the LOGINNAME value from the IBM database driver configuration file defaults for the SCHEMA value.

  • If the LOGINNAME and SCHEMA parameters are not defined, the database login name must be specified on the command line when running one of these utilities.

DB390NAME

Optional.

If the name of the default database in DB2/390 is not the same as DBNAME, set DB390NAME to the name of the default database.

DBPATH The directory where the IBM DB2 database executable runs.

Parameters that Configure Record Caching

Use these parameters to enable record caching.

Parameter Description
ARRAYBUFSIZE

Optional.

Indicates the maximum number of rows to be fetched at a time from the database server. The default is 10 rows.

The setting for this variable in the database driver configuration file applies to all files in the data area or data ID unless a variable specific to a program has been created. When a variable specific to a program has been created, it overrides the setting in the database driver configuration file.

INSERTBUFSIZE

Optional. Only applies to specific utilities (dbreorg, dbcopy, importdb -b, impcsv -b) and batch tokens.

Indicates the maximum number of rows to be buffered in the database driver before an array insert flushes data out to the database. This parameter must be set to a value greater than 1 to enable array inserts. Lawson recommends a setting of no larger than 10 for normal use.

However, when you perform a dbcopy or dbreorg, particularly when a large amount of data has been inserted into the database, increase the size of this parameter. Lawson recommends increasing it to 50 in these cases. Return the parameter to your normal setting when the dbcopy or dbreorg completes.

See Editing the Lawson Database Driver Configuration File

Applications commit records to the database at different intervals. When a commit occurs, the insert buffer is flushed. Batch tokens typically commit every 50 records, importdb commits every 100, and dbcopy commits every 3000 records. Setting INSERTBUFSIZE higher than the commit interval will result in buffered inserts of the commit interval size.

As with ARRAYBUFSIZE, you can set this variable to control a specific program. The program-specific setting overrides the setting in the database driver configuration file.