473,698 Members | 2,005 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ


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 1571
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

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


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.


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

Leonardo pointed this out also.

Thanks for your assistance

Martijn Bos

Jan 11 '06 #9
In article <11************ **********@g47g 2000cwa.googleg roups.com>,
Martijn (ma**********@g mail.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

Kind regards, Gert

Jan 11 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Roy Pereira | last post by:
I have an application that is composed of a set of "Content" dlls and a viewer application. The viewer calls a standard set of functions that are present in all the dlls. I maintain this by making my contnent dlls implement an interface created in vb6. The viewer application is bound to this interface. This way, I am able to add Content without redeploying the dlls (I just have to add the new dlls). I want to write new content for...
by: Anon Email | last post by:
Hi people, I'm learning about header files in C++. The following is code from Bartosz Milewski: // Code const int maxStack = 16; class IStack
by: Doug | last post by:
I am working on an existing .NET (C Sharp) component that had a com interface that was used by a VB component. When it was originally written, it had the SSEAssemblyCom class below - minus the two last methods (for space I modified method names in my example below). I added those. Everything but the two new methods I added referenced the ISSEAssemblyCom interface below. I was told I would need to create a secondary interface...
by: zlst | last post by:
Many technological innovations rely upon User Interface Design to elevate their technical complexity to a usable product. Technology alone may not win user acceptance and subsequent marketability. The User Experience, or how the user experiences the end product, is the key to acceptance. And that is where User Interface Design enters the design process. While product engineers focus on the technology, usability specialists focus on the user...
by: Alex Sedow | last post by:
Example 1 interface I { string ToString(); } public class C : I { public void f() {
by: Ole Hanson | last post by:
I am accessing my database through an interface, to allow future substitution of the physical datastore - hence I would like to declare in my Interface that my DAL-objects implementing the interface and accessing the datastore MUST pass in a UserToken in the constructor of the object. Is this not possible? Am I forced to add the UserToken as a property on the object instead? /Ole
by: Alex Sedow | last post by:
Why interface-event-declaration does not support multiple declarators like event-declaration? Grammar from C# spec: variable-declarators: variable-declarator variable-declarators "," variable-declarator variable-declarator:
by: YellowFin Announcements | last post by:
Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that don't work nearly as well as they should, even for analysts and power users. The reason they haven't reached the masses is because most of the tools are so difficult to use and reveal so little
by: Xah Lee | last post by:
On Java's Interface Xah Lee, 20050223 In Java the language, there's this a keyword “interface”. In a functional language, a function can be specified by its name and parameter specs. For example: f(3) f(3, )
by: rn5a | last post by:
Suppose I have the following class code: Imports System Imports System.Data Imports System.Data.SqlClient Public Class DBSettings Private sqlCmd As SqlCommand Private sqlConn As SqlConnection Public ConnectionString As String
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development projectplanning, coding, testing, and deploymentwithout human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.