SQL/MX 2.x Reference Manual (H06.04+)

Metadata Tables
HP NonStop SQL/MX Reference Manual—540440-003
10-82
RESOURCEPOLICIES Table
RESOURCEPOLICIES Table
RESOURCEPOLICIES is a metadata table in
NONSTOP_SQL_nodename.MXCS_SCHEMA that contains governing information.
Column Name Data Type Description
*1 RES_ID INT Identifier providing link to a parent
object (datasource, user or profile)
2 ATTRIBUTE_NAME VARCHAR(128) Governed resource
3 LIMIT_VALUE LARGEINT Resource attribute test limit value
4 ACTION_ID LARGEINT Action to be taken when limit is
reached
5 SETTABLE SMALLINT 0 User’s preference values cannot
override configured values
1 User's preference values can
override configured values
6 LAST_UPDATED TIMESTAMP(6) Julian timestamp of last update to
this status record
* Indicates primary key