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

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+---------------------------------->
                     '-task--'   

>--(--+-"print partition"------+--,--"partition_number"--)--;--><
      '-"print partition full"-'                                

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");

Copyright© 2019 HCL Technologies Limited