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 ANSI or non-ANSI databases, but each database in the query must have the same ANSI setting. 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 ]