- open and create derived tables
- detect which tables should be locked for write
- lock and fill derived tables
some unitialized variables fixed