Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Reply
 
Thread Tools Search this Thread Display Modes
Old Dec 21, 2008, 01:41 PM   #1
AlmostThere
macrumors 6502a
 
Join Date: Feb 2005
Location: The royal throne of kings, the sceptred isle, the other Eden, the fortress built
DB2 Beta Released for OS X

Don't expect this to be considered a major news item, but for anyone interested in databases, and there should be a few on this forum, IBM have (finally and long last after many years of hints and suggestions) released 9.5.2 Express-C for OS X.

It is 64-Bit, Intel Leopard only. Installation doesn't seem straightforward at the moment, certainly not up to Linux or Windows installers (haven't installed yet, hope to sort it out over Christmas break). Don't expect anything along the lines of the MySQL ease of use and set-up for the time being, it is very much along the lines of "OS X is UNIX", not "OS X is a user-friendly OS".

This is the free version and currently a beta release - it is only really good for development and only time will tell if IBM go the full server route. I am just happy to see tangible progress made to support OS X as development platform.

Anyway, thought people might be interested.

http://www-01.ibm.com/software/data/...&S_TACT=mac952
__________________
Join the army of the dead: http://www.urbandead.com

Last edited by AlmostThere; Dec 21, 2008 at 01:42 PM. Reason: Add link
AlmostThere is offline   0 Reply With Quote
Old Dec 21, 2008, 07:23 PM   #2
toddburch
macrumors 6502a
 
Join Date: Dec 2006
Location: Katy, Texas
Send a message via AIM to toddburch Send a message via MSN to toddburch
Woo-Hoo! Finally, something I am familiar with on the MAC!! WOO-HOO!

I'll download and report back.
toddburch is offline   0 Reply With Quote
Old Dec 22, 2008, 03:56 PM   #3
AlmostThere
Thread Starter
macrumors 6502a
 
Join Date: Feb 2005
Location: The royal throne of kings, the sceptred isle, the other Eden, the fortress built
Well, installation is not without a few hiccups, you need to create or edit /etc/sysctl.conf with this content:

kern.sysv.shmmax=1073741824
kern.sysv.shmmin=1
kern.sysv.shmmni=4096
kern.sysv.shmseg=32
kern.sysv.shmall=1179648
kern.maxfilesperproc=65536
kern.maxfiles=65536

It isn't entirely clear which tools are included - as far as I can see it is simply the database server, and not the administration server or management client software. This is clearly a beta release.

On the other hand, this is more than enough to build and develop with, especially since deployment will be on Windows / Linux. I will try and get some stuff running on this over the next few weeks and see how it fairs with some data, especially compared to parallels.

(There is a thread on this on the DB2 support forums, apparently more documentation will follow).
__________________
Join the army of the dead: http://www.urbandead.com

Last edited by AlmostThere; Dec 22, 2008 at 04:10 PM.
AlmostThere is offline   0 Reply With Quote
Old Jun 29, 2009, 01:33 PM   #4
duggram
macrumors 6502
 
Join Date: Apr 2008
Any updates on using DB2?
duggram is offline   0 Reply With Quote
Old Jun 29, 2009, 05:19 PM   #5
pilotError
macrumors 68020
 
pilotError's Avatar
 
Join Date: Apr 2006
Location: Long Island
All those values are pretty much commonplace among Linux for Databases. Same goes with Oracle and Sybase.

So how is it going so far?
pilotError is offline   0 Reply With Quote
Old Jun 30, 2009, 02:59 PM   #6
AlmostThere
Thread Starter
macrumors 6502a
 
Join Date: Feb 2005
Location: The royal throne of kings, the sceptred isle, the other Eden, the fortress built
For me it has been running fine. I am using it to store sampled data so I can work away from the office to a certain extent, and almost exclusively in Java / shell.

I haven't used to CLI from c/c++, PHP, Ruby or Python bindings (I believe these are all working though). I would like to see if there is a way to get an ODBC connection working for Excel but I have been too busy to look into this.

More than anything, I am aggregating and sorting data. In terms of general performance, my core data sets range between 5 and 10 million records, which are grouped and aggregated by an unindexed field in ~20 seconds (with Java data IDE and Java development IDE running on my work 2.x Ghz MBP with 2Gb RAM). Joining the same query to a dimension table with ~5 million records drives this up to ~5 mins (depends on indexes, result set ~0.5m records). All the olap functions I use on a regular basis are present.

Downside - there doesn't seem to be any sort of real management software (as on Windows and other Unix) so all table stats need to be generated manually / cron-ed, same goes for data transfer. I needed to create a launchd job to start it off on booting.

Defaults parameters needed tweaking (log file size, buffer pools etc.) and almost certainly some performance improvements can be found but I am not going to spend too much time DBA-ing.

It is miles better than SQL Server (or anything) on Parallels, though, which tended to balk at anything more than a few K rows (obviously disk access horrendous). I am not holding out hope for MS to port SQLS to the Mac ... although they would make me very happy if they did.

It has been a while since I tried to get MySQL doing anything similar (was very unhappy with anything 1 million rows and really seems happier as a web DB rather than for any sort of number crunching not to mention the weird syntax, although i confess I know much less about improving MySQL performance) and have never tried Oracle on OS X - I was rather under the impression it had been largely abandoned and is the about the one DBMS we don't have at work.

Overall, there is quite a bit of overhead but it by far the best DB I have found, for me, on a Mac.
__________________
Join the army of the dead: http://www.urbandead.com
AlmostThere is offline   0 Reply With Quote
Old Jun 30, 2009, 05:20 PM   #7
Cromulent
macrumors 603
 
Cromulent's Avatar
 
Join Date: Oct 2006
Location: The Land of Hope and Glory
Quote:
Originally Posted by AlmostThere View Post
Overall, there is quite a bit of overhead but it by far the best DB I have found, for me, on a Mac.
Have you tried PostgreSQL? If so I would be interested to hear how it compares.

I gave up on MySQL pretty quickly and MSSQL is obviously out of the question and from looking at pricing DB2 seems quite reasonable for a small single user license. Oracle is obviously too expensive and I am not even sure if it is the best bet really for what I want to do anyway.
__________________
Neural Advance - Mac OS X, UNIX and Windows Development
Last.fm Profile | Extreme Metal Reviews
MP 4x 2.66Ghz Xeons / 6GB RAM / 640GB + 500GB + 750GB + 1TB HDDs / ATI Radeon 4870 / iPad 3
Cromulent is offline   0 Reply With Quote
Old Jul 1, 2009, 03:21 PM   #8
adrian.oconnor
macrumors 6502
 
Join Date: Jan 2008
Location: Nottingham, England
Quote:
Originally Posted by Cromulent View Post
Have you tried PostgreSQL? If so I would be interested to hear how it compares.

I gave up on MySQL pretty quickly and MSSQL is obviously out of the question and from looking at pricing DB2 seems quite reasonable for a small single user license. Oracle is obviously too expensive and I am not even sure if it is the best bet really for what I want to do anyway.
Postgres is awesome -- IMHO it's on a par with Oracle, but without the many 'add-on' features (things that typical users will never need) that you get with Oracle Enterprise. pg/sql is nearly identical to Oracle's pl/sql -- in several ways it's actually better (which is annoying when you then go back to Oracle -- you really miss the serial data type and the 'returning' keyword). I've never used DB2 properly, though I did once spend a good few days evaluating it. I went with SQL Server that time, though I wish now I'd gone with Postgres...

pgAdmin III has its quirks (double click opening property pages bugs me), but it generally works well. I believe there is a postgres package for OS X that makes it easy to install -- I used it ages ago to first get started -- but now I build my own executable and run it on-demand from the command line. If I quickly need a proper server a fire up a new virtual Ubuntu server and it's ready to go in 10 minutes or less.

By the way, MySQL isn't that bad. I'm not its biggest fan, but I'm coming round to it. Also, I was always under the impression that DB2 was similarly priced to Oracle, but that could have changed since I last looked in to it.
adrian.oconnor is offline   0 Reply With Quote
Old Jul 1, 2009, 04:41 PM   #9
AlmostThere
Thread Starter
macrumors 6502a
 
Join Date: Feb 2005
Location: The royal throne of kings, the sceptred isle, the other Eden, the fortress built
We only have Postgres in some web apps but the just released 8.4 http://www.postgresql.org/about/news.1108 looks like it has a very good range of olap functionality. From my point of view, it is really a matter of time and compatibility with the applicable servers. That and it takes years to get to really know a dbms.

DB2 comes in several versions:

Express-C is the free version, limited to RAM and CPUs, and the version available on OS X.
Express, Workgroup and Enterprise allow increasing scalability and features for HADR and management software. I forget exactly what is included with what. The is also a Data Warehouse version, including data mining and a whole host of analysis / BI stuff (a bit like MS Analysis Services) and development tools (presumably to suck you into buying the pricey Rational tools).

It depend on which version suits your needs.

Pricing runs the full gamut, too Spend as little or as much you like.

OS X is not supported as a server ... I am sure IBM will sell you a z-series, though

There are some good introductory postings on http://antoniocangiano.com/ and he was, until recently, a Mac user too.
__________________
Join the army of the dead: http://www.urbandead.com

Last edited by AlmostThere; Jul 1, 2009 at 04:47 PM. Reason: Added link
AlmostThere is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
iPhone: IntelliscreenX 7 Beta Released Alonso Quijano Jailbreaks and iOS Hacks 170 Mar 18, 2014 03:57 PM
ETA on 7.0.5 since Beta 3 got released today. chillenandy321 iOS 7 10 Jan 7, 2014 03:31 PM
General: iOS 7 GM to be released 02/09/13 as beta ends? Risco iOS 7 69 Sep 4, 2013 02:41 PM
iOS 7 Beta 6 released! geneticfusion iOS 7 121 Aug 15, 2013 11:32 PM
When will iOS 6.1 beta 2 be released? mattburley7 iOS 6 30 Nov 14, 2012 09:13 PM

Forum Jump

All times are GMT -5. The time now is 04:29 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC