The more you understand how DB2 is internally structured, the easier it will be to do system tuning. This presentation will teach you the different components that make up DB2 for z/OS. With every part we examine, we also will look how we can tune this component to achieve maximum performance. This seminar is unique since it focuses completely on the system side of DB2. Once you know how DB2 services your requests you also will find it easier to understand application tuning and the recent DB2 enhancements. This seminar is completely up to date with Version 8 aspects. The target audience is people who have multiple years of experience with DB2 and who want to learn more about the internal structure of DB2.
Architecture trends SOA WebServices Master Data Management Information as a Service
Information- and process-integration models Message call to other business domain Procedure call to other business domain Direct access to data in another business domain Replication of data to other business domain Creation of ‘information broker-layer Master Data Management
System z Data Serving Roadmap Speciality engines
Database application interfaces Stored Procedures, Triggers and UDF XML integration DB2 and SOAP Federated databases
Information placement templates Multi-platform- and network- impact on process and data placement Data federation – solutions Data replication - solutions
Summary
We all know that Version 8 of DB2 for z/OS introduces a new way to partition your data - we now have Table Based as well as Index Based partitioning. Is it all good news though? This presentation looks at the new capabilities of table based partitioning, considers the advantages (and there are many) before looking at some of the pitfalls awaiting the unwary. As with all new features of DB2, there are some hidden surprises that may cause problems that are not immediately aparrent
XML is here to stay. More and more is this method used to transmit and store data. What is so cool about XML? XML data is different from relational data. So how are we going to handle this? Klaas will explain what XML is and why it is used so much. Then we will analyse how we can store, extract and assemble XML. All options are available in DB2. We will go a complete journey with XML functions, XML extender and Native XML storage.
As with every version of DB2 new features are introduced that introduce better and faster ways to get things done. In the area of high availability and performance DB2 9 introduces a whole set of options that make life easier and faster. But as usual not all problems are gone, what else would we get in version next. This presentation goes into the V9 new functions and covers how this can help you and where you still need to pay attention.
As a DBA you are faced with a lot of new terms such as SOA, EII, EIA and many others. This presentation takes you through these new buzzwords and tries to put them in perspective of the DBA.
Bullet Points: Introduction What is SOA The data quality issue Integration solutions EII, EAI Information as a Service
This presentation will review our new Java technology that will simplify access to databases, and greatly improve monitoring, problem determination, and management of the database and application.
The IT Infrastructure Library (ITIL) was first developed in the late 1980s and has become the de facto standard for IT Service Management and the delivery of IT services to the business. There is a growing awareness of this standard among IT organizaions many of whom are now adopting the practices defined by ITIL and as a result are looking for tools to support their adoption of ITIL processes. There is also a growing interest around the world in the adoption of the best practices defined by ITIL for Service Management. This presentation will outline basic ITIL processes and present how DB2 solutions can support those ITIL practices. In some cases the solutions directly assist in the implementation of the processes defined by ITIL, in other cases the solutions provide the support that staff following the ITIL processes would use to make the process more efficient and effective.
Presentation objectives: DR/BC terms and solutions overview Details on the DR solution installed in ZABA Setting priority of the data DB2 group restart considerations Additional benefits of the DR solution
Outline: DR/BC solutions overview – Types of DR DB2 disaster recovery – Data loss/recovery time considerations Solution implemented in ZABA – Implementation steps, current situation, hardware overview DB2 group restart procedure (DB2 DR procedure) – Step by step analysis Additional capabilities and future plans
Full Abstract: Data protection and business continuity are the keys to business survival especially in banking. Being open for business in the shortest time after some kind of disaster occurred and having no data loss are high priority demands.This presentation will introduce the audience with the overview of business continuity (BC) and disaster recovery (DR) solutions. The DR/BC solution implemented in Zagrebacka Banka will be discussed in more details. Special attention will be given to DB2 group restart at recovery site emphasizing important elements that need to be considered in such procedure: setting the data priorities, tuning DB2 ZPARMs for group restart and removing restrictive statuses form DB2 objects at DR site. Additional value of having an exact copy of production system available for testing will also be addressed.
European SQLAdria Seminar – Vodice 2024
SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.
8 reasons to come Speakers Events Contact
VODICE - 12th - 15th June 2023