IDUG DB2 Tech Channel provides multi-media content for a variety of topics on DB2 products
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.
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.
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.
DB2 Tech Talk: Build Next-Gen Applications with DB2 JSON CapabilitiesRapidly changing application environments require a flexible mechanism to store and communicate data between different application tiers. JSON (JavaTM Script Object Notation) has proven to be a key technology for mobile, interactive applications because it reduces overhead for schema designs and eliminates data transformation needs. New DB2 JSON capabilities enable developers to use the JSON-oriented query language, created by MongoDB, to interact with data stored in IBM DB2 for Linux, UNIX, and Windows databases. This driver-based solution embraces flexible JSON data representation within a proven, reliable enterprise-class relational database. The DB2 JSON capability supports a command-line processor, a Java API, and a wire listener to work with JSON documents. Learn about all of these DB2 JSON features and how you can leverage them to deliver data to your next-generation of applications.
IDUG Tech Talk: Top Ten Things Your Need to Know, DBAs, Developers, and ManagersThere are three sections of this presentation, each of which focus on DBAs, Developers, and Managers. There are far more than 10 things you need to know. However, these are the things that should be the most important to know first. The presentation is in reference to DB2 for z/OS but most everything presented can apply to both DB2 for z/OS and DB2 for LUW.