DB2 SQL-Error: -947
SQLState: 56038
Short Description: THE SQL STATEMENT FAILED BECAUSE IT WILL CHANGE A TABLE DEFINED WITH DATA CAPTURE CHANGES BUT THE DATA CANNOT BE PROPAGATED C E SQL C SQLCODE IMS I SQL DATA CAPTURE CHANGES
The DPROP SUPPORT option on the installation panel is set to 2 (support DPROP only). The SQL statement would have changed a table defined with DATA CAPTURE CHANGES. However, the data cannot be propagated because the SQL statement did not originate from an IMS subsystem, or monitor trace class 6 was not active at the beginning of the unit of work for that change. System action: The statement is not executed. System programmer response: Take one of the following actions: v Change the installation option to 1 (no propagation) or 3 (permit changes from any subsystem).