$
volume
.
subvolume
.
file-id
, or simply
file-id
, if you want to put the work file into
the current subvolume.
DSAP $(volume-set), including $*, with a permanent workfile option will display reports for
the selected volumes as long as the collective workfile size is less than or equal to (500MB -
SQL Buffer size). SQL Buffer size = 32 pages. (1Page = 2048Bytes.) It should display this
message for the specific disk on which workfile size exceeds 500MB - SQL Buffer:
"Unable to allocate enough space for workfile. Try again with
an empty workfile."
The SQL buffer size might be increased later to support the SQL/MX tables with a very large
number of partitions.
For SQL/MX objects
For DSAP reports generated from the permanent work file when you use the WORKFILE option,
DSAP:
•
Displays "*SQL" in the SECURITY column
•
Displays the name of the resource fork for the user files in the CATALOG column.
•
Displays in the RCODE:
Executables
0
Tables, views, LOB tables, and so on
1
Indexes
2
•
Displays SQL for the FILE-KIND column
•
Differentiates between SQL/MP and SQL/MX objects
•
Differentiates between SQL/MX tables, views, LOB tables, and so on in SQL-OBJECT-TYPE
•
Differentiates between ANSI and materialized views in SQL-VIEW-TYPE
Completion Information
DSAP returns completion information to the process that started it. The completion code indicates
how successful DSAP ran. Its primary purpose is to support batch processing by allowing conditional
execution of subsequent processes based on the success of the DSAP process. If TACL started the
DSAP process, the completion information is stored in a TACL variable (:_COMPLETION), where
you can examine it by using TACL functions.
The TACL also displays the completion information at the home terminal, unless the DSAP process
completes normally without any warnings or errors. For more information about completion
information and batch processing, see the TACL Programming Guide.
The completion information returned by DSAP includes:
Meaning
Field
An integer that describes how DSAP terminated, as described in
Table 13
.
completioncode
An integer that describes the nature of errors or warnings, as described in
Table 13
.
terminationinfo
The DSAP subsystem ID, TANDEM.32.
release
, where
release
is the product version
of the DSAP utility (C30, for example).
subsystem
A character string describing the code in
terminationinfo
. See
Table 13
.
text
The number of characters in
text
.
textlength
98
Disk Space Analysis Program (DSAP)
