back in 2000 or so, MXG had some SAS process to analyze ADABAS PLOGS,
//ADALOG DD DISP=SHR,DSN=xx.ADABAS.PLOGCOPY //SYSIN DD * OPTIONS NOSOURCE NOFMTERR; %INCLUDE SOURCLIB(XADALOG); RUN; been a long time since I've looked at ADABAS so if you have MXG, this 'may' help some other than that, the SMF30's is the only other place I've looked Carmen Vitullo ----- Original Message ----- From: "Clark Morris" <cfmt...@uniserve.com> To: IBM-MAIN@LISTSERV.UA.EDU Sent: Thursday, August 2, 2018 1:40:27 PM Subject: Re: ADABAS tuning [Default] On 2 Aug 2018 08:43:32 -0700, in bit.listserv.ibm-main t...@vse2pdf.com (Tony Thigpen) wrote: >To answer some of the questions: > >1) There is no monitor. >2) WLM only has two profiles, DAY and NIGHT. These jobs all run during >the NIGHT settings. >3) Turf war prevents me from actually calling ADABAS support. Only the >DBA is allowed that option. And, if the issues are resolved with ADABAS >tuning, then he will look really bad as he has placed all the blame on >'Systems'. So, he will not call them for us. I would compare all of the job statistics that you have access to including CPU time and i-os to see what differs between normal and spike nights. Also check what is running concurrently with the spike night jobs. It may be a scheduling conflict. Also if Adabas is cutting any SMF records that could be helpful get those and ask for access to the tool(s) to interpret them. Clark Morris > >I need to get enough ammo to dump it back on the DBA. > >Tony Thigpen > >Tony Thigpen wrote on 08/02/2018 11:13 AM: >> 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. >> > >---------------------------------------------------------------------- >For IBM-MAIN subscribe / signoff / archive access instructions, >send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
