Can we restrict Fallback table creation in system at user level or system level.?
I mean: Is there any way so that we can restrict users to create fallback table in system ? any DBScontrol parameter ?
no, you can't.
Simply set the database default to NO FALLBACK and hope the end users don't overwrite it.
Maybe add a scheduled job which mails the users when they do and submits ALTER TABLE, NO FALLBACK...
but there is one DBS Control Parameter in Internal Group-113.
This parameter has three values. But it is not fulfil my requirment as it help in fallback direction.