Variables in the database driver configuration file

ibmdb

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

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.

The suggested entry is DBNAME=*LOCAL.

The DBNAME variable in IBM DB2 uses only 8 characters.

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.

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.

Required.

This parameter is the name of the file system library where the files that correspond to the SQL tables are physically stored.

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.

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.

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.