Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / September 2005

Tip: Looking for answers? Try searching our database.

Rows in  syscdr - tables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Heinz Weitkamp - 28 Sep 2005 13:33 GMT
Hi all,

IDS 7.31 UD4
SCO Unix 3.2 5.0.6

In the syscdr db are two tables "trg_receive_sbuf" and "trg_receive_stxn"
which contains only on one server (we have 12 server in ER)
many rows. The rows are very old (committime: 3 month). Can I delete the
rows without any trouble with ER?
If yes, must i stop and start ER?
What are the meaning of the rows?

Thanks in advance

Heinz
sending to informix-list
Madison Pruet - 28 Sep 2005 21:08 GMT
We had some race conditions with ACK management which caused us to not
properly clean up some transactions in the send queue.  My guess is that is
what you are seeing.  If you bounced the server, they should go away.

If you want, you could also examine the progress tables to see if the
transactions have been acked from all of the targets or not.  You could then
manually delete the old transactions, if you wanted.  It gets a bit
complicated to explain how to do this over a news group and is somthing that
I'd rather not do.

> Hi all,
>
[quoted text clipped - 12 lines]
> Heinz
> sending to informix-list
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.