By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,611 Members | 1,711 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,611 IT Pros & Developers. It's quick & easy.

Starting DB2 UDBv9 Express-C in a Linux environment

P: n/a
Hi all,

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?

Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment. My windows control center currently can connect to
other remote DB2 instances, all on a Linux box. This was done using
specific IP addresses but I don't know how to catalog the local linux
instance so that I can at least do some minor work through DB2 control
center.

Finally, can anyone recommend a book (free or not) that takes a linux
newbie through the nitty-gritty of Linux and Db2? A book in the vein
of how-to books.
Thanks
Okonita


Thanks again

Oct 1 '07 #1
Share this Question
Share on Google+
8 Replies


P: n/a
Ok*****@gmail.com wrote:
Hi all,

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?
I'm not sure if that thing exists for linux...
To start db2 use the "db2start" command from your shell (or
startup-script...)
>
Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment. My windows control center currently can connect to
other remote DB2 instances, all on a Linux box. This was done using
specific IP addresses but I don't know how to catalog the local linux
instance so that I can at least do some minor work through DB2 control
center.
Hang on. You mean you try to have DB2 running Linux the same box as
Controlcenter on Windows? Unless you are running some vm thingy I don't
see how you can have Linux and Windows up at the same time....

I admit to being naive, but I though control center would run on Linux...
Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Oct 1 '07 #2

P: n/a
On Oct 1, 3:16 am, Okon...@gmail.com wrote:
Hi all,

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?

Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment. My windows control center currently can connect to
other remote DB2 instances, all on a Linux box. This was done using
specific IP addresses but I don't know how to catalog the local linux
instance so that I can at least do some minor work through DB2 control
center.

Finally, can anyone recommend a book (free or not) that takes a linux
newbie through the nitty-gritty of Linux and Db2? A book in the vein
of how-to books.

Thanks
Okonita

Thanks again
You can add an icon to your Linux Gnome Desktop (right click, "Create
Launcher"). Assuming the instance name is db2inst1, run program /home/
db2inst1/sqllib/bin/db2cc. When you double click, the Control Center
will appear.

Norm
Norm

Oct 2 '07 #3

P: n/a
Serge Rielau wrote:
Ok*****@gmail.com wrote:
>Hi all,

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?
I'm not sure if that thing exists for linux...
To start db2 use the "db2start" command from your shell (or
startup-script...)
>>
Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment. My windows control center currently can connect to
other remote DB2 instances, all on a Linux box. This was done using
specific IP addresses but I don't know how to catalog the local linux
instance so that I can at least do some minor work through DB2 control
center.
Hang on. You mean you try to have DB2 running Linux the same box as
Controlcenter on Windows? Unless you are running some vm thingy I don't
see how you can have Linux and Windows up at the same time....

I admit to being naive, but I though control center would run on Linux...
Cheers
Serge
Serge, I've had mixed results getting the desktop icons installed with both
8.2 and 9.1. I've done installs under KDE that will create the appropriate
folders on the Gnome desktop, others that don't. No rhyme or reason that I
can see, but I've had to create the icons on the KDE desktop manually every
time. Yes, the Control Center (all the tools) run fine with Java 1.5 or 1.6
on 32 bit installs but I'm having some Java problems with the 64-bit
version of 9.1. I'm still running a pre-release version of openSUSE 10.3,
so that is not unexpected. Matter of fact, the CC is apparently more
stable on Linux than on XP or W2K.

--
Will Honea

--
Posted via a free Usenet account from http://www.teranews.com

Oct 2 '07 #4

P: n/a
On 2007-10-01, Ok*****@gmail.com <Ok*****@gmail.comwrote:
I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?
You didn't spesify your desktop environment. In Gnome you
would have to do it manually either by right clicking on desktop -->
"Create launcher" and so on. Also if you want to have an icon, you have
to define it your self.
Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment.
I don't understand this. If you are running Linux and Windows on
dual boot system, there's no way to do this. If you running Linux or
Windows on same machine as virtual machine, you will have to catalog
databases as any other remote databases.

Finally, can anyone recommend a book (free or not) that takes a linux
newbie through the nitty-gritty of Linux and Db2? A book in the vein
of how-to books.
There is an IBM Redbook "Up and Running with DB2 for Linux, SG24-6899-00".
I haven't red and it's actually already four years old, but I believe
most of the information is still accurate and the book is still very
popular.

--
sip:ta*@tav.iki.fi http://tav.iki.fi

The Internet is *full* - go away! -- Gert Doering
Oct 2 '07 #5

P: n/a
On 2007-10-02, Tapio Väättänen <ta*@iki.fiwrote:
You didn't spesify your desktop environment. In Gnome you
would have to do it manually either by right clicking on desktop -->
"Create launcher" and so on. Also if you want to have an icon, you have
to define it your self.
Ment to say that you can do this either on Gnome Desktop or Gnome Panel.

--
sip:ta*@tav.iki.fi http://tav.iki.fi

"By the way, I was being sarcastic" -- Homer J. Simpson
Oct 2 '07 #6

P: n/a
I may be wrong Will, so correct me if I am. I *THINK* what you are
trying to do is catalog DBs and Instances on your windows box that you
can then refer to and manage with the windows tools. I do that all the
time.

What you need is the command set for doing this. Search for "catalog
tcpip node" in the manuals if you have them online. I'd help further on
this but I'm relegated for a couple of months to my lame laptop.

First you catalog the node (the instance really) and then you catalog the
db AT that instance - here, let me google it.

http://publib.boulder.ibm.com/infoce.../v8/index.jsp?
topic=/com.ibm.db2.udb.doc/core/r0001944.htm

Example 2 is the one you want,... and then :

catalog db sample at node _____

node name you used in "catalog tcpip node _____"

"AT NODE nodename
Specifies the name of the node where the database being cataloged
resides. This name should match the name of an entry in the node
directory. If the node name specified does not exist in the node
directory, a warning is returned, but the database is cataloged in the
system database directory. The node name should be cataloged in the node
directory if a connection to the cataloged database is desired. "

that should get you up and running with the CC on Winder$
Hope it helps!!!

Mairhtin O'Feannag
Will Honea <wh****@yahoo.comwrote in
news:47***********************@free.teranews.com:
Serge Rielau wrote:
>Ok*****@gmail.com wrote:
>>Hi all,

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?
I'm not sure if that thing exists for linux...
To start db2 use the "db2start" command from your shell (or
startup-script...)
>>>
Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment. My windows control center currently can connect
to other remote DB2 instances, all on a Linux box. This was done
using specific IP addresses but I don't know how to catalog the
local linux instance so that I can at least do some minor work
through DB2 control center.
Hang on. You mean you try to have DB2 running Linux the same box as
Controlcenter on Windows? Unless you are running some vm thingy I
don't see how you can have Linux and Windows up at the same time....

I admit to being naive, but I though control center would run on
Linux... Cheers
Serge

Serge, I've had mixed results getting the desktop icons installed with
both 8.2 and 9.1. I've done installs under KDE that will create the
appropriate folders on the Gnome desktop, others that don't. No rhyme
or reason that I can see, but I've had to create the icons on the KDE
desktop manually every time. Yes, the Control Center (all the tools)
run fine with Java 1.5 or 1.6 on 32 bit installs but I'm having some
Java problems with the 64-bit version of 9.1. I'm still running a
pre-release version of openSUSE 10.3, so that is not unexpected.
Matter of fact, the CC is apparently more stable on Linux than on XP
or W2K.
Oct 2 '07 #7

P: n/a
Mairhtin O'Feannag wrote:
I may be wrong Will, so correct me if I am. I *THINK* what you are
trying to do is catalog DBs and Instances on your windows box that you
can then refer to and manage with the windows tools. I do that all the
time.

What you need is the command set for doing this. Search for "catalog
tcpip node" in the manuals if you have them online. I'd help further on
this but I'm relegated for a couple of months to my lame laptop.

First you catalog the node (the instance really) and then you catalog the
db AT that instance - here, let me google it.

http://publib.boulder.ibm.com/infoce.../v8/index.jsp?
topic=/com.ibm.db2.udb.doc/core/r0001944.htm

Example 2 is the one you want,... and then :

catalog db sample at node _____

node name you used in "catalog tcpip node _____"

"AT NODE nodename
Specifies the name of the node where the database being cataloged
resides. This name should match the name of an entry in the node
directory. If the node name specified does not exist in the node
directory, a warning is returned, but the database is cataloged in the
system database directory. The node name should be cataloged in the node
directory if a connection to the cataloged database is desired. "

that should get you up and running with the CC on Winder$
Hope it helps!!!

Mairhtin O'Feannag
Will Honea <wh****@yahoo.comwrote in
news:47***********************@free.teranews.com:
>Serge Rielau wrote:
>>Ok*****@gmail.com wrote:
Hi all,

I have gone through the process of installing DB2 UDBv9 Express-C in
my local linux environment. I am used to having icon placed on my
Desktop or taskbar for easy access to (db2cc) Control Center. After
installation, how then can I get access to DB2? How can I place a
desktop icon in linux for easy access to DB2?
I'm not sure if that thing exists for linux...
To start db2 use the "db2start" command from your shell (or
startup-script...)

Also, I will like to know how I can make DB2 control center in my
windows environment detect the recent DB2 installation in the local
linux environment. My windows control center currently can connect
to other remote DB2 instances, all on a Linux box. This was done
using specific IP addresses but I don't know how to catalog the
local linux instance so that I can at least do some minor work
through DB2 control center.
Hang on. You mean you try to have DB2 running Linux the same box as
Controlcenter on Windows? Unless you are running some vm thingy I
don't see how you can have Linux and Windows up at the same time....

I admit to being naive, but I though control center would run on
Linux... Cheers
Serge

Serge, I've had mixed results getting the desktop icons installed with
both 8.2 and 9.1. I've done installs under KDE that will create the
appropriate folders on the Gnome desktop, others that don't. No rhyme
or reason that I can see, but I've had to create the icons on the KDE
desktop manually every time. Yes, the Control Center (all the tools)
run fine with Java 1.5 or 1.6 on 32 bit installs but I'm having some
Java problems with the 64-bit version of 9.1. I'm still running a
pre-release version of openSUSE 10.3, so that is not unexpected.
Matter of fact, the CC is apparently more stable on Linux than on XP
or W2K.
Responding to the wrong post, I think. I use this lab for a sandbox and run
the drill of setting up a new server pretty frequently. Good info - but
since about the time of V7 I also find that the tools in the Control Center
work pretty well for mapping things. The discovery process is especially
handy when you wind up with an odd port assigned to an instance or have an
unfamiliar schema to wade through.

--
Will Honea

--
Posted via a free Usenet account from http://www.teranews.com

Oct 2 '07 #8

P: n/a
Going completely offtopic...

CoLinux hooks into the NT kernel and provides a Linux environment within
Windows. Having said that, I think he means something like 2
workstations. Or perhaps (X-)Windows.

Serge Rielau wrote:
Hang on. You mean you try to have DB2 running Linux the same box as
Controlcenter on Windows? Unless you are running some vm thingy I don't
see how you can have Linux and Windows up at the same time....

I admit to being naive, but I though control center would run on Linux...
Cheers
Serge
Oct 5 '07 #9

This discussion thread is closed

Replies have been disabled for this discussion.