Re: Need info on blobspace blobs
Posted in 2006
Topics: High Availability & Replication, Storage & Space Management
Madison, We use a blobspace today to store images in byte format. And I am looking to run HDR within the next year. I did not know that blobs were not supported in HDR, and so yes - having them supported would be helpful. Or if there is an easy way to migrate the images to smart blobs (which sorry if that is an easy question, I just haven't looked into it yet). Nick
Nick wrote: > Madison, > > We use a blobspace today to store images in byte format. And I am > looking to run HDR within the next year. I did not know that blobs > were not supported in HDR, and so yes - having them supported would be > helpful. Table space blobs are supported because of how they are logged. Blobspace blobs are mostly unlogged - just the blob locater is actually logged. Or if there is an easy way to migrate the images to smart > blobs (which sorry if that is an easy question, I just haven't looked > into it yet). > > Nick >
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7638.1"> <TITLE>Re: Need info on blobspace blobs</TITLE> </HEAD> <BODY> <DIV id=idOWAReplyText82714 dir=ltr> <DIV dir=ltr><FONT face=Arial color=#000000 size=2>We are in a similar situation, only add Word Documents and PDF's to the mix of stored objects. Not much, somewhat less than 100GB total.</FONT></DIV> <DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV> <DIV dir=ltr><FONT face=Arial size=2>We needed replication months ago, and so have been taking advantage of multiple buffer pools to re-attach the blobs and have them 'trash' a different buffer, and get replicated in the process. </FONT></DIV> <DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV> <DIV dir=ltr><FONT face=Arial size=2>(We do run HDR on a smaller, departmental (2GB, total) instance, but had the foresight to set up CLOBs).</FONT></DIV> <DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV> <DIV dir=ltr><FONT face=Arial size=2>All future blob data types have been required to be CLOB /BLOB in our shop, for just this reason, for about the past 6 months or so. It was an excuse to migrate new development towards smart blobs.</FONT></DIV> <DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV> <DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV></DIV> <DIV dir=ltr><BR> <HR tabIndex=-1> <FONT face=Tahoma size=2><B>From:</B> informix-list-bounces@iiug.org on behalf of Nick<BR><B>Sent:</B> Fri 6/23/2006 11:50 AM<BR><B>To:</B> informix-list@iiug.org<BR><B>Subject:</B> Re: Need info on blobspace blobs<BR></FONT><BR></DIV> <DIV> <P><FONT size=2>Madison,<BR><BR>We use a blobspace today to store images in byte format. And I am<BR>looking to run HDR within the next year. I did not know that blobs<BR>were not supported in HDR, and so yes - having them supported would be<BR>helpful. Or if there is an easy way to migrate the images to smart<BR>blobs (which sorry if that is an easy question, I just haven't looked<BR>into it yet).<BR><BR>Nick<BR><BR>_______________________________________________<BR>Informix-list mailing list<BR>Informix-list@iiug.org<BR><A href="http://www.iiug.org/mailman/listinfo/informix-list">http://www.iiug.org/mailman/listinfo/informix-list</A><BR></FONT></P></DIV> </BODY> </HTML>
Related threads
- Conversion to differeent characters sets
- Problem in changing locale via dbexport/dbimport
- RE: openlink error "Unable to load locale categories"