Control Center is a simple, powerful tool at a quarter of the disk space. So the download is in the multi-GB range and it includes a ton of bloatware not needed for your standard database maintenance. Data Studio is built on IBM’s Rapid Application Development (RAD) tool, built on Eclipse.Licensing is prohibitively expensive! If you are not grandfathered in, IBM licensing for a multi-datacenter, PRIMARY, SECONDARY, and Disaster Recovery (DR) setup can be in the multiple $100,000 range.Downside: You have to wait for the final log ship to complete before your DB is back up.

The only way to accomplish a true HADR scenario is to set up NEARSYNC in one datacenter and do logshipping to another datacenter. This drastically increases your overall capital investment.

You cannot run multiple secondary nodes or cluster without additional software purchases in some cases third party tools.

Ability to run commands via CLI (Command Line Interface) or via Control Center / Data Studio ( DB2 10.x+) makes administration a breeze.

Tablespace usage and automatic storage help keep your data segmented while at rest, making partitioning easier.

This allows for ease of maintenance without third party softwares.

Task Scheduler ( DB2 9.7 and earlier ) allows for jobs to be run within other jobs, and exit and error codes can define what other jobs are run.

Failover from PRIMARY to SECONDARY becomes very easy with just a single command or windowed mouse click.

Its use of ASYNC, NEARSYNC, and SYNC HADR (High Availability Disaster Recovery ) models gives you a range of options for maintaining a very high uptime ratio.

The Task Scheduler component of DB2 allows for statistics gathering and reorganization of indexes and tables without user interaction or without specific knowledge of cron or Windows Task Scheduler / Scheduled jobs. So its pros and cons as described “ ” website are given bellow. So We may see lot of use in db2 in enterprises.īenefits of using DB2® Multisystem include improved query performance, decreased data replication, larger database capacity, and so on.īut non of the system is perfect. DB2 is a popular database for integration and IBM Cloud deployments.

Ibm data studio client download