SQL queries usually require temporary storage space for sorting. Very large SQL queries require very large temporary sorting space. FairCom DB now provides up to 128 TB of temporary table space from your largest of SQL queries.
For example, the following sets the limit to 1 TB:
SUBSYSTEM SQL LATTE {
MAX_STORE 1000 GB
}
See SUBSYSTEM SQL LATTE configuration for changing store size limit