SET MOUNTING TIMEOUT (+, DB-Access, ESQL/C)

When you request access to an optical volume, the optical-storage subsystem cannot mount it immediately if all the optical drives are busy processing requests from other users. In addition, one or more drives might be reserved at the time of your request.

Use the SET MOUNTING TIMEOUT statement to control the amount of time that your application waits for a volume to be mounted before it abandons the request to continue processing. The mounting time-out disregards the amount of time spent waiting for an optical VP to become available. If the SET MOUNTING TIMEOUT statement is not executed, the default value for a mounting time-out is five minutes (300 seconds).

Syntax

>>-SET MOUNTING TIMEOUT TO--+-WAIT-----+-----------------------><
                            +-NOT WAIT-+
                            '-seconds--'

Element	Purpose	Restrictions	Syntax
seconds	The maximum number of seconds the process should wait for access to a volume No default value exists for time-out within the statement.	Must be specified as a positive integer or zero. Mounting time of zero seconds is the same as NOT WAIT.	Literal Number segment; see IBM Informix: Guide to SQL Syntax.

Usage

If you set the time-out value to WAIT, all requests for a volume wait until the volume is mounted on an optical drive. The process that made the request waits indefinitely.

If you set the time-out value to NOT WAIT, all requests for a volume return immediately if that volume is not currently mounted on an optical drive.

If you set the time-out value to a positive integer, the integer specifies the number of seconds that the process waits for a volume to be mounted before the request returns back.

If you set the time-out value to zero, the process that made the request will wait for a volume to be mounted only if an optical drive is currently available. If all the drives contain either a reserved volume or a volume that is being accessed, the request returns back. If a drive is available, the process waits for the requested volume to be mounted. In general, mounting a volume takes about 15 seconds.

The following example sets the mounting time-out period to 45 seconds. When the application subsequently requests that a volume be mounted, it waits for up to 45 seconds for that volume to be mounted. If that volume cannot be mounted within the 45-second period, the process times out.

SET MOUNTING TIMEOUT TO 45