DROP TEMPSPACE
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index | |
| E0300 Edition 9 ♥ | |
| E0399 Edition 8 | |
| E0897 Edition 7 |
Scope
ISQL or Application Programs
SQL Syntax
DROP TEMPSPACE TempSpaceName
Parameters
- TempSpaceName
is the name of the TempSpace to be dropped.
Description
If a TempSpace is dropped while temporary files currently exist under the path name it specifies, those files remain until the sort using them completes. However, no further temporary files are created in that TempSpace.
If a TempSpace is being used by another user when the DROP TEMPSPACE statement is issued, then the DROP statement is blocked until the TempSpace usage is finished.
Authorization
You must have DBA authority to use this statement.
Example
TempSpace temporary files are created in the /sort/PurchDB directory when SQL statements require sorting.
CREATE TEMPSPACE ThisTempSpace WITH MAXFILEPAGES = 360,
LOCATION = '/sort/PurchDB'
DROP TEMPSPACE ThisTempSpace
TempSpace temporary files are no longer available in the /sort/PurchDB,
directory but can be allocated under /tmp as needed.
|
DROP TABLE |
DROP VIEW |