Thanks Tom. I also just found the "length" function usefull about doing a bit of googling.
sel * from dbc.tablesv where length(tablename) > 30
What happens if I have some tables in the database which have names more than, lets say 30 chars long, and NameValidationRule now is set to 1? Do I have to first rename those tables?
No, existing objects are not affected. The new Name Validation rule applies when you CREATE new objects (or for the new name specified on a RENAME).
MultiLoad and FastLoad aren't exactly obsolete -- they are still present in recent releases of TTU -- but I agree that you should use TPT nowadays. The MultiLoad and FastLoad partitions within the database are not obsolete, of course; they are used by TPT.