SHOPPING_CART

sc_id 

ingegerNN (PK)

user_id 

integer 

cnt 

ineger 

cat_id

ineger 

status 

varchar(10) 

USERS

id

integer   NN (PK) 

OENUMBER

firstname

varchar(30) 

lastname  

varchar(30) 

id  

integer  NN (PK)

email  

varchar(100) 

sku 

char(8) 

company  

varchar(50) 

oe_no 

char(15) 

street

varchar(40) 

zip 

varchar(12) 

city  

varchar(40) 

status  

integer 

solutation  

varchar(12) 

CATALOG

loginname  

varchar(10) 

password

varchar(10) 

manufacturer 

char(14) 

telephone

varchar(30) 

model        

char(25) 

fax  

varchar(40) 

type         

char(25) 

customer_no   

varchar(12)  

year_from    

char(7) 

year_to      

char(7) 

kw           

char(3) 

hp           

char(3) 

ccm          

char(4) 

cyl_capacity 

char(2) 

motor_code   

char(60) 

prodgroup  

char(2) 

sku          

char(8) 

dimension   

char(12) 

ac          

char(3) 

transmission 

char(3) 

hint        

char(60) 

stock      

integer 

id  

integer    NN (PK)

Figure 3 9   ERD   Diagram

3.2  System environment

In this section, the hardware and software environment used in our migration 

scenario for application porting is described.

The hardware used for porting the application sample in our scenario is an IBM 

Netvista Workstation:

Intel  Pentium  4 CPU, 2,4 GHz

1 GB Ram

39 GB IDE hard disk drive.

Note:

 We recommend that you allocate a minimum of 256 MB of RAM for DB2 

ESE. Additional memory should be allocated for other software and 

communication products.

72 

MySQL to DB2 UDB Conversion Guide