469,914 Members | 2,262 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,914 developers. It's quick & easy.

interface

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

Jan 11 '06 #1
16 1442
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.

Jan 11 '06 #2
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

Jan 11 '06 #3
There is somthing caller commad Center there you can execute DB2
commnads on command line Hope this information is sufficent for u.

Jan 11 '06 #4
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.

Jan 11 '06 #5
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.

Jan 11 '06 #6
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

Jan 11 '06 #7
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

Jan 11 '06 #8
Thanx,

Leonardo pointed this out also.

Thanks for your assistance

Martijn Bos

Jan 11 '06 #9
In article <11**********************@g47g2000cwa.googlegroups .com>,
Martijn (ma**********@gmail.com) says...
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


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

Jan 11 '06 #10
Brian Tkatch wrote:
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
--
Serge Rielau
DB2 Solutions Development
DB2 UDB for Linux, Unix, Windows
IBM Toronto Lab
Jan 11 '06 #11
Ian
Martijn wrote:
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.


Jan 12 '06 #12
Ian
Martijn wrote:
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

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
Jan 12 '06 #13
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

Jan 12 '06 #14
Ian,

Thank you.

That looks nice. When I find the time today I will have something to
play with.

Best Regards

Martijn

Jan 12 '06 #15
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

Jan 13 '06 #16
>*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.

Jan 13 '06 #17

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Roy Pereira | last post: by
4 posts views Thread by Doug | last post: by
3 posts views Thread by zlst | last post: by
20 posts views Thread by Ole Hanson | last post: by
reply views Thread by YellowFin Announcements | last post: by
8 posts views Thread by rn5a | last post: by
1 post views Thread by Waqarahmed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.