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.

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.

All information submitted is secure.

My developerWorks:

My notifications:

Sign out

Select a language:

DB2 10.1 fundamentals certification exam 610 prep, Part 1: Planning

Norberto Gasparotto Filho (norbertogf@gmail.com), Database specialist, IBM

Norberto Gasparotto Filho is a database specialist with more than eight years of experience with database administration. He was the winner of the first edition of "DB2's Got Talent" contest in 2011. He also worked as programmer using a variety of technologies, and has certifications in both programming and database administration areas. In his blog ("Insights on DB2 LUW database admin, programming and more"), Norberto shares lessons learned in the day-to-day database administration work, tips and knowledge. During his spare time, Norberto likes to run, ride a bike and have fun with his kids and wife. Learn more in Norberto's profile in the developerWorks community.

Summary: This tutorial introduces you to the basics of the IBM® DB2® 10.1 product editions, functionalities and tools, along with underlying concepts that describe different types of data applications such as OLTP, data warehousing / OLAP, non-relational concepts and more. It will briefly introduce you to many of the concepts you'll see in the other tutorials in this series, helping you to prepare for the DB2 10.1 Fundamentals certification test 610.

View more content in this series

Date: 18 Oct 2012
Level: Introductory
PDF: A4 and Letter (2287 KB | 48 pages)Get Adobe® Reader®

Activity: 13961 views
Comments:

More about DB2 Linux, UNIX, and Windows

DB2 Information Center

No description about the tools that are available with DB2 would be complete without a comment about the DB2 Information Center (also known as DB2 Infocenter.) Whenever you need specific information about a particular DB2 command, SQL statement, configuration parameter, registry variable, or you just want to know more about what's new in the latest DB2 release, how to migrate databases from older versions, or how to get started with a specific DB2 feature/functionality, you can usually find it in the DB2 Information Center. The DB2 Information Center is the one-stop shop for any information you need about DB2. Its contents go far beyond the product documentation, and it's a must-read for just about any situation you might encounter.

The DB2 Information Center can be accessed via the Internet, but it can also be installed locally during the DB2 installation process. Because DB2 exists in several different versions (which correspond to major releases), when you access the Information Center from the web, you need to make sure that the Information Center you are looking at corresponds to version/release of DB2 that you are using. (For example, make sure you are using Information Center 10.1 when working with DB2 10.1 databases). If you need to access the DB2 Information Center via the Internet but can't remember the link (and don't have the link saved as a bookmark) just search for the words "db2 Infocenter 10.1" with your favorite search engine. (Always include the version number).

There’s an Information Center available for Data Studio as well; the link to that Information Center is: http://publib.boulder.ibm.com/infocenter/dstudio/v3r1/index.jsp

First steps

DB2 First Steps opens right after you install your DB2 product, and can help you get started using DB2 by:

Guiding you to the DB2 documentation website (Information Center)
Checking availability of new updates for your recently installed product
Creating a sample database (populated with sample data) through db2samp
Pointing you to the IBM Data Studio download website

Figure 38 shows how the First Steps dialog looks immediately after it has been invoked.

Figure 38. First Steps
The DB2 First Steps window.

DB2 First Steps can also be accessed through the operating system’s menu, or by executing the db2fs command.

There’s also a great independent tool called “Technology Explorer for DB2" which can help you learning DB2 with command samples and more. It can be accessed through a link in the Resources section.

Comments