Skip to Content

What is maxdb doing with many dbmsrc -sdbstarter processes

1 month ago we have the same problem with the 7.9.08.08 maxdb. I increase the prozessor parameter from 1 to 2. After that we have no problem with many (80 to 95) dbmsrc -sdbstarter processes. But we have only a high load if user are working - and if many batch jobs are running.

Now the problem occours again. Processor load is up to 85 % of a 4 processor machine.

How can I find out what maxdb is doing at the moment ? Index are all ok.

Thanks a lot

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Mar 15 at 09:34 AM

    I deactivate the automatic update stats in maxdb and delete the jobs in db13 temporary. The massive load from dbmsrv is gone. I monitor the system for the next days ...

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 09:00 AM

    Hi,

    Are you care about what maxdb kernel is doing or why so many dbmsrv? what kind of the problem you meant?

    Following os command shows us what maxdb kernel is doing:


    x_cons show active

    Best regards,
    James

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 01:16 PM

    Yes so many dbmsrv and the high load.

    On the development system there is only one kernel and one dbmsrv running in the processes.

    This is running on production - looks not he have a lot to do !

    ID UKT UNIX TASK APPL Current Timeout/ Region Wait
    tid type pid state Priority cnt try item
    T8 9 21708 User 30994 Vwait 0 378688676(s)
    T9 9 21708 User 30287 Vwait 0 378688676(s)
    T10 9 21708 User 29590 Vwait 0 378688676(s)
    T11 8 21707 User 2970 Vwait 0 382410554(s)
    T13 8 21707 User 3509 Vwait 0 382410554(s)
    T15 9 21708 User 3587 Vwait 0 378688676(s)
    T16 8 21707 User 4566 Vwait 0 382410554(s)
    T17 8 21707 User 28510 Vwait 0 382410554(s)
    T19 9 21708 User 30307 Vwait 0 378688676(s)
    T20 9 21708 User 14971 Vwait 0 378688676(s)
    T22 8 21707 User 12046 JobWait UpdStt 0 382410554(s)
    T23 8 21707 User 14568 Vwait 0 382410554(s)
    T28 9 21708 User 28626 Vwait 0 378688676(s)
    T29 8 21707 User 2962 Vwait 0 382410554(s)
    T32 9 21708 User 29614 Vwait 0 378688676(s)
    T34 9 21708 User 12107 Vwait 0 378688676(s)
    T35 8 21707 User 1785 Vwait 0 382410554(s)
    T39 9 21708 User 3675 Vwait 0 378688676(s)
    T41 9 21708 User 30360 Vwait 0 378688676(s)
    T42 8 21707 User 3138 Vwait 0 382410554(s)
    T43 9 21708 User 29837 Vwait 0 378688676(s)
    T44 8 21707 User 14735 Vwait 0 382410554(s)
    T45 8 21707 User 2458 Vwait 0 382410554(s)
    T46 8 21707 User 28615 Vwait 0 382410554(s)
    T47 8 21707 User 14745 Vwait 0 382410554(s)
    T48 9 21708 User 24504 Vwait 0 378688676(s)
    T51 9 21708 User 23823 Vwait 0 378688676(s)
    T54 9 21708 User 30800 Vwait 0 378688676(s)
    T55 8 21707 User 2008 Vwait 0 382410554(s)
    T59 9 21708 User 25484 Vwait 0 378688676(s)
    T60 8 21707 User 2888 Vwait 0 382410554(s)
    T61 8 21707 User 29598 Vwait 0 382410554(s)
    T62 9 21708 User 14766 Vwait 0 378688676(s)
    T63 8 21707 User 12077 Vwait 0 382410554(s)
    T64 8 21707 User 22777 Vwait 0 382410554(s)
    T65 9 21708 User 23116 Vwait 0 378688676(s)
    T66 8 21707 User 31001 Vwait 0 382410554(s)
    T67 8 21707 User 3206 Vwait 0 382410554(s)
    T69 9 21708 User 30454 Vwait 0 378688676(s)
    T70 8 21707 User 3577 Vwait 0 382410554(s)
    T71 9 21708 User 28687 Vwait 0 378688676(s)
    T72 9 21708 User 30608 Vwait 0 378688676(s)
    T75 8 21707 User 14574 Vwait 0 382410554(s)
    T76 8 21707 User 14756 Vwait 0 382410554(s)
    T78 9 21708 User 23815 Vwait 0 378688676(s)
    T81 9 21708 User 14918 Vwait 0 378688676(s)
    T82 9 21708 User 15612 Vwait 0 378688676(s)
    T84 9 21708 User 30143 Vwait 0 378688676(s)
    T85 9 21708 User 24513 Vwait 0 378688676(s)
    T86 8 21707 User 24465 Vwait 0 382410554(s)
    T87 8 21707 User 22768 Vwait 0 382410554(s)
    T88 9 21708 User 29007 Vwait 0 378688676(s)
    T90 8 21707 User 28523 Vwait 0 382410554(s)
    T93 9 21708 User 30134 Vwait 0 378688676(s)
    T98 8 21707 User 23097 Vwait 0 382410554(s)
    T100 9 21708 User 23662 IO Wait (R) 0 19 378688676(s)
    T106 9 21708 User 28694 Vwait 0 378688676(s)
    T107 8 21707 User 4573 Vwait 0 382410554(s)
    T148 9 21708 User 23326 Vwait 0 378688676(s)
    T149 9 21708 User 23189 Vwait 0 378688676(s)
    T150 9 21708 User 23808 Vwait 0 378688676(s)
    T151 8 21707 User 2602 Vwait 0 382410554(s)
    T153 9 21708 User 29197 Vwait 0 378688676(s)
    T154 9 21708 User 14818 Vwait 0 378688676(s)
    T155 9 21708 User 3683 Vwait 0 378688676(s)
    T157 8 21707 User 14825 Vwait 0 382410554(s)
    T159 9 21708 User 29773 Vwait 0 378688676(s)
    T160 9 21708 User 3689 Vwait 0 378688676(s)
    T161 9 21708 User 25732 Vwait 0 378688676(s)
    T165 8 21707 User 2001 Vwait 0 382410554(s)
    T166 8 21707 User 29830 Vwait 0 382410554(s)
    T167 8 21707 User 28274 Vwait 0 382410554(s)
    T168 8 21707 User 20266 Vwait 0 382410554(s)
    T171 9 21708 User 29230 Vwait 0 378688676(s)
    T172 8 21707 User 30300 Vwait 0 382410554(s)
    T173 9 21708 User 28677 Vwait 0 378688676(s)
    T174 8 21707 User 2219 Vwait 0 382410554(s)
    T175 9 21708 User 29000 Vwait 0 378688676(s)
    T176 8 21707 User 22837 Vwait 0 382410554(s)
    T178 8 21707 User 28516 Vwait 0 382410554(s)
    T179 8 21707 User 2018 Vwait 0 382410554(s)
    T180 9 21708 User 24749 Vwait 0 378688676(s)
    T181 9 21708 User 30275 Vwait 0 378688676(s)
    T182 8 21707 User 2239 Vwait 0 382410554(s)
    T183 8 21707 User 22512 Vwait 0 382410554(s)
    T184 9 21708 User 28705 Vwait 0 378688676(s)
    T186 9 21708 User 31008 Vwait 0 378688676(s)
    T187 8 21707 User 23106 Vwait 0 382410554(s)
    T188 8 21707 User 28502 Vwait 0 382410554(s)
    T192 9 21708 User 28796 Vwait 0 378688676(s)
    T194 9 21708 User 15469 Vwait 0 378688676(s)
    T205 9 21708 User 17006 Vwait 0 378688676(s)
    T207 9 21708 User 29605 Vwait 0 378688676(s)
    T208 4 21703 UpdStat IO Wait (R) 0 2 146477472(s)
    T209 4 21703 UpdStat IO Wait (R) 0 8 146477472(s)

    this is running on developement system: (DB version is the newest 7.9)

    ID UKT UNIX TASK APPL Current Timeout Region Wait UKT
    tid type pid state Priority cnt try item count

    Console command finished (2018-03-14 14:16:42).

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 03:21 PM

    I think the problem is many locks in detail: row_share, row_exclusive in dbacockpit. MaxSQLLocks is 1500000. quite enough !

    Add comment
    10|10000 characters needed characters exceeded