- March 22, 2007
- DB2 for z/OS V8 is a huge release of DB2 - the largest ever, and "V8 for Developers" is a transition course designed to inform application developers (and DBAs who support developers) of the differences between V7 and V8.
Bonnie will cover the new features and changes to existing features that impact programmers and program design. Many are features that programmers will want to take advantage of in order to use the new version wisely.
Bonnie also offers suggestions for preparing today to take advantage of DB2 V8 tomorrow as well as suggestions for design rules that will need to be reexamined.
- July18, 2007
- DB2 for LUW Backup & Recovery Features
- Dale McInnis, IBM
- In this presentation we'll present what the current capabilities are for DB2's integrated backup and recovery features. It will provide some insight into what are the key architectural components and how you can utilize them to minimize your recovery time. Examples of how you can design your backup strategy to minimize recovery time will be walked through.
- DB2 for LUW High Availability / Disaster Recovery
- Dale McInnis, IBM
- In this presentation we'll present the trends and directions that are driving the HA strategy for DB2 on Linux, Unix and Windows. It will provide some insight into what are the key architectural components and how they provide the unique leverage points for applications, the key features and how they work, as well as a glimpse of what is coming next.
- Be Like a Hawk - Get a Bird’s Eye View of Your Enterprise Databases
- Brad Price, PMIC
- Many DBA's now find themselves with dozens of UDB instances and often hundreds of databases across many servers and testing/production platforms. How is a DBA to keep track of all of these and ensure that everything is safe, secure and properly configured?? Most tools and commands only provide information for a single instance or database. Come learn how to combine UDB table functions, administrative views and shell scripts to quickly and easily answer critical questions about your databases
- The ins and out of the DB2 Logger - what does it really do?
- Dale McInnis, IBM
- In this presentation we'll present what the current capabilities are for DB2's logger and why DB2 needs a logger. We will discuss how you can monitor the DB2 logger to pro-actively determine if there is a potential performance bottleneck, as well as make recommendations as to what "knobs" can be used to tune the logger thus minimizing your recovery window.
- The Three Best Approaches to Database Security and Data Auditing: Strengths and Weaknesses
- Henry Parnell, Lumingent Technologies, Inc.
- We will discuss the alternative technological solutions that can potentially be used to collect reliable audit trail data on the operations of a DBMS system with a discussion of the strengths and weaknesses of each approach. The alternative selected can greatly affect the depth of information that can be collected as well as the possibility of meeting regulatory compliance requirements without adversely impacting the DBMS system. This presentation will help to demystify the data auditing landscape, will compare each possible data collection approach as well as enumerate the capabilities needed by an enterprise class database auditing solution.
November 13, 2007
"SQL and DB2 for z/OS Database Performance Analysis andTechniques"by Dan Luksetich
Platform: All
Audience: Application Programmers and DBA's
Seminar covers DB2 for z/OS Version V7 and V8 plus a little DB2 V9.
Class content pertains to good SQL construction and analysis, a lot of which transcends versions.
Abstract:
Database are growing at extreme rates, and with ever increasingtransaction volumes and complexity it is most important to have the proper design in place and tested prior to implementation. Once the database is implemented it may be accessed via many different ways (mainframe, intranet, Internet), and you have to be able to track and report on application performance in a complex environment. This seminar will introduce the participant to SQL performance basics and filtering, and give the user the skills to analyze and improve SQL statements for performance. In addition, the participant will be introduced to advanced SQL, and the impact on performance, as well as the ability to use advance SQL for performance improvement. The proper monitoring of systems and SQL will be presented so that the most import SQL will be tuned first. The impact of advanced database object such as stored procedures, user-defined functions, triggers and constraints will be discussed in regards to performance. Techniques for the simulation and testing of performance concepts will be presented, along withadvanced database table and index design for performance.
|
