Q

DB2 versus SQL Server administrators

What are the functional differences between a DB2 administrator and a SQL Server 2000 administrator? (What does a SQL Server 2000 administrator need to know/learn in order to handle DB2?)

At a high level, the DBA will need to handle the same basic duties -- that is, managing performance, managing change, managing security, managing backup and recovery and assuring availability. So the core skills you learn as a SQL Server DBA will serve you well as a DB2 DBA. Of course, the devil is in the details, though, and there is no quick answer to your question about "functional differences." You will need to spend time with DB2...

to learn how it operates and how it differs from SQL Server. Off the top of my head, I would recommend that you start by focusing on SQL (there is no Transact-SQL equivalent in DB2), and then investigate the system differences (e.g. logging, buffering, file usage, etc.).

There may be external issues, too. For example, you may need to learn a new operating system for DB2. Yes, DB2 runs on Windows, but it also runs on Unix, Linux, OS/400, and mainframe platforms - SQL Server runs only on Windows.

Good luck!

This was first published in November 2002

Dig deeper on IBM DB2 management

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSOA

SearchSQLServer

Close