Tony Thigpen wrote: >Is there anyone that would be willing to give me some guidance to solve some >ADABAS issues. Something is causing a performance problem and nobody seems to >even know where to start looking.
At what z/OS and ADABAS level are you? >We have several Natural programs that run in minutes one night, then take an >hour on other nights. We also have some RPG programs (using the VSAM bridge) >that have similar problems. Batch or Online? In what WLM classes / priority are these programs running? What is RMF telling you about performance? Are the _SAME_ transactions / ADABAS calls being run in one night and then longer in other nights? Are the duration not perhaps being due to enqueues or lockouts inside the database? >The programmers don't think it has to do with daily work-load changes. They >want to point the finger at Systems. We (systems) are not making changes. Ask them since when does it happen. Also, how often. What was done earlier in the day before the nights where it took longer? Ask them how often do they re-organizing / enlarging their database(s). This is important. >The 'DBA' belongs to the programmer group, and to be honest, I don't think he >has a clue concerning performance, just how to define the databases. Are the Com-Plete records written out? These records will tell you a lot about ADABAS transactions, calls and workload. Check your Buffer Pool, Work Pool, etc. There are many tuning settings inside ADABAS and Com-Plete. Check them out. >At this point, I just need a better idea of where the problem really is so I >can attempt to throw it back to the DBA. I think there is a SAG-L discussion list somewhere, but you should call Software AG for support. Trust me, ADABAS tuning is a thankless job. Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
