print partition argument: Print partition information (SQL administration API)
Use the print partition argument with the admin() or task() function to print the headers of a specified partition.
Syntax
EXECUTE FUNCTION
{
admin
| task
}
(
{
"print partition"
| "print partition full"
}
,"partition_number" )
;
| Element | Description | Key Considerations |
|---|---|---|
| partition_number | The partition number. | Find the partition numbers in the partnum column of the systables system catalog table. |
Usage
Use this function to print a tblspace report for the specified partition.
Run this function with the full argument to include index-specific information and page-allocation information by page type for dbspaces.
This function with the print partition argument is equivalent to the oncheck -pt command.
This function with the print partition full argument is equivalent to the oncheck -pT command.
Example
The following example prints the headers for a partition with a number of1048611:EXECUTE FUNCTION task("print partition","1048611");