How QUERY SECURITY works depends on:
- Whether SEC=YES or SEC=NO is specified in the system initialization parameters
The value specified for the SECPRFX system initialization parameter
- Which resource classes are active
- Whether the transaction issuing the request is subject to transaction
routing, and if so:
- Which ATTACHSEC parameter was specified on the connection definition
- For RESTYPE('PSB') only, whether the PSBCHK system initialization
parameter is specified as YES or NO
Note: QUERY SECURITY is not affected by the
RESSEC and CMDSEC keywords on the transaction definition.
There are two distinct forms of the QUERY SECURITY command, depending on
the options chosen.
- QUERY SECURITY RESTYPE
- QUERY SECURITY RESCLASS