HP Integrity NonStop H-Series Guia do Utilizador descarregar pdf (Página 235)

HP NonStop Shadowbase Command Definitions

Database Specification Command Descriptions

HP NonStop Shadowbase Command Reference Manual—785421-002

226

When set to OFF (the default), the CONTROLTABLELOCK DBS object

parameter will prevent row locks from being escalated to a table lock on

SQL targets. When set to ON, SQL may escalate locked rows to a table

lock at it's discretion.

Note: That setting CONTROLTABLELOCK to OFF could result in a file

system error 35 (unable to obtain I/O process control block) if the

number of row locks for a transaction exceeds process or system

lock limits. With most system, this could occur on the 5000th lock

attempt. Typically, your applications should not update more than

4999 records or rows per transaction. If you experience an error

35, set CONTROLTABLELOCK to ON.

CREATEOPTIONS { create-option }

{ ( create-option [, create-option] ...)}

Initial Changed

Version Version Values Default Value Specificatons Alter

4.091 5.002 <See Below> Valid Create options No

This parameter provides additional options when the Consumer receives a

CREATE event and creates the target file/table based upon the source.

Prior to this parameter’s availability, the Consumer created the file using

the exact same

partitions and alternate key file information as the source file/table. If an

Enscribe alternate key file existed on the target, it would be purged and

recreated. The

CREATEOPTIONS allows the user to specify whether to keep or purge

existing

Enscribe alternate key files; to specify that the target file is to be created

with no Enscribe alternate keys (useful for certain testing scenarios) or

SQL/MP indexes; to specify whether or not the Enscribe alternate key file

names and SQL/MP indexes are mapped (useful when testing on the

same node or when the target has different volume names than the

source has); and to specify whether the partitions are created like the

source file/table or that the target is created as a nonpartitioned file/table.

CREATEOPTIONS apply to Enscribe files and SQL/MP tables. However,

RECREATEALTFILES, KEEPALTFILES, and NOALTKEYS are only

applicable to Enscribe files.

The alternate key file mapping looks at the relationship between the

source file

and its alternate key files/indexes. If the source alternate key file or index

is in the same subvolume as the source file/table, the target alternate key

file or index is created in the same subvolume as the target file/table.

Similarly, if the source alternate key file is on the same volume as the

source file/table, the target alternate key file or index will be created on the

1 2 ... 230 231 232 233 234 235 236 237 238 239 240 ... 345 346

Comentários a estes Manuais

Sem comentários

HP Integrity NonStop H-Series Guia do Utilizador Página 235

Comentários a estes Manuais

Manuais e produtos relacionados com Software HP Integrity NonStop H-Series