db2 database
Database:create database:
db2 create database test
db2 create database test on /mydir
db2sampl <location>-- create a sample database
db2 create database test using codeset IBM-1252 territory US
using database directories:
db2 list database directory - to view list in the System Database Directory
db2 list database directory on /home/db2inst1 - to view list of databases residing in certain location
db2 list database directory on e:- same on Windows
The database directory has the following structure:
$DBHOME/instance/NODE0000/SQL00001
For example:
myserver : /home/db2inst1/db2inst1/NODE0000 > ls
SQL00001/SQL00002/SQL00003/sqldbdir/
Configuring the database:
db2 get db cfg for <dbname>
db2 get database configuration for <dbname>
db2 update db cfg for <dbname> using locktimeout 10
db2 update database configuration for <dbname> using locktimeout 10
deleting a database:
db2 drop database <dbname>
页:
[1]