Wednesday 13 January 2010

Quickly enable logging

Use the following SQL to quickly update logging to be enabled.

Note that this statement will enable logging for PY(ish) environments for the F0011.

update sy812.f9500001
set frffcfr5 = '1'
where frobjnm = 'F0011' and frenvironmnt like '%PY812%' ;

commit ;

You need to do this because auditing is sometimes a real pain in the ass. It thinks it's off in the catalogs, but maybe after a data refresh, it's actually on... You know what I mean if you got to here!

No comments: