IDUG DB2 Tech Channel

Channel profile:

Joint DB2 Tech Talk series sponsored by IDUG with IBM

This one-stop webcast channel makes it fast and easy to build and extend your technical skills on the IBM DB2 product family. IDUG has joined forces with IBM to bring together a wide array of learning sessions on technical product features, related products, new product developments and more.

Subscribers (7,487)
DB2 Tech Talk: SQL Tips and Techniques, Leverage the Power of SQL SQL is a powerful language that you will learn to use to a greater extent in this talk! Join us to explore some of the less well-known features of SQL and see how they can help in some practical situations. We will also look at some common mistakes and misconceptions and discuss ways of avoiding them. Among the topics:
- tricks with date and time values
- use of common table expression and recursive queries
- use of data change tables
- use of nested tables
- use of the MERGE statement
- and more.

Nick Ivanov is presenting this talk based on his consulting experience with many customers to maximize use of IBM DB2 and other products; move applications to DB2; and tune database and query performance.
Read more >
Apr 10 2014
89 mins
Play

Webinars and videos

  • Live and recorded (45)
  • Upcoming (1)
  • Date
  • Rating
  • Views
  • SQL is a powerful language that you will learn to use to a greater extent in this talk! Join us to explore some of the less well-known features of SQL and see how they can help in some practical situations. We will also look at some common mistakes and misconceptions and discuss ways of avoiding them. Among the topics:
    - tricks with date and time values
    - use of common table expression and recursive queries
    - use of data change tables
    - use of nested tables
    - use of the MERGE statement
    - and more.

    Nick Ivanov is presenting this talk based on his consulting experience with many customers to maximize use of IBM DB2 and other products; move applications to DB2; and tune database and query performance.
  • Although the DBA’s tuning efforts often result in both a decrease of CPU consumption and end user response times, the perception of DBA activities at the C-level sometimes is more of the kind “why didn't they do that before?”.

    This presentation helps you to better understand the C-level perspective and shows you how we managed to improve the image of the DBA team from a reactive team of techies to a proactive team that is directly involved in improving the business results.
  • IBM 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.
  • In 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.
  • IBM 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.
  • Stored 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.
  • SQL 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.
  • Need 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.
  • Rapidly changing application environments require a flexible mechanism to store and communicate data between different application tiers. JSON (Java™ 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.
  • There 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.

Embed in website or blog