Home | Previous Page | Next Page   Managing Databases > Using Distributed Queries >

Database Access Restrictions

To execute distributed queries in an Informix database server environment, all databases must have compatible ANSI modes and logging.

Distributed queries can be performed on databases that are not ANSI-compliant or that are ANSI-compliant , but each participating database must have the same ANSI mode. In other words, all databases involved in a distributed query must be ANSI-compliant, or none should be. Distributed queries can be performed on databases with either buffered or unbuffered logging, as long as they are consistent.

Extended Parallel Server does not support databases without logging. Therefore, all databases in a distributed query with Extended Parallel Server as the coordinator or participant must be logged.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]