>>-SNAP_GET_STO_PATHS--(--dbname--,--dbpartitionnum--)---------><
The SNAP_GET_STO_PATHS table function returns snapshot
information from the storage_paths logical data group.
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 the currently connected database.
- 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 will be 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.