Skip to main content

By clicking Submit, you agree to the developerWorks terms of use.

The first time you sign into developerWorks, a profile is created for you. Select information in your profile (name, country/region, and company) is displayed to the public and will accompany any content you post. You may update your IBM account at any time.

All information submitted is secure.

  • Close [x]

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerworks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

By clicking Submit, you agree to the developerWorks terms of use.

All information submitted is secure.

  • Close [x]

Select a language:

  • Close [x]
  • Close [x]

DB2 fundamentals for Oracle professionals: Introduction to DB2

Date:  07 Oct 2011 (Published 23 May 2011) |Level: Introductory |

Sign in to save your progress (Learn more)

Saving your progress (Learn more)

1. Leverage your existing knowledge of Oracle to quickly learn DB2

Use your current knowledge of Oracle 10g to quickly gain skills in DB2.

Read: Leverage your Oracle 11g skills to learn DB2 9.7 for Linux, UNIX, and WindowsItem marked not complete - Click to mark complete

2. Compare common DB2 tasks in DB2 versus Oracle

Study important ease-of-use differences between DB2 and Oracle.

Read: Comparing DBA Productivity: An Oracle/DB2 Task Complexity AnalysisItem marked not complete - Click to mark complete

3. Install DB2

If you do not already have DB2, you can easily download the free community version of DB2 Express-C, or install our 90-day trial version of DB2 for Linux, Unix, and Windows.

Download: IBM DB2 Express-CItem marked not complete - Click to mark complete

Download: IBM DB2 for Linux, UNIX, and WindowsItem marked not complete - Click to mark complete

4. Identify the new Oracle data compatibility features in DB2

Learn about the new features in DB2 9.7.

Read: DB2 9.7: Created global temporary tablesItem marked not complete - Click to mark complete

Read: DB2 9.7: Using PL/SQL anonymous blocks in DB2 9.7Item marked not complete - Click to mark complete

Read: DB2 9.7: Autonomous transactions Item marked not complete - Click to mark complete

Read: DB2 9.7: Online schema changeItem marked not complete - Click to mark complete

5. Study real-world examples using key Oracle enhancements in DB2

Explore the new Oracle compatibility features in DB2 9.7 like triggers and object enhancements.

Read: SQL Compatibility in DB2 9.7Item marked not complete - Click to mark complete

6. Generate reports

Employ CLPPLUS from a command line to generate complex and neatly formatted reports.

Read: Generate formatted reports for IBM data servers using CLPPlusItem marked not complete - Click to mark complete

7. Discover the best practices for DB2 for Linux, UNIX, and Windows

Get practical guidance for the most common DB2 9 product configurations, and use this knowledge to improve the value of your DB2 data servers.

Read: Best practices for DB2 for Linux, UNIX, and WindowsItem marked not complete - Click to mark complete

8. Explore the virtual version of the DB2 Workshop for Oracle Professionals

The IBM DB2 Workshop for Database Professionals is a technical, hands-on workshop designed to help you quickly and easily extend your existing skills to IBM DB2 for Linux, UNIX, and Windows.

Sign inItem marked not complete - Click to mark complete

9. Start your DB2 application development

This free eBook shows you how easy it is to get started on DB2 application development, and includes topics such as using DB2 Express-C, writing SQL statements, working with open source tools and more.

Read: Getting started with DB2 application developmentItem marked not complete - Click to mark complete




Rate this content



Give us feedback

Submission failed. Please try again.

Please complete one of the following questions before submitting.

1. Are you finished with this knowledge path?

       

2. How much did you learn?

           

3. Tell us more

  • What did you like/dislike?
  • What can we do better?

2500 characters left

Disabled Submit button

Close [x]

developerWorks: Sign in


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 

The first time you sign into developerWorks, a profile is created for you. Select information in your developerWorks profile is displayed to the public, but you may edit the information at any time. Your first name, last name (unless you choose to hide them), and display name will accompany the content that you post.

All information submitted is secure.

Close [x]

Choose your display name

The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 

All information submitted is secure.

Close [x]

Save your progress Green checked checkmark

When you sign in, we will save this item to your developerWorks community home page and track your progress so you know what you've completed and where to resume when you return.

For a list of your saved items, see your My Home > My saved items page.

Close [x]

Thank you for your feedback. We appreciate your sharing your opinion with us.

Close [x]

Do you want to save your progress?

, Sign in to save your progress

Close [x]

Save your progress

Sorry. Our server is not available, and we cannot display your saved progress at this time.

Your progress will be displayed when the server is available again. Any previous progress is retained, and additional progress is being tracked.

If your most recent progress is not displayed within 24 hours, you can click the checkmark to indicate completion.

About this knowledge path

The DB2 Fundamentals for Oracle Professionals knowledge path provides an introduction to IBM DB2 for Linux, UNIX, and Windows (LUW). It highlights various Oracle compatibility features, and provides basic information that demonstrates how quickly and easily you can leverage your existing knowledge of Oracle to gain skills in DB2. It is intended for use by Oracle database administrators and database developers looking to extend their existing skills to DB2.

Activities in this path

  1. Leverage your existing knowledge of Oracle to quickly learn DB2
  2. Compare common DB2 tasks in DB2 versus Oracle
  3. Install DB2
  4. Identify the new Oracle data compatibility features in DB2
  5. Study real-world examples using key Oracle enhancements in DB2
  6. Generate reports
  7. Discover the best practices for DB2 for Linux, UNIX, and Windows
  8. Explore the virtual version of the DB2 Workshop for Oracle Professionals
  9. Start your DB2 application development

Related resources

Share this page:

  • Close [x]

Follow developerWorks:

  • Close [x]
static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=756181
publish-date=10072011