The Role of the DB2 DBA in Load/Performance Testing

You may also like...

3 Responses

  1. harihara says:

    Hi Ember,

    Is there any way to open large number of random connections to a test database ?
    Aim is to increase the count shown in db2 list applications.


    • Ember Crooks says:

      You could run a bunch of scripts that issue connect statements. But I don’t know the purpose of that – they’re useless in load testing if they’re not used in some way.

  2. Isaac Munoz says:

    Thanks Ember for this article.

    I agree in all your statements, the sooner a DBA gets involved in any testing the better a customer saves on licensing, project delays and downtime. On my side, I am very concerned about IBM DSM, we’ve been using it for a while but its TCO does not seem to pay back. Also dsmtop is way too slow compared to db2top, which is still by far my favorite of these two tools.


Leave a Reply

Your email address will not be published. Required fields are marked *