Kbase 21780: Why SQL-92 Sort Files Are Not Visible with 9.1C on UNIX
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
13/02/2002 |
|
SUMMARY:
This Solution explains why SQL-92 Sort file are not visible on UNIX platforms when using 9.1C.
EXPLANATION:
When executing a query that requires SQL Temp Table, Sort Files are created by the SQL-92 Server process. (Example: when using ORDER BY in a SELECT Statement.)
On UNIX platforms with 9.1C, the Sort Files for Temp Tables are
created and then unlinked from any directory. This means that
the Sort files are not visible from any directory.
In previous versions, 9.1A and 9.1B, the Sort Files are visible in
the directory defined by the WRKDIR Environment Variable.
This new feature guarantees that when the SQL-92 Server process
terminates, whether it is a normal or abnormal termination, the
Sort Files will be freed by the Operating System.
This change was made so that all file system resources used
by the SQL-92 Server Process would always be released, and the
machine would not be cluttered with files that SQL-92 should have
removed.
NOTE: On Windows platforms, the unlinked method is also used but files
are not hidden. It will only ensure that Sort Files are cleaned
up in either a normal or abnormal termination of the SQL-92 Server Process.
References to Written Documentation:
Progress Knowledge Base Solutions:
20332, "[JDBC Progress Driver]:MM- bad swap block (7707)"
21206, "SQL-92 - Temp Tables (Mxxxx) Limit and How to Work Around It"
19920, "MERANT] [ODBC PROGRESS driver] [PROGRESS]MM - bad swap file"
20007, "SQL-92 - How to Find Index Used in a SELECT Statement?"
20952, "UPDATE STATISTICS Improves Performance in SQL-92"