 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / January 2006interface
Hi All, I'm a oracle DBA who wants to learn DB2 also. I've installed DB2 V8.1 Personal Edition to play around. Now I wonder whether there is a tool similar to sqlplus in the db2 world. This because I like a command line a little more then a GUI. (btw The Control Center does look OK to me) Any pointer is appreciated. Best Regards Martijn Bos Like sqlplus? Just type db2. I came from an oracle background too, I was surprised, and very happy, to find out that to create an instance on db2 it was just running db2icrt. Not like oracle where you have to create pfile/spfile, edit tnsnames and listener...... Many concepts on db2 are different from oracle, so check the db2 infocenter at IBM's website I think you will find db2 much easier to learn than oracle, at least that was my impression. Hee thank you a lot, I indeed am under the impression that a lot of concepts are really different to oracle. On the other hand : There (luckely) are also some things alike. At least I'm very imressed by the control center. Best regards and thanks for your quick reply, Martijn Bos I think Oracle strives to be "correct", where db2 strives just to get it done. Most of the concepts are the same, but how to implment them is different. B. That I have to find out in the days/weeks/months/years to come. Anyway I'm glad to notice that in this ng questions don;t end up in the "bit bucket" Best Regards Martijn Bos > That I have to find out in the days/weeks/months/years to come. > [quoted text clipped - 4 lines] > > Martijn Bos This might be usefull: If you're a database specialist interested in growing your DB2 Universal Database skills, there's a good chance that you've already developed database skills with another relational database product somewhere along the way. This article shows you how to use your current knowledge of Oracle 9i to quickly gain skills in DB2 UDB for Linux, UNIX, and Windows Version 8. The full developersworks article can be found at http://tinyurl.com/b9alx Kind regards, Gert Gert, That article indeed looks very promising (I just scanned it quickly for the moment). At the moment I have "medium" oracle experience and have to learn a lot more. I always find that such articles help understand both worlds (DB2 and Oracle), so it's more then welcome. Best regards, Martijn > I think Oracle strives to be "correct", where db2 strives just to get > it done. Most of the concepts are the same, but how to implment them is > different. *lol* I take it you are first and foremost an Oracle DBA? Our first experiences will always be felt as the "right" ones. Cheers Serge  SignatureSerge Rielau DB2 Solutions Development DB2 UDB for Linux, Unix, Windows IBM Toronto Lab >*lol* I take it you are first and foremost an Oracle DBA? Well, i was DBA in a small company once, and we used Oracle. >Our first experiences will always be felt as the "right" ones. I think you means "best". Oracle syntax tends to be more clear (to me). Also, there is no "autonumber" in Oracle, one must use SEQUENCE and TRIGGER. That is "correct" because "autonumber" is not actually a data type. Allowing autonumber is convenient, but ultimately not "correct" for a DB. COLUMNs store data, they should not modify it in any way. I like to think the difference between Oracle and Sybase/SQL Server is that Oracle is for the designer but makes compromises for the programmer if it does not conflict, and Sybase/SQL Server is for the programmer but makes compromises for the designer if it does not conflict. Hence, designers like Oracle better, programmers, Sybase/SQL Server. (Basically, the J/P preference in the MBTI.) DB2 falls somewhere in the middle, not quite commiting to either side, which follows IBM's general practice of trying to give everyone what they want, as long as they pay. Further, if a person complains that even though there is a way of doing something, but the syntax is not "technically correct", i get the feeling that in Oracle it is reported as a valid bug, whereas in the other DBs people think the person asking is too much being something works. Whether this is true or not, i don't know. I just like to think of that way. :) B. > At least I'm very imressed by the control center. Wow, now that's something you don't hear every day. :-) Control Center is actually getting pretty decent. Just in time for the V9 rewrite. There is somthing caller commad Center there you can execute DB2 commnads on command line Hope this information is sufficent for u. Thank you for your reply. The command center I allready find :-) The "db2" interface however gives the opportunity to interact with DB2 without a GUI. Since I'm "raised" in a GUI-free (not necessarily a good thing) Unix world I prefer Command Line interfaces Best Regards Martijn Bos > Thank you for your reply. > [quoted text clipped - 4 lines] > Since I'm "raised" in a GUI-free (not necessarily a good thing) Unix > world I prefer Command Line interfaces One thing you'll probably find handy is that you do not have to use the interactive DB2 CLP: You can do everything at the shell prompt, and take advantage of command pipelines and other useful shell features (history, etc). $ db2 "connect to sample" $ ls -la $ db2 "select * from syscat.tables" | grep SYSTABLES Ian, Thank you. That looks nice. When I find the time today I will have something to play with. Best Regards Martijn I know this thread is getting too long, but one thing I was amazed that was finally added to db2 was the option to check the lines you have in the buffer, and edit them ... Just like oracle :) For example: "h" shows the history, "e" edits a line of your choice. I have been doing everything from shell (bash rules!) so I always had those features, but its nice they were added to the clp The command line tool is called run via the command db2. If a command is not supplied, it goes into interactive mode. Although it has a different syntax, it is comparable to SQL*PLUS in most ways. In the documentation it is called the CLP or Command Line Processor. B. Thanx, Leonardo pointed this out also. Thanks for your assistance Martijn Bos |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.