IDUG DB2 Tech Channel provides multi-media content for a variety of topics on DB2 products
Use InfoSphere Information Server with DB2 for Data Integration and GovernanceIBM InfoSphere Information Server is a market-leading data integration and governance platform. It provides a set of capabilities to build confidence in your data by helping you understand, cleanse, transform and deliver trusted information to critical business initiatives, such as big data, master data management and point-of-impact analytics. Information Server provides comprehensive connectivity to DB2 (including DPF and BLU Acceleration) and it can also push computation to DB2 when appropriate. By using Information Server with DB2, you get its best-of-breed capabilities to integrate DB2 data and manage its metadata as well. Join us for this DB2 Tech Talk to learn how using these products together can help you deliver trusted information to your business, support big data initiatives, and more.
IDUG Tech Talk: DB2 11 for z/OS IDUG User ExperiencesIn March 2013 the IDUG DB2 11 Editorial Committee was formed, comprised of volunteers from IDUG's worldwide community of DB2 users and consultants. Working alongside IBM's formal Early Support Program (ESP), the Editorial Committee gained valuable insight into exactly what makes the new release tick. The White Paper, available on the IDUG web site, contains their findings, including practical experiences and independent evaluations of the new features.DB2 11 contains a large number of enhancements, but some will be of more interest than others depending on your job role and background. The paper has been organized according to the features likely to be most applicable to each of the three major technical roles in a DB2 for z/OS environment: Systems Programmers, Database Administrators and Application Developers.This presentation from the IDUG EMEA 2013 Technical Conference looks at some of the key findings presented in the paper.
DB2 Tech Talk: InfoSphere Workload Replay for DB Environment ChangesIBM InfoSphere Optim Workload Replay can significantly improve your database testing experience and help you successfully manage change in your database environments, whether you are adopting BLU Acceleration, upgrading DB2, or making the move to DB2. Using InfoSphere Workload Replay, you can build realistic testing environments to help assess a wide range of database changes before production deployment and without extensive script creation or application setup. This makes the change process faster and less risky. In this session, we will examine the use of InfoSphere Workload Replay to facilitate database testing in efforts to validate version, platform or infrastructure changes. We will discuss how to use the tool to prepare for BLU Acceleration, and review some of the key use cases. Learn the testing methodology and the various features to control capture, replay and generate reports. Using this realistic testing approach you will find key issues sooner in the test cycle, and resolve them before the deployment day.
DB2 Tech Talk: Build and Deploy Stored Procedures with IBM Data StudioStored Procedures and user-defined functions are a great way to consolidate database logic, improve database performance, code re-use, security and integrity. Stored Procedure development in DB2 has always been an integral part of the database, and in this DB2 Tech Talk, we will look at how IBM Data Studio helps accelerate the development and debugging process. IBM Data Studio is a comprehensive database development and administration environment. It includes the tools needed to develop and deploy Stored Procedures. We will look at the various wizards and options available to create a SQL Stored Procedure and walk through the debugging of that stored procedure in a DB2 environment.
IDUG Tech Talk: Taking Advantage of DB2's Advanced SQL FeaturesSQL is way more than a data access language. It is a full fledged programming language. What this means is that any business or scientific question that can be asked can be answered using SQL. There are no longer any limits to the capabilities of the SQL language. By utilizing some built-in advanced SQL constructs and extensions, and also applying a little experience and know-how you can program pretty much anything using SQL.
Use DB2 on the Cloud or BLU Acceleration on the CloudNeed to get started using DB2 quickly and at a low cost? Need BI and Data warehousing in-memory computing fast? This webcast will explain two different IBM cloud solutions that can help get you up and running quickly and cost-effectively:DB2 on the Cloud is available in several pre-installed, pre-configured editions of DB2 to support needs that range from a small workgroup to advanced enterprise data applications. These environments can meet a variety of needs including development, test, online transaction processing and more. BLU Acceleration for Cloud, recently released as a public technology preview, is designed to provide self-service BI or data warehousing in a simple agile cloud-based in-memory computing solution. It includes an option to use BLU Acceleration with Cognos BI so that you can get insights from your data very quickly and affordably. Attend this Tech Talk to learn more about these exciting cloud implementations and how they can work to provide data insights at the speed of business.
DB2 Tech Talk: Introduction and Technical Tour of DB2 with BLU AccelerationJoin 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 in-memory technology. 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.
DB2 Tech Talk: Deep Dive BLU Acceleration Super Easy In-memory AnalyticsJoin DB2 expert Sam Lightstone for an in-depth discussion of the all-new BLU Acceleration features in DB2 10.5 for Linux, UNIX and Windows. BLU Acceleration in-memory computing is designed to deliver results from data-intensive analytic workloads with speed and precision that is termed "speed of thought" analytics. In this Tech Talk, Sam will explain the details of this ground-breaking technology such as:*Dynamic in-memory analytics that do not require all of the data to fit in memory in order to perform analytics processing*Parallel vector processing, driving spectacular CPU exploitation*Enhanced columnar storage techniques, including supporting the coexistence of row-organized and column-organized tables in the same database, and even in the same workload and SQL*Actionable compression that does not require data to be decompressed in order to be analyzed, plus intelligent pre-fetch capabilities... and more! Join us to learn the technical details behind this exciting advancement and find out why it makes super analytics, super easy to perform.
DB2 Tech Talk: Adopt BLU Acceleration in DB2 10.5 the Faster Easier WayDB2 BLU Accelerationis an in-memory computing technology that is designed to handle data-intensive analytic workloads. It extends the capabilities of traditional in-memory systems by providing in-memory performance even when the data set size exceeds the size of the available memory.BLU Acceleration introduces a new column organization for table storage along with parallel data analysis and added compression. Learn about the use InfoSphere Optim tooling to allow for faster and easier adoption of BLU Acceleration:- Monitor the system performance before the adoption- Capture of the workload on the pre-adoption DB2 system- Recommend which tables are the best candidates to convert to columnar organization and obtain estimates on how much improvement you can expect- Automatically apply the conversion to adopt the new technology- Re-monitor and validate the results after conversion.This webcast will demonstrate an end-to-end scenario of how the tools can be used to make the adoption of BLU Acceleration technology faster and easier.
DB2 Tech Talk: BLU Acceleration Competitive Advantages for In-memory ComputingEveryone is talking about in-memory computing and columnar databases to improve analytic query performance. What makes BLU Acceleration different and unique? Learn the advantages of BLU Acceleration compared to other vendors offerings in the market. Chris will cover Oracle, Microsoft, Teradata, Vertica, SAP HANA and other vendors to describe what they have and what they don't have compared to BLU Acceleration. Join Chris for this fact-based discussion that will provide a true comparison of the vendor solutions beyond the hype.