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:

Business Intelligence and Analytics

Webinars and videos

  • Live and recorded (1028)
  • Upcoming (34)
  • Date
  • Rating
  • Views
  • In this 60-minute webinar we will kick-off our Consistent Customer Experience webinar series. We will clearly identify the elements that define the customer experience and will explore why delivering a consistent experience is critical for your brand and bottom line. We’ll outline the processes, tools and technology that enable retailers to deliver their vision for their customers.

    Sessions will take attendees through the entire process of optimizing the customer experience, including strategies around: payroll, labor allocation, communication, space optimization and data analytics. Each presentation also will include an inside look at these strategies in action.
  • Salesforce is rapidly being used for many cloud-first initiatives – from accelerating sales and marketing performance, to developing custom apps to solve a variety of business needs. Due to its wide-ranging use across the enterprise, CIOs are becoming very involved in designing the entire implementation and integration strategy for Salesforce within their organizations.

    Join this fireside chat between Derald Sue, CIO of InsideTrack, a recognized IDG Computerworld’s 2014 Premier 100 IT Leaders, and Eric Johnson, CIO of Informatica and learn:

    •How InsideTrack achieved a 100% return on its Informatica Cloud investment in just one month

    •How InsideTrack generates valuable strategic insights from millions of rows of data each day from disparate sources

    •How InsideTrack eliminated costly and time-consuming manual coding and realized a 6X return on integration development productivity

    Presented by:
    Eric Johnson, CIO, Informatica
    Derald Sue, CIO, InsideTrack
    Moderated by:
    Ashwin Viswanath, Informatica Cloud
  • Salesforce is rapidly being used for many cloud-first initiatives – from accelerating sales and marketing performance, to developing custom apps to solve a variety of business needs. Due to its wide-ranging use across the enterprise, CIOs are becoming very involved in designing the entire implementation and integration strategy for Salesforce within their organizations.

    Join this fireside chat between Derald Sue, CIO of InsideTrack, a recognized IDG Computerworld’s 2014 Premier 100 IT Leaders, and Eric Johnson, CIO of Informatica and learn:

    •How InsideTrack achieved a 100% return on its Informatica Cloud investment in just one month

    •How InsideTrack generates valuable strategic insights from millions of rows of data each day from disparate sources

    •How InsideTrack eliminated costly and time-consuming manual coding and realized a 6X return on integration development productivity

    Präsentiert von:
    Eric Johnson, CIO, Informatica
    Derald Sue, CIO, InsideTrack
    Moderiert von:
    Ashwin Viswanath, Informatica Cloud
  • How many logs files do you have?
    • Ever use them?
    • Wonder what they might contain?
    • Are they lying around unexploited, cropped or deleted to save space?
    • Do you ever try to exploit all the log data your systems produce?
    • Do you have home grown tools to manage them, only to find it’s a nightmare to keep these tools up-to-date?

    HP OLi (Operations Log Intelligence) is here to help. Based on industry leading log file management technology from ArcSight, now operations data in log files can be collected, centralized, archived and searched. The intuitive, visually-compelling dashboards provide easy, fast and powerful access to ALL your log files.

    In this webinar we'll discuss the advantages of centralizing log file management like this, and show you a quick demonstration of this new and exciting product from HP Software.
  • Fibre Channel (FC) has come a long way since its introduction to provide a networking solution that would provide the efficiency and speed necessary for storage to be networked and shared across multiple hosts. However, recently some have begun to question whether FC still has relevancy. The answer is a simple and definitive yes! It is all about the right technology for the job. Come and hear Ben Woo, Managing Director, Neuralytix, describe why Fibre Channel is the right tool for your job.
  • Forty-four states, DC and four territories have adopted the Common Core State Standards (CCSS). This means that school districts across the country are planning for 100% online assessments during the 2014-2015 school year. One of the most important conditions needed for being able to administer online assessments is network infrastructure readiness.
    Attend this 30-minute webinar and join Gavin Lee, Senior K-12 Business Development Manager at Juniper Networks, to discuss the critical network must-haves that all school districts should consider when looking to deploy a robust and supportable network. You will also receive practical guidance on how to get the most out of your network infrastructure and how to best prepare for the CCCSS assessments:
    • Consortia network infrastructure
    • Wired and wireless network capabilities
    • Robust network security
    • Network support readiness
    • Juniper Networks network infrastructure readiness resources
  • Tras crear un prototipo inicial de su aplicación para una vista previa limitada ya es hora de que el equipo pase a consolidar la arquitectura haciéndola más robusta y tolerante a los fallos antes de lanzarla oficialmente al público final.

    En este capítulo se tratan conceptos de la infraestructura de AWS tales como regiones y zonas de disponibilidad; además, se explica cómo utilizar tales características para incrementar la tolerancia de la aplicación a los fallos.

    Servicios y características tratados
    •Conceptos clave sobre infraestructura (regiones y zonas de disponibilidad)
    •Equilibro de carga elástico (Elastic Load Balancing)
    •Amazon RDS

    Demostración
    •Creación de una AMI basada en una instancia en ejecución
    •Creación y configuración de un equilibrador de carga elástico
    •Zonas de disponibilidad múltiples con Amazon RDS
    •Alarmas con Amazon CloudWatch
  • Una vez expandida con éxito la capacidad del centro de datos a Amazon Web Services para los entornos de desarrollo y prueba, el equipo de IT se enfrenta a un nuevo reto en cuanto a la capacidad, es decir, cómo almacenar la cada vez mayor cantidad de datos generados por las aplicaciones empresariales y mantener los costes a la baja. Además, también se enfrentan al reto de mantener copias de seguridad de esos datos de manera adecuada.

    Este capítulo aborda ambas cuestiones con servicios como Amazon S3 y Amazon Glacier.

    Demostración:

    •AWS Storage Gateway
    •Datos de Amazon S3 a Amazon Glacier

    Servicios y características tratados:
    •Amazon S3
    •Amazon Glacier
    •AWS Storage Gateway
    •AWS Import / Export
  • Join backup and recovery experts to find out how to build your backup and recovery requirements checklist. By the end of this session, you’ll learn how you can:

    -Cut storage requirements by up to 80%
    -Save on storage costs and performance hits to your network.
    -Leverage near-instant recovery technology for protected virtual machines or servers.
    -Automate application-aware backups and testing for data corruption.
  • Questo è il primo episodio di una serie di webinar che illustreranno le diverse modalità in cui AWS viene utilizzato dai team di sviluppo agili. Tutti gli episodi faranno riferimento a una startup impegnata nell'apertura di una nuova area di business, illustrando i vantaggi offerti dall'utilizzo di AWS. La startup puo' essere una nuova realtà o un centro di innovazione all'interno di una azienda esistente, ad esempio per seguire il lancio di un nuovo prodotto.

    In questo episodio vengono descritti i principali vantaggi di AWS per le startup e i team IT agili, soffermandosi su come il team abbia sviluppato rapidamente un prototipo funzionante utilizzando i diversi servizi offerti dalla piattaforma.
  • Channel
  • Channel profile
Up Down
  • DB2 Tech Talk: Use DB2 with Cognos BI for Fast, Simple Insights May 1 2014 4:30 pm UTC 90 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.
  • 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.
  • DB2 Tech Talk: Build and Deploy Stored Procedures with IBM Data Studio Recorded: Dec 19 2013 71 mins
    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.
  • IDUG Tech Talk: Taking Advantage of DB2's Advanced SQL Features Recorded: Dec 10 2013 50 mins
    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.
  • Use DB2 on the Cloud or BLU Acceleration on the Cloud Recorded: Nov 21 2013 90 mins
    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.
  • DB2 Tech Talk: Build Next-Gen Applications with DB2 JSON Capabilities Recorded: Oct 17 2013 82 mins
    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.
  • IDUG Tech Talk: Top Ten Things Your Need to Know, DBAs, Developers, and Managers Recorded: Oct 14 2013 62 mins
    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.
  • IDUG Tech Talk: "Sandboxing" Workloads using the WLM Dispatcher for Consolidated Recorded: Sep 29 2013 4 mins
    David gives us a walk-through on the setup of WLM to manage the CPU capacity for two separate applications in a single DB2 for LUW database. You'll learn how to dedicate a fixed percentage of CPU, ensure predictable performance and resource utilization, and
  • DB2 Tech Talk: BLU Acceleration Competitive Advantages for In-memory Computing Recorded: Sep 19 2013 92 mins
    Everyone 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.
  • IDUG Tech Talk: DB2 LUW Advanced Utilities Problem Determination Tips and Tricks Recorded: Sep 10 2013 56 mins
    In this presentation Melanie delivers solid information about advanced performance analysis and tuning of DB2 utilities. She also provides a significant number of tips and tricks to get your utilities humming. Utility problem determination is also covered. Melanie is one of the premier authorities on DB2 for LUW tuning, and so this is a "must view" presentation.
  • DB2 Tech Talk: SQL Refresher on DB2 10.5, SQL Standard Update and More Recorded: Aug 29 2013 89 mins
    SQL is an essential aspect of most data applications in production today. DBAs and Database developers must be in tune with the current state of the technology to help make the most of your organization's data applications.

    In this Tech Talk, Rick Swagerman will be hosting and presenting. Rick is the DB2 for LINUX, UNIX and Windows Language Architect, and will discuss the latest aspects of SQL in DB2, the SQL standard and more:

    - Learn about new SQL advances in DB2 10.5, such as expression-based indexes, extended row size, pipelined table functions, weak types and type constraints

    - Understand what's new with the overall SQL standard

    - Find out about the IBM SQL Language Council and how it defines new SQL and helps you know about SQL compatibility

    - Pick up some tips and techniques in applying the SQL in DB2 to your applications

    Join us for this tech Talk to advance your understanding of SQL as it relates to DB2 10.5.
  • IDUG Tech Talk: DB2 10 for z/OS Optimization Enhancements Recorded: Aug 21 2013 58 mins
    Terry Purcell of IBM SVL Optimization Team gives his IDUG presentation introducing you to the enhancements his team made to the optimizer for DB2 10 for z/OS. Details are giving and examples of where each new optimization technique can and will be applied.
  • DB2 Tech Talk: Adopt BLU Acceleration in DB2 10.5 the Faster Easier Way Recorded: Jul 25 2013 62 mins
    DB2 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 Bit: JSON Technology Brief Recorded: Jul 19 2013 38 mins
    Get a brief JSON technology overview in this Tech Bit. Presenter Bill Bireley is a Java / JSON technology expert from IBM labs and he overviews this new technology. Bill also describes the JSON technology preview available on IBM developerWorks so you can try it.
  • IDUG DB2 Tech Talk - Tuning Queries with IBM Data Studio Recorded: Jul 18 2013 60 mins
    IBM has taken query tuning to a new level with IBM Data Studio. More detail is available than ever before. However, the tool does take some getting used to, especially for folks that are used to a green screen based query tuning experience. This presentation introduces you to IBM Data Studio and gets you started tuning queries.
  • IDUG Tech Talk: Ten Principals of Highly Effective DBAs Recorded: Jul 10 2013 56 mins
    Today database administration is all about doing more with less. We are constantly asked to expand the role and scope of DBA responsibilities without additional resources. Learn the foundation principles that are the underpinning of highly effective DBAs and how you can use them to transform your job. You are invited on a database journey to explore some practical ways these principles have been put into practice in the largest hospital in the United States.
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