SQL/MP Messages Manual

HP NonStop SQL/MP Messages Manual—427720-006
10-1
10
SQL Executor Messages (8000 to
8999)
SQL 8001
Cause. The ALLOCATESEGMENT procedure could not allocate the extended
segment for the SQL executor.
Effect. The statement or program fails.
Recovery. Reissue the statement or rerun the program. If the problem persists,
contact your system administrator.
SQL 8002
Cause. Internal error: The USESEGMENT procedure could not bring the extended
segment for the SQL executor into use.
Effect. The statement or program fails.
Recovery. Reissue the statement or rerun the program. If the problem persists, report
the entire message to your service provider.
SQL 8003
Cause. An application program did not have sufficient stack space left to call the SQL
executor. There should be approximately 3500 words of stack space available for the
execution of an EXEC SQL statement (very complex queries might require more).
Effect. The statement fails. Note: A stack overflow can cause other symptoms. The
application program might also trap, abend, or return file system error code 22. In the
case of an internal trap in the executor, an error message is sent to the operator
console process, and the executor process abends.
Recovery. Try to reduce stack space in the application program. If the MEM RUN
option is available for your compiler, use it to increase the number of data pages for the
application program. For other compilers (such as COBOL), try to reduce stack space
usage in your program. For example, if you use a lot of COBOL subprograms, reduce
the call nesting depth at which SQL statements are executed. If you use a lot of
working storage, consider changing some of it to extended working storage.
8001 Failure in ALLOCATESEGMENT.
8002 Internal error: Failure in USESEGMENT.
8003 Insufficient stack space in the SQL executor.