To enable StoreHouse 5 logging:

  1. Open the registry editor and go to HKLM\Software\USC\sdbserv.2\Server_key
  2. Create the DWORD uplt parameter — the maximum allowed procedure execution time in ms — with a value, for example, 100.
  3. Save your changes and restart the StoreHouse 5 server.

The log looks like this:

11.10.2019 14:30:10- PROCTIME DebugProc time=1.050 sec, conn_id=11, status=

How to read the log: procedure name is DebugProc, the execution time, including the commit or rollback time, is 1.05 seconds, the connection ID is 11, the procedure was completed successfully; the signature for the search is PROCTIME.

  • No labels