CALL [SYSLIB.] FixAllocatedSpace ( 'FixSpaceOption', 'AllDatabases', 'AllProxyUsers', 'FixDatabaseName', FixedDatabaseCount Errinfo ) [;]
Syntax Elements
- SYSLIB
- The name of the database where the function is located.
- FixSpaceOption
- The type of allocated space to be updated. Specify one of the following options:
- P (permanent)
- S (spool)
- A (all options)
Cannot be NULL.
- AllDatabases
- Update allocated space for all databases. Specify one of the following values:
- Y
- N
- NULL
- AllProxyUsers
- Update allocated space for all proxy users. Specify one of the following values:
- Y
- N
- NULL
Only the proxy users with an assigned profile qualify for the fix space operation.
- FixDatabaseName
- Target database name. Required if both AllDatabases and AllProxyUsers are not specified (have a value of N or NULL). FixDatabaseName must be NULL if either AllDatabases or AllProxyUsers has a value of Y.
- FixedDatabaseCount
- Output count of databases whose allocated space was fixed.
- ErrInfo
- NULL if the fix space operation was successful. Otherwise, provides information about the error that caused the procedure to stop before the operation completed.