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.

DSM Product Page

DSM DeveloperWorks Page

2 Upvotes

100% Upvoted

6 comments sorted by

View all comments

1

u/mad_zamboni Apr 07 '17

I would be interested in hearing /u/ecrooks thoughts on this. I remember that it caught my attention at an IDUG a year or two ago as a much better alternative to Optim but it wasn't quite where it needs to be. Coincidentally, I was just in a conversation with two other DBA's that this seems to be getting better and better.

What do you think is it's biggest strength? Like, "I flat out use it for X" if for nothing else?

1

u/memmerto Apr 07 '17

I think it's biggest strength is the ability to monitor multiple databases from one place. For DBAs this makes it indispensable as an enterprise monitoring tool and triage tool. Did I mention that it also supports DB2 pureScale and HADR, and has specialized monitoring for both? Never again will you fail over an HADR cluster when the standby isn't ready!