HP Integrity NonStop H-Series Guía de usuario descargar pdf (Pagina 166)

HP NonStop Shadowbase Command Definitions

Consumer Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

157

Note: That it is up to the user exit code to determine what the outcome

will be.

RESOLVELOCKS { ON }

{ OFF }

Initial Changed

Version Version Values Default Minimum Maximum Alter

3.700 3.980C OFF OFF ON No

Client Server Extended Open Target

At times Guardian file error 40 (timeout) and error 73 (record/row locked)

can occur in a Consumer, for example when the DBS

CONTROLTABLELOCK parameter is set ON. (Note that setting

CONTROLTABLELOCK ON might be necessary if a given application

locks many SQL rows in a SOURCEFILE). This condition might arise

under the following unusual circumstances:

 A given source table/file has many partitions and is being replicated to

a table/file with fewer partitions. Note that it is recommended that

targets have the same number of partitions as the source.

 When using HP Shadowbase to replicate from Enscribe to SQL due to

differences in record/row locking methods. SQL has limitations on the

number of rows that can be locked before requiring row locks to

escalate to a partition or table lock.

 There is a unique alternate key or index on a source file and a

duplicate record error occurs in the source application. This can at

times result in transaction/event sequencing issues in the TMF audit

trail.

Setting the RESOLVELOCKS parameter to ON enables automatic

resolution of locking issues for both Enscribe and SQL files/tables when

replicating between HP NonStop databases. The default is OFF, the

feature is disabled.

Notes:

 As of release v3.980C he Consumer has been modified to output a

general EMS message if it abends due to a target lock error and the

CONS object RESOLVELOCKS parameter is OFF.

 As of release v3.970 , the CONS RESOLVELOCKS and

RESOLVETRANS parameters can now be set to OFF for unstructured

Enscribe files. User errors 1338 and 1340 are obsolete.

 A Consumer object TIDFILE must be configured if RESOLVELOCKS

or RESOLVETRANS is set to ON.

 RESOLVELOCKS must be set OFF for consumers that are replicating

entry-sequenced files or tables.

 If you are replicating from NonStop to NonStop over TCP/IP, the

RESOLVELOCKS and RESOLVETRANS parameters do not need to

1 2 ... 161 162 163 164 165 166 167 168 169 170 171 ... 345 346

Comentarios a estos manuales

Sin comentarios

HP Integrity NonStop H-Series Guía de usuario Pagina 166

Comentarios a estos manuales

Relacionado con productos y manuales para Software HP Integrity NonStop H-Series