If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Db2 dba

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
Join Date: Jan 2011
Posts: 24
Db2 dba

Hello,

I hear people saying traditional DBA and physical DBA. Can some one tell the difference between different types of DB2 DBA? physical, logical, traditional, system DBA?

Thank you.
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
Join Date: Oct 2009
Location: 221B Baker St.
Posts: 487
In the many organizations i've supported, the term "dba" has no constant/consistent definition. All that you mentioned are needed one way or another (plus more) and different organizations address these in different ways.

Is there some particular position of interest? Do you know the specifics of the position?
Reply With Quote
  #3 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,381
Quote:
Originally Posted by Mikky View Post

I hear people saying traditional DBA and physical DBA. Can some one tell the difference between different types of DB2 DBA? physical, logical, traditional, system DBA?
I think these concepts are somewhat overlapping. For example, a traditional DBA is a middle-aged guy with a curtain or garibaldi beard, frequently wearing a homemade sweater. He's typically grumpy and mumbling.

A logical DBA is, basically, any DBA; if he or she isn't logical, there's little chance he or she will remain a DBA for long.

A physical DBA is such a DBA that, in addition to being logical, is able to lift a 100 pound storage unit into a rack, to at least 12U level. Surprisingly, very few traditional DBAs are physical, despite the sweater.

I'm not sure what system DBAs are; I guess it's those that are neither logical nor physical.

You've also omitted some pretty common categories, such as cute DBAs, blonde DBAs, straight-out-of-college DBAs, "global resource" DBAs, and some other, more obscure varieties.
__________________
---
"It does not work" is not a valid problem statement.
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 746
Quote:
Originally Posted by n_i View Post
I think these concepts are somewhat overlapping. For example, a traditional DBA is a middle-aged guy with a curtain or garibaldi beard, frequently wearing a homemade sweater. He's typically grumpy and mumbling.

A logical DBA is, basically, any DBA; if he or she isn't logical, there's little chance he or she will remain a DBA for long.

A physical DBA is such a DBA that, in addition to being logical, is able to lift a 100 pound storage unit into a rack, to at least 12U level. Surprisingly, very few traditional DBAs are physical, despite the sweater.

I'm not sure what system DBAs are; I guess it's those that are neither logical nor physical.

You've also omitted some pretty common categories, such as cute DBAs, blonde DBAs, straight-out-of-college DBAs, "global resource" DBAs, and some other, more obscure varieties.
<mumble> <mumble> Can't find the "like"button <mumble> <mumble> <grumpy> my 1st hit on google: Database administration and automation - Wikipedia, the free encyclopedia <\grumpy>
__________________
Somewhere between " too small" and " too large" lies the size that is just right.
- Scott Hayes
Reply With Quote
  #5 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
Quote:
Originally Posted by n_i View Post
traditional DBA logical DBA physical DBA system DBA cute DBA blonde DBA "global resource" DBA
Where do you fit in?
Reply With Quote
  #6 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,361
Quote:
Originally Posted by dr_te_z View Post
Can't find the "like" button
I was looking for it as well.
Reply With Quote
  #7 (permalink)  
Old
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 5,381
Quote:
Originally Posted by db2girl View Post
Where do you fit in?
I'm not a DBA; I'm a consultant, more on a physical side.
__________________
---
"It does not work" is not a valid problem statement.
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 2,172
a traditional DBA is a middle-aged guy with a curtain or garibaldi beard, frequently wearing a homemade sweater. He's typically grumpy and mumbling.
that is the best description I believe...
__________________
Best Regards, Guy Przytula
Database Software Consultant
Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
Join Date: Jan 2011
Posts: 24
Come on guys. Please seriously explain the difference. At least what a traditional DBA does and what a system DBA does? What is the most common type of DBA these days? I also want to know what is a legacy system?

TIA
Reply With Quote
  #10 (permalink)  
Old
Registered User
 
Join Date: Nov 2011
Posts: 314
I never heard these concepts : traditional DBA , system DBA。
DBA is just DBA。
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,722
Quote:
Originally Posted by Mikky View Post
Come on guys. Please seriously explain the difference. At least what a traditional DBA does and what a system DBA does? What is the most common type of DBA these days? I also want to know what is a legacy system?
TIA
System DBA usually only applies to DB2 for z/OS, and they are usually called DB2 system programmers, and not system DBA's. You need z/OS system programming experience for this, and it is not really a DBA job.

Some DBA's do logical design and work with extensively with application developers, and do things like write stored procedures, triggers, etc, when applicable. Some DBA's only do production support (no design) are typically called physical DBA's. Many DBA's do both, at least to some degree. It often depends on how large the company is and whether there are enough DBA's to have separate groups.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Oct 2009
Location: 221B Baker St.
Posts: 487
Quote:
Come on guys. Please seriously explain the difference.
Other than the "middle-aged guy" description, i believe the other answers were attempts to answer your original question.

Quote:
At least what a traditional DBA does and what a system DBA does?
I suspect the answer Marcus posted is what you want here. Also see next answer.

Quote:
What is the most common type of DBA these days?
I'm not sure there is a "most common" any more. I'm only one person and i have worked with organizations that have had only 1 dba "for everything" (i was asked to go there because that person had ended his own life - talk about no turnover, and no one else knew what/how he did the job) to my most recent client (before now) that had 4 dba teams of 10 - 12 dba's each (32 z/OS lpar's and 100 unix servers supporting more than 20 database engines).

Quote:
I also want to know what is a legacy system?
Has typically meant older "stuff". Now there are even db2 systems that are considered "legacy". Some consider a system a legacy system if the presentation is not gui. Others have a different opinion.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On