2] If you database in DB/400
3] If your jde.log says "JDB9900658 - Failed to drop audit columns for table F3111_ADT"
THEN this is what the CFR document says
Configuring a DB2/400 Database for Auditing
In an auditing configuration, when auditing is disabled for a table, all working columns will be dropped in the table through the SQL operation ALTER TABLE DROP COLUMN. In DB2/400, an Inquiry Message will be issued for this SQL operation when the column contains data. The purpose of the Inquiry Message is to obtain the user’s response to carry on the operation or to cancel the operation. However, the system cannot send this Inquiry Message to the user for a response and this causes the system to automatically cancel the SQL operation. The consequence is failure to disable auditing for the table.
To resolve this issue, perform these setup steps:
-
Add the following entry in the system reply list for the Inquiry Message - CPA32B2:
ADDRPYLE SEQNBR(3283) MSGID(CPA32B2) RPY('I')
-
Modify the job description QDFTJOBD that is the *JOBD for iSeries User QUSER by changing the value for its Inquiry Message Reply option:
CHGJOBD JOBD(QGPL/QDFTJOBD) INQMSGRPY(*SYSRPYL)
1] Dropping a column results in CPA32B2 inquiry message being issued.
2]ADDRPYLE
No comments:
Post a Comment