Deleting Indexes

Note: This procedure is used when a customer’s cursor is hanging in POS Orders. This is faster than resizing the order file in some cases. If it is a low volume customer, then resizing shouldn’t take too long.

  1. At TCL, in PM, type in DELETE-INDEX ORDER * 

Note: This will delete all the indexes for the Order file.

  1. Do a proper shutdown of the VME.
  1. Explore to D3DATABASES\PM\ORDER. Here you would delete the D3X FILES. In this file, you would delete everything that has a .D3X extension.  Use SHIFT-DELETE to delete the files due to the possibility of their large size.

Deleting the indexes from TCL in the PM Account.

       !dir ..\d3database\pm\order\order

       !del /q  ..\d3database\pm\order\order\*.d3x

Tip:

This (DIR COMMAND)will bring you one level back when you are in a directory

Example: Directory E:\PROGRAM FILES\D3\D3PROGRAMS

!dir .. ßThis will bring you to E:\PROGRAMFILES\D3

  1. Start the VME.
  1. Log into PM, at TCL: Type in PM.INDEXES <enter> and type in an A for all the indexes.