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

Manage webcast
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:

IT Service Management

  • Live and recorded (2600)
  • Upcoming (52)
  • Date
  • Rating
  • Views
  • NTT Com Security would like to invite you to join us and our partner LogRhythm on July 28th, 2015 from 2:00-3:00 p.m. EST for a webinar addressing the current and ongoing cyber-threat to Financial and Insurance institutions.
  • This live demo will show you how you can seamlessly blend business communications into your cloud work environment, transforming Microsoft Office 365 into an enterprise-grade communications hub with an easy-to-use interface that is very simple for end-users to deploy and IT to manage.

    Make it easy for employees to initiate PSTN calls and SMS, view screen pops with relevant information, automatically log the calls, and more -- without ever leaving Office 365. You’ll also see how easy it is to add new users and make changes as your business evolves with RingCentral’s cloud based communications system.

    Our expert presenter will walk you through how it works and answer your questions. You’ll see:

    •How to place calls with one click from within Office 365
    •Views of customer profile and communications history
    •Automated ticket creation from calls
  • This live demo will show you how you can seamlessly blend business communications into your cloud work environment, creating an enterprise-grade communications hub with an easy-to-use interface that is very simple for end-users to deploy and IT to manage.

    Make it easy for employees to initiate PSTN calls and SMS, view screen pops with relevant information, automatically log the calls, and more -- without ever leaving their favorite apps. You’ll also see how easy it is to add new users and make changes as your business evolves with RingCentral’s cloud based communications system.

    Our expert presenter will walk you through how it works and answer your questions. You’ll see:

    •How to place calls with one click from within your business apps
    •Views of customer profile and communications history
    •Automated ticket creation from calls
    •And more!
  • Number porting is a meticulous process. You want to do the right thing at the right time, or you could throw off your transition schedule. We’ll take you through the timeline and point out the pitfalls so that you can transition to your new cloud phone system without a hitch.
  • Für die intelligente IT von morgen – Highlights und Features von FNT Command 10

    Die tiefgreifenden Entwicklungen der Trends wie „Big Data“, „Cloud“ und „Internet of Things“ ebnen bereits heute den Weg für die IT der Zukunft. Aufgrund der steigenden Komplexität der zu verwaltenden Infrastrukturen besteht für Verantwortliche in IT, Telekommunikation und Rechenzentren die größte Herausforderung darin, die benötigten Informationen zum richtigen Zeitpunkt abrufen zu können.

    Aus diesem Grund wurden die neuen Funktionalitäten von FNT Command 10 mit dem Fokus entwickelt, jeden Anwender in seinem individuellen Aufgabenbereich optimal zu unterstützen. Claudia Lehmann, Product Marketing Manager, stellt Ihnen die neuen Highlights vor, mit denen Sie einen völlig neuen Einblick in Ihre Daten erhalten können.
  • Over 90% of targeted attacks start with email. Criminals create very convincing emails to trick your users into clicking on a link, opening an attachment, or replying with their credentials. The attack methods criminals employ with phishing emails are constantly changing and so must your email security to block these attacks before damage occurs. Learn about the newest trends in phishing email attacks and how to protect your organization.
  • Employee self-service is often viewed by IT as a 'knight in shining armor' since it can provide quicker employee access to both help and new services, while taking some of the pressure off overworked corporate IT service desks. However, for many organizations, their initial attempts to introduce self-service have been more white elephant than white knight – with low employee adoption and utilization rates – often due to an overemphasis on the technology.

    Thankfully now, after many hard lessons have been learned, some organizations are finally getting self-service right. In this webinar, we’ll share how they’ve succeeded, by:

    * Exploring the variety of challenges and potential pitfalls with self-service – including technology, management, and end-user perspectives
    * Offering practical advice and good practice on how to design, launch, manage, and encourage the use of an employee self-service facility for IT (or any other corporate service provider)
    * Providing sensible actions that will help you to either get started with, or to improve upon, self-service within your organization
  • The economic significance of application management is often underrated. Did you know that about 40% of IT budgets is spent on keeping applications up and running, up to date and under control? But are you getting enough value out of your investments?

    This webinar explores application support, maintenance/renewal and strategy.
    Takeaways:
    - overview of the whole Application Management domain and its relationships with the business and other IT disciplines and external service providers
    - better understanding of the costs and benefits of Application Management and how to influence them
    - frameworks, standards and trends and how to benefits from them
  • Do any of these comments sound familiar?

    - “Only the new people find value in our knowledge base.”
    - “Once our teams learn how to resolve something, they don’t need to use the knowledge base.”
    - “It takes longer to find it in the knowledge base than it does to figure it out.”
    - “Our knowledge base is out dated and cumbersome to use.”
    - "I’ll ask (insert name here), he / she will know the answer.”
    If so, you may be stuck in the knowledge-engineering rut. The Knowledge-centered-support methodology is a proven best practice that overcomes these challenges. Attend this session to learn about the KCS methodology and how you can use it to:

    -reduce the time to resolution
    -standardize answers to your customers
    -lower support costs
    -increase customer satisfaction
    -increase employee job satisfaction

    KCS becomes the way you resolve incidents, answer questions, share your knowledge with peer staff, and in short get people back to work. Because it is part of the Incident process, it is always current and accurate and enables your teams to continually support an expanding breadth of services.

    Additionally, you will hear about the journey of the University of Phoenix, and parent company Apollo Education Group, in moving out of old-school knowledge engineering, “ivory tower” knowledge approaches, and into the realm of real-time knowledge management – using KCS to empower front-line staff content administration, and manage knowledge by positive peer-to-peer relationships. We will discuss the use of the Knowledge-Centered Support (KCS) methodology in a highly-regulated business environment, to capture, structure, and reuse knowledge as new incidents occur and the business environment changes. Our chat will discuss the methods utilized, uncover the “ditches” to avoid, and present the metrics used to measure and prove success.
  • Channel
  • Channel profile
  • An Overview of the New DB2 Native Encryption Capability Recorded: Feb 26 2015 91 mins
    Greg Stager
    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
    John J. Park
    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
    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
    Sam Lightstone and Christian Garcia-Arellano
    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
    Chris Eaton
    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
    Soloman Barghouthi (presenter), Rick Swagerman (host)
    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
    Randy Ebersole
    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
    Guersad Kuecuek (presenter) and Rick Swagerman (host)
    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
    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
    Jef Treece and Shawn Moe, IBM Labs; with Rick Swagerman (host)
    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
    Lori Ann Galluzzo
    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
    Les King, Kelly Schlamb, Vladimir Stojanovski (presenters) and Rick Swagerman (host)
    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
    Bob Vargo
    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
    Vladimir Stojanovski, Predictive & Business Intelligence Segment Leader
    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
    Nick Ivanov (presenter), Rick Swagerman (host)
    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
    Thomas Baumann
    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
    Sriram Padmanabhan (presenter) and Rick Swagerman (host)
    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
    Julian Stuhler
    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
    John Vonau (presenter, IBM Labs)
    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.
  • DB2 Tech Talk: Build and Deploy Stored Procedures with IBM Data Studio Recorded: Dec 19 2013 71 mins
    Anson Kokkat (presenter), Tony Leung (presenter), Rick Swagerman (host)
    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.
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