![]() |
Debugging Synchronized Systems
|
|
Example QueriesTo list in order all failed transactions from publication MY_PUB, issue the following query:
SELECT e.errorTime, printFailedTransaction(e.errorID) To restrict the previous query to a particular one-hour window, issue a query like the following:
SELECT e.errorTime, printFailedTransaction(e.errorID) The following query generates output that includes the time of the transaction failure, the associated error message, and the TransactionListVTI output from SYSERRORS. The output shown here is a fragment. SELECT e.errorTime, e.errorinfo.getErrorMessage(), printFailedTransaction(e.errorID) FROM SYS.SYSERRORS e; ERRORTIME |SQLCol1 |SQLCol2 ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------- 1999-09-29 11:28:48.158 |The statement was aborted because it would have |TransactionLis& caused a duplicate key value in a unique or primary key constraint |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |