DB2 Tech Talk: Oracle Database and PL/SQL Compatibility Features of DB2 10

Serge Rielau
IBM introduced very successful PL/SQL Compatibility features in the previous version of DB2 for LUW. Now, with the introduction of DB2 10, there are new enhancements that make it easier than ever before to make the move to DB2. This webcast will discuss:

•Native PL/SQL support, as well as other compatibility features including: concurrency control, PL/SQL package support, Oracle SQL dialect support, OCI, SQL * Plus Scripts, Oracle Forms

•New compatibility features in DB2 10 including enhanced support for triggers, new scalar functions, declared types and procedures within a local scope

•Tooling that IBM has made available to streamline this move process

•Case studies drawn from elements of the process with actual customers and shown at the code level. We will also share some of the excellent compatibility results that our customers have found during the early access program.

Serge Rielau, SQL Architect for DB2 for LUW , is from the IBM labs and is both your host and presenter. Note that the start time is 12:30 PM ET and that you may be seeing this time translated into your local time zone.
May 31 2012
81 mins
DB2 Tech Talk: Oracle Database and PL/SQL Compatibility Features of DB2 10
Join us for this summit:
More from this community:

Data Center Management

  • Live and recorded (2932)
  • Upcoming (96)
  • Date
  • Rating
  • Views
  • With 40% of time at work spent on administrative chores, inefficient communication is a big problem in business. Find out how to use tech to reduce wasted time in meetings, spend less time in your inbox and improve the way your company collaborates.

    About the presenter: Ray Gillenwater is the Co-founder and CEO of SpeakUp (getspeakup.com) an Enterprise Collaboration platform that enables collaborative problem solving and ideation. A student of Communications and a former executive at BlackBerry, Ray will share his experience and recommendations to help improve communication at your company.
  • A lot has changed in the way we communicate for business. A decade ago, most organizations had employees who came to the office every day, used desktop computers and desk phones, and stopped communicating for work when they went home.

    Today, people communicate for work anywhere, anytime, and on any device. Per Forrester, sixty-six percent of employees use two or more mobile devices for work. And according to Frost & Sullivan, nearly 25 percent of employees work from home or the road. What’s more, the desk phone is not the only business device. Based on a RingCentral survey, 35 percent of employees are using their mobile phones for work even when they are in the office. And nearly 80 percent of employees text for business, with 32 percent reporting that they’ve even closed a business deal via text.

    Even with these undeniable business behavior changes, the vast majority of companies haven’t optimized their communications infrastructure for mobile workforces or BYOD.

    Join this webinar to get ahead of the pack and learn the benefits of a cloud communications solution that supports the new world of work.

    •Understand the trends driving mobility and behavior changes in the work place, with Melanie Turek, VP of Research for Enterprise Communication & Collaboration, Frost & Sullivan.
    •Get the real story from a business that has addressed their mobility needs first hand from Adam Fishman, director of growth and operations for Lyft, a community ride-sharing service.
    •Hear how a cloud communications solution is addressing several challenges businesses face in the new work world from Nisha Ahluwalia, VP of product marketing at RingCentral.
  • A lot has changed in the way we communicate for business. A decade ago, most organizations had employees who came to the office every day, used desktop computers and desk phones, and stopped communicating for work when they went home.

    Today, people communicate for work anywhere, anytime, and on any device. Per Forrester, sixty-six percent of employees use two or more mobile devices for work. And according to Frost & Sullivan, nearly 25 percent of employees work from home or the road. What’s more, the desk phone is not the only business device. Based on a RingCentral survey, 35 percent of employees are using their mobile phones for work even when they are in the office. And nearly 80 percent of employees text for business, with 32 percent reporting that they’ve even closed a business deal via text.

    Even with these undeniable business behavior changes, the vast majority of companies haven’t optimized their communications infrastructure for mobile workforces or BYOD.

    Join this webinar to get ahead of the pack and learn the benefits of a cloud communications solution that supports the new world of work.

    •Understand the trends driving mobility and behavior changes in the work place, with Melanie Turek, VP of Research for Enterprise Communication & Collaboration, Frost & Sullivan.
    •Get the real story from a business that has addressed their mobility needs first hand from Adam Fishman, director of growth and operations for Lyft, a community ride-sharing service.
    •Hear how a cloud communications solution is addressing several challenges businesses face in the new work world from Nisha Ahluwalia, VP of product marketing at RingCentral.
  • Remote Direct Memory Access (RDMA) has existed for many years as an interconnect technology, providing low latency and high bandwidth in computing clusters. More recently, RDMA has gained traction as a method for accelerating storage connectivity and interconnectivity on Ethernet. In this Webcast, experts will cover:

    •Storage protocols that take advantage of RDMA
    •Overview of iSER for block storage
    •Deep dive of SMB Direct for file storage
    •Benefits of available RDMA technologies to accelerate your Ethernet storage connectivity, both iWARP and RoCE
  • With 75% of enterprise users reporting that they use their cell phones for making work calls, the inevitable question we must ask is, "can we just run our business on cell phones and ditch the PBX?" In this webinar, we will review the massive changes in the wireless landscape that have made this viable in the past 3 months, the solutions that make it possible and what implications this has for the modern BYOD organization.
  • You may not know much about it, but Hadoop is coming in a big way. The list of services you provide and support grows larger by the day and very soon Hadoop related technologies will likely play a critical role in many of those services. Much of the processing that happens in Hadoop is batch related but the built in tools for managing that batch is inferior and will cause delays when trying to deploy the related applications and services. Join us to learn:

    •What Hadoop is and what it is used for
    •The type of processing performed in Hadoop environments
    •How to deliver better Hadoop workload related services
  • You may not know much about it, but Hadoop is coming in a big way. The list of services you provide and support grows larger by the day and very soon Hadoop related technologies will likely play a critical role in many of those services. Much of the processing that happens in Hadoop is batch related but the built in tools for managing that batch is inferior and will cause delays when trying to deploy the related applications and services. Join us to learn:

    •What Hadoop is and what it is used for
    •The type of processing performed in Hadoop environments
    •How to deliver better Hadoop workload related services
  • You may not know much about it, but Hadoop is coming in a big way. The list of services you provide and support grows larger by the day and very soon Hadoop related technologies will likely play a critical role in many of those services. Much of the processing that happens in Hadoop is batch related but the built in tools for managing that batch is inferior and will cause delays when trying to deploy the related applications and services. Join us to learn:

    •What Hadoop is and what it is used for
    •The type of processing performed in Hadoop environments
    •How to deliver better Hadoop workload related services
  • Lee Smith (Dee Smith & Associates) and David Cuthbertson (SMS) will cover their approach and methods of assessing existing data centre facilities and management processes. Rapid changes in both IT and data centre technologies often mean that facilities and management techniques fail to evolve fast enough, with the data centre potentially being the weak link in the delivery chain of all IT services. Achieving a baseline through an assessment is critical for any improvement or transformation activity - but is not so easy to do in practice.
  • Companies are increasingly driving revenue and customer satisfaction through digital business initiatives, and IT leadership is more essential to the success of the business than it ever was. You’ll learn how HP’s unique technology - Connected Intelligence - blends big data with automation, enables exceptional user experience, agility with compliance and cost efficiencies across the board.
  • Channel
  • Channel profile
  • Introducing the New IBM Data Server Manager Mar 26 2015 4:30 pm UTC 90 mins
    -Introduction to IBM Data Server Manager
    -How Do I Get IBM Data Server Manager
    -Performance Management Features - real time and historical monitoring
    -Database Administration Features
    -Some of the cool features and tips for using IBM Data Server Manager
  • An Overview of the New DB2 Native Encryption Capability Recorded: Feb 26 2015 91 mins
    In this session, we will review foundational cryptographic concepts and discuss the key highlights of the new DB2 native encryption capability, including encrypting online data, encryption backup images and key management.
  • A deeper dive into dashDB - know more in a dash Recorded: Jan 29 2015 90 mins
    dashDB is a newly announced data warehouse as a service deployed in the cloud that leverages technologies like BLU Acceleration, in-database analytics and Cloudant to allow you to focus more on the business and less on the business of IT. In this DB2 Tech Talk you will learn a little more about IBM’s cloud initiatives and the value proposition around dashDB as well as...
    -dashDB’s architecture and use cases
    -pricing and offerings as as service
    -competitive differentiations and customer feedback
  • IDUG Tech Talk: DB2 Cancun : A Technical Overview Recorded: Nov 24 2014 59 mins
    Matt Huras from IBM development gives an intense technical overview of IBM's latest DB2 for LUW release know as DB2 10.5.4 and Cancun.
  • What’s New in DB2 10.5 “Cancun Release” Recorded: Nov 20 2014 89 mins
    DB2's most recent release added significant new capabilities for both transaction and analytic processing. This presentation will take you through the new features and what you need to know. Attend this DB2 Tech Talk to learn about:
    • BLU Shadow Tables
    • Expanded Oracle SQL compatibility for data marts
    • Enhanced SAP Business Warehouse support
    • Standard TCP/IP sockets for pureScale
    • Additional capabilities
  • DB2 Tech Talk: DB2 Competitive Update Recorded: Oct 16 2014 88 mins
    In-memory, columnar, faster analytics, high availability and scalability. There is a lot happening in the data management space these days. In this presentation, we will go through some of the key capabilities in the newest release of DB2, including BLU Shadow Tables, standard TCP/IP sockets for pureScale, and other enhancements. We'll also talk through some of the latest competitive announcements and how DB2 stacks up to these offerings.
  • Learn how DB2 integrates with IBM WebSphere Recorded: Aug 28 2014 89 mins
    In a 3 tier architecture, an application server is considered tier 2 and a database is considered tier 3. IBM offers a well known Composable, secure and high scalable application server called WebSphere Application Server. IBM also offers multiple databases one of which is is DB2. This session will explain some of the key integration features between the two products and why this combination helps you create a secure, scalable and highly reliable solution for your middleware and backend database. Topics covered in this session are:
    -- Security: Trusted connection support
    -- Scalability: Heterogenous pooling support and Lock sharing
    -- Resiliency: Automatic client reroute and failover enhancements
    -- and more
  • IDUG Tech Talk: Exploiting DB2 11 for z/OS Where do we Start? Recorded: Aug 26 2014 56 mins
    In this session from the IDUG 2014 Technical Conference in North America, Randy Ebersole highlights some of the new features of DB2 11. He introduces some of the new functionality to get you thinking about moving to DB2 11!
  • DB2 Tech Talk: Use DB2 with BLU Acceleration for SAP Recorded: Jul 17 2014 78 mins
    Analytics are the hot business need because the competitive advantage goes to the organization who is first to discover and capitalize on the business insight. Data is at the root of this, but it is the analytics that provide data value. For many years DB2 has been used with OLAP and OLTP systems by SAP customers worldwide to deliver a cost-effective database engine to SAP applications.

    Now with DB2 10.5 with BLU Acceleration, you can use this next generation in-memory technology to deliver these insights from data fast and simply. DB2 with BLU Acceleration is an in-memory technology, which makes analytical jobs by factors faster right out of the box, while requiring dramatically less storage and nearly eliminating the need for tuning.

    Although BLU Acceleration is in-memory optimized, it is not main memory-limited. DB2 BLU is highly optimized for accessing data in RAM, but performance won’t suffer as data size grows beyond RAM. These benefits are achieved through next generation columnar processing, operating on compressed data, carefully exploiting modern microprocessor designs, and accessing memory efficiently. The result is a system that simultaneously looks and feels like DB2 while being in-memory optimized, CPU-optimized and I/O-optimized.

    SAP-DB2 customers have seen tremendous performance improvements with the same hardware. Because of this, customers can reuse their existing IT infrastructure and simply update to the newer DB2 10.5 version-- converting row-store tables to column-store tables.

    Join DB2 - SAP expert Guersad Kuecuek for a discussion of the technical features of this solution including how to use BLU, how to derive performance improvement and how to do the sizing for BLU.
  • IDUG Tech Talk: DB2 for z/OS Disaster Recovery for the Rest of US Recorded: Jul 8 2014 54 mins
    Judy Ruby-Brown gives a thorough overview of system level backup and using FlashCopy for disaster recovery as provided by various vendors. This presentation is quite thorough but yet very easy to understand, even for a beginner. Judy explains the types of services that need to be setup for disaster recovery as well as easy scenarios for the DBA in the implementation of disaster recovery. Just the summary at the end is enough to pass on to the system programmers in your shop as a checklist for implementation.
  • DB2 Tech Talk: Develop Mobile & Internet-Connected Apps with DB2 & Informix Recorded: Jun 4 2014 89 mins
    The "Internet of Things" is the growing number of devices and sensors that communicate via the Internet, offering vast new opportunities. Harnessing data from billions of connected devices lies in the ability to store, access and query SQL and NoSQL data together, seamlessly. The result of all this data is the need for fast development of web and mobile applications and speed-of-thought insight for fast business decisions.

    Learn how to use Informix and DB2 to bridge the gap between new computing technologies designed for big data, cloud, and mobile computing with the enterprise world of relational data in the "Internet of Things" era. Jef Treece and Shawn Moe will present how to develop mobile applications using techniques that preserve the native look and feel specific to such devices as Android and iOS. They will also show device-agnostic techniques and discuss new approaches to handling a range of types of mobile devices. A discussion of how to keep data on the device in sync with a back-end database or cloud service, such as DB2 or Informix on BlueMix will also be included. And finally, using an embedded database to achieve a truly scalable and reliable Internet of Things architecture will be included.
  • IDUG Tech Talk: Hit the Ground Running with DB2 10 for z/OS Features Recorded: May 21 2014 51 mins
    In this comprehensive overview of DB2 10 for z/OS Lori Ann Galluzzo goes through the features of DB2 10 in great detail. Each feature is discussed, along with how and when to take advantage of the feature, as well as some pitfalls and things to watch out for.
  • DB2 Tech Talk: Use DB2 with Cognos BI for Fast, Simple Insights Recorded: May 1 2014 91 mins
    Today in order to remain competitive, there is a tremendous demand on lines of business to be able to analyze more aspects of business data and do this very quickly. There is a control shift to the business analyst so they can analyze what they need to, NOW!

    Big Data requirements are also emerging, even as everyone is being asked to accomplish more with less. Join us to learn how the combination of DB2 10.5 with BLU Acceleration and Cognos BI 10.2 can help bring sanity to satisfying these ever increasing demands.

    We will provide an overview and technical deep dive of DB2 10.5 with BLU Acceleration, Cognos BI 10.2 and Dynamic Cubes. Join experts from the DB2 and the Cognos BI teams who will also explain how these two offerings fit together and the benefits they have provided to clients already. See the value that DB2 with BLU Acceleration can bring to Cognos BI, and ask these experts your questions, so you can understand how this solution helps solve business challenges.
  • IDUG Tech Talk: IDUG 2014 North America Conference Orientation Webinar Recorded: Apr 30 2014 41 mins
    Conference Chairman Bob Vargo gives attendees a detailed overview of the conference, seminars, keynotes, and the technical sessions that will be featured at this year's North American conference. Viewers are introduced to the schedule, speakers, and are given tips and insights into the conference.
  • DB2 Tech Bit: BLU Acceleration with Cognos Recorded: Apr 29 2014 5 mins
    Watch a demonstration of IBM Cognos Business Intelligence running on a DB2 BLU Acceleration in-memory database.

    The demo compares, side-by-side, the performance of a dashboard sitting on top of a traditional row-based data warehouse with indexes, versus a dashboard sitting on top of the same database, with BLU Acceleration.

    BLU Acceleration is an innovation from IBM Research and Development labs that delivers a new generation of In-memory database technology, for "speed of thought" analytics. Coupled with Cognos Dynamic Cubes, it results in sub-second query result times. See it for yourself!
  • DB2 Tech Talk: SQL Tips and Techniques, Leverage the Power of SQL Recorded: Apr 10 2014 89 mins
    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.
  • IDUG Tech Talk: Explaining Tuning Results to the C-level Recorded: Mar 9 2014 76 mins
    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.
  • Use InfoSphere Information Server with DB2 for Data Integration and Governance Recorded: Feb 27 2014 86 mins
    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.
  • IDUG Tech Talk: DB2 11 for z/OS IDUG User Experiences Recorded: Jan 30 2014 54 mins
    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.
  • DB2 Tech Talk: InfoSphere Workload Replay for DB Environment Changes Recorded: Jan 23 2014 83 mins
    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.
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.

Embed in website or blog

Successfully added emails: 0
Remove all
  • Title: DB2 Tech Talk: Oracle Database and PL/SQL Compatibility Features of DB2 10
  • Live at: May 31 2012 4:30 pm
  • Presented by: Serge Rielau
  • From:
Your email has been sent.
or close
You must be logged in to email this