Db2

Db2 起動/停止/接続 コマンド

Posted on by keeper

停止

[db2inst1@localhost ~]$ db2 terminate
DB20000I  The TERMINATE command completed successfully.
[db2inst1@localhost ~]$ db2 deactivate db sample
DB20000I  The DEACTIVATE DATABASE command completed successfully.
[db2inst1@localhost ~]$ db2stop
08/07/2024 16:36:03     0   0   SQL1064N  DB2STOP processing was successful.
SQL1064N  DB2STOP processing was successful.

起動

[db2inst1@localhost ~]$ db2start
08/07/2024 16:36:53     0   0   SQL1063N  DB2START processing was successful.
SQL1063N  DB2START processing was successful.

接続

[db2inst1@localhost ~]$ db2 connect to sample

   Database Connection Information

 Database server        = DB2/LINUXX8664 11.5.9.0
 SQL authorization ID   = DB2INST1
 Local database alias   = SAMPLE

SQL実行

[db2inst1@localhost ~]$ db2 "select count(*) from customer"

1          
-----------
          6

  1 record(s) selected.
keeper