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 Database Tools. The following link https://www-950.ibm.com/events/global/iod/agendabuilder/preview.html?agendaid=165 provides you with a list of all the Optim Database Tools sessions at IOD in a saved agenda from the official IOD site. There are 39 different Optim Database Tools sessions to choose from, that include elective session, hands-on labs, and usability sandbox sessions. Happy IOD planning!
Managing the data lifecycle
vpetrill 0700000NDM Tags:  tuning opm tuner releases ods data-studio petrillo ds performance optim purequery oda query data_studio fixpacks 6,502 Views
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:
We all know that poorly performing applications can lead to lost revenue and customer dissatisfaction. We have made numerous improvements in all these products to make it easier to identify and resolve issues before they can impact your business. There are far too many improvements to list but some notable improvements include:
IBM InfoSphere Optim Performance Manager V5.2
We have added enhancements to better analyze stored procedure performance. Rank stored procedures and drill down to find poorly performing SQL. We have extended reporting now with scheduling, emailing, and retention management. To help you automate actions, we have provided the ability to trigger user defined jobs in response to alerts.
IBM InfoSphere Optim Query Workload Tuner for DB2 Linux, UNIX, Windows V3.2
Once you have identified SQL that could use some help, use Query Workload Tuner to provide suggestions and analyze possible improvements or use Query Workload Tuner to analyze SQL before it ever goes into production. V3.2 has many enhancements to help with "what-if" analysis. Use Query Workload Tuner and virtual indexes to analyze the impact of adding, dropping or changing an index. Use the plan comparator to see the changes to access plans.
IBM InfoSphere Optim pureQuery Runtime for Linux, Unix Windows V3.2
Suppose you have poorly performing SQL from a third party application. pureQuery Runtime can help with that. Use pureQuery to swap out poorly performing SQL. With V3.2, new configuration scripts makes it easier to deploy on WebSphere Application Server and configuration changes can go into effect immediately.
IBM Data Studio V3.2
IBM Data Studio has also been updated. Many enhancements were made to alerts and scheduling in the web console. Users can now define their own alert view preferences. The client was updated to make debugging even simpler and more robust. Debug triggers and PL/SQL anonymous blocks. You can now view global and package variables, associative arrays and array of rows in the debugger. It is also much easier to recompile a routine for debugging. It is almost automatic. Starting with V3.2 the Data Studio administration client will be available via DB2 Express-C and refreshed as needed. The full client is available via the normal Data Studio download page. Remember, for the full client, when using the Installation Manager option, only the options selected will be downloaded and installed on your system. If you are using the administration client, try the full client.
Finally, connection management is now easier for many of these products. IBM InfoSphere Optim Performance Manager, Query Workload Tuner, and Data Studio can now obtain and stay synchronized with connection information from the Optim Configuration Manager's database repository.
For more information, check the announcement here.
vpetrill 0700000NDM Tags:  optim fixpacks ods ds data-studio releases data_studio oda petrillo 2 Comments 9,403 Views
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:
These DB2® V10.1 features are fully supported by Data Studio making it easier for you to take advantage of them.
Other product enhancements include updated syntax checking, additional support for pureScale, improvements to SQL routine support, improved performance information gathering, as well as enhancements to query tuning, shell sharing, and the Data Stuido web console, here are the details:
The query tuning features in Data Studio have been enhanced to include the following:
In addition to the Data Studio query tuning enhancements, the client for InfoSphere Optim Query Workload Tuner is now part of the Data Studio v3.1.1 product. After you install Data Studio v3.1.1, all that you need is a license to enable InfoSphere Optim Query Workload Tuner, simplifying the install process for those of you who use both Data Studio and InfoSphere Optim Query Workload Tuner.
On top of all the new functionality, the Data Studio v3.1.1 clients are now built off of Eclipse 3.6, which means the Data Studio full client is now compatible (for shell-sharing) with newer Eclipse based offerings such as the latest IBM Rational Application Developer and Rational Developer for System z.
For the Data Studio web console, we have included the following enhancements:
Visit the Data Studio product page and download from developerWorks. Data Studio is bundled with a number of IBM data servers such as DB2 for Linux, Unix and Windows, DB2 Connect and IBM Informix. For a good overview, check out the "Getting started with IBM Data Studio for DB2" ebook.
Greetings Optim Community,
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 30th, 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 and column access control, multi-temperature storage, adaptive compression, and query performance improvements. The new releases are:
The new capabilities help developers, DBAs, or security administrators
Furthermore, InfoSphere Optim tools continue to extend support for production deployments of DB2 pureScale environments with added configuration, administration, and monitoring capabilities. Developers will benefit from new tool support that facilitates application migration and co-existence, with added support for PL/SQL procedure profiling and Oracle database federation definition.
And those are just the enhancements focused on DB2 10. Over the next few weeks, we’ll be blogging on the releases in detail including enhancements not mentioned here.
And more BIG news: DB2 Advanced Enterprise Server Edition now includes more of the InfoSphere Optim portfolio: specifically InfoSphere Data Architect, InfoSphere Optim Query Workload Tuner, InfoSphere Optim pureQuery Runtime, InfoSphere Optim Performance Manager Extended Edition, and InfoSphere Optim Configuration Manager. The Fillmore Group is doing a webcast April 5th titled DB2 Advanced Enterprise Server Edition -Why You Should Consider it. Check it out.
And stay tuned!
I've been a development manager on database administration capabilities for Data Studio for many years, and recently took over as product manager, as well. I am very excited about our new Data Studio 3.1 release. It not only includes enhancements to the previous release of Data Studio, but, more importantly, combines the feature set of Optim Database Administrator and Optim Development Studio with Data Studio and Data Studio Health Monitor to create one comprehensive product for application development and database administration, all available at no charge! Data Studio can be found as a download from developerWorks and soon will be bundled with a number of IBM data servers such as DB2 for Linux, Unix and Windows, DB2 Connect and IBM Informix.
Data Studio 3.1 now consists of three components:
Data Studio administration client: Reduced footprint client for administration and non-Java based development. (You may remember we referred to this previously as the stand-alone package)
Data Studio full client: Full-feature client that can shell-share with other Eclipse-based products (This was previously called the integrated development environment package) .
Data Studio web console: health monitoring and new job scheduling capability (this was formerly known as Data Studio Health Monitor)
In addition to the consolidation, we've enhanced the following areas:
The object management feature has been completely overhauled. The new UI provides for in place editing of objects and eliminates the need for a separate editor. Complex object management for Optim Database Administrator for DB2 for Linux, Unix and Windows has been incorporated into the new object management for Data Studio 3.1.
There are a number of enhancements related to navigating, monitoring and managing a DB2 pureScale environment.
There are numerous enhancements to the query editor. They include version specific validation, execution control and special register support.
You can now change the user name and password on any or all connections with one action. The Data Studio web console also provides a central place to define database connections that can be imported by the Data Studio full or admin clients.
Compare and Sync
There are enhancements to reporting and visualizing changes.
DB2 for z/OS
We added support for temporal tables and query tuning now includes set/update profile support for runstats and table data sampling
Scripts may be scheduled as jdbc or clp scripts for DB2 for Linux, Unix and Windows and jdbc scripts for DB2 for z/OS.
You can find current Data Studio product information here. Check out and post questions, comments, or requests on our forum or visit our information center and information roadmap.
P.S: Today we also announced the following:
InfoSphere Data Architect 7.6
InfoSphere Optim pureQuery Runtime z/OS 3.1
InfoSphere Optim pureQuery Runtime LUW 3.1
InfoSphere Optim Query Workload Tuner LUW 3.1
InfoSphere Optim Query Workload Tuner z/OS 3.1
Optim Performance Manager – Optim Performance Manager 4.1.1 is now available. We put a lot of focus on up-and-running improvements in this release. This includes embedding a lightweight web container to simplify installation, configuration, and security, simplifying our port infrastructure for Extended Insight support, improving the out-of-the-box monitoring templates based on customer experience and more. We have added pureScale-specific monitoring enhancements including pureScale monitoring templates, group buffer pool hit ratios, cluster facility lock wait time, escalations, timeouts, etc. We provided more flexibility for monitoring large DPF environments by separating collection intervals for bufferpool versus tablespace and table statistics, which provides more comprehensive information at a lower cost. We have also included DB2 Enterprise Server Edition 9.7 for use with Optim Performance Manager. For the complete list of features and more information, see the IBM Optim Performance Manager 4.1.1 release notes.
Optim Development Studio – Optim Development Studio 188.8.131.52 now also officially supports deployment on Citrix (I know several organizations that went ahead and deployed before our formal support was announced). It also includes two very cool items:
Optim Database Administrator - Optim Database Administrator 184.108.40.206 also adds official support for Citrix deployment. It also sports a new table data editor for DB2 for LUW and z/OS databases and closed a couple gaps in the dependency analysis space for packages and procedures. It also includes catalog filtering improvements tailored to very large databases. Optim Database Administrator is available to DB2 for Linux, UNIX, and Windows customers as part of their DB2 9.7 Linux or Windows eAssembles on Passport Advantage. See IBM Optim Database Administrator Version 220.127.116.11 Release Notes for more information and download updates from Fix Central.
Data Studio – Data Studio 18.104.22.168, both stand-alone and IDE, inherit the Optim Database Administrator Citrix, table data editor, dependency analysis, and catalog filtering enhancements. In addition, this release includes some enhancements specifically for DB2 for z/OS, notably use of TABLESAMPLE keyword on statistics recommendations and catalog navigation performance improvements. For more information, see the IBM Data Studio Version 22.214.171.124 Release Notes. Download updates from Fix Central or a fresh install at developerWorks.
Check them out and post questions, comments, or requests here or on our forums
Anson_Forum 120000KVU9 Tags:  recovery recovery-expert kokkat mbu optim merge-backup re 5,370 Views
Have you ever worked with Backup and Recovery Tools for DB2 for z/OS and wondered what is the equivalent on DB2 for LUW?
With the announce of DB2 Recovery Expert V3.1 on June 7, we now have a complete set of backup and recovery tools for DB2 for Linux, UNIX and Windows. DB2 Advanced Recovery Solution is a term we use to talk about these 3 separate products: DB2 Merge Backup, DB2 Recovery Expert, High Performance Unload.
DB2 Recovery Expert helps customers with the more granular recovery needs in DB2 and also works as a log analysis tool to read active and archive db2 logs. Think about those times when you accidentally deleted a production table instead of a test table and you just wanted to get that back... Also think about a developer who ran his application last night and it deleted 1000 rows by accident... Use DB2 Recovery Expert to help you recover what you need and pinpoint mistakes to help generate UNDO SQL to put the database back the way it was before.
All this is pretty powerful stuff when you are a DBA and you need the 'advanced recovery' capability that is provided with these tools. If you want to find more about DB2 Recovery Expert refer to the main webpage:
Anson_Forum 120000KVU9 Tags:  tools kokkat merge-backup db2 recovery mbu optim backup 6,970 Views
Are your databases so large that it is too hard to take DB2 backups? Is the CPU usage that is being used to take these backups affecting your application processing?
IBM has just introduced the New DB2 Merge Backup for Linux, UNIX and Windows. This tool was announced at IDUG on May 3, and it allows DB2 customers to greatly reduce downtime, CPU consumption, DBA Labor and Risk during Recovery.
IBM DB2 Merge Backup combines incremental and delta backups with the latest full backup to create a new full and current backup without actually taking a new full backup and slowing down your production system. All this processing runs outside and independently of the current DB2 process. If a restore is later required, DB2 Merge Backup can help speed the recovery. Think about never having to take a full backup again...
Imagine a tool that allows backups strategies that have the lowest impact on production yet provides the necessary recovery assets when time is of the essence.
Feel free to contact me if you want more information.
Happy IOD Season! Kimberly Madia here from the Optim product marketing team, and I am excited to be blogging for the first time. I wanted to share some details about key activities for the Optim tools at the IOD Global Conference in
You will also not want to miss our big tent events. This is a fantastic opportunity to hear from the executive team and other thought leaders including Arvind Krishna and Steven Adler.
• Expo Grand Opening Reception, Sunday, 6:00 – 8:00 PM
• InfoSphere Community Reception, Sunday, 8:00 – 10:00 PM
• Data Management Keynote Session, Monday 2:45 – 3:45 PM
• InfoSphere Keynote, Tuesday, 3:00 – 4:00 PM
• Information Governance Keynote, Wednesday, 10:00–11:00 AM
• IOD 2010 Networking Party, Tuesday, 7:00 – 11:00 PM
Next, you will have the opportunity to meet Optim tools product experts including several distinguished engineers and of course Curt Cotner, IBM Fellow, VP & CTO for Database Servers. Here are a few of the experts, session numbers and times when these folks will be available to you.
• MTE-3683, Curt Cotner, Tue, 26/Oct 4:30-5:30 PM
• MTE-3490, Bryan Smith, Tue, 26/Oct 1:00-2:00 PM
As for technical presentations, we have lots. Certainly too many to mention here, so I will just point out a few highlights. Look for the Optim tools sessions in both DB2 and Information Governance tracks.
We have hands on labs covering the following products:
We also have usability labs for the following products:
Finally, at IOD you will have numerous opportunities to see live product demos. Optim tools will be available in the InfoSphere demo area as well as all Data Management demo suites.
Well that wraps up the highlights. We in product marketing are certainly excited about this conference. Looking forward to seeing you there! Have a great weekend.
hollyann 100000SR9G Tags:  data-studio optim lifecycle hayes 2010 october 7 Comments 7,977 Views
Big news last week on the Optim tools front.
Let me take you through the highlights.
Administration and Availability
In one of my last blogs, I wrote about the untold story of data privacy focusing on non-production systems. This past week, IBM made a significant acquisition of Guardium to improve support for compliance and the protection of privacy across all systems. As discussed in the previous blog, we often forget about the systems not in production and think that the current security in place is enough yet that is not the case.
The addition of Guardium to the mission of privacy, protection and compliance continues IBM’s mission in helping organizations at the enterprise level. Just like with data masking, often organizations don’t think of monitoring use, access and change to archives, but it is yet a risk. The combination of Guardium and Optim will provide that capability to monitor the SQL accesses and usage of data not only in production data sources, but also those in archives, development, test and training environments.
With Guardium comes an enterprise solution supporting most popular databases and application frameworks. Like the Princeton Softech and Ascential acquisitions of years ago, IBM plans to continue support for databases beyond those that are “Blue” and with the proof that they will based on now 4 years post Ascential and 2 years past Princeton Softech, I believe they will keep that promise. Most enterprises contain multiple technologies and enterprise solutions require support across them. Guardium continues IBM software’s vision of meeting the enterprises needs.
enaiburg 03000001UH Tags:  management data eric integrated naiburg optim 1 Comment 7,203 Views
As I have now written a few blogs, some folks have asked, "who are you and why are you blogging", so here it goes :-)
My name is
About 3 years after IBM had acquired Rational, I decided to take some time and try my hand working for a much smaller company where I joined Dr. Ivar Jacobson and his consulting company as Vice President of Sales and Marketing. I spent more than 2 years helping to grow Ivar’s business, while learning great things from him, but in the end, I decided that IBM was the place for me and last September, I decided to come back. I had a great opportunity to join the Optim (Princeton Softech) team about a year after they had been acquired and here I live happy and enjoying working with a new group of people, new products and a team with a ton of energy.
As I wrote about in my last blog, Data Privacy goes well beyond just protecting production environments and in his latest article, Shawn Moe discusses how to bring privacy directly to the development environment. http://www.ibm.com/developerworks/data/library/techarticle/dm-0910optimprivatizeddata/index.html This article goes into great detail on the definition of privacy policies early and how to ensure they are followed throughout the software development lifecycle starting with requirements and data models and ending with a masked non-production environment.
In the past few weeks, I have traveled around New England and met with several organizations that are suddenly looking at making data masking a key priority in their data management activities. I asked them why it has taken so long and the common answer was "we had limited budget and had to start with production. We knew there was a need, but we had to prioritize. Now we have been told that it is mandatory and we need to reduce risk immediately". So, what has brought on this risk and need to insurance? Well, states are starting to both regulate and enforce data privacy standards, PCI seems to be going from paper process to reality of not being able to do business and SOX is starting to be enforced too. So, what does that mean for you? Start looking at what sensitive information is being passed all around your organization, limit the amount being passed and mask anything that is sensitive.
Follow Shawn's process and see how your organization can protect the privacy of data from the start!
Goodbye for now and hope to see you at IOD
Greetings from Berlin! I’m very pleased today to tell you about several new announcements we are making in the portfolio previously known as Data Studio. With these new releases, we are taking great strides toward the vision of Integrated Data Management -- An integrated, modular environment to manage enterprise application data and optimize data-driven applications, from requirements to retirement across heterogeneous environments.
While delivering on an Integrated Data Management vision is a very broad value proposition and one that will involve all aspects of IBM Software Group, you’ll see with this release that we are adopting the Optim name as a rallying point for this technology emphasizing our focus on optimizing the value of your data assets by managing them across their lifecycle. This announcement represents another major step in delivering on our vision focusing both on extending heterogeneity and portfolio integration that provides the basis for cross-role, cross-lifecycle collaboration, efficiency, and alignment.
In future posts, we’ll take you through a couple of scenarios enabled by the new releases, but to get you started, here is a summary of the announcement and links to announcement letters and web pages:
Here’s a link to the announcement letter or visit the Web sites for Optim Development Studio , Optim pureQuery Runtime, Optim Database Administrator.
Many of you may be wondering about the no-charge capabilities. We heard loud and clear that our customers want a stand-alone download package for the no-charge capability. We are reverting to that packaging model with this release. More on that as it becomes available in the near future.
I’m asking some of my technical leaders and product managers to go into more detail on these announcements in future blog posts. In the meantime, I must go back to the conference. Lots to talk about…
IBM_Optim 27000269HS Tags:  rational_data_architect rda kokkat data_privacy data_model optim 4,645 Views
Have you heard the news? The new release of IBM's premiere data modeling tool, Rational Data Architect (RDA) 7.5 has been announced and will be available for download on September 26. The key themes for Rational Data Architect, now and in the future, include integration and to provide the foundational modeling capability you need to support your information initiatives, including data privacy support.
This release includes our first step in integrating with Optim Data Privacy solutions and of course, the integration with the other architecture management products in the Rational 7.5 portfolio. Because we're committed to supporting a heterogeneous database environment, we've also extended our support for both Oracle and SQL server databases.
Rational Data Architect 7.5 integration with Optim data privacy and test data management solutions
You have probably heard a lot of stories in the news of large companies that have been compromised because confidential information of its clients has been stolen. A lot of theft happens within the company and so it becomes difficult to manage. Optim gives you tools to enforce a data governance strategy.
What we have done in Rational Data Architect is now allow you to specify data privacy attributes (policies, data masking rules) and export the data privacy and test data definition artifacts for easy import to an Optim directory that can be used for creating the physical test databases. We have extended the domain model in RDA so that you can specify data privacy classifications and masking rules right in the domain model and then apply it to the various columns in your data model. This will then create a file that Optim can consume and read. Not only do you have a privacy specification that can be reused across your test databases, it saves a lot of manual effort. And you can also generate a compliance report that will come in handy for audits!
If you want to try this integration yourself, go to the IOD web site and sign yourself up for the following hands on lab that I and my colleague in Optim, Rick Buglio, will teach:
Rick and I are also working on a developerWorks tutorial that we hope to have available in the October timeframe.
This gives you a lot of benefits in terms of functionality. RDA still maintains its close integration with RSA so that you can do things like transform a data model to an application model, etc. We have enhanced some further transformations especially in the XML space. Also there is a RDAM (Rational Data Architect + Rational Software Modeler) bundle based on 7.5 that gives you a great deal on these two products together.
Enhanced support for non-IBM databases
Where is the trial?
I look forward to seeing you at IOD. For those of you doing data architecture, be sure to join me and other Rational developers at a Birds of a Feather session on Wednesday, October 29th at 6.00 pm in the Mandalay Bay North Convention Center - Tropics B. The number is BOF-3280. If you can’t join us, please use the comments link below or send an email to firstname.lastname@example.org to send feedback on our product or if you are interested in more discussion on particular areas of data architecture.
--Anson Kokkat[Read More]