SQL/MP Messages Manual

SQL Executor Messages (8000 to 8999)
HP NonStop SQL/MP Messages Manual—427720-006
10-51
SQL 8627
Cause. A file system error occurred while accessing a temporary file used as the
overflow file for a hybrid hash join operation. See the SQLCA or the error display from
SQLCI for the specific file system error.
Effect. The statement fails.
Recovery. Consult the documentation or contact your service provider for information
on recovering from specific file system errors. A common file system error on a
temporary file is error 43, which indicates there was insufficient disk space. This error
can be avoided by directing the temporary file to a disk volume with more free space.
SQL 8628
Cause. The SQLESPMG process stopped, another operating system resource was
unavailable, or an internal error occurred.
Effect. The statement fails.
Recovery. Attempt to diagnose the problem by using the operating system error code.
If the problem persists, report the entire message to your service provider.
SQL 8629
Cause. Hash table for grouping has reached its limit that was specified in the define
=_SQL_EXE_HASH_GP_LIMIT.
Effect. The statement in program fails.
Recovery. Increase the limit by altering the define =_SQL_EXE_HASH_GP_LIMIT.
8627 An error occurred on the overflow file value-1 of a
hybrid hash join operation.
8628 An error occurred in the communication between the SQL
Executor and the SQL ESP Manager process (SQLESPMG). The
Guardian error code is value-1.
8629 Hash table for grouping has reached its limit.