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]

developerWorks Community:

  • Close [x]

DB2 fundamentals for Oracle professionals: Introduction to DB2

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

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

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

2. Compare common DB2 tasks in DB2 versus Oracle

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

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.

4. Identify the new Oracle data compatibility features in DB2

Learn about the new features in DB2 9.7.

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.

6. Generate reports

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

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.

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.

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.




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

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.

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.

 


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

Do you want to save your progress?

, Sign in to save your progress

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.

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