DB2 Tech Talk: Database Application Performance Management Best Practices

Listen to this brief webcast of the impressions these two IBM Champions have after evaluating DB2 10.5 with BLU Acceleration.

Join Distinguished Engineer and DB2 expert Berni Schiefer and host Rick Swagerman for a technical tour of the all new DB2 10.5 with BLU Acceleration software. You will learn about new features such as:

•BLU Acceleration, for “Speed of Thought” analytics
Designed to handle data-intensive analytics workloads, BLU Acceleration extends the capabilities of traditional in-memory systems by providing in-memory performance even when the data set size exceeds the size of the memory. Learn about RAM data loading capabilities, plus “data skipping”; parallel data analysis; actionable compression for analysis without decompressing data and more.

• New DB2 pureScale capabilities that enable online rolling maintenance updates and capacity growth with no planned downtime, plus new integration HADR capabilities to help ensure always available transactions.

• SQL and Oracle Database compatibility refinements in DB2 10.5, helping to ensure fast, easy moves to DB2 as well as increased flexibility for DB2 applications.

• Enhancements to NoSQL technologies that are now business-ready in DB2 10.5. Although not part of the DB2 10.5 announcement, we will fill you in on other No SQL technology introduction plans as well.

• New packaging editions of DB2 that that handle either OLTP or data warehousing needs.

• DB2 tools advances that support these new functions.

Join us for this Tech Talk to find out about these exciting enhancements and how they can help you deliver the data analytics your organization needs while providing tools to keep your OLTP systems in top shape.

In this brief Tech Bit, IBM Champion Tony Winch speaks on his impressions of DB2 10.5 with BLU Acceleration.

IDUG North America 2013 - Conference Orientation Program

Data warehousing is a rapidly growing and exciting area of technology because warehouse applications provide insightful information. In turn, these insights result in an operational or marketplace advantage for the organization.

While keeping the OLTP systems in top condition is a full time focus for many, warehousing has become a must-have skill. Through this technical webcast, you can quickly expand your level of understanding on data warehousing technologies.

Join Jessica Rockwood, IBM warehouse development and performance expert, to learn the current technologies in warehousing and what is needed in the future. Jessica will review core principles - the why, what, and how of warehousing. Then, she’ll cover current day challenges and the new capabilities needed for warehouses of the future.

Attend this talk to expand your warehousing knowledge.

Join architect James Cho for an in-depth discussion of this new tool for realtime operational warehousing that can help your organization speed the decision making process. You will learn when to use an operational warehouse for realtime decision making, for example fraud detection. James will also explain the features and advantages of this expert integrated system -- simplified deployment and maintenance and more.

Please note this talk is being delivered at 12:30 PM ET. You may see a different time presented depending the default CT zone or the time zone you indicate when you register.

Big Data is a hot topic today because it is now possible to analyze 'all' available data and derive meaningful insights. This includes a massive volume of both structured and unstructured data from standard relational databases to internet chatter, to device-derived data such as sensors and more.

While DB2 is commonly associated with relational data, it is able to handle many other data types. XML data support has been available for several releases and in DB2 10 RDF Graph Store has been introduced for building next-generation applications.

This Tech Talk will hit on features in DB2 10 that make it suitable for certain types of Big Data applications. It will also cover capabilities in other product offerings in the IBM Big Data portfolio and how they integrate with and compliment DB2.

Our presenters are Rav Ahuja, a DB2 on cloud expert and Big Data evangelist as well as Mario Briggs who is the developer for the RDF technologies in DB2 10.

This was the keynote presentation at IDUG EMEA 2012 Technical Conference. With the recent focus on Big Data, new technologies have emerged to help deal with the massive growth of structured and unstructured information. But what does this mean for the future of traditional database technologies? How do we prepare for it? And how might it affect our careers as data professionals? David Barnes, Program Director for IBM’s Emerging Internet Technologies group, will address those questions and more. David will also discuss how analytics are affecting our data strategies, and how to adapt your skills to the world of Data Science.

Many organizations are struggling to comply with data security and compliance mandates, while also reducing costs. With the new row-permission and column-mask features, IBM DB2 10 takes security and ease of use to the next level.

Join IM Information Management Chief Security Architect Walid Rjaibi for a deep dive technical discussion of the new Row and Column Access Control (RCAC) features in DB2 10 for Linux UNIX and Windows and InfoSphere Warehouse 10. Walid will also teach you proven methods to implement data security in the most cost-effective way.

IBM Gold Consultant and Champion Cristian Molaro discusses best practices on why where and how to achieve performance and cost savings on DB2 10 for z/OS.

Kick-start your learning on the new IBM PureData Systems expert integrated solutions, which utilize DB2 for Linux and as a core technology. James Cho, architect for IBM PureData System for Transactions and IBM PureData System for Operational Analytics, will introduce these solutions at the technical level. We will also briefly cover PureData for Analytics, which is based on the Netezza platform, providing a complete picture of the PureData Systems products.

We will cover technical aspects of the transactional and operational analytics products such as:
• Which type of workload is best on which system

• Fully integrated management features that streamline the management process and automate routine tasks

• Applying database patterns to speed deployment, provisioning and replicating databases

• Expert integrated and optimized out of the factory to ensure built-in scalability, and reliability with automatic failoverfor better system responsiveness

• Cloud-based capabilities for transactional and operational analytics systems, with application-as-a-service and infrastructure-as-a-service features

•New DB2 features such as Adaptive Compression that helps to maximize existing storage resources and improve performance

• Support for DB2 applications without change and Oracle applications with minimal change

• And more!

Join us for this informative webcast to get the learning process started! This Tech Talk will kick off some additional “deep dives” on these integrated expert systems. Reserve a space from the start.

Host Serge Rielau will take you through the highlights and hot news from the Information on Demand conference about DB2 for Linux, UNIX and Windows and other IBM Data Management products! This will include new offerings such as IBM PureData Systems for Transactions and IBM PureData Systems for Analytics. We will also cover IBM Mobile Database, which is a new free download that works with DB2. And we'll hit some of the best presentations from the conference too. Don't miss this Tech Talk!

Running the data storage environment can be a costly proposition. In addition to escalating costs for storage resources, there are additional costs associated with managing, powering and cooling the systems.

In response to customers concerns about these storage-related costs, IBM Information Management has been delivering advanced capabilities within the DB2 for Linux, UNIX and Windows product family to reduce storage requirements and improve database performance by focusing on various forms of in-database and in-memory compression.

With an eye toward current industry capabilities, this Tech Talk delves into the benefits and advantages of the DB2 solution in the following areas:
• database compression
• backup and archival compression
• how and when to use file system and storage deduplication technology

Along with these features and capabilities native to DB2, we will also compare these to Oracle and the rest of the database industry to show you why DB2 has a clear advantage when it comes to storage optimization.

Today's decisions need to be made “as soon as possible” to keep up with the fast pace of business and gain competitive advantage. For this reason the new DB2 10 and InfoSphere Warehouse 10 software products have some key new enhancements that help speed decision making with realtime operational data warehousing.

We will discuss the advantages of this type of warehousing as compared to non-realtime warehousing and traditional database applications.

And wer'll continue the "deep dive" into the major new features of the DB2 10 for Linux, UNIX and Windows and InfoSphere Warehouse 10, you will learn in this webcast how to :

--Deliver insights faster by combining the new Continuous Data Ingest feature with several performance enhancements for BI queries, such as star schema queries

-- Reduce capture and analysis latency across the warehousing process

-- Employ near real-time loading of warehouse data from multiple data sources, without the need to lock the entire target table

This is an exciting time to work with IBM data warehousing and analytics solutions. Please join us to see how these new features can help you advance your data applications on pace with growing business needs.

Rigorous performance monitoring and management are crucial for business critical applications. Even with premier in-engine query optimization, application performance for DB2 is dependent on factors like available resources, good database design, and data access best practices.

Join us for this DB2 Tech Talk where we will "deep dive" into IBM InfoSphere Optim solutions that offer state of the art performance monitoring and optimization technology for DB2 for Linux, UNIX and Windows applications. Using these performance management solutions for IBM DB2, experts from IBM labs will show you how to:

- Identify emergent performance related problems
- Diagnose where the problem resides
- Resolve issues in the application or database design, and
- Proactively prevent performance problems from re-occurring


The featured offerings include IBM InfoSphere Optim Performance Manager, InfoSphere Optim Query Workload Tuner, InfoSphere Optim Configuration Manager, and InfoSphere Optim pureQuery Runtime, which are also part of DB2 Advanced Enterprise Edition and InfoSphere Warehouse Advanced Enterprise Edition.

Validated DB2 skills help you stand out with your employer, meet annual education objectives, and create an edge in the employment marketplace.

IBM is offering the all new DB2 10.1 Fundamentals Certification (exam 610) to attendees of the Information on Demand global conference in Las Vegas, Nevada from October 21 – 25, 2012. And if you are not attending the conference, IBM is offering the Take it Again promotion through November 30, 2012.

This two-part Tech Talk can help you prepare for the exam. Part one was presented on Thursday July 26 from 12:30 to 2:00 PM ET. Part two is presented on Thursday August 2nd from 12:30 – 2:00 PM ET.

Basics of the DB2 products and tools, DB2 pureScale feature, plus data warehousing and OLAP concepts

·Security including authentication, authorization and privileges, and the new Row and Column Access Control (RCAC) feature

·Working with databases and database objects including use of DDL statements to create objects

·Accessing data using SQL, to query data including XML data with XQuery, and use of Time Travel Query with temporal tables

·Working with tables, views and indexes including XML and Oracle compatibility data types and the new temporal tables

·Data concurrency mechanisms


This talk is hosted by Serge Rielau, SQL architect for DB2 for LUW, with presentations by experienced DB2 instructor Andre Albuquerque.

The time is 12:30 PM ET, however note that your view may present in your local time zone.

Validated DB2 skills help you stand out with your employer, meet annual education objectives, and create an edge in the employment marketplace.

IBM is offering the all new DB2 10.1 Fundamentals Certification (exam 610) to attendees of the Information on Demand global conference in Las Vegas, Nevada from October 21 – 25, 2012. And if you are not attending the conference, IBM is offering the Take it Again promotion through November 30, 2012.

This two-part Tech Talk can help you prepare for the exam. Part one is presented on Thursday July 26 from 12:30 to 2:00 PM ET. Part two will be presented on Thursday August 2nd from 12:30 – 2:00 PM ET.

Basics of the DB2 products and tools, DB2 pureScale feature, plus data warehousing and OLAP concepts

·Security including authentication, authorization and privileges, and the new Row and Column Access Control (RCAC) feature

·Working with databases and database objects including use of DDL statements to create objects

·Accessing data using SQL, to query data including XML data with XQuery, and use of Time Travel Query with temporal tables

·Working with tables, views and indexes including XML and Oracle compatibility data types and the new temporal tables

·Data concurrency mechanisms


This talk is hosted by Serge Rielau, SQL architect for DB2 for LUW, with presentations by experienced DB2 instructor Andre Albuquerque.

The time is 12:30 PM ET, however note that your view may present in your local time zone.

This Tech Talk continues the "deep dive" on all all new IBM DB2 10 and IBM Infosphere Warehouse 10 features. Matthias Nicola from IBM labs explains the new Time Travel Query feature, which is a collection of bitemporal data management capabilities. These capabilities include temporal tables, temporal queries and updates, temporal constraints, and other functionality to manage data as of past or future points in time. Time Travel Query helps improve data consistency and quality across the enterprise and provides a cost-effective means to address auditing and compliance issues. As a result, organizations can reduce their risk of noncompliance and achieve greater business accuracy.

The presentation will discuss:
· How to create and manage temporal tables in DB2 10
· How insert, update, delete, and query data for different points in the past, present, or future
· How to use DB2 as a time machine

Please note that this webcast is conducted at 12:30 PM ET. You may see this time translated into your local time zone.