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


1  EXECUTE FUNCTION
1 admin
1 task
2  ( 
3.1 "print partition"
3.1 "print partition full"
2 ,
2 "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 of 1048611:
EXECUTE FUNCTION task("print partition","1048611");