The use of dynamic SQL is increasing with the escalating use of packaged applications and off-platform client interfaces. In addition to the static SQL that has traditionally been managed, the ability to manage dynamic SQL is a requirement that can no longer be ignored. Dynamic SQL doesn’t give you the luxury of testing the SQL in advance or monitor changes like you do with static SQL. However, you can still manage dynamic SQL if you have the right knowledge, process and tools. Attend this webinar and learn how you can improve the performance of dynamic SQL running in your DB2 for z/OS systems. Gain the knowledge you need to answer these questions: Do you know where the dynamic SQL originated? How do you find which statements cause problems? How do you fix problem dynamic SQL statements? Do you have a process for managing dynamic SQL? Join Dan Hoffmann, Director Product Management and Joe Brockert, Sr. Software Consultant, and see how to easy it can be to manage dynamic SQL and protect application and system performance.

Poor performing SQL statements can be extremely disruptive to a business, causing application slow-downs, or worse, an outage. The only way to prevent this is to optimize both dynamic and static SQL problems before they reach production. As your DB2 mainframe system changes – application changes, system changes, and database changes are introduced – how do you measure the performance affect they have on your DB2 production system? Most SQL tuning tools and monitors are designed to identify problems only after they occur. Learn how you can detect SQL-related problems BEFORE changes are put into production. With NEON’s Bind ImpactExpert and SQL PerformanceExpert, you can: Manage the bind and rebind process; you decide when to rebind or not based on predicted performance. Get control of your dynamic SQL environment; easily locate problem dynamic SQL statements for possible correction or identify other DB2 changes to improve performance. Identify poorly performing SQL; analyze SQL from source code, packages, DBRMs or the dynamic cache. Eliminate the fear and uncertainty caused by data growth and application changes. Instead of reacting to problems—get proactive and prevent them. Keep your DB2 mainframe applications performing at their best. Whether you are making minor changes to an application or planning a migration to a new version of DB2, you can prevent SQL-related performance problems from being introduced into your production system. It’s easy with the right tools. Join Dan Hoffmann, and Joe Brockert for this webinar.

Do you have a DB2 recovery strategy that supports the risk, cost, and service profile of your business? When an unplanned database outage occurs, can you tell IT and line of business management how long the application will be down? Can you determine cost-benefit tradeoffs? There are many critical components to any recovery strategy—from what type of storage media to use, frequency of backups, recovery time objectives, risk analysis, cost-benefit tradeoffs and more—along with an ongoing understanding of all of these elements as the IT infrastructure and business needs change. And most IT organizations have lapses and gaps in their recovery strategy. Database administrators know that recovering DB2 data has many potential points of failure. It is essential to validate recovery processes and policies. In this time of mergers, acquisitions and tightened budgets, it's never been more important to make sure the critical data is recoverable and the business is protected. Attend this webinar and learn how NEON's Recovery AssuranceExpert can: Quickly identify gaps and lapses including unrecoverable DB2 objects Use benchmarks to predict recovery times for your DB2 objects, system and applications Report recoverability status now and over time to IT and business personnel and management Determine recovery risk and cost-benefit backup and recovery scenarios Join Dan Hoffmann, Director Product Management, and Michael Figaro for this webinar.

Business availability requires much more than just having a reliable hardware and database platform. Most companies cannot afford significant downtime, and some cannot afford any! As such, it is crucial for unplanned outages to be as short as possible. But it is not just a business requirement, in many cases assuring a speedy recovery is also a legal mandate. Regulations such as SOX and Basel II dictate that any outage is resolved within a predefined period of time. But how many of us can answer, with any degree of certainty, the question “How long will this outage last?” This webinar will tackle these issues, including a discussion of regulations, IT complexity, and business continuity, We’ll also make the case that planning for database recoverability is the most important task among the many tasks of the DBA. And we will also introduce and demonstrate Recovery AssuranceExpert, a new technology to help you ensure that all of your critical DB2 objects are recoverable within your recovery time objectives. Recovery AssuranceExpert is an automated solution to perform daily health checks of data availability and recoverability, as well as provide actual recovery times required for a DB2 object, a complete application, or even a whole DB2 subsystem. Join in to find out how you can insure that your actual recoverability times fit to your SLAs. Presented by Craig Mullins, Vice President of Data Strategy, NEON and Michael Figaro, Software Consultant, NEON

As the list of government regulations impacting IT grows organizations must adapt to understand and comply with new rules. This increasing compliance pressure is particularly intense on data stored in corporate databases. As such, organization need to be ever more vigilant in the techniques used to protect their data, and monitor access. Database auditing, sometimes called data access auditing, is one technique growing in popularity as a response to the demands of regulatory compliance. At a high level, database auditing is basically a facility to track the use of database resources and authority. It can be used to help answer questions like “Who accessed or changed data?” and “What was actually changed?” and “When did it change?” This presentation will discuss the issues and requirements driving database auditing and serve as a roadmap of sorts for your data access auditing needs. Presented by Craig Mullins, Vice President of Data Strategy, NEON

Anyone who has been paying attention lately knows at least something about the large number of data breaches that have been in the news. Data breaches and the threat of lost or stolen data will continue to plague organizations until comprehensive plans are enacted to combat them. Although many of these breaches have not been at the database level, some have, and more will be unless better data protection policies and procedures are enacted on operational databases. This presentation will provide an overview of the problem, providing examples of data breaches, their associated cost, and series of best practices for protecting your valuable production data. Attend Craig's presentation and avoid having your company's name splashed on the front page because you did not adequately protect your databases. Understand the various laws that have been enacted to combat data breaches and the trends toward increasing legislation Learn how to calculate the cost of a data breach based on industry best practices and research from leading analysts Gain knowledge of several best practices for managing data with the goal of protecting the data from surreptitious or nefarious access (and/or modification) Learn about the available techniques for securing, encrypting, and masking data to minimize exposure of critical data Uncover new data best practices for auditing access to database data and for protecting data stored for long-term retention Presented by Craig Mullins, Vice President of Data Strategy, NEON

Protecting corporate data is a requirement of doing business in today's regulatory and security-minded business environment. Protecting corporate data—an especially sensitive data—is a matter of knowing who is accessing data and what are they doing with it. There have been many solutions for addressing this need on distributed databases, but no reasonable solution for protecting mainframe data until now. This webinar introduces Guardium for Mainframes, the only database auditing solution available that provides 100% visibility into mainframe database activities without impacting normal business operations. See how the product gives you better insight into database activity without the performance penalty of typical database trace utilities and without relying on inadequate log file data. Guardium for Mainframes provides 100% visibility into all database activities, letting you identify access to sensitive data and potential security breaches, in real-time, and without sacrificing performance or availability. Presented by Bill Baker, Software Consultant, NEON

zIIP processors—a specialty mainframe processing engine from IBM—are now available for IMS processing. You can reduce the cost of IMS database maintenance—as well as other computing costs on the mainframe—by using zIIP processors for IMS work. Join Tom Harper, lead developer on the IMS Database Utilities Development Team, to find out how you can reduce general processor MIPs usage by offloading IMS work to a zIIP processor using the Eclipse Reorganization Utilities for IMS. Tom will also discuss how you can trial zIIP processors FREE as part of the IBM Specialty Engine Loaner Program. Presented by Tom Harper, NEON

Most changes are strictly controlled in the mainframe environment. But that is not the case for DB2 access paths. When we BIND or REBIND a program, DB2 formulates access paths "on the fly" and we do not have any control over what DB2 creates. This lack of control over changes can cause unpredictable performance. NEON's  Bind ImpactExpert product can help you analyze and manage access path changes, thus delivering better control over DB2 applications. Whether upgrading to a new version of DB2, introducing program changes, or simply rebinding for performance, Bind ImpactExpert helps bring a change control discipline to the DB2 access path generation process. Join Craig Mullins, DB2 Expert, and Joe Brockert, Sr. Software Consultant, for a discussion about managing access paths and a live demo of Bind ImpactExpert.  See the solution that provides predictability in access path changes.

This presentation offers a roadmap of sorts for DBAs at a higher level than just the bits and bytes. Based on the successful "Chicken Soup for the Soul" book series, this presentation offers database administration tasks, procedures, and operations. Topics covered include: •   Offers a framework for DB2 database administration •   Provides control objectives for DBAs to ensure an effective DB2 environment •   Offers best practices for DBA tasks such as database design, performance management, etc. •   How to expand your horizons from being viewed only as technicians to being viewed as integral to the business •   Guidance on how to interact with other IT professionals Presented by Craig S. Mullins, NEON

Looking for ways to reduce DB2 database maintenance costs? Learn how RealTime DBAExpert helps you accomplish this. With RealTime DBAExpert, you can identify and automatically schedule maintenance on an as-needed basis, eliminating unnecessary and costly utility jobs. Discover how RealTime DBAExpert exploits the use of RealTime Statistics to reduce the need for Runstats. Eliminate the need for pre-maintenance Runstats and Runstats-like scans and substantially reduce the need for post-maintenance Runstats and Runstats-like scans. RealTime DBAExpert enables on-demand scheduling that can reduce or eliminate database maintenance windows. Come learn how RealTime DBAExpert can reduce costs and help you perform DB2 database maintenance more efficiently. Presented by Joe Brockert, NEON

This presentation offers advice, guidelines, and observations on DB2 performance, administration, and development. The information is presented in a humorous fashion in the format of a series of Top Ten lists - kind of like if David Letterman were a DBA. This presentation was voted as one of the top presentations of IDUG in Denver. Presented by Craig S. Mullins, NEON