 |
» |
|
|
|
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-38 System.TempSpace
|
Column Name | Type | Length | Description |
|---|
| TEMPSNAME | CHAR | 20 | Name of the TempSpace
| | LOCATION | CHAR | 8 | System identifier for the group
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 |TEMPGRP
---------------------------------------------------------------------------
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
-------------------------------------------------------------------------
|
|
