Verifying the Dictionary

This procedure guides you in running the dbverify utility to ensure that the Lawson database dictionary and the Microsoft SQL Server database definition match.

To verify the dictionary

  1. Run the utility on your product line or data area, and direct the output to a file. Type one of the following:

    dbverify [OPTIONS] dataarea [name ...]

    dbverify [OPTIONS] --prodline prodLine [name ...]

    dbverify [OPTIONS] --tenant tenant [name ...]

    dbverify [OPTIONS] --all [name ...]

    where the following parameters apply.

    Program Option Description
    dataarea The data area you want to check the database definitions for. You can specify multiple space-separated data area names.
    --prodline prodLine Run the utility for all active data areas in the product line. You can specify multiple space-separated product line names.
    --tenant tenant Run the utility for all active data areas of the tenant. You can specify multiple space-separated tenant names.
    -all Run the utility for all active data areas.
    -b or --brief Print anomalies and brief summary only (default).
    --gridstatus= ID Publish progress to grid. You can then use managegrid getprogress to see a list of all running programs, or you can use managegrid getprogress ID to see the status of this program. The value you specify for ID must be unique across the system for any programs being run with the gridstatus option.
    -i or --only-indexes Only report index differences.
    -l List all of the indexes and what type they are.
    --mustbemissing Everything checked must be missing. Internal use only.
    --primaryonly Check on the primary index.
    -q or --quiet Quiet mode - only print anomalies.
    -r or --report Report mode - only print summary report.
    -s or --stringent Stringent mode - prints detailed listing of tables that are checked.
    --showstatistics Display the time since the last table/index statistics update.
    -t or --only-tables Only report table differences.
    --threads=count

    Maximum active threads for processing, for example, --threads=3. If you use multiple threads, you may see a performance improvement. However, performance depends on other factors as well. Note that a very large table will be processed in a single thread.

    The default number of threads is four.

    --useupgradenames Use the upgrade names for tables. Only use if directed to by support personnel.
    --verbose Print file names as they are checked.
    name

    A list of names of dictionary files, business classes, modules, database spaces, or business class patterns to execute the command against.

    Use the prefixes file-, pattern-, space-, or module- to resolve ambiguity. Use prefix- and type- to select files by prefix name or types used. File names can be the long or classic name and can include ? and *. Specifying "!" anywhere in the list will complement the selected files. Specifying @path reads names from the file, one per line. A hyphen ( - ) indicates stdin. Wildcard characters may need to be quoted in the command line or they will be interpreted by the command processor. A :L on a file name selects the lobs table. A :B on a file name selects the base table.

  2. Open the output in a text editor. Use the information it contains to diagnose any mismatches between the Lawson repository and your Microsoft SQL Server database.

Example: Column Name and Definition Do Not Match

The following example shows the output of dbverify when the name of a column and its type do not match.

Verifying table SampleJobCode
  Additional Columns defined by database
      JOBCODEDESCRIP
  Columns not defined by database
      JOBCODEDESCRIPTION
  Additional Indexes defined by database
      PK_SMPJC
  Indexes not defined by database
      SMPJCSYMBOLICKEY



Number of SQL tables checked                     :    1
Number of SQL tables with no errors              :    0
Number of SQL tables in an empty dbspace         :    0
Number of missing SQL tables                     :    0
Number of SQL tables with incorrect definitions  :    1
Number of views that were skipped                :    0

Number of SQL indexes with no errors             :    1
Number of extra SQL indexes                      :    1
Number of missing SQL indexes                    :    1
Number of SQL indexes with incorrect definitions :    0

Verification found inconsistencies