Db2 Express C Db2 Install Graphical Mode
For our current pet project we’ve decided to use DB2 Express-C as a database back-end. The choice is made, so our junior developers could practice their art on databases that resemble enterprise databases more than MySQL or Postgres. (We have already ruled out SAPDB/MaxDB on previous occasions.) First off the system I’m trying to install the server is remotely located, and doesn’t have any kind of X on it. This rules out all kind of graphical installs, but I never was fond of those anyway. The system is running a Debian testing, with pretty strict firewall rules.
The install went easy, but with a few glitches. First off I’ve downloaded the installer from.
This required my PartnerWorld password, so I guess it’s not as easy to get as it seems. Then I’ve unpacked the installer and went on to install as root (this is usual for most installs, but almost mandatory for IBM products) This turned out to be a mistake later, as Express-C is different from other enterprise DB2-s. It’s preferred to be installed as a DB user, unless you want to run several instances on a given machine (not common for a single-shot pet-project). The install went on fine with the console mode, and as a nice feature, even the text-mode installer shows a time estimate for each step. After installing the application several times, I went to read some documentation, as I couldn’t find any of the tools I was used to on DB2 EE 8.2. The IBM Infocenter is always a good idea to look up such informations, see the one I looked. Unfortunately all manuals described the startup as a simple process, all starting with the usual loading of DB2 profile, and then starting up the db with the db2start command.
Your personal information and card details are 100% secure. You will need this if you want to use the DB2 graphical installer. The easy way to install DB2 Express-C. Install the DB2 Express-C database. Follows is not listed in the standard DB2 Express-C installation guide. Demand sample application — multi-user mode. Your personal information and card details are 100% secure. You will need this if you want to use the DB2 graphical installer. The easy way to install DB2 Express-C.
Unfortunately it always threw an error message, which to be a problem with the default shared memory size. The simple solution is to add the lines: kernel.msgmni = 1024 kernel.shmmax = 268435456 to the /etc/sysctl.conf file and then applying the changes with the sysctl -p command. The db then started up fine, but as it turned out I should not be running the non-root installation, as that only permits local “APP” level connections. Blazevideo dvd copy torrent. So I’ve created the system users dasadm, db2inst for later use. Mkdir /data/db2 adduser -system dasadm -home /data/db2/dasadm touch /data/db2/dasadm/.profile chown dasadm.nogroup /data/db2/dasadm/.profile adduser -system db2inst -home /data/db2/db2inst touch /data/db2/ db2inst /.profile chown db2inst.nogroup /data/db2/ db2inst /.profile Then the entire DB was reinstalled using the root user. Creating an admin server The admin server is used to monitor, and manage your DB2 instances on a system.
Db2 Express C Installation
To create and start service, issue the commands: chsh dasadm -s/bin/sh DB2HOME/instance/dascrt dasadm There seems to be some error on the current version of DB2, the admin server keeps sending messages like: The state of instance 'dasadm' gcf module '/opt/ibm/db2/V9.5/das/lib/libdb2dasgcf.so.1' is OPERABLE (OFFLINE). I could not yet locate the actual reason, but to disable this message it’s great to turn the db2fmd off. That can be achieved by commenting out the respectable lines in the inittab, and then reloading the inittab with: init q I’ll keep this off until I find some way to work around the current problem. Creating a db instance The DB2 instance was created and started using the following commands, as root: DB2HOME/instance/db2icrt -u db2inst db2inst DB2HOME/instance/db2istrt -u db2inst db2inst command. When using the command one must make sure the provided ID actually HAS A SHELL! Of course it took me quite a while to find that out. Getting the Control Center to work First off I thought it would be a good idea to just forward the DB2CC X11 output to my computer.
To get X forwarding on the server I tried doing what I read. After installing the xauth package I was able to forward my favorite X application (xteddy) through to my desktop. There still seems to be a problem, that the window content is not forwarded, even thought the bear shaped window appears. However when I switch over to another user (root and then to db2inst) it simply fails to forward the X. It turned out that the xauth must be copied over to the user that is to be authorized using a command like: xauth -f /home/MYUSER/.Xauthority extract /root/.Xauthority:0 I could not however use this, to extract the xauth from my user directly to the db2inst user.
Cutting the crap, I’ve got fed up with the xauth, so I just thrown in a shell for the db2inst user, and authorized my user to log-in remotely. Then X11 forwarding worked straight away, and I was able to forward the db2cc without any problem. It’s quite slow, but what the heck?
The speed problem can be helped a bit by adding a -C (compress) parameter to the ssh. It speeds the connection up almost to the level of running it on the local network through my ADSL connection. Summarizing After wasting hours on trying to set things up I got some problem starting up the administrator instance, being unable to trace it down to the root of the problem, I uninstalled the entire installation, wiped the install directory and started up the install in graphical mode as root with copying the X authorization as described above. The installer was running for about 5 minutes, and created and configured the basic DB instance.
One of the following three error symptoms might be encountered during installation on Windows 8.1 & Windows 2012 R2. GUI mode of Domain installation might fail with the 'Windows installer has stopped working' error on 'Select the installation type' Dialog. GUI mode of Fix Pack update installation may fail with the following error: 3. Shortcuts created under All Apps for the default DB2 copy do not start on invocation immediately after installation. With DB2 V10.1, the db2prereqcheck tool reports Windows 8.1 and Windows 2012 R2 as not supported platform: Checking DB2 prerequisites for DB2 database version '10.1.0.3' on operating system 'Windows' OS is Windows 'Server' ERROR: Requirement not matched. Requirement not matched for DB2 database 'Server'. Version: '10.1.0.3'.
Summary of prerequisites that are not met on the current system: Requirement not matched for DB2 database 'Server'. Version: '10.1.0.3'. For the currently available fix packs, choose the silent installation method using response files in the following scenarios as we do not have fully enabled GUI installs yet. This helps avoid the first two errors listed in the symptom section: 1. Domain installation 2. Fix Pack update installation Further instructions on performing a silent installation using response files can be found in the 'Related information' section below. Also, if the shortcuts created under the All Apps directory for the DB2 copy do not start on invocation after the installation of DB2 for Windows either through the GUI or silent installation, log off and log back on again.
Db2 Express C Limitations
The db2prereqcheck tool reports Windows 8.1 and Windows 2012 R2 as not supported platforms for DB2. However, installation can be performed on these platforms using the resolutions provided in this document. These possible issues are resolved in 10.5 Fix Pack 4. In 10.1 Fix Pack 4, the first two and the fourth issue are addressed. The third issue will be addressed in the future fix pack of 10.1. Related information.