log usage with ER and blobs

Posted in 2011

Madison Pruet — Wed, 13 Jul 2011 15:41:54 — source: IIUG Forums & Mailing Lists

Karl, We won't log the blobspace blob data when writing it, and also for a blob space blob, we extract the blob when transmitting the replicated transaction to the target server. However, on the target, we may have to spool the blob because we can't apply the replicated transaction until the complete transaction has been received. My guess is that your CDR_QUEUEMEM size is not large enough to hold the transaction being received and thus we are having to spool the transaction (and the LOB) in the sblob queue. And you configured the SBLOB space on the target server as a logged SBLOB. Thus there would be an increase in log consumption on the target. Not for the apply of the transaction, but the logging performed when the LOB was spooled in the receive queue. M.Pruet

↪ replying to Madison Pruet

KARL OLIVER — Sun, 17 Jul 2011 20:48:16 — source: IIUG Forums & Mailing Lists

the CDR queue smart blob space is logged. What is the general recommendation

↪ replying to KARL OLIVER

Nagaraju Inturi — Tue, 19 Jul 2011 20:24:07 — source: IIUG Forums & Mailing Lists

General recommendation is to configure one logging and one non-logging sbspace for CDR queue smart blob space. This way smaller size txns gets spooled to logging sbspace and larger txns gets spooled to non-logging sbspace. CDR_QDATA_SBSPACE accepts multiple sbspace names. Thanks & Regards, Nagaraju From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org Date: 07/17/2011 03:49 PM Subject: Re: log usage with ER and blobs [24396] the CDR queue smart blob space is logged. What is the general recommendation ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Nagaraju Inturi

KARL OLIVER — Wed, 20 Jul 2011 02:18:14 — source: IIUG Forums & Mailing Lists

thanks for that information Nagaraju Does the system automatically decide which sblob to use the for smaller and larger transactions. At this tage we wont change things as the problem we has was caused by an application error .

↪ replying to KARL OLIVER

Nagaraju Inturi — Wed, 20 Jul 2011 03:40:29 — source: IIUG Forums & Mailing Lists

Yes, ER automatically decides which sbspace to use. Thanks & Regards, Nagaraju From: "KARL OLIVER" <karl.oliver@maf.govt.nz> To: ids@iiug.org Date: 07/19/2011 09:18 PM Subject: Re: log usage with ER and blobs [24410] thanks for that information Nagaraju Does the system automatically decide which sblob to use the for smaller and larger transactions. At this tage we wont change things as the problem we has was caused by an application error .. ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Glossary

blobspace