DB2 basics

In this DB2 basics guide, get DB2 news and expert advice about certifications and tools and listen to podcasts about DB2 basics and product information.

SearchDataManagement.com regularly covers IBM DB2 basics, news and job trends. Make this DB2 Basics guide your resource for learning about and staying current on every aspect of DB2. Answer sample DB2 9 certification exam questions, get fundamental DB2 terms and definitions, listen to podcasts with industry experts about DB2 basics and certifications, get the latest DB2 news and expert advice and access DB2 product manuals.

IBM terms and acronyms

  • AIX
    AIX is an open operating system from IBM that is based on a version of Unix.
    Read full definition
  • AS/400
    The AS/400 was formally renamed the "IBM iSeries," but is still commonly known as AS/400.
    Read full definition
    COBOL (Common Business Oriented Language) was the first widely-used high-level programming language for business applications.
    Read full definition
  • DB2
    DB2 is a family of relational database management system products from IBM that serve a number of different operating system platforms.
    Read full definition
  • iSeries
    iSeries is IBM's midrange server line, designed for small businesses and departments in large enterprises.
    Read full definition
  • mainframe
    A mainframe is a high-performance computer used for large-scale computing purposes that require greater availability and security than a smaller-scale machine can offer.
    Read full definition
  • OS/390
    OS/390 is the IBM operating system most commonly installed on its S/390 line of mainframe server.
    Read full definition
  • SQL
    SQL (Structured Query Language) is a standard interactive and programming language for getting information from and updating a database.
    Read full definition
  • z/OS
    z/OS is the computer operating system for IBM's zSeries 900 (z900) line of large (mainframe) servers.
    Read full definition

DB2 basics

Understanding IBM DB2: Product history and strategy

Data management professionals new to DB2 may find it helpful to start from square one -- by learning about IBM DB2 product history and strategy. DB2 has been around for a while -- since 1983! -- so get up-to-date by reading or downloading a free sample chapter from Understanding DB2: Learning visually with examples, 2nd edition. Learn about IBM DB2 history and development, read about DB2 server editions and clients, get a list of DB2 information management products and more.

More on IBM DB2

See how DB2 BLU Acceleration boosts IMBs flagship RDBMS

Find out how IBM’s new database is aimed at Oracle users

Read about how IBM is helping the city of Boston with open data

IBM DB2 basics podcast

Both novice and seasoned IT professionals and DBAs can benefit from a podcast about IBM DB2 basics. Learn what makes DB2 unique, hear common DB2 challenges and misconceptions, get information about DB2 career options and more. Become familiar with today's DB2 in this interview with Dan Luksetich and Susan Lawson of YL&A, DB2 consultants and producers of DB2expert.com.

DB2 tools and products for Linux, UNIX and Windows: The basics

Already know your DB2 history? Already a master of DB2 basics? To get to the next level, read or download a free sample chapter from DB2 9 for Linux, UNIX, and Windows: DBA Guide, Reference, and Exam Prep, 6th Edition. In this chapter, you will get an overview and learn the basics of DB2 tools and products that run on Linux, UNIX and Windows operating systems.

DB2 product information and manuals

Find the information you need about DB2 V9, V8 and V7 by choosing the appropriate detailed IBM product manual below.

DB2 9 certification exam quiz questions

Do you know IBM DB2 9 well enough to pass the certification exam? Studying real questions from previous certification exams is an educational advantage, according to Roger E. Sanders, author of DB2 9 Fundamentals Certification Study Guide. These sample questions and answers from Sanders's book can help you prepare for the certification exam or simply test your current knowledge of DB2 9 basics.

Listen to a podcast with Roger Sanders, author of DB2 9 Fundamentals Certification Study Guide, to learn about the IBM DB2 9 certification process, how IBM DB2 9 certifications compare to job experience and what an IBM DB2 9 certification really means to an employer.

  • IBM DB2 9: Is certification worth it?

If you don't have time to listen to a podcast about DB2 9 certifications, you can read about them! Read or download a free .pdf of A guide to the IBM DB2 9 Fundamentals certification exam, by Roger Sanders, to get advice and information on IBM DB2 9 Fundamentals certification and learn how to prepare for the test.

  • A guide to the IBM DB2 9 Fundamentals certification exam

DB2 case studies

Learning from other organizations' successes and failures is a great way to ensure your own success and avoid major problems. Check out the following DB2 case studies to learn what worked -- and what didn't.

  • DB2 9 Viper helps hospital cure performance pain by storing XML, relational data in one DBMS
    IBM's DB2 9 Viper can manage XML and relational data in one database. An analyst says IBM's architecture is unique -- and that other vendors might not appreciate the challenge. Read more in this exclusive DB2 case study.
  • Business intelligence and DB2 case study: Suzuki revs up retail reporting
    In this case study, see how Suzuki Powersports improved the speed and quality of its retail reporting, helped by a metadata layer and Web-based reporting.
  • Customer data mining built up by Northern Tool
    Northern Tool enhanced its customer data mining by bringing an outsourced (DB2) database in-house, integrating new data sources and implementing marketing automation tools.

DB2 trends

It's important to be informed about DB2 market trends to stay competitive. This section of the DB2 Basics guide will highlight current DB2 trends -- so check back frequently for updates.

  • DB2 looks to enterprise information management to fend off Microsoft
    IBM's DB2 has come a long way since first hitting the scene in 1983. IDC analyst Carl Olofson sizes up DB2 in all its forms and reveals what to expect next from Big Blue, in this exclusive DB2 Q&A.
  • IBM exec discusses data management trends, products and plans
    IBM outlines emerging data management trends and which products announced at its 2007 Information on Demand event garnered the most market interest -- in this podcast.

DB2 expert advice

SearchDataManagement.com's Ask the Expert panel is a great way to get your DB2 questions answered by an industry expert -- for free. Submit your own DB2 question to our expert, or check out the DB2 questions below, submitted by your peers.

  • VSAM to DB2: Before you convert
    There are reasons to convert from VSAM to DB2 -- and there are reasons not to. Find out what the DB2 expert has to say about a VSAM to DB2 migration project.
  • Data export command: Migration from a DB2 table to a flat file
    To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a database to an operating system file, which, our expert explains, can be in one of several external file formats.
  • Resources on creating and supporting BLOBs in DB2
    A DB2 expert recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2.
  • VSAM to DB2 migration project design
    The DB2 expert offers his opinion about a SearchDataManagement.com member's design for a migration of data from VSAM to DB2, which creates 4-5 MQTs that will hold data pertaining to 40+ DB2 tables.
  • Do you have IBM DB2 questions -- either basic or advanced? Let us try to help you by submitting your question to our DB2 expert.

Dig Deeper on Data management tutorials