Hi,
One query is failing on the database and its a long query which was
running fine earlier. One possible reason we can think of is increase
in data in tables in query.
It is failing with following error:-
SQL0659N Maximum size of a table object has been exceeded.
SQLSTATE=54032 (SQLSTATE 54032) -659
Earlier we were having the temp file system size of around 60 GB. then
once query failed with the error "File system full"
so we increased it to 85 GB. now we got the above "Maximum size of a
table object has been exceeded" error.
My study suggest me that it is due to the temporarry table getting
bigger than 64 GB. Is SQL possess some limit on temporary table size
also as for normal tables it is 64 GB.
If Yes, is there any other way to increase the temp table size more
than 64 GB.
Thanks
Sandeep
One query is failing on the database and its a long query which was
running fine earlier. One possible reason we can think of is increase
in data in tables in query.
It is failing with following error:-
SQL0659N Maximum size of a table object has been exceeded.
SQLSTATE=54032 (SQLSTATE 54032) -659
Earlier we were having the temp file system size of around 60 GB. then
once query failed with the error "File system full"
so we increased it to 85 GB. now we got the above "Maximum size of a
table object has been exceeded" error.
My study suggest me that it is due to the temporarry table getting
bigger than 64 GB. Is SQL possess some limit on temporary table size
also as for normal tables it is 64 GB.
If Yes, is there any other way to increase the temp table size more
than 64 GB.
Thanks
Sandeep