Hi
Running a relatively simple sql, selecting from the nodes table with 150 nodes
causes the exhaustion.
There should be plenty of space in the db(about 9.5 GB) to create this temorary
table.
any ideas ??
Regards,
Carsten Moldrup
tsm: ADSM-C11>select platform_name,count(*) from nodes group by platform_name
ANR2958E SQL temporary table storage has been exhausted.
|
V..............................................................
select platform_name,count(*) from nodes group by platform_name
ANS8001I Return code 26.
tsm: ADSM-C11>help 2958
-------------------------------------------------------------------------------
ANR2958E SQL TEMPORARY TABLE STORAGE HAS BEEN EXHAUSTED.
ANR2958E SQL TEMPORARY TABLE STORAGE HAS BEEN EXHAUSTED.
Explanation: The result of an SQL query could not be computed because
insufficient temporary table storage space was available. Free space in the
server database is used to store temporary tables created during the execution
of an SQL SELECT query. In many cases the web admin client uses SQL commands
to retrieve necessary data from the server. Complex SQL queries such as those
containing the following conditions can cause temporary table space to be
required: the ORDER BY clause, the GROUP BY clause, and, the DISTINCT operator.
In most cases this error can be resolved by increasing the size of the server
database.
System Action: The SQL query is terminated.
User Response: None.
tsm: ADSM-C11>q db
Available Assigned Maximum Maximum Page Total Used Pct Max.
Space Capacity Extension Reduction Size Usable Pages Util Pct
(MB) (MB) (MB) (MB) (bytes) Pages Util
--------- -------- --------- --------- ------- --------- --------- ----- -----
23,404 20,664 2,740 0 4,096 5,289,984 2,851,636 53.9 53.9
23,404 20,664 2,740 0 4,096 5,289,984 2,851,636 53.9 53.9
tsm: ADSM-C11>
|