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.
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.