Change Directory and Record Defaults

About this task

The default directory for Store and Forward files is %SITE_ROOT%\arc , and the default number of records per file is 100. You can change both of these defaults.

Important: Please consider carefully when changing the maximum number of records per stored file. Setting too high a number will result in unmanageable files, while setting too low a number will cause excessive disk I/O.

Procedure

  1. Click Tools>Command Prompt on the Workbench menu bar.
  2. At the command prompt type:

    cd master

    idtpop dbms_def

    notepad dbms_def.idt

    The file looks like this:

    |-* IDT file generated by IDTPOP utility v1.0
* RECORD: DBMS_DEF ODBC Database Definitions
*??????0 DBMS_ID??????????????????????????????????????????????????????Name of the database/service for logging
*??????1 driver????????????????????????????????????????????????????????ODBC name of DMBS driver
*??????2 connect_string????????????????????????????????????????Connection string for ODBC driver
*??????3 wait_period??????????????????????????????????????????????reconnect wait period
*??????4 wait_units????????????????????????????????????????????????reconnect wait period units
*??????5 store_forward??????????????????????????????????????????0=off 1=on
*??????6 store_path????????????????????????????????????????????????path of stored file
*??????7 recs_per_file??????????????????????????????????????????max recs per stored file
*??????8 limited??????????????????????????????????????????????????????0=unlimited store else max num of recs
*
$LOGGING|Microsoft Access Driver <*.mdb>|-
DSN=CIMPLICITY Alarm Logging;UID=admin;DBQ=BSM_ROOT:\arc\CIMPLOG.MDB|-1|0|0||100|0.000000
$LOGGING|Microsoft Access Driver <*.mdb>|-
DSN=CIMPLICITY Point Logging;UID=admin;DBQ=BSM_ROOT:\arc\POINTLOG.MDB|-1|0|0||100|0.000000

    Note that the Alarm Logging and Point Logging databases have separate records.

  3. To define a new path for the stored records for a database, enter the pathname in the store_path field for the database. You can set a different path for each database.
  4. To define a new maximum number of records per stored file for a database, enter the new maximum in the recs_per_file field for the database. You can set a different maximum for each database.
  5. Exit Notepad and save the updated file.
  6. Enter the following commands to regenerate the data file and close the command window:

    ????????????scpop dbsm_def

    ????????????exit

  7. Shut down your project, perform a Configuration Update, and then restart the project.

Results

This change to takes effect when the project restarts.