login as: db2inst1
db2inst1@ub1's password:
Linux ub1 2.6.24-24-server #1 SMP Fri Sep 18 16:47:05 UTC 2009 x86_64
The programs included with the Ubuntu system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.
Ubuntu comes with ABSOLUTELY NO WARRANTY, to the extent permitted by
applicable law.
To access official Ubuntu documentation, please visit:
http://help.ubuntu.com/
Last login: Sat Nov 14 10:17:12 2009 from 192.168.0.97
db2inst1@ub1:~$
db2inst1@ub1:~$
db2inst1@ub1:~$ db2
(c) Copyright IBM Corporation 1993,2007
Command Line Processor for DB2 Client 9.7.0
You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd
For general help, type: ?.
For command help, type: ? command, where command can be
the first few keywords of a database manager command. For example:
? CATALOG DATABASE for help on the CATALOG DATABASE command
? CATALOG for help on all of the CATALOG commands.
To exit db2 interactive mode, type QUIT at the command prompt. Outside
interactive mode, all commands must be prefixed with 'db2'.
To list the current command option settings, type LIST COMMAND OPTIONS.
For more detailed help, refer to the Online Reference Manual.
db2 => CREATE DB dbtest AUTOMATIC STORAGE YES ON '/home/db2inst1/databases/dbtest' USING CODESET UTF-8 TERRITORY US
DB20000I The CREATE DATABASE command completed successfully.
db2 => UPDATE DB CFG FOR dbtest USING AUTO_MAINT ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
db2 => UPDATE DB CFG FOR dbtest USING AUTO_TBL_MAINT ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
db2 => UPDATE DB CFG FOR dbtest USING AUTO_RUNSTATS ON
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
db2 => UPDATE ALERT CFG FOR DATABASE ON dbtest USING db.db_backup_req SET THRESHOLDSCHECKED YES
DB20000I The UPDATE ALERT CONFIGURATION command completed successfully.
db2 => UPDATE ALERT CFG FOR DATABASE ON dbtest USING db.tb_reorg_req SET THRESHOLDSCHECKED YES
DB20000I The UPDATE ALERT CONFIGURATION command completed successfully.
db2 => UPDATE ALERT CFG FOR DATABASE ON dbtest USING db.tb_runstats_req SET THRESHOLDSCHECKED YES
DB20000I The UPDATE ALERT CONFIGURATION command completed successfully.
db2 => quit
DB20000I The QUIT command completed successfully.