db2 instance
Instance:Creating / updating / dropping the instance (be careful)
db2icrt<instance_owner_id>
db2icrt -u <fenced_user_id> <instance_owner_id>
db2iupdt <instance_owner_id>
db2idrop <instance_owner_id>
db2ilist- list all instances on the machine
creating an instance of DAS (db admin server) on Windows:
db2admin create /user:<name> /password:<password>
db2admin
db2admin start
db2admin stop
db2admin drop
dasidrop <das_instance_owner_id>
configuring the instance:
db2 get dbm cfg
db2 get database manager configuration
db2 update dbm cfg using diaglevel 4
db2 update database manager configuration using <param_name> <new_value>
restart the instance:
db2stop
db2start
db2 reset dbm cfg
instance config commands:
db2 get admin cfg
db2 update admin cfg using <param_name> <new_value>
db2 reset admin cfg
页:
[1]