CDR_QDATA_SBSPACE
Posted in 2016
Topics: Storage & Space Management
Hi,
I have a dbspace specified in the CDR_QDATA_SBSPACE.
Acoording with the onstat -d command, It has 262144 of space and 113534 of
free space.
It has ben working about one year with any problem, but in the last 2
weeks, I see
the free space has ben reducing drastically
My Question is, what will happend if the free space is consumed ? I what
do I have to
do to avoid ?
Thanks in advance.
--001a11430c7a736cc9052e09bf1a
blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px
#715FFA solid !important; padding-left:1ex !important; background-color:white
!important; } That means that one of your nodes is not receiving replicated
transactions.
Sent from Yahoo Mail for iPad
On Monday, March 14, 2016, 7:15 PM, jorge valenzuela <jorgervt@gmail.com>
wrote:
Hi,
I have a dbspace specified in the CDR_QDATA_SBSPACE.
Acoording with the onstat -d command, It has 262144 of space and 113534 of
free space.
It has ben working about one year with any problem, but in the last 2
weeks, I see
the free space has ben reducing drastically
My Question is, what will happend if the free space is consumed ? I what
do I have to
do to avoid ?
Thanks in advance.
--001a11430c7a736cc9052e09bf1a
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
Do you have ER queued data in send queue ?
what are outputs of ,
cdr list server
onstat -g rqm brief
?
Thanks
Frank
On Mon, Mar 14, 2016 at 7:01 PM, jorge valenzuela <jorgervt@gmail.com>
wrote:
> Hi,
>
> I have a dbspace specified in the CDR_QDATA_SBSPACE.
> Acoording with the onstat -d command, It has 262144 of space and 113534 of
> free space.
>
> It has ben working about one year with any problem, but in the last 2
> weeks, I see
> the free space has ben reducing drastically
>
> My Question is, what will happend if the free space is consumed ? I what
> do I have to
> do to avoid ?
>
> Thanks in advance.
>
> --001a11430c7a736cc9052e09bf1a
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a114710925e5284052e199e87
Thanks for your help. You were right. I had to do an onmode -ky to one
node, then on oninit.
after that I see the QUEUE was reducing from 398110303 until 0.
Then I run onstat -d again and the space was freeded again.
On 14 March 2016 at 16:01, jorge valenzuela <jorgervt@gmail.com> wrote:
> Hi,
>
> I have a dbspace specified in the CDR_QDATA_SBSPACE.
> Acoording with the onstat -d command, It has 262144 of space and 113534 of
> free space.
>
> It has ben working about one year with any problem, but in the last 2
> weeks, I see
> the free space has ben reducing drastically
>
> My Question is, what will happend if the free space is consumed ? I what
> do I have to
> do to avoid ?
>
> Thanks in advance.
>
> --001a11430c7a736cc9052e09bf1a
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a1143e3dc832c19052e1bf0b9
The problema was resolved.
The cdr list server command had a big queue aprox. 398110303.
It was the problema. I did an onmode -ky, oninit on the secondary server.
After that the QUEUE, was empty.
Thanks.
On 15 March 2016 at 11:08, FRANK <yunyaoqu@gmail.com> wrote:
> Do you have ER queued data in send queue ?
>
> what are outputs of ,
>
> cdr list server
> onstat -g rqm brief>
> ?
>
> Thanks
> Frank
>
> On Mon, Mar 14, 2016 at 7:01 PM, jorge valenzuela <jorgervt@gmail.com>
> wrote:
>
> > Hi,
> >
> > I have a dbspace specified in the CDR_QDATA_SBSPACE.
> > Acoording with the onstat -d command, It has 262144 of space and 113534
> of
> > free space.
> >
> > It has ben working about one year with any problem, but in the last 2
> > weeks, I see
> > the free space has ben reducing drastically
> >
> > My Question is, what will happend if the free space is consumed ? I what
> > do I have to
> > do to avoid ?
> >
> > Thanks in advance.
> >
> > --001a11430c7a736cc9052e09bf1a
> >
> >
> >
> >
>
>
*******************************************************************************
> > Forum Note: Use "Reply" to post a response in the discussion forum.
> >
> >
>
> --001a114710925e5284052e199e87
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--001a11441386d83d9d052e1c8c81
Related threads
- IDS 10 table-level restore
- Informix Development Webinar December 11, 2007
- ontape -p/r with changed ROOTPATH
- Migrate from HP PA-RISC to HP ITANIUM by ontape