SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-31
SQL 8311
Cause. The disk was not operating.
Effect. The statement fails.
Recovery. Check the availability of the disk. If the problem persists, report the entire
message to your service provider.
SQL 8312
Cause. Two possible causes are that you did not start a transaction, or the system
aborted your TMF transaction. The TMF transaction is required because the statement
used either REPEATABLE ACCESS or STABLE ACCESS mode to access one or
more audited tables or views. SQLCI automatically starts transactions when
necessary; application programs must verify that a transaction is present.
Another possible cause is that an application program omitted the BROWSE ACCESS
clause from a subquery in a SELECT statement where BROWSE ACCESS was
intended. This access mode overrides the need to execute within a TMF transaction.
BROWSE ACCESS, however, must be specified in the outer query and in each
subquery. (A subquery that omits BROWSE ACCESS uses REPEATABLE ACCESS.)
Effect. The statement fails.
Recovery. Start a transaction before reexecuting this statement. If the file system
aborted the transaction, the SQLCA contains that information. Alternatively, if you do
not want to execute a SELECT statement or to use a cursor within a TMF transaction,
verify that BROWSE ACCESS is used correctly.
8311 A disk was not available to fetch required data. Error
occurred for value-1.
8312 The statement cannot be executed because no TMF
transaction is currently in progress. The error was detected
for value-1.