[progress Communities] [progress Openedge Abl] Forum Post: Re: Database Really Slooooow

[ctoman]

George dbmon script check this out - all database files are on hdisk11 dbmon.sh Release 3.1.3, Jul 06, 2016 Command: iostat 4 5 Date: Wed Mar 29 06:41:04 2017 Host: AIX bmhc-pos2 3 5 00F66B1D4C00 Uptime: 06:41AM up 1213 days, 19:59, 2 users, load average: 2.05, 2.06, 2.03 . 2017/03/29 06:41:08 2017/03/29 06:41:08 System configuration: lcpu=4 drives=6 ent=1.00 paths=12 vdisks=2 2017/03/29 06:41:08 2017/03/29 06:41:08 tty: tin tout avg-cpu: % user % sys % idle % iowait physc % entc 2017/03/29 06:41:08 0.0 211.0 28.6 41.8 8.1 21.4 0.9 90.4 2017/03/29 06:41:08 2017/03/29 06:41:08 Disks: % tm_act Kbps tps Kb_read Kb_wrtn 2017/03/29 06:41:08 hdisk6 6.0 23.0 5.8 32 60 2017/03/29 06:41:08 hdisk7 0.0 1.0 2.2 2 2 2017/03/29 06:41:08 hdisk9 0.0 0.0 0.0 0 0 2017/03/29 06:41:08 hdisk8 0.0 0.0 0.0 0 0 2017/03/29 06:41:08 hdisk10 0.2 84.0 5.2 0 336 2017/03/29 06:41:08 hdisk11 100.0 3724.0 453.5 14560 336 2017/03/29 06:41:12 2017/03/29 06:41:12 tty: tin tout avg-cpu: % user % sys % idle % iowait physc % entc 2017/03/29 06:41:12 0.0 94.7 11.0 19.6 50.6 18.8 0.4 40.5 2017/03/29 06:41:12 2017/03/29 06:41:12 Disks: % tm_act Kbps tps Kb_read Kb_wrtn 2017/03/29 06:41:12 hdisk6 11.1 32.2 0.3 0 128 2017/03/29 06:41:12 hdisk7 0.0 1.0 2.0 2 2 2017/03/29 06:41:12 hdisk9 0.0 0.0 0.0 0 0 2017/03/29 06:41:12 hdisk8 0.0 0.0 0.0 0 0 2017/03/29 06:41:12 hdisk10 0.3 209.0 13.1 0 832 2017/03/29 06:41:12 hdisk11 100.5 3661.3 446.5 13612 960 2017/03/29 06:41:16 2017/03/29 06:41:16 tty: tin tout avg-cpu: % user % sys % idle % iowait physc % entc 2017/03/29 06:41:16 0.0 87.3 7.6 14.1 59.2 19.1 0.3 29.1 2017/03/29 06:41:16 2017/03/29 06:41:16 Disks: % tm_act Kbps tps Kb_read Kb_wrtn 2017/03/29 06:41:16 hdisk6 0.3 1.0 0.3 4 0 2017/03/29 06:41:16 hdisk7 0.3 1.0 2.3 2 2 2017/03/29 06:41:16 hdisk9 0.0 0.0 0.0 0 0 2017/03/29 06:41:16 hdisk8 0.0 0.0 0.0 0 0 2017/03/29 06:41:16 hdisk10 0.8 224.1 14.0 0 896 2017/03/29 06:41:16 hdisk11 100.1 4352.7 531.8 16504 896 2017/03/29 06:41:20 2017/03/29 06:41:20 tty: tin tout avg-cpu: % user % sys % idle % iowait physc % entc 2017/03/29 06:41:20 0.0 96.6 5.9 12.6 58.1 23.4 0.2 24.4 2017/03/29 06:41:20 2017/03/29 06:41:20 Disks: % tm_act Kbps tps Kb_read Kb_wrtn 2017/03/29 06:41:20 hdisk6 0.0 0.0 0.0 0 0 2017/03/29 06:41:20 hdisk7 0.0 1.0 2.2 2 2 2017/03/29 06:41:20 hdisk9 0.0 0.0 0.0 0 0 2017/03/29 06:41:20 hdisk8 0.0 0.0 0.0 0 0 2017/03/29 06:41:20 hdisk10 0.2 43.7 2.7 0 176 2017/03/29 06:41:20 hdisk11 99.4 3996.0 486.2 15300 784 2017/03/29 06:41:24 2017/03/29 06:41:24 tty: tin tout avg-cpu: % user % sys % idle % iowait physc % entc 2017/03/29 06:41:24 0.0 88.4 5.4 10.0 65.0 19.5 0.2 20.8 2017/03/29 06:41:24 2017/03/29 06:41:24 Disks: % tm_act Kbps tps Kb_read Kb_wrtn 2017/03/29 06:41:24 hdisk6 0.0 0.0 0.0 0 0 2017/03/29 06:41:24 hdisk7 0.2 1.0 2.2 2 2 2017/03/29 06:41:24 hdisk9 0.0 0.0 0.0 0 0 2017/03/29 06:41:24 hdisk8 0.0 0.0 0.0 0 0 2017/03/29 06:41:24 hdisk10 0.5 40.0 2.5 0 160 2017/03/29 06:41:24 hdisk11 99.9 3543.6 429.5 13648 544

Continue reading...