I worked on a system (state govm't) that had ADABAS years ago, mostly it depends on what version your running, some tuning opportunities were in the latest release, about 2011,2012 timeframe, another tuning opportunity was placement of the DB's and index files( ASSOC file) - what I recall back with DB performance was DASD CACHE, it was suggested DFW was turned off, IIRC, and the ASSOC file and DB be on the same volume? that's all from memory, a good resource as Rob has suggested is ADABAS support.
Carmen Vitullo ----- Original Message ----- From: "Tony Thigpen" <[email protected]> To: [email protected] Sent: Thursday, August 2, 2018 10:13:58 AM Subject: ADABAS tuning 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. 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. 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. 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. 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. -- Tony Thigpen ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
