01-11-12, 05:11 #1Registered User
- Join Date
- Jan 2009
- Zoetermeer, Holland
Unanswered: Not a specific question, just wondering
At 1 of my clients I am in charge of "DB2 content manager" and "DB2 content manager on demand" systems. a.k.a. ECM systems. Both systems use the db2 database to keep track of all the documents (index) and the location where the actual documents are located. The documents themselves are stored outside of the database on the filesystem (later on in a black-box called TSM ).
Nice concept, performance is allright but backup/rerstore/revocery/consistancy is a nightmare! A db2 backup is no problem, but a backup of your filesystem containing millions of documents takes foreever. No one has ever been able to explain to me why ECM-systems do not use the database to store the documents as BLOB's. Yes, BLOB's are 'slower' because db2 has to do an extra I/O outside of the bufferpools to obtain the data.. but the ECM system itself has to do exactly the same: locate the document on disk and retrieve it.... Is that really that much faster?? I doubt that.
And what about storage: I'd rather manage disks with a "few" very large tablespace containers instead of disks with millions of small files.
But still: most of the ECM vendors choose to store it outside of the database (even IBM and they have DB2 at their disposal). Any one out there who understands the concept and is able to explain it to me?
01-11-12, 08:56 #2Registered User
- Join Date
- May 2003
It has been a awhile since I worked with it, but I many customers store their files on optical or other off-line media which can be automatically retrieved to disk by the application, and DB2 is not able to use this kind of storage for tablespaces. If your database is relatively small, then it might have been able to use DB2 BLOBs, but many such databases would be too large to store on disk or in a DB2 database.M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
01-12-12, 05:17 #3Registered User
- Join Date
- Aug 2011
At my previous company, they had a ECM solution, that does give you option to store pdf's,tifs,jpegs etc in database. We had Oracle as database, and chose to store all files in the database, for some reason , I still don't know who made that choice .
Anyway performance was horrible, one month long performance tuning didn't help much, a nightmare !! Finally we gave up and opted second option, to store files on filesystem. Well performance was not ecstatic , but good enough to meet the SLA. End of nightmare !!!!