IBM DB2 run sql script

db2 -tvf script_name.db2 -z script.log

-z -> show log
-f -> use script
-v -> show in detail

IBM DB2 set dbm parameter

List database parameter : db2set -all
set database parameter  : db2set PARA_NAME=XXX
set database parameter to empty : db2set PARA_NAME=

List database cfg parameter : db2 get db cfg
set database cfg parameter  : db2 update db cfg using CFG_NAME XXX

DB2 LOGIN METHOD

Easy Login

     db2 connect to db_name user userID using password
eg. db2 connect to newinst user db2inst1 using 1234

List all applications
     db2 list applications
stop all applications
     db2 force applications all
stop application
     db2 "force application (Appl.)"

select statment
   db2 select * from staff

Command List - IBM DB2 modify instance and database

Command List - IBM DB2 modify instance and database

Run the command in /opt/ibm/db2/V9.7/instance
Create a new instance        : ./db2icrt -u instance_name instance_name
Remove instance*              : ./db2idrop instance_name

Run the command in /opt/ibm/db2/V9.7/binCheck all existing instance* : db2ilist
Check current instance      : db2 get instance
Set current instance            : set db2instance=instance_name

Create new database       : db2 create db db_name
connect to database        : db2 connect to db_name
stop connecting database: db2 terminate
List all database              : db2 list db directory
remove database             : db2 drop db db_name
LIST all table                   :db2 list tables

Create table : db2 create table

check dbm cfg parameter : db2 get dbm cfg
update dbm cfg parameter: db2 update dbm cfg using PARAMETER OPTION

stopall application to stop connection
   db2 force application all
   db2 terminate

Run the command in /opt/ibm/db2/V9.7/admStartup current instance  : db2start
Stop current instance      : db2stop


* Which request user run the command by root