Managing the data lifecycle
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 18.104.22.168 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 22.214.171.124 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 126.96.36.199 Release Notes for more information and download updates from Fix Central.
Data Studio – Data Studio 188.8.131.52, 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 184.108.40.206 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,359 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,959 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.
We released several fixpacks on April 19th that I want to call your attention to. Not only do they provide defect fixes, but also some cool new function.
Data Studio Health Monitor - This fixpack adds support for health monitoring for DB2 for z/OS as well as alert notification support. Customers that we previewed the function with really liked the easy setup and the ability to share it with teams members in development and other operations staff. It monitors and alerts application blocking conditions like database down or log full plus users can view system log messages and see what application and utilities are running. Data Studio Health Monitoring is available at no charge and support DB2 for z/OS and DB2 for Linux, UNIX, and Windows databases. Check it out now! For more information, see the IBM Data Studio Health Monitor Version 220.127.116.11 Release Notes and product overview pages. You can download Data Studio Health Monitor V18.104.22.168 for an upgrade from version 2.2.1 or for a fresh install at IBM software downloads.
Optim Query Tuner - Query Tuner users will definitely want to pick this up! This fixpack for Optim Query Tuner offerings provides a new Access Plan Explorer. Many customers who have very complex SQL wanted a textual access plan navigation method in additional to the visual explain. This new tool displays access plans as tables or hierarchical trees. There are also additional usability and SQL capture enhancements. See What's New in Optim Query Tuner and the Release Notes pages.
InfoSphere Data Architect - This is a standard fixpack with defect fixes. For more information, see the IBM InfoSphere Data Architect Version 22.214.171.124 Release Notes and product overview pages. View the download document to learn how to download InfoSphere Data Architect V126.96.36.199 to upgrade from version 7.5.3.
Let us know how you like these enhancements :-)
We have released an update to our popular free e-book "Getting started with IBM Data Studio for DB2". The update covers some major new features that were released in Data Studio 2.2.1. The chapters covering database administration have been completely revised for the new Administration Explorer, which replaces the legacy Data Source Explorer. The updates also cover usability enhancements like improved context menus, DB2 Information Center links in the Task Assistants and also the new Task Launcher, which has gotten great feedback from our customers. Download the book today!
RichieEscarez 270000WWFW Tags:  features stand-alone studio data compare capabilities ide 7,299 Views
I want to take a moment of your time to share the new support page that highlights the features and capabilities between the stand-alone and IDE packages of IBM Data Studio:
Previously, this feature comparison table was available only from the Features and Benefits page but now it has its own dedicated page and is available through the IBM Support site. Use this page to compare features and help you determine which package is appropriate for your needs.
Hi, my name is Leif Pedersen, and one of my responsibilities is helping customers learn about and use Optim products, including Optim Query Workload Tuner for DB2 for z/OS. This week I received many
emails about how-to install the server side of Optim Query Workload
Tuner for DB2 for z/OS. I have collected some links with some of the information that
is needed to be able to set up Optim Query Worload
Tuner on DB2 for z/OS on the server. All of these links are within the Optim Query Tuner Information Center.
Installation and configuration roadmaps
The detailed information for setting up from the server side by using JCL batch jobs can be found from this topic.
I hope the above links can help you find answers to your questions about installing and configuring Optim Query Workload Tuner.
ellenl 120000QUAX 3,516 Views
We have a couple of great new features in the latest release of the Eclipse-based products (see the list in my last post) to help you get started. If you have ever opened a new product and you couldn't figure out what to do first, these features are for you!
The first feature is the new Task Launcher. We developed this in response to feedback from users like you about the Eclipse Welcome experience. This tabbed view highlights the key tasks that are available in each phase of the data management lifecycle, and using it, you can launch the initial context for each of the tasks. Simply click a task and get started! Additional help is available for each task so you can learn more as you go. User feedback on this new feature has been very positive so give it a try.
The other new feature is the Task Navigator, a new drop-down control that lets you switch easily between different types of tasks in the products. If you are the type of user who wears different hats and needs to switch back and forth often (for example, maybe you do some Java development, but also routine development or even some basic database administration) you can use the Task Navigator to make the perspective switch much easier. And if you close the Task Launcher, you can re-open it using the Task Navigator, as well!
We hope these new features are helpful as you get started with the lastest versions of these products.
ellenl 120000QUAX 3,590 Views
I am excited to talk about some new options for accessing product help in the latest releases of the Eclipse-based products:
In these releases, there are new options for accessing the contents of the product information center (either via F1 or the Help > Help Contents menu). These options are presented on a new panel in the Installation Manager Install wizard, and they can be changed at any time on the Window > Preferences > Help > Contents preferences page.
The local help for the Data Studio stand-alone package is still always installed with the product, and the stand-alone product does not include the new install options. However, you can still view the Data Studio stand-alone product information online using the link below.
For more information about these new options and how to configure them, see the following topic in one of the information centers: "Configuring Web-based help".
As part of this enhancement, you can also choose to view the product-specific information centers online (outside of the products), in an external web browser. The new information centers are located here:
Data Studio (IDE and stand-alone): http://publib.boulder.ibm.com/infocenter/idmhelp/ds-v2r2/index.jsp
Enjoy your new help options!