ADSM-L

SQL temporary table storage exhausted.

2000-01-10 09:42:51
Subject: SQL temporary table storage exhausted.
From: Carsten Moldrup <cmoldrup AT CSC DOT DK>
Date: Mon, 10 Jan 2000 15:42:51 +0100
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>
<Prev in Thread] Current Thread [Next in Thread>