BEFORE triggers not allowed on QSYS2.SQL_ERRORT and QSYS2.SYSIXADV tables

The QSYS2.SQL_ERRORT (SQL Error Logging Facility) and QSYS2.SYSIXADV (Index Advisor) tables are changed so users cannot modify the content of the tables through insert or update operations. As part of this change, BEFORE triggers can no longer be defined for these tables.

AFTER INSERT, AFTER UPDATE, and AFTER DELETE triggers remain supported for these tables.

This change will occur on IBM® i with following:

  • Base release of IBM I 7.6
  • IBM i Db2® for i 7.5: PTF Group SF99950 level 9
  • IBM i Db2 for i 7.4: PTF Group SF99704 level 30