How can I identify which table a cdr_deltab table
Dave Thacker asked on IDS 9.4 how to identify which table a cdr_deltab table belongs to. Jack Parker and Madison asked what he needed. He explained that several tables have growing delete tables and he wanted to list the largest, re-sync the parent and find out why. Replication was 9.4 to 9.3. No answer in the thread.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Is there a way to query the CDR database to get this info? IDS 9.4 Thanks! DT
What information? The version number? Try select * from systables where tabname = ' VERSION'; j. -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org]On Behalf Of Dave Thacker Sent: Friday, April 21, 2006 4:26 PM To: ids@iiug.org Subject: How can I identify which table a cdr_deltab ta.... [6583] Is there a way to query the CDR database to get this info? IDS 9.4 Thanks! DT **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.
What are you wanting to do??? M.P. = "Dave Thacker" = <dthacker@omnihot = els.com> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect How can I identify which table a= 04/21/2006 03:25 cdr_deltab ta.... [6583] = PM = = = Please respond to = ids@iiug.org = = = Is there a way to query the CDR database to get this info? IDS 9.4 Thanks! DT ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =
On Fri, 2006-04-21 at 16:25 -0400, Dave Thacker wrote: > Is there a way to query the CDR database to get this info? > IDS 9.4 > > Thanks! DT Sheesh, talk about bad cut and paste. I have several tables which produce cdr_deltab tables that grow. I need to pull a list of the largest cdr_deltabl tables, re-sync the parent table, and find out why they are growing. This is IDS 9.4 replicated to IDS 9.3. Thanks. DT > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >