====== Created database dbtest ====== 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.