Cause
The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Action
Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.
Error Message
maximum number of temporary table locks exceeded
The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created by large sorts.
Increase the value of the TEMPORARY_TABLE_LOCKS initialization parameter and warm start.