Topic
No replies
KennyKC
KennyKC
1 Post
ACCEPTED ANSWER

Pinned topic CREATE AUDIT POLICY encountered error

‏2010-03-17T07:51:53Z |
Hi,
When I run below script in db2 version 9.1.6

CREATE AUDIT POLICY MIS_AUDIT CATEGORIES SYSADMIN STATUS BOTH ERROR TYPE AUDIT
COMMIT

I encountered error message

DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "POLICY" was found following "CREATE AUDIT ".
Expected tokens may include: "JOIN". SQLSTATE=42601

My id has SECADM rights. Pls assist and thanks in advance.

Kenny.