check extents argument: Check extent consistency (SQL administration API)

Use the check extents argument with the admin() or task() function to verify that the extents on disk correspond to the current control information.


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

>--(--"check extents"--+-------------------+--)--;-------------><

Element Description Key Considerations
dbspace_number The number of the dbspace to check.  


Run this function to check each chunk-free list and corresponding free space and each tblspace extent. If you do not specify a dbspace number, all dbspaces are checked. The function checks dbspaces, blobspaces, smart-large-object extents, and user-data and metadata information in sbspace chunks.

This function is equivalent to the oncheck -ce command.


The following example checks the extents in the dbspace with the number 2:
EXECUTE FUNCTION task("check extents",2);

Copyright© 2018 HCL Technologies Limited