Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Alter Table script does not include Audit and Statistics Profile commands when rebuilding table.
설명
Table has the following characteristics: AUDIT POLICY and STATISTICS PROFILE. When a table change requires a drop and recreate of the table the AUDIT TABLE..USING POLICY and RUNSTATS....SET PROFILE ONLY commands are not retained (i.e. generated in the change script) in the Alter Table script and so these characteristics are lost.
해결 방안
WORKAROUND: None
STATUS: Waiting for fix to be released in a future version of Toad for DB2.