Tables
1 1
DB2 commands list . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19
1 2
Multi tier configuration examples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23
1 3
Permission information stored in tables . . . . . . . . . . . . . . . . . . . . . . . . . 33
4 1
Currently supported Linux distributions, kernels, and libraries . . . . . . . 76
4 2
DB2 installation methods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78
5 1
Default data type mapping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94
5 2
MySQL to DB2 UDB conversion of list information statement . . . . . . . 110
6 1
Mapping of MySQL to DB2 privileges . . . . . . . . . . . . . . . . . . . . . . . . . 145
7 1
Differences in DB2 and MySQL grouping, having and ordering . . . . . 160
7 2
MySQL and DB2 UDB string related function . . . . . . . . . . . . . . . . . . . 162
7 3
SQL 92 functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 168
7 4
ODBC 3.0 functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 169
7 5
MySQL and DB2 UDB operator comparison . . . . . . . . . . . . . . . . . . . . 170
7 6
Date and Time related functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170
7 7
Other functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171
7 8
MySQL data type mapping to Java data type . . . . . . . . . . . . . . . . . . . 197
7 9
DB2 UDB data types mapping to Java types . . . . . . . . . . . . . . . . . . . . 197
7 10 DB2 isolation level . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
7 11 MySQL and DB2 table comparison . . . . . . . . . . . . . . . . . . . . . . . . . . . 229
8 1
MySQL options files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250
9 1
Aggregations for data migration verification. . . . . . . . . . . . . . . . . . . . . 275
9 2
List of monitor switches and related DBM parameters . . . . . . . . . . . . 287
9 3
Common snapshot table functions. . . . . . . . . . . . . . . . . . . . . . . . . . . . 291
9 4
Parameters for the autoconfigure command . . . . . . . . . . . . . . . . . . . . 314
Copyright IBM Corp. 2004. All rights reserved.
xi
footer
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