18.2.3 Setting execution monitoring time limit for database reorganization processing

If an error (such as, communication error or disk error) occurs while a database is being reorganized, the reorganization process might stop responding. In some cases (for example, when reorganization is automatically executed by a Windows task function or JP1/AJS), the non-responding process cannot be forcibly terminated by manual operation. This subsection describes how to set an execution monitoring time limit for database reorganization processing, and how to stop a reorganization process that does not respond.

Notes

Before you set execution monitoring time limit for database reorganization processing, on the asset management server, stop all Asset Console services, commands, and tasks.
Stop the Asset Console services in the following order:
1. World Wide Web Publishing Service or World Wide Web Publishing
2. Asset Console commands and tasks
When you run Asset Console after having changed the execution monitoring time limit for database reorganization processing, start the services in the reverse of the order in which they were stopped.

Stop the database. (For details about how to stop the database, see F.4(2) Stopping the database.)
Use a text editor to open the pdsys file stored in Asset-Console-installation-folder\aimdb\conf.
Add the following line:

set pd_utl_exec_time = execution-monitoring-time-limit-for-reorganization-processing^#
Start the database. (For details about how to start the database, see F.4(1) Starting the database.)

#

To monitor the execution time of a database access command, set the monitoring time limit in the range from 0 to 35791394 (minutes). If nothing is specified or 0 is specified, the execution time of a command will not be monitored. If the monitoring time limit specified here expires, an executing command will terminate abnormally. For this operand, specify a value that is a little larger than the maximum value of the actual command execution time. For example, if the maximum execution time for reorganizing a database is about 90 minutes, you may need to specify pd_utl_exec_time=120. This setting is based on the consideration that, if a process that usually takes about 90 minutes does not complete within 120 minutes, a no-response error has probably occurred.

Coding example:
```
   #
   #------------------------------------------------------------------
   # set form 
   #
   :
   (Omitted)
   :
   set pd_utl_exec_time = 120
   #
   #------------------------------------------------------------------
   # putenv form 
   #
```

To Page Top