Meeting Announcement
Date: Thursday March 5th, 2009
Place: AT&T Riverwood Conference Center
Note: Cutoff date for pre-registration is February 27th, 2009.
Click here to register for the meeting
DB2 z/OS Track DB2 LUW Track 8:30 - 9:00 Registration - Coffee, juice and rolls Registration - Coffee, juice and rolls 9:00 - 10:30 Welcome and IBM Announcements Welcome and IBM Announcements pureXML Database Technology : An Introduction 10:30 - 10:45 Break Break 10:45 - 12:00
Throw away the gateway and go direct. DB2 Connect and DB2 for z/OS data sharing is recognized for providing high availability, addressing both planned and unplanned outages. Nevertheless, a user only cares that the task is executed, which is not the case if the application server cannot access the database server, even if the database server is up and running. This session walks through the step-by-step process to set up direct connections accessing a DB2 data sharing group eliminating the use of a gateway. It discusses frequently asked questions about direct connections, sysplex workload balancing and connection concentration. Querying and Managing pureXML Databases: An Overview 12:00 - 1:15 Lunch - on your own or “Lunch & Learn” with Joe Bell from Micro Focus. Topic is "Be Secure! Be Compliant! Be Productive! The importance of secured and right-sized data", which is geared for DB2 on z/OS, but all WDUG attendees are welcome. See Other Issues on the next page for a description of Joe’s presentation. Lunch will be provided courtesy of Micro Focus. Sign-up is required when pre-registering. Lunch - on your own or “Lunch & Learn” with Joe Bell from Micro Focus. Topic is "Be Secure! Be Compliant! Be Productive! The importance of secured and right-sized data", which is geared for DB2 on z/OS, but all WDUG attendees are welcome. See Other Issues on the next page for a description of Joe’s presentation. Lunch will be provided courtesy of Micro Focus. Sign-up is required when pre-registering. 1:15 - 2:30 Speed Time to Market by Improving Testing Productivity and Quality Best Practice on using External Stored Procedures and UDFs 2:30 - 2:45 Break Break 2:45 - 4:00 Best Practice on Transaction Log File Management
Protect your business using new DB2 9 security features
Jim Pickel , IBM Silicon Valley
The information highway continues to increase the demand for instant access to information without boundaries. How can you protect your data with all these new demands? The mainframe is the most secure environment but only if you utilize its features. This session discusses various new practices for DB2 for z/OS security including trusted context and roles introduced in Version 9. Most sites have a range of security needs and objectives. For some situations, a basic application security plan is adequate to protect your information. For others, a comprehensive data-centric security plan is needed to protect your information from all types of access. Choices and guidelines will be primary points, discussing ways to utilize the new techniques to improve compliance and security for your site. The objective is to help you understand the range of choices, the recent DB2 changes and how to make incremental enhancements to protect your data. Don’t let your business be in the headlines.
Susan Malaika, IBM
Learn how you can store, index, and query XML data in IBM DB2 easily without first mapping to relational structures and achieve considerable design and development savings. Schema evolution becomes easier as there is no longer any need to re-structure the way data is stored in the face of XML structure changes. There is no need to associate exactly one schema with the stored XML; the appropriate version of the schema can be used. New SOA, Web Services, Web 2.0, Mashup and Forms solutions for XML are easier to build. A pureXML solution will be described and illustrations will be provided. The session will include a brief introduction to basic XML principles if required by the audience.
Jim Pickel , IBM Silicon Valley
Susan Malaika, IBM
SQL/XML is one of the main ways to access or produce XML from a database and is part of the ANSI/ISO SQL standard. This session will provide an overview of XPath, a cornerstone of XML technologies such SQL/XML, XQuery, XSLT. It will then introduce SQL/XML which enables the querying and manipulation of XML in IBM DB2 on UNIX/Windows and on z/OS. Examples will be used throughout. Hints and tips for determining when to store XML and for managing XML data with IBM DB2 will also be provided.
Joe Bell, Micro Focus
The availability, quality and size of test data can be significant factors in reducing test times, improving quality and accelerating time to market. This session will explore the challenges of creating high quality test data that meets the varied needs of different testing requirements and will discuss what is needed to be able to rapidly create appropriate and secure subsets of mainframe test data.
Benjamin Leung, IBM Toronto
External Stored Procedures and UDFs are routines that are written in a host language (e.g. C, Java, CLR etc). They are encapsulated logic that resides on the database server, and are powerful tools for DB2 as they simplify business logic maintenance and improve performance by reducing network traffic. This presentation shows various types of external routines that DB2 supports and allows you to choose the most appropriate type of routines for your work. Also included are numerous hints and tips on writing, maintaining and tuning external routines.
DB2 and DASD Fast Replication
Ken Rodger, Mainstar Software Corporation
Many applications have critical requirements for quick and accurate cloning of entire DB2 subsystems or select table and index spaces, due to the need for production or development copies, recovery initiatives, query-only access, reporting, or testing. Using current techniques, data cloning can require the better part of a day. By making use of DASD-based Fast Replication technologies, the creation of clones can be automated and accomplished quickly, with minimal downtime. These same replication technologies can be used to backup DB2 subsystems, and recover all or portions of those subsystems. This session explores the Fast Replication options for both automated cloning, and backup and recovery.
Ron Castelletto, IBM Toronto
This talk will discuss best practices for log file management issues including suggestions for database configuration settings related to log file issues (LOGSECONDARY, LOGARCHMETH1, etc). Examples from real customer problems will be used to illustrate potential problems.
Speaker Bios
Susan Malaika, IBM, is a senior technical staff member in IBM's Information Management Group (part of IBM Software Group). Her specialties include XML, the Web, and databases. She has initiated multiple technologies that have been incorporated into products. She has developed standards that support data for grid environments at the Global Grid Forum. She has also co-authored a book on the Web and published articles on XML, Web and transaction processing - including more that 10 articles on pureXML. She is a member of the IBM Academy of Technology.
Benjamin Leung is a Staff Software Developer at the IBM Toronto Lab. He has worked in the DB2 Stored Procedures and UDFs team since joining IBM. He is the technical lead on the Stored Procedures and UDFs in DB2 Continuing Engineering team. He received a Bachelor of Applied Science degree in Computer Engineering from the University of Waterloo.
Ron Castelletto is a Software Developer at the IBM Toronto Lab working in the DB2 Continuing Engineering team. He has been working in the area of database recovery since joining the IBM Toronto Lab in 1991. He received a B.Math in Computer Science and M.Math in Computer Science from the University of Waterloo.
Jim Pickel , IBM Silicon Valley, received his BA in Computer Science from UC Berkeley and is a Senior Technical Staff Member at IBM. He has been working in DB2 for z/OS Development since Version 1 and is one of the original designers of the Distributed Data Facility and architect of DRDA. He is a member of the Open Group Database Interoperability Group and his primary focus is distributed database and security technologies.
Joe Bell, Micro Focus, is a Senior Solutions Engineer specializing in Micro Focus solutions that address data privatization and test data creation. He has thirty years of Information Technology experience in application programming, systems analysis and design, software acquisition, project management and technology and migration strategy assessment.
Ken Rodger joined Mainstar Software Corporation as a Systems Engineer in 2001 with over twenty years of experience in mainframe performance tuning, capacity planning and storage management. Ken has worked in industries as diverse as oil, healthcare, publishing, human resources consulting, and manufacturing. He clearly understands the myriad challenges facing IT enterprises today, and works with users to provide comprehensive solutions.
