DB2 Database Management Common operations

Querying DB2 database-related configuration (log, character set)

 for uppdb

Querying the DB2 database Db2codepage

Db2set

You may want to modify the db2codepage when you import and export the database

Db2set db2codepage=1208(UTF-8) db2set db2codepage=1386 (GBK)

View the database table structure

Table xxxxx

Clear Table Data

ALTER TABLE  not  with TABLE

Modify table field type

Alter Table Alter column Set varchar (a) Alter Table Alter column Set Data Type Date Alter Table Alter column Set Char (1)

Database Startup

Db2start

Database shutdown

Db2stop

View Database App connections

DB2 List Applications

Disconnecting a database application connection

All

Activating a DB instance

Database <dbname>

DB2 Database Management Common operations