Well after speaking with the former DBA (he left zero details) I gathered more info about our db2 environment. Basically the tables all need major reorgs to free up wasted space in our environment. I started the reorgs this week and they take at least an hour since it hasnt been done in a long long time. I then ran some statistics after each reorg (runstats) and will use db2look for re-creation of tables that may fail during production loads. Basically when a deadlock occurs, we have to reorg the table, run db2look to recreate the ddl, drop the table that failed and re-create the table using the ddl gathered by db2look. So I am ramping up as the new dba. Its chaotic but then again thats why we dbas get paid the big bucks.