Kbase 17259: What is the -Q2 startup option in ESQL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
What is the -Q2 startup option in ESQL?
Startup option -Q2
==================
The -Q2 startup option is described in the Embedded SQL Guide and
Reference on page 3-20 as follows:
Provides the same Ansi SQL86 level II support as -Q and adds guaranteed
serializability of transactions.
What does "serializability of transactions" mean?
=================================================
Serializability of transactions means only one client has
exclusive access to the database. Other connections pend until
the completion of the active connection. This ANSI feature
should only be used if you need to guarantee serialized SQL
transactions in ESQL. If you wish CONCURRENT database access (more
than one client accessing a database at a time) exclude
the -Q2 in your startup parameter list.
Progress Software Technical Support Note # 17259