sp_iqmpxretryexec procedure

Function

Helps operations that may have to be retried.

Syntax

sp_iqmpxretryexec( IN _cmd VARCHAR(1024),
		IN _msg VARCHAR(1024)
		)

Usage

Executes a command, retrying up to 10 times if there is a lock conflict (SQLSTATE 42W18). Catches and logs all errors to the server log.

Description

Table 9-39: sp_iqmpxretryexec columns

Column name

Description

_cmd

SQL statement to execute

_msg

Text to place in error message, if any