Manualshelf

SQL/MP Messages Manual

ManualsBrandsHP ManualsServerHP NonStop G-Series
271272273274275276277278279280
SQL Compiler Optimizer Messages (6000 to 6999)
HP NonStop SQL/MP Messages Manual—427720-006
8-9
SQL 6104
Cause. The CONTROL TABLE directive specified JOIN METHOD HASH. Statistics
indicate that the overflow file size for inner or outer relation will be more than the limit
of 1.5 GB.
Effect. A warning is issued and the statement is compiled. However, the execution of
the statement may fail due to disk file overflow.
Recovery. Use CONTROL TABLE * JOIN METHOD SYSTEM.
6104 The query may fail during execution if the size of the
overflow files created for the relations in the Hybrid Hash
join are greater than 1.5 GB.