IBM DB2 and IMS Tools

This telecon helps you understand how IMS HALDB Conversion and Maintenance Aid not only assists with the conversion but with post-conversion maintenance as well. You'll also learn how IMS Online Reorganization Facility can reorganize your HALDB databases in seconds in one step.

This telecon discusses importance of referential integrity and role of DB2 Tools for z/OS in taking your RI relationships from passive to active whether you are managing DB2 enforced or application Referential Integrity. With DB2, you can see it in the DB2 catalogs if you know where to look. With Application RI, if the application is aging, documentation may be missing or incomplete. In either case, there is no meta data. In this telecon, you will learn how to make your passive RI active by using DB2 Grouper, a component in DB2 Recovery Expert, DB2 Data Archive Expert, and DB2 Test Database Generator. And you will see how to share your RI information across recovery, creation of test data and finally the archiving of your data.

Your IMS databases have hit the 4 and 8 GB limit. You've applied all the fixes you can but it's not enough. Learn why you need to move to HALDB sooner rather than later to take advantage of the partition independence that brings the high availability you need for backup, recovery, and reorganization processing.

Terry Purcell, IBM Senior Software Engineer, explains how DB2 for z/OS V8 simplifies identification of SQL performance problems and fundamental optimization challenges such as uneven distribution of data, data correlation or unknown ranges. Hear how to pinpoint problems and determine appropriate solutions to handle your SQL questions.

John Campbell discusses what you can expect when it comes to virtual and/or real storage as you move to Version 8's 64 Bit environment and DBM1 address space of 16 Exabytes. This should make it easier to manage your virtual storage -- but what if the relief that you expected is not there? Learn what will or has happened to your virtual and real storage, and understand how you can alleviate any issues you are having.

Learn how IBM® DB2 Query Monitor and DB2 SQL Performance Analyzer work together to give you a complete SQL performance solution that optimizes your overall database performance through well performing SQL queries. Join speakers Elaine Morelli and John Casey to explore tuning SQL statements, estimating the cost of queries, and determining the best access paths for queries.

If you are involved in or about to be involved in the migration to DB2 for z/OS V8, you'll be interested in hearing John Campbell discuss how to plan for a successful upgrade. You will learn tips for implementing new V8 functions, and how to traverse the three modes to completing your upgrade -- Compatibility Mode (CM), Enable New Function Mode (ENFM) and New Function Mode (NFM) -- and you will have an understanding of the value that this release can offer your company.

Learn why IMS Command Control Facility has no peers when it comes to processing IMS commands from a single point of control and helping you manage IMS database environments more efficiently while improving overall IMS system performance. If you want to ensure synchronization of online change and database commands across all IMS regions in your sysplex, and want to limit the number of places you have to search for IMS problems, listen to speakers Janet Leblanc and Gary Heimerl discuss the value this tool brings to your IMS environment.

Learn how IBM® WebSphere® DataStage and WebSphere Information Integrator Classic Federation for z/OS® can help maximize the value of your data while minimizing cost. You will see how to --

Reuse and repurpose your System z data for everything from business intelligence and data warehousing to e-business -- in a fraction of the time and without mainframe programming.

Deliver data when, where and how it’s needed. Whether it’s a daily update of total sales or a real time feed of available inventory, data becomes information ONLY when it is delivered to the right user or application, in the right format and in time to make a difference.

Regulatory compliance, security and integrity demands are constantly increasing. This webcast discusses various practices for compliance and security, how you can make improvements, and how to respond to the increase in security and compliance demands. Emphasis is on the improvements in DB2 for z/OS V8, DB2 9 for z/OS and in a number of different IBM DB2 Tools for z/OS that can help increase data security and promote regulatory compliance.

Learn tips and techniques from Ed Woods as he shows you how OMEGAMON XE for IMS™ provides a performance and availability management solution that can help you manage and tune IMS. Ed Woods teaches you valuable techniques to analyze IMS application performance and resource consumption, and isolate IMS performance issues using OMEGAMON historical and real time features.

Ed Woods explains how to navigate through the OMEGAMON XE for DB2 performance tools for z/OS to quickly identify the root cause of slowdowns and take fast action to correct the problems. This teleconference was developed for OMEGAMON users who want to learn more about some of the most powerful aspects of using OMEGAMON to manage and tune DB2 in the z/OS environment. Learn how to use powerful command capabilities to analyze DB2 performance challenges.

Learn how the automated functions and task-oriented design of IMS Database Control Suite help increase the overall productivity of DBAs. Supporting Full Function, HALDB, and Fast Path databases, IMS Database Control Suite brings together IBM database tools and utilities into an integrated suite containing all the functions necessary to centrally maintain and manage IMS Databases.

Designed for auditors and compliance and security administrators as well as DBAs, this teleconference led by Ernest Mancil and Elaine Morelli discusses how to proactively respond to compliance regulations by auditing, archiving, and encrypting your valuable data assets.

Production downtime from application outages can be costly. IBM can help you quickly optimize programs and easily identify and resolve problems that occur in batch, IMS™, DB2®, CICS®, WebSphere® MQ, WebSphere Application Server on z/OS and UNIX® System Services applications. IBM’s problem determination tools not only tolerate, but exploit the latest technology of current platforms to optimize CPU usage. Tools covered in this telecon include: Fault Analyzer, File Manager and Debug Tools Utilities; Application Performance Analyzer; Workload Simulator, Application Time Facility and File Export; Rational Performance Tester for z/OS; Rational function tester extension for terminal-based applications.

Learn how DB2, at the center of the warehouse, has been enhanced to support data warehousing…with new functions like enhanced index options, new partitioning options as well as SQL enhancements to mention but a few. Additional software technologies from IBM can offer high-volume, complex data transformation and data movement used for standalone ETL or as a real-time data transformation engine.

Event Detection and Publishing is a new approach within SOA that gives you a non-intrusive way to unlock the power of z/OS applications and data. It provides immediate detection of, and immediate action on, application and data events with no change requirements to underlying code. The IBM z/OS Event Publishing toolset can help you use core z/OS applications to leverage new business opportunities or new technology, distribute CICS, VSAM, DB2, IMS™, CA-IDMS, Adabas and other database information without rewriting code, and deliver external event logging or notification of CICS, DB2 or IMS activity. Speakers are: Dot Alexander, Vice President, System z Software, Americas; Satish Tanna, Senior IT Specialist, Technical Specialist for CICS z/OS Tools; and Karen Durward, Information Management, WebSphere II Product Management to learn how event publishing can work for you.

Learn how to gain control of and optimize DB2 on Linux, UNIX, and Windows and improve throughput response time and consistency. See how DB2 Performance Expert and Query Patroller optimize database operations in multiple environments and help you adapt IT systems easily and economically to support changing business needs. Speakers are: Dwaine Snow, Senior Product Manager, DB2 Data Server; Salvatore Vella, Vice President, DB2 for LUW; and Alice Ma, DB2 Tools Specialist.

Judy Ruby-Brown discusses how to improve the robustness of the DB2 data sharing infrastructure of your company. Based on 4 years of performing health checks on large parallel sysplex systems where data sharing has been implemented, Judy describes the obstacles observed and provides recommendations for achieving high availability targets.

Mark Rader explores 6 key reasons why customers who need more capacity and higher availability, who want scalable growth and workload balancing should consider data sharing.

Need to change DB2 structures and data more frequently and under tighter deadlines than ever before? Are you finding the change management process to be prone to error, tedious, and slow? In this webcast, Jeff Ruggles, team leader for DB2 Change Management Expert, will describe how database managers and database administrators can improve their teams' productivity on Linux, Unix and Microsoft Windows. This webcast will focus on solving the problems that are often involved in database change management.

Recovery is a topic everyone faces – best to deal with it before it's too late. The problem could be as simple as deleting rather than updating a customer file... or as dramatic as a disk error. When you need to recover fast, that's when you need the software to help. Learn about the latest DB2 recovery tools that can help your DB2 for z/OS environment.

What is the one thing that keeps you up at night? If it is IMS performance, you are like many of our customers. If performance is key to user satisfaction, both externally and internally in your company, learn what you can do to ensure top performance from your IMS database by using IMS Performance Analyzer and Tivoli OMEGAMON XE for IMS.

If you are like most of our customers, you probably have not thought about your DB2 Utilities for a while -- the Utilities just run. This teleconference focuses on helping you learn how to augment your Utilities by using IBM DB2 Automation Tool to automate mundane tasks and DB2 Thread Expert to cancel long- running applications that have stopped you from running your Utilities when they are needed.. Hear how to enhance your DB2 V8 environment, exploit the IBM zIIP engines, and offload Utilities processing. Join speakers Bryan Smith, Senior Technical Lead for DB2 for z/OS Utilities, and David Schwartz, Chief Architect DB2 Tools Strategy and Planning, to hear the latest news.

Learn how DB2 V9 for z/OS & DB2 tools continue to provide an unmatched IT infrastructure to solve your information-intensive business problems. This release promises exciting new innovations such as a Hybrid relational-XML data server that helps you manage the integration of new types of applications in an SOA environment. With DB2 V9, you can realize the business value of your company’s information, manage risk and streamline compliance while taking advantage of the features of DB2 tools that exploit this new release.

This teleconference is packed with important information for DBAs responsible for the reorganization of IMS data, while maintaining maximum data availability. Hear the latest news about IBM IMS Online Reorganization Facility.

This teleconference is packed with important information for DBAs, Application Programmers, Project Leaders and I/T personnel responsible for Data Warehouses/ETL, who have requirements for accessing data from diverse mainframe sources. Learn about IBM® WebSphere II Classic Federation, WebSphere DataStage, and WebSphere II Replication.

Learn how DB2 and IMS Tools broadens the scope of their OLTP mission to provide application tooling to help take your business to the next level -- where availability of information on demand leads to business transformation. Dan Wardman, IBM vice president, discusses the new dynamic of information management that encompasses concepts such as information as a service, Service Oriented Architecture (SOA), and Master Data Management. Dan explains how DB2 and IMS tools will emerge as key components of total business solutions in content management and business intelligence. Dan looks at future processes and applications that will place increasing demands on infrastructure and shows how tools form the foundation of these applications.

Understand the role DB2 V8 plays in promoting and serving new workloads with Service Oriented Architecture. You will learn how to make DB2 applications available in a SOA environment and integrate DB2 for z/OS with Web services.

Today's on demand e-business demands speed. Fast response to business initiatives. Quick access to data and applications. You need cost-effective solutions that help create competitive advantage--and you need them now. Ray Jones, IBM worldwide vice president of System z sofware tells you how IBM technology and pricing alternatives can help you meet requirements and increase ROI.

This teleconference is focused on IMS Database Recovery Facility, a tool that provides solutions to a wide variety of recovery nightmares. If you are responsible for database recovery and continuous availability in both online and batch IMS environments, you'll be interested in hearing speakers Allen Hall and Victor Lim from IBM Silicon Valley Lab as they show you how this tool can help solve your recovery problems.

Does excessive sorting have a major impact on the performance of your BI system? Do you need an easier way to identify and understand your top long running queries? Are you supporting a DPF environment ? Do you need a faster way to get information about individual partitions? IBM DB2 Performance Expert for Multiplatforms offers solutions to these and many more database and BI performance challenges. If you're interested in optimizing the performance of your BI environment on Linux, Unix and Microsoft Windows, join speakers Kevin Taylor and Marcia Miskimen to learn how DB2 Performance Expert can help tune your BI system.

Explore the value that DB2 Web Query Tool and DB2 Table Editor offer to meet your database access requirements. If you create applications that need to access DB2 data from the Web, or want the ability to edit DB2 data from a Web browser, speakers Shawn Sullivan and Tom Hubbard answer your questions as they unveil the secrets of two exciting tools.

This webcast focused on integrating IMS with IBM Rational and WebSphere tools. It covered the new enhancements that can help you take advantage of the latest technologies and on demand business processes with your applications while leveraging the scalability and robustness of IMS. Greg Lotko, IMS Product Director, Bob Love, Senior Technical Staff Member and Classic Federation/Event Publisher Development Manager, and IMS Development Leads Kyle Charlet, Kevin Flanigan, and Haley Fung lead the discussion on new and enhanced IMS application development and enablement options.

To get the full value of data existing throughout your organization, you need to make it readily available for daily operations, for critical operational decision support, and for longer-term analysis. With data volumes expanding everywhere, you may not have the time or specialized skills for integrating all of your critical mainframe information from sources such as DB2, VSAM, IMS, CA-IDMS, CA-Datacom and more. Join IBM's Paula Sigmon, Marketing Director, and Karen Durward, Product Manager, to learn how leading companies seamlessly integrate their mainframe data in real time -- without unnecessary data movement and replication, and without custom programming.

This webcast is designed to show you how DB2 for z/OS, Version 8, DB2 Tools and z9 or z/Series provide an optimized infrastructure to manage information for diverse workloads securely and efficiently. Speakers Roger Miller and Tom Ramey team up to explain how DB2 and DB2 Tools can optimize your resources, reduce the complexity of managing data systems, and make DBAs more productive.

Would a single point of control for IMS in a Sysplex environment make managing IMS easier? Would it be useful to see the attributes and status of IMS resources across the Sysplex and be notified about critical events? If your answers are yes, and you want to know more, join IBM on February 14 for a teleconference featuring a new tool, IMS Sysplex Manager. You will learn how this tool can help simplify managing IMS in a Sysplex. Whether you choose an aggregated view of all IMS systems or a local view of a single IMS, you'll see how this tool can make your job easier.

Join IBM on February 2 and learn where to look for help when DB2 response time has deteriorated and how to check the health of your DB2 subsystems. As businesses expand and performance demands increase, you can look to IBM for best of breed tools in DB2 online and batch performance monitoring. This telecon focuses on Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS and Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS. You will see how to look at response time degradation from an historical perspective and how to use online functionality to monitor problems as they occur.

This telecon looks at the changing requirements for data warehousing and business intelligence andthe new challenges they bring for IT professionals. Join IBM speakers Jay Yothers and Bill O'Connell for a discussion of how new capabilities in DB2 and the unique values of the z9/zSeries platform can give you a competitive advantage for your business-critical applications. You'll learn why you can't afford not to run BI on z9/zSeries, and you'll hear why SAP BW on z9/zSeries makes good business sense... as well as dollars and cents. It's all about real-time access to core business data.

From hardware to operating systems to software, encryption has many facets. Learn how IBM can help keep your data safe by leveraging ICSF, Data Encryption for IMS and DB2 Databases, and IBM Encryption Facility for z/OS. Register now.

Based on actual customer experiences, this telecon shows you how to build solutions that address new applications and data types, access incompatible heterogenous data stores, handle replication of 10M transactions with less then 2-second latency, and integration information from various databases such as DB2, Oracle, IDMS, Adabase, and Microsoft SQL Server. WebSphere Information Integration Tools help make it happen.

Join Dan Wardman, Vice President IBM DB2® and IMS(TM) Tools, for his latest update on the newest tools and enhancements available to help you get the most value from the dollars you invest in your DB2 and IMS systems. In the tools space, there is always new news, and this time is no exception. Since Dan's last discussion in May, there is plenty of interesting news to catch up on. Register now.

More data, more users, longer hours. It adds up to more mistakes -- and that means having a contingency plan to restore versions of objects without the backups, or retrieve lost data due to the loss of a disk drive or a customer profile deleted in error. See how DB2® Log Analysis Tool, DB2 Automation Tool and DB2 Object Restore can help you make contingency planning for DB2 easier and safer.

OMEGAMON® XE, the market leading end-to-end zSeries® systems management solution, has enhanced a series of OMEGAMON XE products for z/OS®, IMS(TM), DB2®, storage and mainframe networks. These products are the central interface for all infrastructure management products, such as NetView®, SA and distributed monitoring systems.

Learn how to meet demands for enhanced integration and growth by applying new IMS(TM) function and tooling. Focusing on your need for flexible integration with IMS, this interactive session features an in-depth discussion of the latest IMS enhancements and related IMS tooling technology.

This teleconference addresses auditing information that every DBA Manager, System Programmer Manager and System Programmer needs to know to respond to governmental regulatory actions and requests from auditors. Whether someone changed your IMS data hours or months ago, you may need to answer questions like who, when, what and where. IMS Problem Investigator works across a Sysplex, in IMS Transaction Manager or IMS Database Manager System. Register to join Fundi Software's Jim Martin and IBM's Ben Harrison to find out how this tool can provide you with easier analysis and quicker ways to get the data for your auditors.

Learn how DB2 UDB for z/OS Version 8 can optimize your performance. Topics include the performance improvements we have seen in the lab, as well as performance measurements and the range of improvements for application and query performance. See how to use less CPU time and get faster response.

Utilities, utilties, and more utilities! If you're a DBA looking to increase your productivity by putting DB2 Utilities to work for you, join Mary Petras and Winston Tobias on October 13 for a teleconference that shows you how to pair DB2 Utilities with DB2 Automation Tool to get the most from your z/OS system.

Find out about Event Publishing--what it is and what it can do for you. Learn how WebSphere Information Integrator Classic Event Publisher can help you meet the challenges you face to push operational data, deliver changed data, and use data to drive additional operational processes. Join IBM's Paul Cadarette to see how to put event publishing techniques to work for your enterprise.

Hear IBM's Janet LeBlanc discuss the latest enhancements to IMS High Performance SysGen Tools and IMS ETO Support and explain how these tools can help system administrators face the demands of managing more with less.

David Wilson, IT Project Lead and DB2 Analyst at WorldSpan, an industry-leading travel technology company, discusses how his decision to move to a suite of DB2 Tools for z/OS helps WorldSpan maintain 100% availability without impacting key applications, and paves the way for migration to DB2 UDB for z/OS, Version 8.

This is a teleconference packed with important information for System Programmers, Database Administrators and Database Managers who need to make the move to DB2 V8, and want to maintain performance of their DB2 applications.

Knowledge of IMS Connect and IMS Connect Extensions can help provide the solutions you need.

As an Application Developer or DBA, did you know that DB2 keeps information other than just recovery information in the Logs? If not, here’s your chance to learn.

Do you need 100% availability of your IMS databases...without outages for reorganizations? Do you need to reorganize your databases without causing other issues...allowing applications to run with minimal affects from the reorganization...making reorganization a good citizen in the online system? Applications are requiring larger capacity databases...can you accommodate the requests and still maintain high availability? If the answer is no, we may be able to help.

More and more businesses are relying on mainframe servers to power their transformation into on demand enterprises. For them, IBM eServer zSeries is the clear choice. zSeries servers have long been recognized for the rich set of features they offer around business resiliency, security, systems management and business integration. Find out how you can take advantage.

Using IBM Information Integration Tools for Continuous Availability, Web Access, and Event Notification.

Learn how IBM DB2 and IMS tools can help you redefine what TCO means to your business.

Privacy Acts and Government Regulations — IBM Tools for DB2 for z/OS Can Help You Take Control.

Migrating to DB2 Version 8: Rich enhancements to accelerate development of business-building applications

IMS database update: High Availability Large Database, Online Reorganization and associated new IMS tools.

It's all about performance!

See how Information Integration software provides a foundation for on demand business.

IMS V9 and Tools Web-enable databases...

Benefit from better data integration.

DB2 Utilities Best Practices Clinic.

DB2 UDB V8 Migration Webcast.

Learn how JAVA can be used to drive IMS transactions.

Learn how IBM's Data Archive Expert will help you automate and manage the archival and retrieval of inactive data.

Explore the factors that influence DB2 applications, database, and system performance. Learn how to deploy a proactive DB2 monitoring strategy to manage processes. Join IBM's Charles Lewis for this educational session. In Part 2 of this Clinic, IBM's Doug Clifton positioned DB2 performance tools as potential solutions to your performance concerns.

Understand the changes in DB2 Version 8 and explore the benefits of using IBM DB2 Tools in a DB2 V8 environment. Join Curt Cotner, IBM Distinguished Engineer and chief architect for DB2, and Dan Wardman, Director of DB2 and IMS Tools, on February 17 for a webcast that looked at the readiness of the DB2 Tools to support DB2 V8.

A series of three webcasts that focused on z/Series tools:

• On February 26, we talked about how to "Gain Competitive Advantage -- Leverage IBM's full Portfolio of zSeries Performance Management Capacity Planning Tools."
• On March 4, we showed you how to "Leverage zSeries Hardware and Software Automation Capabilities to Improve System, Data, and Application Productivity."
• On March 9, we discussed how to "Provide High Availability and Reduce Recovery Time -- Learn about Application, Data and System Management Backup and Recovery Solutions for zSeries."

Join Jim Ruddy, from the IBM DB2 Tools Lab, to learn more about DB2 V7 Utilities Optimization and V8 Utilities Update.

Join Rich Lewis to learn more about IMS HALDB and several implementation tips and tricks.

Are you involved with DB2 application development, production tuning, or the conversion of applications to DB2? Could you benefit from an up-to-date review of the latest guidelines and tips to achieve optimum performance? If so, view this replay!

Got IMS Tools? What about IMS Tools that support IMS V8? Day 1 availability of IMS Tools with IMS is critical to you our IMS users. Hear Dan Wardman, Silicon Valley Lab Director for DB2 and IMS Tools, discuss the current and future directions for IMS tools.

Join Ray Jones, IBM VP of Worldwide zSeries Software and learn how IBM is striking a bold blow to reduce total cost of computing in the enterprise computing space with a revamped and complete portfolio of enterprise tooling solutions. Ray will be joined by Tony Kimbrell, Director of Mainframe System Technology at LabCorp who will discuss why they made the decision to implement IBM enterprise tools and the savings they are currently receiving. Tony will also share LabCorp's experiences in migrating to IBM tools and what he believes is key to a smooth and successful migration.

This Webcast focuses on additional integration in new application development and connectivity aspects of IMS Version 8, WebSphere Version 5.0 IMS XML support, DB2 Version 8 IMS Control Center, and additional solutions for IMS integration.

This Webcast covers the new and enhanced IBM Data Management Tools for DB2 and IMS announced in April, 2003. Learn the latest news about how these tools can work for you and your business.

The 'S' in IMS has long been associated with the greatest scalability in the industry. In IMS, scalability comes in many aspects. This Webcast focuses on these aspects and the additional Scalability aspects of IMS Version 8, including Fast Path enhancements; Virtual Storage Constraint Relief; Parallel Database Open; DBRC bottleneck reduction and Java/JDBC performance improvements and additional new and planned DM Tools for IMS scalability.

View a replay of the Feb. 27 Webcast on migrating to DB2 for z/OS V7 with DB2 Tools.

View a replay of the January 30 Webcast on DB2 V7, DB2 Tools, and QMF in On Demand z/OS environments.

View a replay of the January 15 z/OS Webcast on the latest news for IMS and IMS Tools.