> 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
>
>
>
> JUST forgot....the server is 3.1.2.40 on MVS
>
>
> 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.
>
> 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
>    23,404   20,664     2,740         0   4,096 5,289,984 2,851,636  53.9
53.9
>
> tsm: ADSM-C11>