We are currently running our development database - DB2 v8.1.2 on Windows2k platform and observed that our db2 instance crashes very frequently. This would involve restarting of db2 instance several times in a day. So, the developers get affected all the time. We have checked up manuals, db forums on several tuning paramters for eg: LOCKLIST, MAXLOCKS, MAXAPPLS etc -- but, the problem still persists. Even the log file doesn't seem to show the information we are interested in...

My question is: Why is our db2 instance crashing frequently? How can we avoid this from happening?

Any help is greatly appreciated.