DB2 for i Template

DB2 for i Controls

Powertech Database Monitor For IBM i Controls

The following User Activity controls can be applied to DB2 for IBM i Database software from within the Powertech Database Monitor for IBM i pre-configured datasource:

Action	Subaction	Condition
User Statement	Delete Statement	OPERATION TYPE=D
User Statement	Insert Statement	OPERATION TYPE=A
User Statement	Select Statement	OPERATION TYPE=R
User Statement	Update Statement	OPERATION TYPE=C

VMC DataMonitor (Delete-Clear Table-End Journaling action), (Insert-Update statements) and VMC Interactive SQL Monitor

The following System Management and User Activity controls can be applied to DB2 for IBM i Database software from within the VMC DataMonitor (Delete-Clear Table-End Journaling action pre-configured datasource:

Datasource	Control	Action	Subaction	Condition
VMC DataMonitor (Delete-Clear Table-End Journaling action)	System Management	Audit Modification	End Journaling	OPERATION TYPE=E
		Object Deletion	Table Clear	OPERATION TYPE=C
		Object Deletion	Table Deletion	OPERATION TYPE=F
	User Activity	User Statement	Delete Statement	OPERATION TYPE=D
		User Statement	Select Statement	OPERATION TYPE=R
VMC DataMonitor (Insert-Update statements)	User Activity	User Statement	Insert Statement	OPERATION TYPE=A
		User Statement	Update Statement	OPERATION TYPE=U
VMC Interactive SQL Monitor	User Activity	User Statement	Failed Interactive SQL Sentence	Message ID equals .*SQl9000.*
		User Statement	Successful Interactive SQL Sentence	Message ID equals .*SQl8000.*