The first download packages for the DB2 Express-C 9.5.2 refresh are now available. The 9.5.2 refresh level includes integrated Text Search as well as many other fixes, enhancements, and changes.
When images for all the platforms are ready, we intend for this beta to become the general 9.5.2 release.
The updated Windows 32-bit image should install correctly on all Windows locales. Updated Visual Studio Add-ins are available alongside the Windows beta. md5sums will be added to the wiki shortly.
Quick question though: do we need (or will there be) an updated DB2 Runtime Client to work with Express-C 9.5.2, or should the existing 9.5 Runtime Client work as is?
I've freshly installed DB2 Express-C 9.5.2 64-bit Linux, created a fresh database, and enabled it for text searching. But when I try to create a text search index, I get:
CIE00340 Cannot start executable program "cieadmsv"
Any ideas where to start looking? Nothing is appearing in the db2diag.log
there is long standing (from db2 v8) bug in db2 instance creating, file .fenced has incorrect owner and permissions. Search this forum for my post about how to fix it or search IBM Support documents.
you need to have your linux kernel Shared memory and semaphores limits configured as noted in db2 installation manual, this prevents text searching from starting as well.
It took us 1 week to get this problem fixed mainly because recommended persmissions on .fenced file in ibm document were incorrect, so we tried all possible combos including changing file owner and group until we managed to get it right. It is linux only problem, on AIX it works even with bad persmissions and this confused us.
Thanks Z-Company!! As you pointed out, I needed to change the .fenced file's group to match the primary group of the db2 instance user.
Actually, there were a number of other things I had to do too... which may or may not be related. The installer actually failed to create the DAS user, and thus the DAS server was not created either. So, in the end, I had to:
root ~] /opt/ibm/db2/V9.5/instance/dasdrop
root ~] rm -f /home/dasusr1
root ~] /usr/sbin/useradd -g dasadm1 -m -d /home/dasusr1 dasusr1
root ~] /opt/ibm/db2/V9.5/instance/dascrt -u dasusr1
DBI1766W Cannot change the secondary group list of db2inst1.
root ~] /usr/sbin/usermod -G dasadm1 db2inst1
db2inst1 ~] db2 "UPDATE ADMIN CONFIGURATION USING DASADM_GROUP dasadm1"
db2inst1 ~] db2 "CREATE TOOLS CATALOG SYSTOOLS USE EXISTING DATABASE TOOLSDB FORCE"
root ~] chown db2fenc1:db2iadm1 /home/db2inst1/sqllib/adm/.fenced
db2inst1 ~] db2ts "STOP FOR TEXT"
db2inst1 ~] db2ts "START FOR TEXT"
So now it all seems to work the same as 9.5.0 did.
I probably should have asked this last night (but it was late, and I was tired): how/where should we report issues with Express-C 9.5.2 Beta... for example, with problems like this one, would you (IBM) prefer us to create new Express-C threads? Or add them to this 9.5.2 Beta thread? On the one hand, it's not good to hi-jack this thread... but then, do other forum members want to see multiple topics specific to a "beta" version? Doesn't bother me either way, so just let me know what you prefer :)
Thanks again Z-Company!! And thanks IBM for the new version! :)
No probs, I'll create separate topics if (when) anything else comes up. :)
The above install was on Fedora Core 5. I will be performing the same install on a Fedora Core 8 box in a couple of days, so I'll let you know if that's any different.
I read the license terms of this DB2 Express-C 9.5.2, some as below. Regarding 3), does this mean we can only use it for free within 1 year? If so, what is the difference between trial version and DB2 Express-C ? Thanks a lot.
3) Fixed Term - 12 Months License and Subscription
3.1) Usage Terms
If You acquire the Program under a Fixed Term License the following terms apply: Use of the Program is governed under the International Program License Agreement. You may use the Program only for a limited period of time, called "Fixed Term". The Fixed Term will be specified in your PoE. At the end of the Fixed Term, Your authorization to use the Program terminates and You agree to discontinue use of the Program. IBM may agree to extend the Fixed Term for an additional payment. If You wish to continue to use the Program beyond the Fixed Term, contact IBM or your DB2 reseller prior to the expiration of the Fixed Term.
3.2) License Key Registration
After acquiring the Program under a Fixed Term License, You agree to register the appropriate license key using the included DB2 License Center component. The license key is included with Your PoE. At the end of the Fixed Term, You agree to deregister the license key from the DB2 License Center.
Express-C has a permanent free license that you can use indefinitely.
If you buy support and extra features -- under the Fixed Term License -- they will last for one year. Afterwards, FTL will automatically turn back into regular free Express-C which you can still use indefinitely.
I saw this and I jumped for joy that IBM is finally looking at Mac again:
Mac OS X Leopard 64-bit (Intel)
But my joy was short lived when I noticed the "(Intel)". I have a PowerPC Quad G5 running Leopard.
What's wrong with the G5, after all it's YOUR processor!
Tags
Use the search field to
find all types of content in My developerWorks with that tag.
Use the slider bar to see more or fewer tags.
Popular tags shows the top tags for this particular type of content or application that you're viewing.
My tags shows your tags for this particular type of content or application that
you're viewing.
