 |
» |
|
|
|
SYSTEM.TEMPSPACE contains information about TempSpace names.
This view is initially empty, but is updated whenever ALLBASE/SQL
processes a CREATE TEMPSPACE or DROP TEMPSPACE.
You can use this view to determine the defined TempSpaces.
isql=> SELECT * from SYSTEM.TEMPSPACE;
|
Table 8-37 System.TempSpace | Column Name | Type | Length | DESCRIPTION |
|---|
| TEMPSNAME | CHAR | 20 | Name of the TempSpace | | LOCATION | CHAR | 35 | System identifier for the directory being used for TempSpace files | | MAXFILEPAGES | INTEGER | 4 | Maximum number of pages per file opened in the TempSpace | | CTIME | CHAR | 16 | Time of creation: yyyymmddhhmmsstt |
EXAMPLE | |
select * from system.tempspace;
--------------------+--------------------------------------------
TEMPSNAME |LOCATION
--------------------+--------------------------------------------
MJTMPSP |/misc/mjdir/tmp
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > r
+------------+----------------
|MAXFILEPAGES|CTIME
+------------+----------------
| 128|1990041216384500
---------------------------------------------------------------------------
Number of rows selected is 1
U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd] > e
---------------------------------------------------------------------------
|
|
