API for housekeeping with active data integrity framework

FTM SWIFT provides the Db2® stored procedures DNI_DI_OPEN and DNI_DI_CLOSE that can be used to do housekeeping using SQL with INSERT and DELETE statements in an active data integrity framework:
  • DNI_DI_OPEN can be used to open a connection to the data integrity framework so that external applications can insert and delete data in access-controlled tables.
  • DNI_DI_CLOSE can be used to close the connection to the data integrity framework so that external applications can no longer manipulate data in access-controlled tables.

Required privileges

To be able to invoke stored procedures DNI_DI_OPEN and DNI_DI_CLOSE, you have to execute the following GRANT statements: 
GRANT READ,WRITE ON VARIABLE DNIvSN.DI_SESSION_INFO
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_DI_OPEN
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_DI_CLOSE
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_DI_CHECK
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_DI_CHECK_INSERT
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_DI_CHECK_UPDATE
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_WRITE_SYSLOG
GRANT EXECUTE ON PROCEDURE DNIvSN.DNI_WRITE_SYSLOG_CODE
where DNIvSN represents the database schema of your FTM SWIFT environment. These permissions should be limited to housekeeping users only.

Transactional behavior

DNI_DI_OPEN and DNI_DI_CLOSE are processed under transactional control. For example, a rollback after DNI_DI_OPEN closes the connection to the data integrity framework. A commit after DNI_DI_OPEN persists the connection to the data integrity framework for the duration of the Db2 connection.