Changing Storage Parameters

Use this procedure to make changes to the storage parameters of the Lawson tables stored in the Oracle database.

To implement storage parameter changes

  1. Start the Oracle sqlplus utility. At the command prompt, type

    sqlplus username/password

    Run the Microsoft SQL Server osql utility. At the command prompt, type

    osql -U username -P password -S servername

    Note: If you have a large number of changes and do not want to run bldora11ddl / bldora12ddl for each table, specify the data area/data ID only. This drops and recreates all of the indexes in the dataarea/dataID. You can also specify the data area/data ID and system code. This drops and recreates all of the tables in the system code.
  2. Make changes to the law_dba_table, law_dba_index, and law_dba_clauses table values by issuing SQL UPDATE statements.
  3. Run dbreorg to unload and reload only the files in the list. At the command prompt, type

    dbreorg -g dataarea [-f filename...]