Effect of issuing a PREPARE statement with only the EXPLAIN privilege
When you issue a PREPARE statement, Db2 checks for the privilege to issue the statement on which PREPARE is performed, and then checks for the EXPLAIN privilege.
When the RACF access control module is used for authorization checking, and you do not have the authority to issue the SQL statement on which PREPARE is performed, RACF issues unauthorized request message ICH408I. If you do not have the authority to issue the SQL statement, but you have the EXPLAIN privilege, you receive message ICH408I, but PREPARE processing succeeds. The statement that Db2 prepares when you have only the EXPLAIN privilege cannot be executed. However, Db2 provides the descriptive information for the statement.