Re: performance problems db2 after moving from AIX

2020-11-04 Thread Grzegorz Powiedziuk
On Tue, Nov 3, 2020 at 8:46 AM Grzegorz Powiedziuk wrote: > Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 > on Z and we are having big performance issues. > What about enabling SMT in z/VM ? Would 10 cpu db2 take an advantage of this? On the p8 they had SMT-8 turned

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Eric Covener
> Where can I look for potential relief? Everyone was hoping for a better > performance not worse.I am hoping that there is something we can tweak to > make this better. Only because I didn't see it specifically in the thread yet, do you have similar large page size support/tuning in both

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Tully, Phil (CORP)
Can you provide the zVM SRM parameters and MT status? Regards, Phil Tully Chief Architect-z/VM & z/Linux phil.tu...@adp.com cell: 973-202-7427 1-800 377-0237,,5252697# On 11/3/20, 12:25 PM, "Linux on 390 Port on behalf of Grzegorz Powiedziuk" wrote: WARNING: Do not click links or

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Rob van der Heij
On Tue, 3 Nov 2020 at 21:27, Grzegorz Powiedziuk wrote: > > In the performance monitor toolkit it shows around 12.000 diag x'9c' /s > and 50 x'44' > But at this time of a day everything is calm. i will check again tomorrow. > Lot's of diag x'9c' would indicate too many virtual cpus right? > You

Re: performance problems db2 after moving from AIX

2020-11-03 Thread barton
Diag 9C are low cost, Diag 44 not so much.  50 is a low number. On 11/3/2020 12:27 PM, Grzegorz Powiedziuk wrote: On Tue, Nov 3, 2020 at 1:58 PM Grzegorz Powiedziuk wrote: Thanks Christian. There is no pagging (swapping) here besides just regular kernel's house keeping (vm.swappiness =5 )

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
On Tue, Nov 3, 2020 at 3:25 PM Jim Elliott wrote: > Gregory, > > Yes, thrashing. :-) > > I like my name better and it even fits better :) I will keep an eye on page faults tomorrow but we are not overcommitting memory at all. Unless something inside of db2 is cooking but in linux there is no

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
On Tue, Nov 3, 2020 at 1:58 PM Grzegorz Powiedziuk wrote: > Thanks Christian. > There is no pagging (swapping) here besides just regular kernel's house > keeping (vm.swappiness =5 ) > rhel 7 doesn't give me diag_stat in the debug filesystem hmm > > On Tue, Nov 3, 2020 at 12:37 PM Christian

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Jim Elliott
Gregory, Yes, thrashing. :-) Jim Elliott Senior IT Consultant - GlassHouse Systems Inc. On Tue, Nov 3, 2020 at 2:07 PM Grzegorz Powiedziuk wrote: > On Tue, Nov 3, 2020 at 1:57 PM Jim Elliott wrote: > > > Gregory, > > > > The 9117-MMD could range from 1 chip/4 cores all the way up to 16 >

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
On Tue, Nov 3, 2020 at 1:57 PM Jim Elliott wrote: > Gregory, > > The 9117-MMD could range from 1 chip/4 cores all the way up to 16 chips/64 > cores at either 3.80 or 4.22 GHz. If it has 15 cores, then it was likely > the 4.22 GHz 5 chip/15 core version. Using 10 out of 15 cores (even at 100% >

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
On Tue, Nov 3, 2020 at 1:35 PM r.stricklin wrote: > > I recently had a vaguely similar problem with a much smaller database on > linux (x86, mysql for zabbix) that presented bizarre performance issues > despite clearly having lots of resources left available. > > What our problem ended up being

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
Thanks Christian. There is no pagging (swapping) here besides just regular kernel's house keeping (vm.swappiness =5 ) rhel 7 doesn't give me diag_stat in the debug filesystem hmm On Tue, Nov 3, 2020 at 12:37 PM Christian Borntraeger < borntrae...@linux.ibm.com> wrote: > On 03.11.20 14:46,

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Jim Elliott
Gregory, The 9117-MMD could range from 1 chip/4 cores all the way up to 16 chips/64 cores at either 3.80 or 4.22 GHz. If it has 15 cores, then it was likely the 4.22 GHz 5 chip/15 core version. Using 10 out of 15 cores (even at 100% busy) should fit on 5 z14 ZR1 or z14 M0x IFLs. Sounds like there

Re: performance problems db2 after moving from AIX

2020-11-03 Thread r.stricklin
On Nov 3, 2020, at 5:46 AM, Grzegorz Powiedziuk wrote: > DB2 is running on the ext4 filesystem (Actually a huge number of > filesystems- each NODE is a separate logical volume). Separate for logs, > data. I recently had a vaguely similar problem with a much smaller database on linux (x86, mysql

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Tully, Phil (CORP)
Can you provide the output of Q MULTITHREAD and Q SRM Regards, Phil Tully Chief Architect-z/VM & z/Linux phil.tu...@adp.com cell: 973-202-7427 1-800 377-0237,,5252697# On 11/3/20, 8:47 AM, "Linux on 390 Port on behalf of Grzegorz Powiedziuk" wrote: WARNING: Do not click links or open

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Christian Borntraeger
On 03.11.20 14:46, Grzegorz Powiedziuk wrote: > Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 on > Z and we are having big performance issues. > Same memory, CPU number is down from 12 to 10. Although they had > multithreading ON so they saw more "cpus" We have faster

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
Hi Jim, correction - we have z14 not z114 .. .not sure why I keep calling our z14 z114 ;) We have z14 We have 16 IFLs in total shared across 5 z/VM lparps but really there is literally nothing running in there yet beside this one huge VM which has 10 IFLs configured. We have plenty of spare

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Jim Elliott
Gregory: Do you have a z114 with 10 IFLs? That is the maximum number of IFLs available on a z114 (2818-M10) and would be unusual. Is this a single z/VM LPAR? How much memory is on the z114 (and in this LPAR)? Also, what was the specific MT/Model for the P7 box? If you were to compare a 12-core

Re: performance problems db2 after moving from AIX

2020-11-03 Thread Robert J Brenneman
you've got a gig of swap used , and you said %system CPU time is way higher while the system becomes unusable ? are you actively swapping during that time when the system is not responsive? If yes you need to try to either add memory or reduce the memory demand on the system. On Tue, Nov 3, 2020

performance problems db2 after moving from AIX

2020-11-03 Thread Grzegorz Powiedziuk
Hi, I could use some ideas. We moved a huge db2 from old p7 aix to rhel7 on Z and we are having big performance issues. Same memory, CPU number is down from 12 to 10. Although they had multithreading ON so they saw more "cpus" We have faster disks (moved to flash), faster FCP cards and faster