Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

    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?

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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

  3. #3
    Join Date
    Aug 2011
    Posts
    46
    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 !!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •