allocinfo

Returns a list of allocation pages that are stored in an object allocation map (OAM) page.

Syntax

allocinfo(dbid, pageid, "option")

Parameters

dbid – is the database ID.
pageid – is the page ID.
option –
- help – shows a message with the different options.
- alloc pages on oam – provides the allocation page information.

Examples

– provides a list of allocation pages that are stored in an object allocation map (OAM) page.
select allocinfo(1,888,"alloc pages on oam")

Usage
allocinfo
Mechanism to retrieve all allocation pages for a particular partition or index.

Returns NULL for an invalid page, on a page other than OAM page, option values

Permissions
You must have sa_role to execute this command.