The granting of the privileges was done by the instance owner 

db2inst1

 with the 

DB2 command shown in Example 6 13.

Example 6 13   Granting of privileges

db2 => connect to itsodb2

   Database Connection Information

 Database server        = DB2/LINUX 8.1.4

 SQL authorization ID   = DB2INST1

 Local database alias   = ITSODB2

db2 => grant createin, dropin on schema itsodb to group db2app1

DB20000I  The SQL command completed successfully.

db2 => grant select, insert, update, delete on table itsodb.shopping_cart to user itsodb

DB20000I  The SQL command completed successfully.

db2 => grant select, insert, update, delete on table itsodb.users to user itsodb

DB20000I  The SQL command completed successfully.

db2 => grant select, insert, update, delete on table itsodb.catalog to user itsodb

DB20000I  The SQL command completed successfully.

db2 => grant select, insert, update, delete on table itsodb.oenumber to user itsodb

DB20000I  The SQL command completed successfully.

6.2.4  Export MySQL application data

The export of the MySQL application data was done automatically when 

exporting the MySQL data with MTK as described in Chapter 5.5,  Sample 

database migration  on page 117.

In Example 6 14 the created export files are listed.

Example 6 14   Automatically created export files

bash>ls  l *.dat

 rw r  r      1 itsosj   db2app1      2166 2004 02 03 09:46 catalog.dat

 rw r  r      1 itsosj   db2app1    186660 2004 02 03 09:46 oenumber.dat

 rw r  r      1 itsosj   db2app1       791 2004 02 03 09:46 users.dat

 rw r  r      1 itsosj   db2app1        37 2004 02 03 09:46 shopping_cart.dat

Each of the files is tabulator delimited containing the data from the corresponding 

MySQL table. This format can be read by the DB2 

LOAD 

command.

6.2.5  Convert MySQL application data to DB2 format

As no special data types (

TIMESTAMP

 or 

BLOB

) are used in our sample application, 

no manual conversion has to be done in our export files.

 Chapter 6. Data porting 

149