To build the ibm_db2 extension, the DB2 application development header files and libraries must be installed on your system. DB2 does not install these by default, so you may have to return to your DB2 installer and add this option. The header files. (Prereq: I've installed DB2 express-c before, and also Apache and php).

For a proof of concept Yves Groenen was asked to make a connection from Excel powerquery to an IBM DB2 database. Read more about his findings. Situation For a proof of concept I was asked to make a connection from Excel powerquery to an IBM DB2 database. Since I didn’t have a server somewhere with DB2 installed on it, so I went searching for a solution. A thing to keep in mind is that this post isn’t a deep dive into DB2, but a connectivity test between Excel and DB2. First let’s go over the environment and tools that I used to set up Excel- and the DB2 (note: it’s best you create an account with IBM which allows you to download the IBM tools listed here): • Windows 8 (64 bit): I used my own computer as DB2 host • DB2 Express-C database server v10.5.1 (64 bit): This is the free version of DB2. It’s kind of the IBM equivalent of SQL Server Express edition • IBM data studio: a free DB2 database management tool.

The installation of this tool isn’t necessary since we can do administrative tasks through the command line, but I installed it since I’m a ‘GUI’ kind of guy (pun intended) and I wanted to check it out • Excel 2013 (32-bit) Installation/configuration Installing DB2 Express-C database server. First of all, I created an IBM account since this is a prerequisite if you want to download their software. After that I downloaded the DB2 Express-C.

When we run the installer you will have the following overview: We will be doing a fresh installation so click Install New. I used the typical installation. You can view the features provided by a typical installation: At the next page you will have to choose if you want to install DB2, want to create a RSP file or do both.

I’ve chosen the latter. You could look at the RSP file as the equivalent of the configuration file in SQL Server.

This way you can install new deployments with the same configuration. As in SQL Server this file should be used in command line installation: This file also comes in handy when you want to check out the settings you used after an installation.

Next you choose the install folder for DB2 express –C and the IBM SSH server installation. If you already performed another DB2 installation on your computer, you will get an extra step: DB2 copy name. Starting from version 9, multiple DB2 copies can be installed on the same machine. This name will be used to distinguish these installations: Also mind the comment here regarding default application connections. Next you will have to set the user information that will be used to run the DB2 administration server and the other DB2 services. For this example I created a local administrator account. Also in DB2 you can’t create database users.

They have to be created at the OS level: Next you will see the instance that will be installed. You can configure different options regarding TCP/IP, Named Pipes and whether the service should run at system startup. I will use the defaults: Finally we get an overview of our installation settings.

We finish the installation. After this you will get a DB2 first steps screen where you will find different items to get you started. You could get a sample database generated, but later this post we will create one ourselves. IBM data studio I’m not going to walk through the installation steps since it’s pretty straight forward. The download will be done through IBM’s download manager found.

Excel 2013 In case you haven’t installed powerquery yet, it can be as an add-in for Excel. Create a testing environment in DB2 For managing DB2 we have the data studio we installed, but we also have a command line based tool to our disposal. For the creation of the database and a test table, we will use the command line tool. For filling up the table, we will use data studio (I’m doing all of the following steps while logged on under my domain account (domain groenyv), not the db2_dba local admin account. So all the objects created will be created under this domain account). Create database and test table First run the DB2 command window: You notice you are going to the install folder. At this path you will find different applications you can use to manage your DB2 environment.

We will use the db2.exe. Then we simply issue a create database statement: To list all the databases issue the following command: To connect to this database we have to issue the following command: Notice that the authorization ID is my domain account. Next we create a test table. To get an overview of all the tables issue the following command: Notice that the table schema is my domain account.

Next we create a test table: To get an overview of all the tables issue the following command: Notice that the table schema is my domain account. Fill up test table For this part we will use the data studio which provides a graphical user interface much like SQL Server management studio. First we connect a new database connection: There we use the default IBM Data Server Driver and fill in the database info.

Then you can test connection: After that we open a query window. You will have to select the database connection we just created. Then we do some simple inserts and a select: So now we are ready to open up Excel to connect extract this data. Excel Open Excel Open the powerquery tab Select “From database” and click on IBM DB2 database: Specify the server, the database and the sql instruction: And finally we get to see our DB2 data in Powerquery: In case you experiencing problems connecting because the IBM DB2 Data Server Driver is not installed on the computer, you should visit the following.

I downloaded the x86 UDB/Linux zip. I'm running VirtualBox under Windows, and have set up a CentOS partition expressly (!) for running DB2 Express-C. Does anyone know how to get VirtualBox pointing to a ZIP that's not on the LinuxFS (It's on the Windows NTFS but I can move it to FAT64 if that'll help)? Phil Sevetson, having a clueless moment. ________________________________ From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Leon Katsnelson Sent: Saturday, June 11, 2011 8:40 AM To: [login to unmask email] Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage DB2 Express is not free. DB2 Express-C is free and it is available for Linux, Windows, Solaris x86, and as a beta for Mac OS X. You will find all this and a lot more at and also on my blog at Leon Katsnelson Program Director, IM Cloud Computing Center of Competence and Evangelism From: [login to unmask email] To: [login to unmask email] Date: 2011/06/10 07:39 PM Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage Sent by: IDUG DB2-L ________________________________ db2 express is free for everyone Renu In a message dated 6/9/2011 1:46:09 P.M.

Central Daylight Time, [login to unmask email] writes: Hello All, Seeking information on the usage of DB2 on Linux, UNIX and Windows. Dose anyone have any idea of which platform has the most users, Linux, UNIX or Windows. Also, I understand years ago their was a Windows version that was free or almost free for developers, or did I just dream this up? If not, where can I get my hands on a copy. ________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. ________________________________ [ ] The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. ___________________________________________________________________ IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * ___________________________________________________________________ International DB2 User Group (IDUG) - Independent, not-for-profit, User Run Your only source for independent, unbiased, and trusted DB2 information. Phil, You want to SCP the file to the image.

You could use Samba to access a Windows share from Linux but that is way more complex. Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer. HTH Phil N From my Android phone On Jun 13, 2011 3:29 PM, 'Sevetson, Phil' wrote: >Okay.

I downloaded the x86 UDB/Linux zip. I'm running VirtualBox under Windows, and have set up a CentOS partition expressly (!) for running DB2 Express-C. >>Does anyone know how to get VirtualBox pointing to a ZIP that's not on the LinuxFS (It's on the Windows NTFS but I can move it to FAT64 if that'll help)? >>Phil Sevetson, having a clueless moment. >>________________________________ >From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Leon Katsnelson >Sent: Saturday, June 11, 2011 8:40 AM >To: [login to unmask email] >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >>DB2 Express is not free. DB2 Express-C is free and it is available for Linux, Windows, Solaris x86, and as a beta for Mac OS X. You will find all this and a lot more at and also on my blog at >>>Leon Katsnelson >Program Director, IM Cloud Computing Center of Competence and Evangelism >>>>>>>>>>>>>From: [login to unmask email] >To: [login to unmask email] >Date: 2011/06/10 07:39 PM >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >Sent by: IDUG DB2-L >>________________________________ >>>>db2 express is free for everyone >Renu >>In a message dated 6/9/2011 1:46:09 P.M.

Central Daylight Time, [login to unmask email] writes: >Hello All, >Seeking information on the usage of DB2 on Linux, UNIX and Windows. >Dose anyone have any idea of which platform has the most users, Linux, UNIX or Windows. >>Also, I understand years ago their was a Windows version that was free or almost free for developers, or did I just dream this up?

If not, where can I get my hands on a copy. >>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG.

If you are not already an IDUG member, please register here. >>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. >>>________________________________ >>[ >>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. Phil N., Thanks.

________________________________ From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Philip Nelson Sent: Monday, June 13, 2011 11:50 AM To: [login to unmask email] Subject: Re: [DB2-L] DB2 Express-C for Linux/X86 on VirtualBox running CentOS Phil, You want to SCP the file to the image. You could use Samba to access a Windows share from Linux but that is way more complex. Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer. HTH Phil N From my Android phone On Jun 13, 2011 3:29 PM, 'Sevetson, Phil' >wrote: >Okay. I downloaded the x86 UDB/Linux zip. I'm running VirtualBox under Windows, and have set up a CentOS partition expressly (!) for running DB2 Express-C.

>>Does anyone know how to get VirtualBox pointing to a ZIP that's not on the LinuxFS (It's on the Windows NTFS but I can move it to FAT64 if that'll help)? >>Phil Sevetson, having a clueless moment. >>________________________________ >From: IDUG DB2-L [mailto:[login to unmask email]] On Behalf Of Leon Katsnelson >Sent: Saturday, June 11, 2011 8:40 AM >To: [login to unmask email] >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >>DB2 Express is not free. DB2 Express-C is free and it is available for Linux, Windows, Solaris x86, and as a beta for Mac OS X. You will find all this and a lot more at and also on my blog at >>>Leon Katsnelson >Program Director, IM Cloud Computing Center of Competence and Evangelism >>>>>>>>>>>>>From: [login to unmask email] >To: [login to unmask email] >Date: 2011/06/10 07:39 PM >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >Sent by: IDUG DB2-L >>>________________________________ >>>>db2 express is free for everyone >Renu >>In a message dated 6/9/2011 1:46:09 P.M.

Central Daylight Time, [login to unmask email] writes: >Hello All, >Seeking information on the usage of DB2 on Linux, UNIX and Windows. >Dose anyone have any idea of which platform has the most users, Linux, UNIX or Windows. >>Also, I understand years ago their was a Windows version that was free or almost free for developers, or did I just dream this up? If not, where can I get my hands on a copy.

>>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. >>>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. >>>>________________________________ >>[ ] >>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

>>___________________________________________________________________ >>IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * >___________________________________________________________________ >International DB2 User Group (IDUG) - Independent, not-for-profit, User Run >Your only source for independent, unbiased, and trusted DB2 information >>________________________________ [ ] The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. ___________________________________________________________________ IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * ___________________________________________________________________ International DB2 User Group (IDUG) - Independent, not-for-profit, User Run Your only source for independent, unbiased, and trusted DB2 information. >Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer. Try fiddling with the content of /etc/redhat-release. Kind regards, Frederik On Mon, Jun 13, 2011 at 5:49 PM, Philip Nelson wrote: >Phil, >>You want to SCP the file to the image. >>You could use Samba to access a Windows share from Linux but that is way >more complex.

>>Be aware that TSA/MP will not install under CentOS since the Linux distro >checking is pretty strict in its installer. >>HTH >>Phil N >From my Android phone >On Jun 13, 2011 3:29 PM, 'Sevetson, Phil' wrote: >>Okay. I downloaded the x86 UDB/Linux zip. I'm running VirtualBox under >Windows, and have set up a CentOS partition expressly (!) for running DB2 >Express-C. >>>>Does anyone know how to get VirtualBox pointing to a ZIP that's not on >the LinuxFS (It's on the Windows NTFS but I can move it to FAT64 if that'll >help)? >>>>Phil Sevetson, having a clueless moment. >>>>________________________________ >>From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Leon >Katsnelson >>Sent: Saturday, June 11, 2011 8:40 AM >>To: [login to unmask email] >>Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >>>>DB2 Express is not free.

DB2 Express-C is free and it is available for >Linux, Windows, Solaris x86, and as a beta for Mac OS X. You will find all >this and a lot more at and also on my blog >at >>>>>>>Leon Katsnelson >>Program Director, IM Cloud Computing Center of Competence and Evangelism >>>>>>>>>>>>>>>>>>>>>>>>>>From: [login to unmask email] >>To: [login to unmask email] >>Date: 2011/06/10 07:39 PM >>Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >>Sent by: IDUG DB2-L >>>>________________________________ >>>>>>>>db2 express is free for everyone >>Renu >>>>In a message dated 6/9/2011 1:46:09 P.M. Central Daylight Time, >[login to unmask email] writes: >>Hello All, >>Seeking information on the usage of DB2 on Linux, UNIX and Windows. >>Dose anyone have any idea of which platform has the most users, Linux, >UNIX or Windows. >>>>Also, I understand years ago their was a Windows version that was free or >almost free for developers, or did I just dream this up? If not, where can I >get my hands on a copy. >>>>>>Ed.

>>>>>>________________________________ >>>>>>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you >are not already an IDUG member, please register here. >>>>>>>>________________________________ >>>>>>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you >are not already an IDUG member, please register here.

>>>>>>>>________________________________ >>>>[ >>>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you >are not already an IDUG member, please register here.

>>>>___________________________________________________________________ >>>>IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * >>>___________________________________________________________________ >>International DB2 User Group (IDUG) - Independent, not-for-profit, User >Run >>Your only source for independent, unbiased, and trusted DB2 information >>>>>>------------------------------ >>[image: Introducing IBM® DB2® 10 for z/OS ] >>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are >not already an IDUG member, please register here.

>___________________________________________________________________ IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * ___________________________________________________________________ International DB2 User Group (IDUG) - Independent, not-for-profit, User Run Your only source for independent, unbiased, and trusted DB2 information. I run VMWare Fusion on my Mac so I am not an expert in VirtualBox. Here is what I found in one of the forums: You can add a share to the virtual machine which you can map as a network drive. You'll have to have installed the Guest Additions for XP. Mad Wave more.

It's most concisely explained in the user manual in chapter 4.6 (Folder sharing) page 61 ( Quote: Originally Posted by VirtualBox User Manual 4.6 Folder sharing Shared folders allow you to access files of your host system from within the guest system, much like ordinary shares on Windows networks would – except that shared folders do not need a networking setup. Shared folders must physically reside on the host and are then shared with the guest; sharing is accomplished using a special service on the host and a file system driver for the guest, both of which are provided by VirtualBox. In order to use this feature, the VirtualBox Guest Additions have to be installed. Note however that Shared Folders are only supported with Windows (2000 or newer) guests and Linux guests.

To share a host folder with a virtual machine in VirtualBox, you must specify the path of that folder and choose for it a “share name” that the guest can use to access it. Hence, first create the shared folder on the host; then, within the guest, connect to it.

There are several ways in which shared folders can be set up for a particular virtual machine: • In the graphical user interface of a running virtual machine, you can select “Shared folders” from the “Devices” menu, or click on the folder icon on the status bar in the bottom right corner of the virtual machine window. • If a virtual machine is not currently running, you can configure shared folders in each virtual machine’s “Settings” dialog. • From the command line, you can create shared folders using the the VBoxManage command line interface; see chapter 8, VBoxManage reference, page 98. The command is as follows: VBoxManage sharedfolder add 'VM name' -name 'sharename' -hostpath 'C: test' There are two types of shares: 1. VM shares which are only available to the VM for which they have been defined; 2. Transient VM shares, which can be added and removed at runtime and do not persist after a VM has stopped; for these, add the -transient option to the above command line.

Shared folders have read/write access to the files at the host path by default. To restrict the guest to have read-only access, create a read-only shared folder. This can either be achieved using the GUI or by appending the parameter -readonly when creating the shared folder with VBoxManage. Then, you can mount the shared folder from inside a VM the same way as you would mount an ordinary network share: • In a Windows guest, starting with VirtualBox 1.5.0, shared folders are browseable and are therefore visible in Windows Explorer. So, to attach the host’s shared folder to your Windows guest, open Windows Explorer and look for it under “My Networking Places” ->“Entire Network” ->“VirtualBox Shared Folders”. By right-clicking on a shared folder and selecting “Map network drive” from the menu that pops up, you can assign a drive letter to that shared folder. Alternatively, on the Windows command line, use the following: net use x: vboxsvr sharename While vboxsvr is a fixed name (note that vboxsrv would also work), replace “x:“ with the drive letter that you want to use for the share, and sharename with the share name specified with VBoxManage.

I would like to make a general comment for everyone going through the process of getting virtual machines on their laptops just to experiment or learn DB2 Express-C. You may want to take a look at DB2 Express-C on the cloud instead. If you don't have an account you can use it free of charge for a year. It takes minutes to get set up and you don't have to overburden your machine with poorly performing virtual machines.

The only down side is that you do have to have internet connectivity. Follow this short tutorial to set up a DB2-backed website and run it free for a year If you are interested in taking an early peek at the next version of DB2 for LUW and you want to do it on the cloud instead of hunting for a server, installing and patching software only to have to go and do it again when we update the code, apply here While there will be charges for the cloud resources (not for DB2), we can offer very sizable credit to offset these charges i.e. You should be able to get everything you need free of charge. If you are a DB2 for z/OS person, don't despair, DB2 Early Experience program has a lot to offer. You may be interested in the new features in DB2 for z/OS v10 but don't have access to the system to learn. The upcoming version of DB2 for LUW has many of these features and using it on the cloud is a great way to learn. Leon Katsnelson Program Director, IM Cloud Computing Center of Competence and Evangelism From: Frederik Engelen To: [login to unmask email] Date: 2011/06/13 05:46 PM Subject: Re: [DB2-L] DB2 Express-C for Linux/X86 on VirtualBox running CentOS Sent by: IDUG DB2-L >Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer.

Try fiddling with the content of /etc/redhat-release. Kind regards, Frederik On Mon, Jun 13, 2011 at 5:49 PM, Philip Nelson wrote: Phil, You want to SCP the file to the image. You could use Samba to access a Windows share from Linux but that is way more complex. Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer. HTH Phil N From my Android phone On Jun 13, 2011 3:29 PM, 'Sevetson, Phil' wrote: >Okay. I downloaded the x86 UDB/Linux zip. I'm running VirtualBox under Windows, and have set up a CentOS partition expressly (!) for running DB2 Express-C.

>>Does anyone know how to get VirtualBox pointing to a ZIP that's not on the LinuxFS (It's on the Windows NTFS but I can move it to FAT64 if that'll help)? >>Phil Sevetson, having a clueless moment. >>________________________________ >From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Leon Katsnelson >Sent: Saturday, June 11, 2011 8:40 AM >To: [login to unmask email] >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >>DB2 Express is not free. DB2 Express-C is free and it is available for Linux, Windows, Solaris x86, and as a beta for Mac OS X. You will find all this and a lot more at and also on my blog at >>>Leon Katsnelson >Program Director, IM Cloud Computing Center of Competence and Evangelism >>>>>>>>>>>>>From: [login to unmask email] >To: [login to unmask email] >Date: 2011/06/10 07:39 PM >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >Sent by: IDUG DB2-L >>________________________________ >>>>db2 express is free for everyone >Renu >>In a message dated 6/9/2011 1:46:09 P.M.

Central Daylight Time, [login to unmask email] writes: >Hello All, >Seeking information on the usage of DB2 on Linux, UNIX and Windows. >Dose anyone have any idea of which platform has the most users, Linux, UNIX or Windows. >>Also, I understand years ago their was a Windows version that was free or almost free for developers, or did I just dream this up?

If not, where can I get my hands on a copy. >>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

>>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

>>>________________________________ >>[ >>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. >___________________________________________________________________ >>IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * >___________________________________________________________________ >International DB2 User Group (IDUG) - Independent, not-for-profit, User Run >Your only source for independent, unbiased, and trusted DB2 information >>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. ___________________________________________________________________ IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * ___________________________________________________________________ International DB2 User Group (IDUG) - Independent, not-for-profit, User Run Your only source for independent, unbiased, and trusted DB2 information. Leon, Thanks very much for the manualpage - I didn't have a clue that it was out there. Thanks also for the time spent researching.

________________________________ From: IDUG DB2-L [mailto:[login to unmask email] On Behalf Of Leon Katsnelson Sent: Monday, June 13, 2011 6:32 PM To: [login to unmask email] Subject: Re: [DB2-L] DB2 Express-C for Linux/X86 on VirtualBox running CentOS I run VMWare Fusion on my Mac so I am not an expert in VirtualBox. Here is what I found in one of the forums: You can add a share to the virtual machine which you can map as a network drive. You'll have to have installed the Guest Additions for XP. It's most concisely explained in the user manual in chapter 4. Swords And Sandals 2 Full Version Free Download Torrent. 6 (Folder sharing) page 61 ( Quote: I would like to make a general comment for everyone going through the process of getting virtual machines on their laptops just to experiment or learn DB2 Express-C. You may want to take a look at DB2 Express-C on the cloud instead.

If you don't have an account you can use it free of charge for a year. It takes minutes to get set up and you don't have to overburden your machine with poorly performing virtual machines. The only down side is that you do have to have internet connectivity. Follow this short tutorial to set up a DB2-backed website and run it free for a year If you are interested in taking an early peek at the next version of DB2 for LUW and you want to do it on the cloud instead of hunting for a server, installing and patching software only to have to go and do it again when we update the code, apply here While there will be charges for the cloud resources (not for DB2), we can offer very sizable credit to offset these charges i.e. You should be able to get everything you need free of charge.

If you are a DB2 for z/OS person, don't despair, DB2 Early Experience program has a lot to offer. You may be interested in the new features in DB2 for z/OS v10 but don't have access to the system to learn. The upcoming version of DB2 for LUW has many of these features and using it on the cloud is a great way to learn.

Leon Katsnelson Program Director, IM Cloud Computing Center of Competence and Evangelism From: Frederik Engelen To: [login to unmask email] Date: 2011/06/13 05:46 PM Subject: Re: [DB2-L] DB2 Express-C for Linux/X86 on VirtualBox running CentOS Sent by: IDUG DB2-L ________________________________ >Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer. Try fiddling with the content of /etc/redhat-release. Kind regards, Frederik On Mon, Jun 13, 2011 at 5:49 PM, Philip Nelson >wrote: Phil, You want to SCP the file to the image. You could use Samba to access a Windows share from Linux but that is way more complex. Be aware that TSA/MP will not install under CentOS since the Linux distro checking is pretty strict in its installer. HTH Phil N From my Android phone On Jun 13, 2011 3:29 PM, 'Sevetson, Phil' >wrote: >Okay.

I downloaded the x86 UDB/Linux zip. I'm running VirtualBox under Windows, and have set up a CentOS partition expressly (!) for running DB2 Express-C. >>Does anyone know how to get VirtualBox pointing to a ZIP that's not on the LinuxFS (It's on the Windows NTFS but I can move it to FAT64 if that'll help)? >>Phil Sevetson, having a clueless moment. >>________________________________ >From: IDUG DB2-L [mailto:[login to unmask email]] On Behalf Of Leon Katsnelson >Sent: Saturday, June 11, 2011 8:40 AM >To: [login to unmask email] >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >>DB2 Express is not free. DB2 Express-C is free and it is available for Linux, Windows, Solaris x86, and as a beta for Mac OS X. You will find all this and a lot more at and also on my blog at >>>Leon Katsnelson >Program Director, IM Cloud Computing Center of Competence and Evangelism >>>>>>>>>>>>>From: [login to unmask email] >To: [login to unmask email] >Date: 2011/06/10 07:39 PM >Subject: Re: [DB2-L] DB2 for Linux UNIX and Windows usage >Sent by: IDUG DB2-L >>>________________________________ >>>>db2 express is free for everyone >Renu >>In a message dated 6/9/2011 1:46:09 P.M.

Central Daylight Time, [login to unmask email] writes: >Hello All, >Seeking information on the usage of DB2 on Linux, UNIX and Windows. >Dose anyone have any idea of which platform has the most users, Linux, UNIX or Windows. >>Also, I understand years ago their was a Windows version that was free or almost free for developers, or did I just dream this up? If not, where can I get my hands on a copy. >>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here.

>>>>________________________________ >>>>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. >>>>________________________________ >>[ ] >>The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. >>___________________________________________________________________ >>IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * >___________________________________________________________________ >International DB2 User Group (IDUG) - Independent, not-for-profit, User Run >Your only source for independent, unbiased, and trusted DB2 information >>________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. ________________________________ The IDUG DB2-L Listserv is only part of your membership in IDUG.

If you are not already an IDUG member, please register here. ________________________________ [ ] The IDUG DB2-L Listserv is only part of your membership in IDUG. If you are not already an IDUG member, please register here. ___________________________________________________________________ IDUG DB2 Tech Conference * Prague, Cz * 14-18 Nov 2011 * ___________________________________________________________________ If you need to change settings, is the home of IDUG's Listserv.