Db2

  • 1.  db2license

    IBM Champion
    Posted Mon January 11, 2021 05:18 AM
    Hi, 

    I'm running DMC 3.1.3.0 Enterprise Build: 20201101-211702.

    I have a question regarding connections the DMC makes to the database that is being monitored. I see an excessive amount of connections with application name db2license.

    Is this necessary since they consume 1 agent and never close the connection. The list keeps on growing day after day.

    Here is the list I have today:

    Auth Id  Application    Appl.      Application Id                                                 DB       # of

             Name           Handle                                                                    Name    Agents

    -------- -------------- ---------- -------------------------------------------------------------- -------- -----

    DB2INST1   db2license     56421      ::ffff:10.230.2.4.40422.210107122043                           DBPRD   1

    DB2INST1   db2license     24967      ::ffff:10.230.2.4.40708.210111085204                           DBPRD   1

    DB2INST1   db2license     41513      ::ffff:10.230.2.4.51782.210106222736                           DBPRD   1

    DB2INST1   db2license     53763      ::ffff:10.230.2.4.39688.201231220119                           DBPRD   1

    DB2INST1   db2license     46980      ::ffff:10.230.2.4.33334.210105093102                           DBPRD   1

    DB2INST1   db2license     31230      ::ffff:10.230.2.4.41696.210111091204                           DBPRD   1

    DB2INST1   db2license     40651      ::ffff:10.230.2.4.47336.210107232710                           DBPRD   1

    DB2INST1   db2license     31197      ::ffff:10.230.2.4.41402.210104112703                           DBPRD   1

    DB2INST1   db2license     39289      ::ffff:10.230.2.4.36776.201231010220                           DBPRD   1

    DB2INST1   db2license     49460      ::ffff:10.230.2.4.48302.201228194248                           DBPRD   1

    DB2INST1   db2license     60256      ::ffff:10.230.2.4.34890.210104140238                           DBPRD   1

    DB2INST1   db2license     44394      ::ffff:10.230.2.4.43990.210110011601                           DBPRD   1

    DB2INST1   db2license     38894      ::ffff:10.230.2.4.34896.210106011339                           DBPRD   1

    DB2INST1   db2license     42065      ::ffff:10.230.2.4.45610.210107010310                           DBPRD   1

    DB2INST1   db2license     39190      ::ffff:10.230.2.4.59926.210106140124                           DBPRD   1

    DB2INST1   db2license     361        ::ffff:10.230.2.4.38206.210104203835                           DBPRD   1

    DB2INST1   db2license     49986      ::ffff:10.230.2.4.33626.210106103541                           DBPRD   1

    DB2INST1   db2license     5111       ::ffff:10.230.2.4.50062.210105074043                           DBPRD   1

    DB2INST1   db2license     63111      ::ffff:10.230.2.4.42410.210104114714                           DBPRD   1

    DB2INST1   db2license     35532      ::ffff:10.230.2.4.33460.201230083418                           DBPRD   1

    DB2INST1   db2license     34124      ::ffff:10.230.2.4.44950.210111020038                           DBPRD   1

    DB2INST1   db2license     1920       ::ffff:10.230.2.4.45874.210105231327                           DBPRD   1

    DB2INST1   db2license     48091      ::ffff:10.230.2.4.51822.210105125644                           DBPRD   1

    DB2INST1   db2license     13716      ::ffff:10.230.2.4.35080.210106191705                           DBPRD   1

    DB2INST1   db2license     55808      ::ffff:10.230.2.4.58392.210108125446                           DBPRD   1

    DB2INST1   db2license     7183       ::ffff:10.230.2.4.60538.210108020730                           DBPRD   1

    DB2INST1   db2license     58183      ::ffff:10.230.2.4.39004.201228231823                           DBPRD   1

    DB2INST1   db2license     55854      ::ffff:10.230.2.4.49358.201228200248                           DBPRD   1

    DB2INST1   db2license     6900       ::ffff:10.230.2.4.43768.210101195026                           DBPRD   1

    DB2INST1   db2license     3900       ::ffff:10.230.2.4.54708.210101154933                           DBPRD   1

    DB2INST1   db2license     36196      ::ffff:10.230.2.4.50386.210104010437                           DBPRD   1

    DB2INST1   db2license     35071      ::ffff:10.230.2.4.45006.210107185119                           DBPRD   1

    DB2INST1   db2license     19867      ::ffff:10.230.2.4.45836.201231231124                           DBPRD   1

    DB2INST1   db2license     59913      ::ffff:10.230.2.4.41610.210101190507                           DBPRD   1

    DB2INST1   db2license     46459      ::ffff:10.230.2.4.38692.210111050621                           DBPRD   1

    DB2INST1   db2license     49755      ::ffff:10.230.2.4.51558.210107082942                           DBPRD   1

    DB2INST1   db2license     29005      ::ffff:10.230.2.4.46654.210106111042                           DBPRD   1

    DB2INST1   db2license     57176      ::ffff:10.230.2.4.55906.210108120433                           DBPRD   1

    DB2INST1   db2license     7926       ::ffff:10.230.2.4.39022.210102003058                           DBPRD   1

    DB2INST1   db2license     21643      ::ffff:10.230.2.4.60134.201230201132                           DBPRD   1

    DB2INST1   db2license     44518      ::ffff:10.230.2.4.54396.210104160742                           DBPRD   1

    DB2INST1   db2license     1610       ::ffff:10.230.2.4.49380.210108084407                           DBPRD   1

    DB2INST1   db2license     55235      ::ffff:10.230.2.4.45384.210107131043                           DBPRD   1

    DB2INST1   db2license     60485      ::ffff:10.230.2.4.48608.210108141958                           DBPRD   1

    DB2INST1   db2license     15406      ::ffff:10.230.2.4.52184.210110050644                           DBPRD   1

    DB2INST1   db2license     61031      ::ffff:10.230.2.4.39176.210104143733                           DBPRD   1

    DB2INST1   db2license     45827      ::ffff:10.230.2.4.41668.210104152740                           DBPRD   1

    DB2INST1   db2license     50873      ::ffff:10.230.2.4.37868.201231165012                           DBPRD   1

    DB2INST1   db2license     10794      ::ffff:10.230.2.4.59346.210107180120                           DBPRD   1

    DB2INST1   db2license     41886      ::ffff:10.230.2.4.33524.210104133723                           DBPRD   1

    DB2INST1   db2license     58195      ::ffff:10.230.2.4.58848.201230234701                           DBPRD   1

    DB2INST1   db2license     55208      ::ffff:10.230.2.4.54700.210101154927                           DBPRD   1

    DB2INST1   db2license     56083      ::ffff:10.230.2.4.43014.210104115713                           DBPRD   1

    DB2INST1   db2license     39333      ::ffff:10.230.2.4.45848.210110015620                           DBPRD   1

    DB2INST1   db2license     42754      ::ffff:10.230.2.4.41434.210106203715                           DBPRD   1

    DB2INST1   db2license     46425      ::ffff:10.230.2.4.40122.210101020653                           DBPRD   1

    DB2INST1   db2license     39392      ::ffff:10.230.2.4.47816.201231025241                           DBPRD   1

    DB2INST1   db2license     58642      ::ffff:10.230.2.4.48702.210104125724                           DBPRD   1

    DB2INST1   db2license     33642      ::ffff:10.230.2.4.53654.210101025159                           DBPRD   1

    DB2INST1   db2license     35892      ::ffff:10.230.2.4.52900.210110234513                           DBPRD   1

    DB2INST1   db2license     5813       ::ffff:10.230.2.4.60736.210101231047                           DBPRD   1

    DB2INST1   db2license     21984      ::ffff:10.230.2.4.47624.210104123710                           DBPRD   1

    DB2INST1   db2license     21609      ::ffff:10.230.2.4.44282.210109005644                           DBPRD   1

    DB2INST1   db2license     21905      ::ffff:10.230.2.4.38068.201230021809                           DBPRD   1

    DB2INST1   db2license     12076      ::ffff:10.230.2.4.45398.201231020232                           DBPRD   1

    DB2INST1   db2license     2701       ::ffff:10.230.2.4.58964.210104230414                           DBPRD   1

    DB2INST1   db2license     29122      ::ffff:10.230.2.4.60950.210104132223                           DBPRD   1

    DB2INST1   db2license     51997      ::ffff:10.230.2.4.35936.210104102655                           DBPRD   1

    DB2INST1   db2license     23589      ::ffff:10.230.2.4.59938.210109022158                           DBPRD   1

    DB2INST1   db2license     31589      ::ffff:10.230.2.4.55910.210108120437                           DBPRD   1

    DB2INST1   db2license     55510      ::ffff:10.230.2.4.58402.210108125451                           DBPRD   1

    DB2INST1   db2license     25135      ::ffff:10.230.2.4.34634.210106010839                           DBPRD   1

    DB2INST1   db2license     37681      ::ffff:10.230.2.4.48990.210104130220                           DBPRD   1

    DB2INST1   db2license     61431      ::ffff:10.230.2.4.37396.210111083657                           DBPRD   1

    DB2INST1   db2license     25431      ::ffff:10.230.2.4.33086.210109025202                           DBPRD   1

    DB2INST1   db2license     45977      ::ffff:10.230.2.4.54404.210104160747                           DBPRD   1

    DB2INST1   db2license     54977      ::ffff:10.230.2.4.39922.201231220621                           DBPRD   1

    DB2INST1   db2license     15727      ::ffff:10.230.2.4.40550.210108203056                           DBPRD   1

    DB2INST1   db2license     2898       ::ffff:10.230.2.4.39424.201229011331                           DBPRD   1

    DB2INST1   db2license     14569      ::ffff:10.230.2.4.54164.201230230159                           DBPRD   1

    DB2INST1   db2license     38444      ::ffff:10.230.2.4.38502.201231013728                           DBPRD   1

    DB2INST1   db2license     5694       ::ffff:10.230.2.4.39228.210108025238                           DBPRD   1

    DB2INST1   db2license     47490      ::ffff:10.230.2.4.46818.210104122225                           DBPRD   1

    DB2INST1   db2license     13740      ::ffff:10.230.2.4.54098.201228204256                           DBPRD   1

    DB2INST1   db2license     34365      ::ffff:10.230.2.4.51034.210101055735                           DBPRD   1

    DB2INST1   db2license     23615      ::ffff:10.230.2.4.60014.210107142057                           DBPRD   1

    DB2INST1   db2license     64161      ::ffff:10.230.2.4.59454.210104231407                           DBPRD   1

    DB2INST1   db2license     35036      ::ffff:10.230.2.4.39672.210104210846                           DBPRD   1

    DB2INST1   db2license     5036       ::ffff:10.230.2.4.40036.201228233815                           DBPRD   1

    DB2INST1   db2license     34661      ::ffff:10.230.2.4.60610.210104131731                           DBPRD   1

    DB2INST1   db2license     56128      ::ffff:10.230.2.4.44696.210107125534                           DBPRD   1

    DB2INST1   db2license     39003      ::ffff:10.230.2.4.45638.201231020731                           DBPRD   1

    DB2INST1   db2license     22253      ::ffff:10.230.2.4.43442.210107123031                           DBPRD   1

    DB2INST1   db2license     49299      ::ffff:10.230.2.4.47344.201231234128                           DBPRD   1

    DB2INST1   db2license     23549      ::ffff:10.230.2.4.47106.210105233818                           DBPRD   1

    DB2INST1   db2license     47174      ::ffff:10.230.2.4.52904.210110234518                           DBPRD   1

    DB2INST1   db2license     38720      ::ffff:10.230.2.4.54110.210106180152                           DBPRD   1

    DB2INST1   db2license     52187      ::ffff:10.230.2.4.58066.201231210102                           DBPRD   1

    DB2INST1   db2license     7483       ::ffff:10.230.2.4.53110.210106123058                           DBPRD   1

    DB2INST1   db2license     32983      ::ffff:10.230.2.4.54284.210106125621                           DBPRD   1

    DB2INST1   db2license     60779      ::ffff:10.230.2.4.42430.210104114725                           DBPRD   1

    DB2INST1   db2license     36621      ::ffff:10.230.2.4.39832.201230220153                           DBPRD   1

    DB2INST1   db2license     5042       ::ffff:10.230.2.4.60868.210105091605                           DBPRD   1

    DB2INST1   db2license     32167      ::ffff:10.230.2.4.48934.210101204535                           DBPRD   1

    DB2INST1   db2license     42088      ::ffff:10.230.2.4.54140.210106231244                           DBPRD   1

    DB2INST1   db2license     12338      ::ffff:10.230.2.4.40080.201230220702                           DBPRD   1

    DB2INST1   db2license     41180      ::ffff:10.230.2.4.49784.210104091137                           DBPRD   1

    DB2INST1   db2license     40851      ::ffff:10.230.2.4.60444.210110010601                           DBPRD   1

    DB2INST1   db2license     2726       ::ffff:10.230.2.4.49484.210106021347                           DBPRD   1

    DB2INST1   db2license     31351      ::ffff:10.230.2.4.42378.210111092712                           DBPRD   1

    DB2INST1   db2license     63568      ::ffff:10.230.2.4.58746.210109015655                           DBPRD   1

    DB2INST1   db2license     25943      ::ffff:10.230.2.4.37676.210107092940                           DBPRD   1

    DB2INST1   db2license     44785      ::ffff:10.230.2.4.53256.210101212532                           DBPRD   1

    DB2INST1   db2license     44035      ::ffff:10.230.2.4.47592.201229050420                           DBPRD   1

    DB2INST1   db2license     60285      ::ffff:10.230.2.4.51985.210101061737                           DBPRD   1

    DB2INST1   db2license     41081      ::ffff:10.230.2.4.55206.201228210302                           DBPRD   1

    DB2INST1   db2license     59502      ::ffff:10.230.2.4.53864.210104155742                           DBPRD   1

    DB2INST1   db2license     4048       ::ffff:10.230.2.4.48754.201229052927                           DBPRD   1

    DB2INST1   db2license     55548      ::ffff:10.230.2.4.35500.210108134957                           DBPRD   1

    DB2INST1   db2license     7140       ::ffff:10.230.2.4.34328.201230210144                           DBPRD   1

    DB2INST1   db2license     53857      ::ffff:10.230.2.4.42084.210101191526                           DBPRD   1

    DB2INST1   db2license     32528      ::ffff:10.230.2.4.51898.210101002135                           DBPRD   1

    DB2INST1   db2license     51449      ::ffff:10.230.2.4.48342.210104084143                           DBPRD   1

    DB2INST1   db2license     16949      ::ffff:10.230.2.4.60172.210111012519                           DBPRD   1

    DB2INST1   db2license     41883      ::ffff:10.230.2.4.55016.210108011223                           DBPRD   1

    DB2INST1   db2license     6133       ::ffff:10.230.2.4.45816.210106090028                           DBPRD   1

    DB2INST1   db2license     42929      ::ffff:10.230.2.4.46828.210110021620                           DBPRD   1

    DB2INST1   db2license     20554      ::ffff:10.230.2.4.41398.210104112701                           DBPRD   1

    DB2INST1   db2license     10975      ::ffff:10.230.2.4.50670.201230063355                           DBPRD   1

    DB2INST1   db2license     17771      ::ffff:10.230.2.4.60628.201229210223                           DBPRD   1

    DB2INST1   db2license     52646      ::ffff:10.230.2.4.49444.210101205531                           DBPRD   1

    DB2INST1   db2license     29442      ::ffff:10.230.2.4.54146.210106231247                           DBPRD   1

    DB2INST1   db2license     58317      ::ffff:10.230.2.4.59730.210105144703                           DBPRD   1

    DB2INST1   db2license     25988      ::ffff:10.230.2.4.54538.210106130121                           DBPRD   1

    DB2INST1   db2license     52784      ::ffff:10.230.2.4.40196.210106201216                           DBPRD   1

    DB2INST1   db2license     28784      ::ffff:10.230.2.4.54290.210103011031                           DBPRD   1

    DB2INST1   db2license     63784      ::ffff:10.230.2.4.60636.201228215804                           DBPRD   1

    DB2INST1   db2license     3659       ::ffff:10.230.2.4.37622.201230020806                           DBPRD   1

    DB2INST1   db2license     51909      ::ffff:10.230.2.4.38338.201231170025                           DBPRD   1

    DB2INST1   db2license     29580      ::ffff:10.230.2.4.48552.210110230506                           DBPRD   1

    DB2INST1   db2license     16580      ::ffff:10.230.2.4.46916.201228191744                           DBPRD   1

    DB2INST1   db2license     18205      ::ffff:10.230.2.4.43724.210107123541                           DBPRD   1

    DB2INST1   db2license     56672      ::ffff:10.230.2.4.44278.210104234905                           DBPRD   1

    DB2INST1   db2license     1547       ::ffff:10.230.2.4.38690.201229005821                           DBPRD   1

    DB2INST1   db2license     46468      ::ffff:10.230.2.4.45606.210107010304                           DBPRD   1

    DB2INST1   db2license     53718      ::ffff:10.230.2.4.44692.210107125532                           DBPRD   1

    DB2INST1   db2license     60343      ::ffff:10.230.2.4.40418.210107122037                           DBPRD   1

    DB2INST1   db2license     33889      ::ffff:10.230.2.4.39824.201230220148                           DBPRD   1

    DB2INST1   db2license     27685      ::ffff:10.230.2.4.46638.201228191245                           DBPRD   1

    DB2INST1   db2license     26323      ::ffff:10.230.2.4.60472.210106081512                           DBPRD   1

    DB2INST1   db2license     22119      ::ffff:10.230.2.4.46800.210106092030                           DBPRD   1

    DB2INST1   db2license     46915      ::ffff:10.230.2.4.38464.201228230810                           DBPRD   1

    DB2INST1   db2license     16553      ::ffff:10.230.2.4.53278.201228202758                           DBPRD   1

    DB2INST1   db2license     31678      ::ffff:10.230.2.4.46804.210106092032                           DBPRD   1

    DB2INST1   db2license     34974      ::ffff:10.230.2.4.45648.201229234741                           DBPRD   1

    DB2INST1   db2license     37599      ::ffff:10.230.2.4.58454.210106133119                           DBPRD   1

    DB2INST1   db2license     24599      ::ffff:10.230.2.4.53388.210101005139                           DBPRD   1

    DB2INST1   db2license     16645      ::ffff:10.230.2.4.35920.210105152709                           DBPRD   1

    DB2INST1   db2license     270        ::ffff:10.230.2.4.51984.201230010253                           DBPRD   1

    DB2INST1   db2license     33737      ::ffff:10.230.2.4.46392.210111023035                           DBPRD   1

    DB2INST1   db2license     54987      ::ffff:10.230.2.4.34324.201230210142                           DBPRD   1

    DB2INST1   db2license     41158      ::ffff:10.230.2.4.45856.210110015623                           DBPRD   1

    DB2INST1   db2license     29875      ::ffff:10.230.2.4.47366.210106112555                           DBPRD   1

    DB2INST1   db2license     1875       ::ffff:10.230.2.4.53832.201228203816                           DBPRD   1


    ​I can force the connections from time to time but would prefer to know the cause or which setting i have to change in order to avoid this. 

    I also monitor a community edition db2 database and there I don't see the db2license application staying open.

    The previous version of DMC (3.1.1) had the same problem. 

    Many thanks in advance

    ------------------------------
    Luc Vandaele
    ------------------------------

    #Db2


  • 2.  RE: db2license

    Posted Tue January 12, 2021 04:47 AM
    Hi Luc,

    Thanks for bringing up this issue. I'll pass the issue to console team to investigate. Will let you know the update. thanks.

    Refer to https://github.ibm.com/tools-for-aps/zh/issues/21979

    ------------------------------
    KAI DING
    ------------------------------

    Original Message


  • 3.  RE: db2license

    Posted Tue January 12, 2021 05:44 AM
    ​Hello Luc,
    we have the same problem with our productive databases. This exceeded the number of MAXAPPLS.

    Should I open a PMR or can you keep me up to date via the community.

    Best regards

    Karsten

    ------------------------------
    Karsten Wilhelm
    ------------------------------

    Original Message


  • 4.  RE: db2license

    Posted Tue January 12, 2021 05:07 PM
    Hi Luc, Karsten,

    It is good if you can open a case for this issue.  You can collect the following information as a snapshot and upload to the case.  It will help to determine if the connections are active or it can be closed.  

    db2 connect to <mydb>
    list applications for database <mydb>
    SELECT application_handle, uow_id, total_cpu_time, WORKLOAD_OCCURRENCE_STATE FROM TABLE(MON_GET_UNIT_OF_WORK(NULL,-1)) ORDER BY application_handle with UR
    SELECT application_handle, uow_id, activity_id, VARCHAR(stmt_text, 256) as stmt_text FROM table(MON_GET_ACTIVITY(NULL, -1)) ORDER BY application_handle with UR

    Thanks.

    ------------------------------
    Jason Sizto
    ------------------------------

    Original Message


  • 5.  RE: db2license

    Posted Wed January 13, 2021 02:46 AM
    Please also collect the logs when you open a PMR, thanks.

    Also, can you help to verify if the issue disappear if you turn off an alert?
    Turn off alert:
     Monitor profile->Alert Settings->Performance->Statement performance

    ------------------------------
    XU QIN ZHAO
    ------------------------------

    Original Message


  • 6.  RE: db2license

    Posted Fri January 15, 2021 04:05 AM
    @Luc Vandaele Finally I have worked with Zhao Xu Qin to locate the root cause, ​​​it is due to some DMC created JDBC connections are not being released. I will fix into our future release. Sorry for the problem and thanks a lot for raising the issue.

    For now the workaround is as Zhao Xu Qin mentioned to turn off the alert from Monitor profile->Alert Settings->Performance->Statement performance. This alert compare each query execution with its historical executions and also detect if the performance downgrade is caused by access plan change.

    #Db2