Turning off level check is a sure way to corrupt your database files. It also can bring about data problems that you might not find out for some time.

I don't recommend it under any circumstances and turning off level check should never be a shop standard and the use of LVLCHK(*NO) can produce unpredictable results.

To change a PF DDS efficiently, look at the CHGPF command SRCFILE parameter.

To find the objects to recompile, you can find them out using several methods:-

1) DSPDBR the physical to get the list of logicals. Use the option 25 in PDM (STRPDM, option 2, then select your source files, then use 25). Run searches for each logical file name (or partial name if you name your logicals generically)

2) OR DSPDBR the physical to get the list of logicals. DSPPGMREF the program object libraries to a PF (with *ADD) to get a list of all the program references. Write a query to pull out a list of all programs etc. that are referencing the files (again, generically named logicals make it a bit easier

3) Formalise step 2 to create a utility to automate the process - it will pay you back for doing so.

So the bottom line is never ever use LVLCHK(*NO) for your tables, use other alternatives.