2009年1月4日星期日

DB2之Instance管理

1.创建
db2icrt instance_name //windows

db2icrt -u fanced_user instance_name //linux or unix
User-defined functions and stored procedures, by default, are created in fenced mode so that these processes run in a different address space than the DB2 engine

2.删除
db2idrop -f instance_name

3.查看
db2ilist //list

4.Migration
db2imigr instance_name //从32位migrate到64位

5.Update
db2iupdt instance_name //打了fix pack就需要update

没有评论: