cdr_qdata_sbspace
Aix 5.3 IDS 11.50.fc4 I have ER set up between the above system ... and another system Aix 7.1, IDS 12.1.fc5. On the 11.50 system the dbspace defined by the above parameter continues to grow. Seems as if it's not cleaning things up. On the other system that is part of the ER, it stayes around the same size, and is considerably smaller than on this 11.50 system. Is there any way of determining what is sucking up the space ... or is there a way to free it back up. The 11.50 only has about 6 tables being replicated and they are all quite small ... any help would be appreciated ... thanks ... Peter Logan Database Administrator SpartanNash INC. Office: 616/878-8309 Mobile: 616/304-9672 E-Mail: peter.logan@spartannash.com
There was a known problem with 11.50.fc4 related to cleaning up temporary = smartblobs. You may need to upgrade to 11.50FC5 or later version and try=20 cleaning up the orphaned temporary sblobs using command 'cdr check paging=20 --reclaim' option. These temporary sblobs probably created while paging=20 large transaction(s) by ER. Thanks & Regards, Nagaraju From: "Peter.Logan@spartannash.com" <Peter.Logan@spartannash.com> To: ids@iiug.org Date: 09/08/2015 12:56 PM Subject: cdr=5Fqdata=5Fsbspace [35766] Sent by: ids-bounces@iiug.org Aix 5.3=20 IDS 11.50.fc4=20 I have ER set up between the above system ... and another system Aix 7.1,=20 IDS 12.1.fc5. On the 11.50 system the dbspace defined by the above=20 parameter continues to grow. Seems as if it's not cleaning things up. On=20 the other system that is part of the ER, it stayes around the same size,=20 and is considerably smaller than on this 11.50 system.=20 Is there any way of determining what is sucking up the space ... or is=20 there a way to free it back up. The 11.50 only has about 6 tables being=20 replicated and they are all quite small ...=20 any help would be appreciated ...=20 thanks ...=20 Peter Logan=20 Database Administrator=20 SpartanNash INC.=20 Office: 616/878-8309=20 Mobile: 616/304-9672=20 E-Mail: peter.logan@spartannash.com=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20