Getting started with DB2 for Linux, UNIX, and Windows

Compiled for those less experienced with IBM® DB2®, this page is designed to help you get started. In just about two hours, these training materials will prepare you to take a series of self-study tutorials and to download and try IBM DB2 for Linux®, UNIX®, and Windows®.

Step 1. Read overview

Read these articles for an overview of DB2:

  • Which distributed edition of DB2 9.5 is right for you?
    Learn the details on what makes each edition of DB2 9.5 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, outlines licensing considerations, historical changes from DB2 9, and describes some interesting things customers are doing with each edition of DB2. This popular article has been rewritten for the DB2 9.5 release and is current as of the date of publication.
  • Compare the distributed DB2 9.5 data servers
    In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 9.5 data server family.

Step 2. Read details

Read these book excerpts for more in depth knowledge of functionality:

Step 3. Download code

Step 4. Take tutorials

Now that you're familiar with DB2, you are ready to put that knowledge to use. The tutorial series below provides an introduction to SQL and covers how DB2 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation.

Step 5. Take advantage of other educational resources

Feature articles:

  • DB2 basics article series
    These articles are geared toward beginning users. The DB2 basics series introduces fundamental topics and provides a walk through of situations often encountered by the first time user.
  • DB2's Command Line Processor and scripting
    This article shows you how to use the Command Line Processor (CLP) to your advantage. But, if your command of SQL is strong -- or you want to enter one quick command to verify the installation of DB2 -- the command line is ideal, and usually faster than submitting similar requests through a front-end. The CLP is a direct route to every DB2 programming interface.
  • Quick reference: Common DB2 Command Line Processor (CLP) Commands
    A crisis hits, you need to issue commands, and the syntax escapes your mind. This handy deskside reference, although not complete, can help you remember most of the commonly used commands, especially if you are new to DB2.
  • Recommended reading list: DB2 for Linux, UNIX, and Windows database administration
    Learn about DB2 with this reading list, compiled especially for the database administrator community. This popular article is updated to include the latest content that has been published for DB2 9.

Online skills and technical information:

  • Training and certification
    The home base for developing skills. Find out all you need to know about getting skilled and certified.
  • developerWorks DB2
    Access our vast library of information on database, analysis, and enterprise content management, featuring white papers, tips, Q&A, Webcasts, and sample code.

Publications:

User groups: