What Is the Verify Database Utility?

The Lawson repository contains descriptions of all Lawson tables and indexes. When these objects are stored in Microsoft SQL Server, the database driver (msfdb2000) translates the Lawson description for storage in the Microsoft SQL Server database. For Lawson programs to work properly with Lawson tables stored in the Microsoft SQL Server database, Lawson dictionary descriptions must match the expected translations in Microsoft SQL Server. Mismatches in these definitions can lead to performance problems or even program failure (column definition mismatches).

The verifymsf2000 utility checks for two kinds of differences when it compares the Lawson dictionary with the Microsoft SQL Server definitions:

  • Missing objects

    Any table or index defined in the Lawson dictionary that has no counterpart in the Microsoft SQL Server database results in a missing file or index message.

    The utility checks to make sure that each table and index defined in the Lawson dictionary has a matching table and index in the Microsoft SQL Server database. It does not check to make sure that all objects defined in the Microsoft SQL Server database have counterparts in the Lawson dictionary. Any tables or indexes placed in the Microsoft SQL Server database from a non-Lawson source do not show up in a report.

  • Mismatched column definitions

    When the columns defined in a Lawson table or index are not matched by the Microsoft SQL Server database definitions of those columns, the utility returns a mismatched file or index definition message. Mismatches include differences in data types, lengths, and so on. All fields are assumed to not allow nulls―only those that do allow nulls have output noting this fact.

    When verifymsf2000 compares definitions, it matches each column in the Lawson table or index with the Microsoft SQL Server database column at the same position in the table or index. If a column is missing in the SQL definition, the missing column appears in the report as a mismatch in the succeeding columns.

While the utility finds the differences between the Lawson dictionary and the Microsoft SQL Server database definitions, it does not fix the mismatches or alter the definitions in any way.

If you run verifymsf2000 without options, it prints out a line that notifies you as it checks each table and index in the specified product line, system code, or file. If you run the utility in quiet mode, it prints out only the messages that identify the differences between the definitions, followed by a summary.