db2 database

luzl

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>