Whether you are an IOD newbie or expert it never hurts to take some time before the conference to explore and learn about the different session offerings. Information On Demand (IOD) 2013, IBM’s biggest conference for information and analytics, is happening November 3rd – 7th at Mandalay Bay in fabulous Las Vegas Nevada. With just a couple days left to finish planning your IOD schedule, time is valuable. This year there are plenty of opportunities to learn more about database management, and more specifically learn more about Optim... [More]
Hot off the press is a new Redbook on InfoSphere Optim Performance Manager and InfoSphere Optim Query Workload Tuner here: http://www.redbooks.ibm.com/abstracts/sg248111.html?Open
You'll find architectural overviews, planning and installation guidance, feature overviews, as well as usage scenarios. This is a great reference whether monitoring transaction processing or business intelligence workloads.
Let us know if you find this helpful!
BLU Acceleration has been available for a few weeks now. Have you had a chance to try it? One of the design themes for BLU was "simplicity". No SQL changes. Just enable BLU on your database, convert some tables and presto, your queries run WAY faster. Is it that simple? Well pretty much, but what do you need to do to enable BLU on a database? How do you know what tables to convert. I have just learned that Danny Zilio, a Senior Software Developer in the Optim Query Workload... [More]
We have been blogging about some of the new features that were announced here and in my " BLU Acceleration and IBM Infosphere Optim Database Management Solution s" blog. I am pleased to announce that, along with DB2 10.5 for Linux, UNIX and Windows, all of the following are now available:
IBM Data Studio V4.1
IBM DB2 Merge Backup for Linux, UNIX and Windows V2.1
IBM DB2 Recovery Expert V4.1
IBM InfoSphere Configuration Manager for DB2 for Linux, UNIX and Windows V3.1
In my last blog I focused on tooling support for the new DB2 BLU Acceleration and rightfully so. BLU Acceleration is a game changer and tooling support makes it even easier to use. I also want to point out there were many enhancements to Data Studio beyond support for BLU Acceleration. A number of requests from the Data Studio user base led to one of these enhancements, checkpoint support in the script editor.
Checkpoint's provide significantly more control over the execution of... [More]
One of the issues that users have raised to me is the impedance mismatch between our web-based tools and our eclipse-based tools, in particular, between InfoSphere Optim Performance Manager (Performance Manager) and InfoSphere Optim Query Workload Tuner (Query Tuner). Query Tuner availability on the Eclipse platform grew out of our rich investment in Eclipse and our strategy to drive improved query performance early in the development cycle. Thus, key integration with Data Studio and Rational development... [More]
IBM® DB2® pureScale® (also known as DB2 application cluster transparency) feature introduced clustering technology to DB2 on distributed platforms, so you can deploy continuously available and scalable database clusters. The technology is based on the IBM DB2 for z/OS® architecture that businesses worldwide trust for their most critical systems.
IBM InfoSphere® Optim™ Configuration Manager for DB2 for LUW V3.1 (OCM) includes the following capabilities for IBM DB2 pureScale®... [More]
I think that you have all seen the various announcements and press around the new DB2 10.5 and all the various features and functions. I wanted to dive a little bit deeper on the DB2 Advanced Recovery Feature. First of all now there is one package that contains all 3 of the backup and recovery tools for DB2 for LUW – DB2 Recovery Expert V4.1, DB2 Merge Backup V2.1 and Optim High Performance Unload V5.1.
With DB2 Recovery Expert V4.1 for Linux, UNIX and Windows one of the most significant features added in... [More]
Yesterday was an exciting day with some very important announcements. IBM announced DB2 for Linux, UNIX and Windows Version 10.5 with the new column-organized tables that utilize BLU Acceleration; a unique and advanced columnar data store with advanced compression and hardware exploitation. IBM also announced updates to a number of database management solutions to help develop, monitor, manage and tune your DB2 LUW database. All of these... [More]
If you're heading to IDUG, then don't miss Sue Sterling's session " C05 - Highlight Zone-MetLife DB2 LUW-Tooling Time ". This is a great opportunity to hear how this enterprise customer manages hundreds of DB2 databases.
Abstract : At MetLife we “create time” for our DBAs with performance, availability, cost reduction, and expense avoidance tools. The presentation shares our DB2 LUW footprint with easy-to-follow examples illustrating OPM 5, STMM, WLM, ROS and V10 Orac le... [More]
Today IBM announced updates to several performance management products, all of which are available individually or as part of the DB2 Advanced Enterprise Server Edition. They include:
IBM InfoSphere Optim Performance Manager V5.2 IBM InfoSphere Optim Query Workload Tuner for DB2 Linux, UNIX, Windows V3.2 IBM InfoSphere Optim pureQuery Runtime for Linux, Unix Windows V3.2 IBM Data Studio V3.2
We all know that poorly performing applications can lead to lost revenue and customer dissatisfaction. We have made numerous improvements... [More]
At the end of August we released a new fixpack for InfoSphere Optim Performance Manager (OPM) 126.96.36.199. In addition to defect rollup, there were a few functional enhancements as well: Most importantly, we have improved the ability to generate custom reports from the performance repository. New documentation, table functions, and Tivoli Common Reporting support custom report generation. Or users can use any reporting tool of choice. Commonly requested, we have added a pre-built cross-database report for periodic reviews of your database... [More]
Hi folks, Sorry for the late notice. Cliff Leung, chief architect of Optim Query Workload Tuner, and I will be presenting a webcast on Optim Performance Management this Thursday via the DB2 Tech Talk series. This setting provides an opportunity to drill down a little given that we have 90 minutes. We are hoping that it will be informative with lots of time for questions. You can register here . I hope you will join us. Holly
Hi folks, If you haven't heard much about IBM PureApplication Systems , now is the time! With built-in expertise to deploy transactional and datamart patterns in private clouds, PureApplication is really revolutionizing time to value and infrastructure simplification. And for Optim followers, DB2 and Optim Performance Manager come built-in :-) There's going to be a Twitter Chat Monday from 1 to 2 p.m. EDT (5 to 6 p.m. GMT) entitled "IT Infrastructure Improvements for Midsize Businesses" moderated by Paul Gillin, a veteran technology... [More]
In October 2011, we released a new product: InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX, and Windows. As with InfoSphere Optim Query Workload Tuner for DB2 for z/OS, you can capture and save a set of queries into a workload, and then launch advisors to get expert advice for tuning the workload as a whole. The advisors are the Workload Statistics Advisor, which can recommend RUNSTATS control statements for collecting statistics on database objects that are used by the workload, as well as scripts for creating statistical views... [More]
Now that IBM Data Studio Version 3.1.1 is available for download, we thought it would be helpful to share this list of documentation links to help you with everything from finding what's new in this release to getting you up and running in IBM Data Studio:
IBM Data Studio Version 3.1.1 release information:
What's New in IBM Data Studio Version 3.1.x
Data Studio V3.1.x features: by data server and component
Determine which features are available in each component of Data Studio... [More]
Hi all, As mentioned in Holly's blog dated April 3, 2012 - Optim Releases Support DB2 10. I wanted to drill down a little further into what enhancements are available for the DB2 Advanced Recovery Solutions with respect to support for DB2 V10. With the new release of DB2 Recovery Expert V3.1.1 you can now restore altered, incorrect or missing DB2 V10 for Linux, UNIX and Windows database assets including tables, tablespaces, indexes and data to a specified point in time often without taking the database or business operations offline.... [More]
Hi folks, Here is my promised update on InfoSphere Optim Performance Manager (OPM) 5.1.1 that will be available April 30 th . As I mentioned in my earlier posting Optim Releases Support DB2 10 , the majority of the enhancements are in support of DB2 10 features, so let me go over those first: Multi-temperature support – DB2 10 multi-temperature data management allows you to store different portions of your data on different classes (speed and cost) of storage so that you can match access requirements to underlying storage and ... [More]
Hello all, We have been busy working on an update to Data Studio just in time for DB2 10.1 for Linux, Unix and Windows . This release includes enhancements throughout the product as well as the added support for DB2® V10.1 for Linux, UNIX, and Windows databases which include the following features: Adaptive compression for table rows Special registers for temporal tables in server profiles Time-based data management with temporal tables Data management using multi-temperature storage Data security with row and column access control (RCAC)... [More]
I’m hoping that you
saw the big DB2 10 for Linux, UNIX, and Windows announcement or will be attending the virtual conference The Future of Database and Data Warehousing Software today through Thursday . Concurrent with
the upcoming delivery of DB2 10, scheduled for April 30 th , our
InfoSphere Optim tools team is planning a set of releases designed to provide
support for the new DB2 10 features. We hope these enhancements will help
you get going with new features including time travel query, row... [More]