Db2

Running sql files
db2 -tvf mySql.sql

MYSQL commands
v9.7.2 onwards

you can get DB2 to accept mysql commands

from a del file

 * export


 * import

REORG
needs to be performed after an ALTER

Type 2 connection
DB2 Version 8 Connectivity Cheat Sheet

Error codes
db2 ? [error code] db2 ? SQL[int]N

Error SQL1072C
For single-node instances, perform the following as the instance owner from the sqllib directory :
 * delete the .ftok file


 * create a new .ftok file


 * List of DB2 Error codes

db2batch
Use db2batch


 * ensure tables are fully qualified, e.g. user.table_name.
 * place the ; at the end of the statement.

time

 * time a simple command or give resource usage