Help! Need a quick answer please folks..

Unix 7.3 If you are on one box and run a delete on a table on a remote box does it use the logical logs on the local or remote box? Does the answer apply to any processes which generate log transactions? Sent via Deja.com http://www.deja.com/ Before you buy.

<strangiato@my-deja.com> wrote in message news:7v4ad7$76$1@nnrp1.deja.com... > Unix 7.3 > > If you are on one box and run a delete on a table on a remote box does > it use the logical logs on the local or remote box? > > Does the answer apply to any processes which generate log transactions? Databases on both boxes must have same logging mode. If you are on the machine A and is running statement, that, for example, delete rows from machine B, logs for delete are written on machine B. Logs on machine A are used for coordinator's records and takes little space. --------------------------------------------------- With best regards, Yuri Dovgart SAP R/3, Informix technical consultant, Senior System Consultant System Architecture and High Availability Systems, 'Telecominvest' company Email y_dovgart@tci.ukrtel.net ICQ 39284285

strangiato@my-deja.com wrote: > Unix 7.3 > > If you are on one box and run a delete on a table on a remote box does > it use the logical logs on the local or remote box? > The logical logs are wherever the database is. > Does the answer apply to any processes which generate log transactions? > Yes. /J\\ -- "The internet is like a car boot sale" - Jon Sopel, BBC News