mysql>insert into itsotable1 (col2) VALUES ("itso1"),("itso2");

mysql>insert into itsotable2 (col2) VALUES ("itso3"),("its04 );

DB2 UDB uses the updateable UNION ALL view to achieve the above 

feature. 

UNION ALL

 views are commonly used for logically combining different 

but semantically related tables. 

UNION ALL

 view is also used for unification of 

like tables for better performance, manageability, and integrating federated 

data sources:

UNION ALL

 Views are created using:

db2>create view itsounionview as select * from itsotable1 union all

    select * from itsotable2

HEAP table

A heap table is a hashed index and is always stored in memory. Heap tables 

are fast but not crash safe. Data is lost when MySQL crashes. 

The MySQL internal HEAP tables use 100% dynamic hashing without 

overflow areas. There is no extra space needed for free lists. HEAP tables 

also do not have any problem with delete and inserts, which normally is 

common with hashed tables. It can be created using

mysql> create table itsoheap type=heap select * from itsotable1;

MySQL HEAP tables can be migrated to a temporary table, materialized 

query tables, or indexes depending upon your requirements.

  Temporary table

DB2 UDB temporary tables are tables used for storing data in 

non persistent, in memory, session specific tables. Once the session is 

over the definition of this table is lost. When your application is using 

HEAP table in this fashion, temporary tables can be declared in your 

application by calling statements:

  Create user temporary table space if not existing using:

create user temporary tablespace discompose managed by system using 

( usertemp1 )

  Declare temporary table in the application:

declare global temporary table distemper like itsotable1 on commit 

delete rows not logged in discompose

  Materialized query table

A materialized query table (MQT) is a table whose definition is based on 

the results of a query, and whose data is in the form of precomputed 

results. If the SQL compiler determines that a query will run more 

104 

MySQL to DB2 UDB Conversion Guide