dbTalk Databases Forums  

Q about DB2 Express-C and Admin Tools

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss Q about DB2 Express-C and Admin Tools in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michael Lueck
 
Posts: n/a

Default Q about DB2 Express-C and Admin Tools - 07-20-2010 , 08:38 PM






Greetings:

I saw a news article about DB2 Express-C running on Ubuntu Linux. I have one question about the DB2 Express-C edition: Do the usual DB2 admin tools (which come with DB2 workgroup edition for example)
work and come with DB2 Express-C edition that may be installed on another system - be it a Linux or Windows system?

Ubuntu Linux server edition is a text only interface, so I am thinking IBM has this covered that there is some provision to be able to install the DB2 admin tools on a admin workstation and remote
connect to the DB2 Express-C server. At least I hope so! ;-)

Might indeed be incentive for us to upgrade our in-house development server, and this time install on an Ubuntu Linux server.

TIA!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Reply With Quote
  #2  
Old   
Mark A
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 12:26 AM






"Michael Lueck" <mlueck (AT) lueckdatasystems (DOT) com> wrote

Quote:
Greetings:

I saw a news article about DB2 Express-C running on Ubuntu Linux. I have
one question about the DB2 Express-C edition: Do the usual DB2 admin tools
(which come with DB2 workgroup edition for example) work and come with DB2
Express-C edition that may be installed on another system - be it a Linux
or Windows system?

Ubuntu Linux server edition is a text only interface, so I am thinking IBM
has this covered that there is some provision to be able to install the
DB2 admin tools on a admin workstation and remote connect to the DB2
Express-C server. At least I hope so! ;-)

Might indeed be incentive for us to upgrade our in-house development
server, and this time install on an Ubuntu Linux server.

TIA!

--
Michael Lueck
Yes, you can install DB2 Express-C on a Windows machine and remotely control
your Linux databases with the supplied GUI applications. You could also just
intall the Data Server Client (which has no database engine, but just the
client software and GUI tools).
You can get the client here:
http://www-933.ibm.com/support/fixce...wg/selectFixes

There is also IBM Data Studio 2.2 which is a separate GUI interface that is
free (the old GUI interfaces are not going to be enhanced and are being
phased out).
http://www.ibm.com/developerworks/do...ata/learn.html

Reply With Quote
  #3  
Old   
Michael Lueck
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 06:34 AM



Mark A wrote:
Quote:
You can get the client here:
http://www-933.ibm.com/support/fixce...wg/selectFixes
This lead to a "No results found - Information Management, IBM Data Server Client Packages (9.7.*, Linux 32-bit,x86)" screen...

Quote:
There is also IBM Data Studio 2.2 which is a separate GUI interface that is
free (the old GUI interfaces are not going to be enhanced and are being
phased out).
http://www.ibm.com/developerworks/do...ata/learn.html
Seems if I go this route...

"Download IBM Data Studio (stand-alone)
Red Hat Linux, SUSE Linux, Windows V2.2.0.1"

Which there is no Ubuntu installer.

My main development box currently runs Ubuntu 9.04.

Currently I am getting to DB2 admin tools via a VM session running Windows... so would like to get rid of the need to fire the VM up if possible.

Thanks very much!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Reply With Quote
  #4  
Old   
Mark A
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 07:30 AM



"Michael Lueck" <mlueck (AT) lueckdatasystems (DOT) com> wrote

Quote:
This lead to a "No results found - Information Management, IBM Data Server
Client Packages (9.7.*, Linux 32-bit,x86)" screen...
Try this, and then navigate to the latest fixpack.
http://www-01.ibm.com/support/docvie...id=swg27007053
IBM websites are brutal and not all pages can be bookmarked.

Reply With Quote
  #5  
Old   
Michael Lueck
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 10:08 AM



Mark A wrote:
Quote:
Try this, and then navigate to the latest fixpack.
http://www-01.ibm.com/support/docvie...id=swg27007053
IBM websites are brutal and not all pages can be bookmarked.
That link is certainly worth bookmarking for now! Thanks!

Seems there are many choices... lots to learn with our upgrade / platform migration project. :-)

One last question, can I simply download "V9.7 Fix Pack 2" code to install, or do I need FP0 installed, then update to FP2?

Thanks very much!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Reply With Quote
  #6  
Old   
Helmut Tessarek
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 12:12 PM



Quote:
One last question, can I simply download "V9.7 Fix Pack 2" code to install, or
do I need FP0 installed, then update to FP2?
You can install FP2 right away. Every FP package code has 3 install options
(Unix, Linux):

../db2setup GUI installer
../db2_install manuall installer (installs everything)
../installFixpack upgrade to fixpack level

On Windows there is one installer that handles either the installation or
upgrade of DB2.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

Reply With Quote
  #7  
Old   
Mark A
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 03:35 PM



"Michael Lueck" <mlueck (AT) lueckdatasystems (DOT) com> wrote

Quote:
That link is certainly worth bookmarking for now! Thanks!

Seems there are many choices... lots to learn with our upgrade / platform
migration project. :-)

One last question, can I simply download "V9.7 Fix Pack 2" code to
install, or do I need FP0 installed, then update to FP2?

Thanks very much!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/
As already mentioned, you can install the latest fixpack only. Just remember
that only the clients are free and come with a perpetual license. The other
versions that have a full database engine(except DB2 Express-C that you
download elsewhere) come with a 90 day free trial license that will expire
unless a valid license is installed.

Reply With Quote
  #8  
Old   
Will Honea
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 04:44 PM



Michael Lueck wrote:

Quote:
Mark A wrote:
You can get the client here:
http://www-933.ibm.com/support/fixce...wg/selectFixes

This lead to a "No results found - Information Management, IBM Data Server
Client Packages (9.7.*, Linux 32-bit,x86)" screen...

There is also IBM Data Studio 2.2 which is a separate GUI interface that
is free (the old GUI interfaces are not going to be enhanced and are
being phased out).
http://www.ibm.com/developerworks/do...ata/learn.html

Seems if I go this route...

"Download IBM Data Studio (stand-alone)
Red Hat Linux, SUSE Linux, Windows V2.2.0.1"

Which there is no Ubuntu installer.

My main development box currently runs Ubuntu 9.04.

Currently I am getting to DB2 admin tools via a VM session running
Windows... so would like to get rid of the need to fire the VM up if
possible.
You might be interested in an article I saw on the Register today about
Ubuntu shipping DB2 Express C as part of it's upcoming server release.

The article was at
http://www.theregister.co.uk/2010/07...al_db2_ubuntu/

I just skimmed it but it may have some useful info for you about what you
are asking.

--
Will Honea

Reply With Quote
  #9  
Old   
Michael Lueck
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 08:42 PM



Helmut Tessarek wrote:
Quote:
You can install FP2 right away. Every FP package code has 3 install options
(Unix, Linux):
Aaahhh, excellent planning on IBM's part. Thanks much!

--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Reply With Quote
  #10  
Old   
Mark A
 
Posts: n/a

Default Re: Q about DB2 Express-C and Admin Tools - 07-21-2010 , 08:56 PM



"Michael Lueck" <mlueck (AT) lueckdatasystems (DOT) com> wrote

Quote:
Aaahhh, excellent planning on IBM's part. Thanks much!

--
Michael Lueck
Keep in mind that this does not apply to DB2 Express-C. You cannot apply
fixpacks to it and must follow the upgrade instructions included in the
latest DB2 Express-C release you are installing (there will not be a DB2
Express-C release for every fixpack release).

Also, be sure to save any DB2 Express-C images you may need, because as soon
as the next release of DB2 is available, the old DB2 Express-C images will
be removed from the IBM website.

Reply With Quote
Reply




Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.