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 > General > Chit Chat > Sql DBA or DB2 DBA?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #31 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,357
Well, I don't use GUI tools from day one and I hope I never will. I do everything using the command line (or scripts), I know exactly what I'm doing and can react quickly if something goes wrong.
Reply With Quote
  #32 (permalink)  
Old
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,322
Pat,

What GUI Tools are you talking about???

You're a command line junkie as well..if your gonna say the a query window is a GUI Tool, then so is SPUFI I Guess. or SQL+

DB2 Gal

Don't let Pat Fool ya
__________________
Brett
8-)

It's a Great Day for America everybody!

dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was

The physical order of data in a database has no meaning.
Reply With Quote
  #33 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,524
Quote:
Originally Posted by db2girl View Post
Well, I don't use GUI tools from day one and I hope I never will. I do everything using the command line (or scripts), I know exactly what I'm doing and can react quickly if something goes wrong.
Sorry, but if you dogmatically refuse to use tools that make your job easier then you are not a good DBA. You're just an inefficient DBA.

I can't avoid scoffing at that attitude. Frankly, its moronic.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #34 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,357
Quote:
Originally Posted by blindman View Post
Sorry, but if you dogmatically refuse to use tools that make your job easier then you are not a good DBA. You're just an inefficient DBA.

I can't avoid scoffing at that attitude. Frankly, its moronic.

I don't need any GUI tools to make my job easier or more efficient. I can do everything using the command line or scripts and don't need to worry about GUI tools hanging / crashing on me or consuming too much resources. I do use tools that assist me with my job (specifically my previous job as tech support), but those are not GUI.
Reply With Quote
  #35 (permalink)  
Old
Programming since 1BC
 
Join Date: Sep 2009
Location: Ontario
Posts: 934
@dbafresher. You have to know one thing really well, and have a little bit of knowledge about something else, otherwise you will not be able to participate in discussions like this one.
Reply With Quote
  #36 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,524
Quote:
Originally Posted by db2girl View Post
I don't need any GUI tools to make my job easier or more efficient. I can do everything using the command line or scripts and don't need to worry about GUI tools hanging / crashing on me or consuming too much resources. I do use tools that assist me with my job (specifically my previous job as tech support), but those are not GUI.
Clueless. I don't have problems with the GUI tools I use crashing or consuming too much resources. In fact, they just generate and execute SQL commands which I can and often do script out and run independently.
If these tools seriously tax the resources of your platform then you seriously need a more powerful platform.
Your attitude is positively Amish. Grow up and stop being so dogmatic.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #37 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,357
Quote:
Originally Posted by blindman View Post
Clueless. I don't have problems with the GUI tools I use crashing or consuming too much resources. In fact, they just generate and execute SQL commands which I can and often do script out and run independently.
If these tools seriously tax the resources of your platform then you seriously need a more powerful platform.
Your attitude is positively Amish. Grow up and stop being so dogmatic.

Everyone is entitled to their own opinion. Mine is that command line is always better than GUI (I'm only talking about DB2 GUI tools here).
Reply With Quote
  #38 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,524
Well, I haven't used the DB2 GUI tools, so I suppose it is possible that there has never been written a useful or efficient GUI tool for DB2.
But I find that highly doubtful. I know it is not the case for the other database platforms with which I do have considerable experience.
More likely is that you have gotten it into your head that exclusively using command line tools somehow makes you a superior DBA, when in fact the opposite is true, and thus you dismiss out of hand any GUI tool that might make you more efficient. You come across as someone who refuses to learn new technologies. A luddite of the database world. In then end, you are damaging your own marketability. Walk into an interview and explain your ignorance of the many common administrative tools by claiming to be a purist and lets see how far you get. Most likely you'd end up as an entry on The Daily WTF's "Tales From The Interview" feature.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #39 (permalink)  
Old
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 2,357
I'm sure I will do better in a job interview than someone who only knows how to use GUI tools.

I don't want to spend time and energy to argue with you. Good luck with using the GUI tools that make you more efficient. And I'll continue using command line and scripts.
Reply With Quote
  #40 (permalink)  
Old
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 14,451
I agree with DB2Girl that the GUI tools for DB2 are very, very poor compared to the GUI tools for other platforms. Command Center for DB2 isn't bad, as long as it has the funcitonality needed for a given task (which it usually does). The AIX GUI tools that I've seen are nothing short of abominable. As a general rule of thumb DB2 GUI tools are roughly 10-15 years behind the more popular database engines, but I expect the GUI support for DB2 to eventually catch up with the rest of the market.

There are some decent third-party tools for using and/or administering DB2. At one time there was Toad support for DB2, but that was quite some time ago. BMC provides some excellent TSO tools for managing zOS DB2. I've even seen a prototype of a web based admin tool that was derived from MyPHPAdmin that was quite nice, but I've never seen it formally released.

Don't get me wrong, when the chips are down I head for a command promp/script tool in a heartbeat. Character mode control will probably never die because it is the simplest and most reliable way to manage/control a database. Even with that, the GUI is hundreds or thousands of times more efficient when it works, and that translates directly to cost savings for boh me and my customers so I will use the GUI tools when I can use them safely and securely.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #41 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,524
Quote:
Originally Posted by db2girl View Post
I'm sure I will do better in a job interview than someone who only knows how to use GUI tools.
...but not as well as someone who uses both.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #42 (permalink)  
Old
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,322
Are you kidding me blind dude...you really don't use GUI tools either

a Query Window is not really a GUI "tool"

and except for scripting, what ELSE do you use SSMS for?

And if you have ERWin, you don't even need to do the scripting in SSMS
__________________
Brett
8-)

It's a Great Day for America everybody!

dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was

The physical order of data in a database has no meaning.
Reply With Quote
  #43 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,524
I use SSMS for creating, dropping, altering, and auditing objects.
I use the scheduler for jobs, and create standard maintenance plans.
I track the history of job execution using the Job Activity Monitor.
I use the Activity Monitor to detect blocking and kill offending connections.
I use SSMS for changing properties of databases and objects.
I use SSMS for managing replication and mirroring.
I use SSMS for managing security access at the server and database level.
The list could go on, but does that answer your question?
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
  #44 (permalink)  
Old
Window Washer
 
Join Date: Nov 2002
Location: Jersey
Posts: 10,322
Quote:
Originally Posted by blindman View Post
I use SSMS for creating, dropping, altering, and auditing objects.
Really?

How do you promote the changes?
__________________
Brett
8-)

It's a Great Day for America everybody!

dbforums Yak CorralRadio 'Rita
dbForums Member List
I'm Good Once as I ever was

The physical order of data in a database has no meaning.
Reply With Quote
  #45 (permalink)  
Old
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 12,524
If I am promoting them I script them, often using the GUI to generate the script for me.
But I do a lot of administrative tasks that aren't promoted.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
www.LobsterShot.blogspot.com
Reply With Quote
Reply

Tags
db2 dba, dba, market trend, oracle pioneer, sql dba

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