bash> MYSQL_TCP_PORT=3307

bash> export MYSQL_UNIX_PORT MYSQL_TCP_PORT

bash> mysql

DB2 UDB supports similar functionality using multiple database manager 

instances on the same machine; each database manager instance has its own 

configuration files, directories, and database. Figure 5 4 shows the typical 

scenario.

Figure 5 4   Typical DB2 UDB setup

DB2 UDB on all the UNIX systems support creation of different instances on the 

same machine with a different DB2 UDB version.

Multiple databases and schema conversion

In MySQL, tables within a database cannot be logically grouped by a schema or 

qualified name based on the application. To fulfill this requirement MySQL tables 

are placed in separate database. Application can than access these tables in the 

multiple databases.

MySQL supports accessing of the tables in multiple databases using the same 

connection. So an application connected to MySQL can use two tables in 

different databases in a single statement.

108 

MySQL to DB2 UDB Conversion Guide