The IBM Optim Query Tuner and Optim Query Workload Tuner for z/OS can help DBAs and developers maximize application performance with expert advisors and tools while increasing customer satisfaction, productivity, and quality of service.
More specifically Optim Query Tuner helps developers to write more efficient SQL queries, it reduces costs and risks by enabling developers to tune SQL during development, while problems are still relatively inexpensive to fix and before they cause a costly outages or performance issues . It Operates within a familiar Eclipse development environment and features seamless integration and natural launch points within Optim Development Studio. It also accelerates query tuning analysis by providing expert advice and recommendations. It really helps DBAs and developers maximize application performance.
Check out the demo that shows an online retailer, who wants to uphold their commitment to customer satisfaction. See how they achieved their goal for online ordering response to be no more than 30 seconds.
It's all part of creating a smarter planet!
southworth 100000HBX4 Tags:  for performance db2 a planet smarter smart optimization 4,059 Views
Check out the optional DB2 Performance Optimization Feature. It gives you the insight and ability to optimize workload execution. This feature can save you money and lower your risks by helping you to do more work with your existing hardware, and increase DBA productivity. Saving resources is a smart thing.
Performance optimization is very complex with many interdependent factors requiring deep skills. These skills are often hard to come by and typically very expensive. Problem isolation can take days and require many people across different domains and expertise. Add to this, the pressure on business today and the constant state of flux – hardware upgrades, software upgrades, application enhancements, new application deployment.
IBM Optim Performance Manager helps optimize the performance and availability of mission critical databases and applications. This enables organizations to resolve performance bottlenecks before they affect the business. Optim Performance Manager delivers a proactive, comprehensive performance management approach that allows IT staff to identify, diagnose, solve and prevent performance workload management issues in DB2.
Check out the demo!
See how one fictional company uses DB2® Workload Management and Optim™ Performance Manager Extended Edition to allocate database system resources to help a high priority application achieve its business objectives in a data warehousing environment. These capabilities are conveniently packaged together in the DB2 Performance Optimization Feature.
southworth 100000HBX4 Tags:  performance manager extended insight install optim feature ibm the configure and 5,208 Views
Optim™ Performance Manager for DB2® for Linux®, UNIX®, and Windows® boasts a whole new architecture that includes modern browser-based user interfaces which provide system health overviews and detailed diagnostics to isolate the source of emergent problems. It provides performance analysis and tuning for managing DB2 systems using an easy to use web interface.
You should check out these demos to get started on the basics. It is a really cool product.
IBM Optim Performance Manager 220.127.116.11, Part 1: Install the product
Part 1 of this demo series describes IBM Optim Performance Manager 18.104.22.168 architecture and packaging, and how to install the product. Part 2 describes the Extended Insight architecture, and how to install and configure the Extended Insight client.
IBM Optim Performance Manager 22.214.171.124, Part 2: Install and configure the Extended Insight feature
Part 2 describes the Extended Insight architecture, and how to install and configure the Extended Insight client.
It is all part of creating a smarter planet!
southworth 100000HBX4 Tags:  manager utilization data optimize dba resource with configuration and availability performance database optim infosphere 3,304 Views
Maintaining database and application uptime while improving performance and lowering costs is an important challenge for DBAs and IT organizations.
IBM® InfoSphere™ Optim™ Configuration Manager allows you to view an auditable inventory of the information in your data systems. You can track configuration changes, determine and resolve problems by working with current and historical configuration data, and manage client configurations all from a central repository.
In this demo, check out how an IT team at a fictional company, the Sample Outdoor Company, can optimize their data availability and resource utilization with InfoSphere Optim Configuration Manager.
It is all about creating a smarter planet through software.
Check out the Demo!
southworth 100000HBX4 Tags:  merge expert ibm and optim recovery efficient with performance db2 unload advanced backup solution infosphere high 3,932 Views
Backup and recovery of systems is extremely important! From an IT perspective, manual backup and recovery processes are tedious, error prone, and time consuming, therefore, they are not frequently implemented. As the volume of data increases, though, it becomes more difficult to back up and recover without longer downtime that impacts production applications. To help resolve these challenges in database backup, recovery, and data unload, IBM DB2 Advanced Recovery Solution for DB2 for Linux, UNIX, and Windows provides three distinct products: IBM DB2 Merge Backup, IBM DB2 Recovery Expert, and IBM InfoSphere Optim High Performance Unload.
Watch how database administrators at a fictitious company improves their backup and recovery strategies with an IBM DB2 advanced recovery solution. See how the team uses various Optim and DB2 tools to make their backup and recovery process faster, simpler, and more efficient. This recovery solution includes three distinct products: DB2 Merge Backup, DB2 Recovery Expert, and Optim High Performance Unload.
IBM® Optim™ Performance Manager is a performance analysis and tuning tool for managing DB2 systems using a web interface. It can be deployed in two configuration options: Standalone and Extended Insight. Part 1 of this demo series shows the standalone configuration option. Part 2 shows the process of installing the Extended Insight feature.
Check out the demos and have fun!
southworth 100000HBX4 Tags:  dashboard using the performance database extended optim ibm manager insight administrators 3,892 Views
Using the IBM Optim Performance Manager Extended Insight dashboard
This is a really cool product! A follow-on to DB2 Performance Expert,
In this demo, check out how the Extended Insight capability of Optim™
It's all part of creating a smarter planet. Here is the Demo.
southworth 100000HBX4 Tags:  using db2 z/os applications manage for optim performance infosphere 3,240 Views
Manage DB2 for z/OS applications performance using InfoSphere Optim
InfoSphere Optim Data Lifecycle Management solutions manage data from requirements to retirement. Boost performance, empower collaboration, and improve governance across applications, databases and platforms.
See how the staff at one fictional organization, the Great Outdoors Company, takes advantage
of InfoSphere Optim integrated data management solutions for performance management. InfoSphere Optim solutions help the team work collaboratively to gain more value from their z/OS business-critical applications.
Watch how the team:
- Resolves an emergent database workload performance problem.
- Accelerates the performance and stability of the application without requiring code changes.
- Builds performance into a new application right from the start, thereby reducing downstream risks and costs.
It's all part of using tools to help create a smarter planet!