Database concepts

As with Informix®, an IBM® DB2® database server can handle more than one database entity. Informix servers have an ID (INFORMIXSERVER) and databases are identified by name. IBM DB2 instances are identified by the DB2INSTANCE environment variable and databases have to be cataloged as data sources (see IBM DB2 documentation for more details).

Tip: If you have several Informix database entities, migrating from the Informix database to another database it is a good opportunity to centralize all tables in a single database. To avoid conflicts with table names, use a prefix when needed.