Configuring a DB2 for i 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 for i, 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')
```
If you are using IBM i version V5R2 or prior, modify the job description QDFTJOBD that is the *JOBD for IBM i User QUSER by changing the value for its Inquiry Message Reply option:
```
CHGJOBD JOBD(QGPL/QDFTJOBD) INQMSGRPY(*SYSRPYL)
```
If you are using IBM i version V5R3 or later, modify the job description QDFTSVR that is the *JOBD for IBM i User QUSER by changing the value for its Inquiry Message Reply option:
```
CHGJOBD JOBD(QGPL/QDFTSVR) INQMSGRPY(*SYSRPYL)
```
Note: Whenever you change the configuration of IBM i, you must delete the SQL packages.