How to build database on DB2 with db2 command

Take DB2 on Linux for example:
1.su - db2inst1
2.run db2 to get into db2 command line
3.check existing database
list db directory
4.Create a database with UTF-8 and page size is 8K
create database <database name> using codeset UTF-8 territory us pagesize 8192

5.Additional check if db2admin service started.
db2admin start

6.Connect to database with db2 username and password
connect to <db name> user <db2 user name> using <db2 password>

7.delete database
connect reset
drop database xxxx

8.Check the DB2 port
[db2inst1@vs302 ~]$ cat /etc/services | grep db2
ibm-db2         523/tcp                 # IBM-DB2
ibm-db2         523/udp                 # IBM-DB2
questdb2-lnchr  5677/tcp                # Quest Central DB2 Launchr
questdb2-lnchr  5677/udp                # Quest Central DB2 Launchr
qdb2service     45825/tcp               # Qpuncture Data Access Service
qdb2service     45825/udp               # Qpuncture Data Access Service
db2c_db2inst1   50000/tcp

db2 port is 50000

If DB2 on windows, please use 'db2 get dbm cfg | find "SVCENAME"' to check the DB2 port.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值