SE_serverinfo_set_trimlocking

Sets trim locking type of a SE_SERVERINFO object

Usage syntax

LONG SE_serverinfo_set_trimlocking (SE_SERVERINFO svrInfo, SE_TRIM_LOCKING_TYPE trimLocking)

Parameters
svrInfo The opaque SE_SERVERINFO object to update
trimLocking The new trim locking type for the input SE_SERVERINFO object
Description

This function sets the trim locking type for a SE_SERVERINFO object. This was not an issue for pre-ArcSDE 9.0 because compress acquired a full state tree lock.

Added in ArcSDE 9.2 for Oracle server only:

- No operation for non-Oracle ArcSDE server.
- Is not a problem on non-Oracle server because of writers blocking readers.

The TRIMLOCKINGTYPE parameter defines whether or not explicit table locking occurs on a versioned table’s D (deletes) table during a compress operation or when a versioned row is updated or deleted. By default, explicit table locking is enabled.

Possible values are:

1 = Never

2 = Always

3 = Only during compress (the default value)

Returns

SE_SUCCESS
SE_INVALID_POINTER

SE_INVALID_PARAM_VALUE
SE_INVALID_SERVERINFO_OBJECT

SE_SDE_NOT_STARTED