Returns general information from an application snapshot.
>>-SNAPSHOT_APPL_INFO--(--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 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 authorizations is required:
- EXECUTE privilege on the SNAPSHOT_APPL_INFO table function
- DATAACCESS authority
To access snapshot monitor data, one of the
following authorizations is also required:
- SYSMON authority
- SYSCTRL authority
- SYSMAINT authority
- SYSADM authority
Default PUBLIC privilege
In a non-restrictive database, EXECUTE privilege is granted
to PUBLIC when the function is automatically created.
The function returns a table as shown in the following
section: