Returns information about subsections of access plans from
an application snapshot.
>>-SNAPSHOT_SUBSECT--(--dbname--,--dbpartitionnum--)-----------><
Table function parameters
- dbname
- An input argument of type VARCHAR(255) that specifies a valid
database name in the same instance as the currently connected database
when calling this function. Specify a database name that has a directory
entry type of either "Indirect" or "Home", as returned by the LIST
DATABASE DIRECTORY command. Specify the null value to take
the snapshot from all databases under the database instance.
- dbpartitionnum
- An input argument of type INTEGER that specifies
a valid database partition number. Specify -1 for
the current database partition, or -2 for all
active database partitions. An active database partition is a partition
where the database is available for connection and use by applications.
If
the null value is specified, -1 is set implicitly.
If both parameters are set to NULL,
the snapshot is taken only if a file has not previously been created
by the SNAPSHOT_FILEW stored procedure for the corresponding snapshot
API request type.
Authorization
One
of the following authorities is required to execute the function:
- EXECUTE privilege on the function
- DATAACCESS authority
To access snapshot monitor data, one of the following
authorities is required:
- SYSMON authority
- SYSCTRL authority
- SYSMAINT authority
- SYSADM authority
The function returns a table as shown in the following
section.