The schema is SYSPROC.
EXECUTE privilege on the ADMIN_GET_MSGS table function. The fenced user ID must have read access to the files under the directory indicated by registry variable DB2_UTIL_MSGPATH. If the registry variable is not set, then the fenced user ID must have read access to the files in the tmp subdirectory of the instance directory.
In a non-restrictive database, EXECUTE privilege is granted to PUBLIC when the function is automatically created.
SELECT * FROM TABLE(SYSPROC.ADMIN_GET_MSGS('24523_THERESAX')) AS MSG
DBPARTITIONNUM AGENTTYPE SQLCODE MSG
-------------- --------- --------- ---------------------------------------...-
- - SQL3104N The Export utility is beginning to
export data to file
"/home/theresax/rtest/data/ac_load03.del".
- - SQL3105N The Export utility has finished
exporting "8" rows.
2 record(s) selected.
The query statement that invokes this table function with the appropriate operation_id can be found in the MSG_RETRIEVAL column of the first result set returned by the ADMIN_CMD procedure.
Column name | Data type | Description |
---|---|---|
DBPARTITIONNUM | INTEGER | dbpartitionnum - Database partition number monitor element |
AGENTTYPE | CHAR(4) | Agent type. This value is only returned for
a distributed load. The possible values are:
|
SQLCODE | VARCHAR(9) | SQLCODE of the message being returned. |
MSG | VARCHAR(1024) | Short error message that corresponds to the SQLCODE. |