Start of change

SQWIDSC in macro DSN6SPRM

Specifies whether, when RENAME TABLE or DROP ALIAS is issued against an object against which there is already SQL activity, the DB2® database manager performs only an invalidate operation, or performs a quiesce operation and an invalidate operation on all SQL statements in the dynamic statement cache that depend on that object.

The default is NO, which means that the database manager invalidates and performs a quiesce operation on SQL statements in the dynamic statement cache that depend on an object that is the target of a RENAME TABLE or DROP ALIAS statement.

A value of YES means that the database manager invalidates but does not quiesce SQL statements in the dynamic statement cache that depend on an object that is the target of a RENAME TABLE or DROP ALIAS statement.

In a data sharing environment, all data sharing members need to use the same setting.

This parameter is deprecated.

End of change