Ask the Expert

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?)

    Requires Free Membership to View

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

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: