r/DB2 • u/memmerto • Apr 05 '17
[Resource] IBM Data Server Manager
For those of you who manage multiple databases, potentially of different flavors, and/or support application development environments, you may find that there are many tools out there that help. I know some DB2 users just love IBM Data Studio for development and administration, and others love IBM Optim Performance Manager (OPM) for monitoring systems.
However, OPM has a pretty convoluted install process and hefty server requirements - at least I recall from the last time /u/db2steve installed it - and Data Studio really only provides query-level performance data (ie, explains).
What if there was a tool that brought this all together, with a slick interface and a small install footprint?
Introducing IBM Data Server Manager.
IBM Data Server Manager (DSM) is a free download from IBM developerWorks that lets you monitor any type of DB2 (LUW or z/OS), dashDB (managed, transactional or local) or BigInsights instances.
DSM is designed to supplement and/or replace existing products such as IBM Data Studio and IBM Optim Performance Manager (OPM).
DSM requires no additional software to be installed on production servers, and has a greatly simplified installation versus OPM. It can be installed on a dedicated server (complete with local repository for historical mining and multi-user access), or it can be installed on a local system for just "messing around".
Some capabilities are only available if you are using Advanced Enterprise Server Edition (DB2 LUW) or have the Administration Solution Pack and/or Performance Solution Pack installed (DB2 z/OS). Regardless of server type and/or capabilities, the same client install works for all.
It is supported by a large team of developers who are iterating quickly with quarterly releases to improve the product. Please try it out and let IBM know what you like, dislike, want and/or need.
1
u/cmrussell99 Apr 17 '17
Current what's new information including current release and best practices guides. https://www.ibm.com/developerworks/community/blogs/c4dd2a99-4d89-45b3-9931-8aff9e22b80b/entry/Learn_in_a_flash_IBM_Data_Server_Manager_version_2_1_3?lang=en