Each MySQL database is now represented by a DB2 UDB schema to hold the 
tables under that database. All the tables can be accessed by the application 
using single connection. The DBA only need to manage one database. 
DB2 UDB schema can be created using 
db2>create schema itsoschema1 authorization itsoschema1
The tables created in the particular schema can be accessed using the full table 
qualifier 
table schema.table name
.
Table placement
MySQL does not support table space for managing physical location and page 
size or distributing tables onto the different table spaces except for optional 
InnoDB which supports multiple table space distributed in different files. 
DB2 UDB supports table spaces to establish the relationship between the 
physical storage devices used by your database system and the logical 
containers used to store data. Table spaces reside in database partition groups. 
They allow you to assign the location of table data directly onto containers.
Before migration of database structure you should create a proper table space of 
different sizes in DB2 UDB, so that when you create tables they are placed into 
the table spaces which will give best performance.
List information
MySQL provides a 
show
 command to list the information about databases, tables, 
columns, or status information about the server.
DB2 UDB provide commands for getting the instances, database, table space, 
etc. information. The DB2 UDB system catalogues contain all the information 
about table, column, and index etc. You can use 
describe 
command to display 
table structure or use select statement to get the details of the table definition.
Table 5 2 shows examples of MySQL and corresponding DB2 UDB 
statements/commends to list database or table related information.
Table 5 2   MySQL to DB2 UDB conversion of list information statement
MySQL
DB2 UDB 
show databases
ist database directory
show table
select tabname from syscat.tables
show columns from tablename
describe select * from tablename
110 
MySQL to DB2 UDB Conversion Guide






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved