Creating the Database

The following instructions assist you in using the Microsoft SQL Server Enterprise Manager to create the database and file groups for Lawson tables and indexes. Perform this procedure using tools provided by the database vendor.

Note: A file group named PRIMARY was automatically created when you created the Microsoft SQL Server database.

To create the database and file groups

  1. Create the database user that is the Microsoft SQL Server database owner for Lawson data.

    The lawson user is often used as the database owner for Lawson data.

  2. Enter the database owner in the MICROSOFT database driver configuration file as the SCHEMA parameter.
  3. Enter the following values in the Database Properties fields.
    File Name

    The name of the database you are creating.

    This name is also entered in the DBNAME parameter of the MICROSOFT database driver configuration file.

    Location

    The physical location where you want the data to be kept.

    To simplify recovery and improve performance, Lawson recommends that you store the data, index information, and transaction logs on separate disks.

    Note: The default file location entered in the Location field can be changed by typing or by browsing to the desired location.
    Space allocated

    The initial size of the database.

    When using only Process Server Runtime, Lawson recommends the following initial sizes:

    • GEN index

    • GEN data

    • 100 MB for the LOGAN index

    • 100 MB for LOGAN data

    When using Lawson Core Technology and two application product lines (for example, a test and production product line), Lawson recommends the following initial sizes:

    • 600 MB for GEN indexes

    • 400 MB for GEN data

    • 100 MB for LOGAN indexes

    • 100 MB for LOGAN data

    Filegroup

    The file group name.

    File group names are case-sensitive and must exactly match the table space or index space name entered when creating database spaces for your Lawson data.

    File properties: automatically grow file

    Select this checkbox to enable automatic file growth.

    File growth

    A size or percentage value to meet your data processing needs.

    Maximum file size

    Lawson recommends that you select Restrict file growth and specify a size that reserves at least one-half of the disk space for needs other than Microsoft SQL Server data.