CentOS 6.4 x64 DB2 Database Installation
System: CentOS 6.4 x64
Database: db2-v10.1
Preparation Environment steps
Vi/etc/hosts # modifying the hosts host name is best if it is the same as the computer name.
Reboot
Yum Install Libaio Libaio-devel
for the installation DB2 database Create corresponding account and user group permissions
Groupadd-g DB2IADM2
Groupadd-g DB2FADM2
Groupadd-g DB2ASGRP2
Useradd-m-G db2iadm2-d/home/db2inst2 Db2inst2
Useradd-m-G db2fadm2-d/home/db2fenc2 DB2FENC2
Useradd-m-G db2asgrp2-d/home/db2as2 DB2AS2
Set DB2 Database related account password
passwd Db2inst2
passwd DB2FENC2
passwd DB2AS2
Installation steps
Tar zxvf db2_ese_10_linux_x86-64.tar.gz
CD ESE
./db2_install
Enter the installation database directory
Cd/opt/ibm/db2/v10.1/instance
Chmod-r 775 *
Create an instance Db2inst2
./db2icrt-p 50111-u Db2fenc2 Db2inst2
Switch to the newly created user
Sudb2inst2
Start the sample database
Db2start
To Create a sample database , sample
Db2sampl
DB2 Connect to sample
in for connection DB2 Data Success
To test the sample database SQL statement
DB2 "SELECT * from Staff"
###### View database All table Commands # # # #
DB2 "SELECT Name Fromsysibm.systables"
Switch to the newly created user
Su-db2as2
Configure ports
DB2 update dbm CFG using SVCENAME 50111
View configuration information
DB2 Get dbm Cfg|grep SVCENAME
Create a database --------------------------------------------
Su Db2inst2
Cd/opt/ibm/db2/v10.1/instance
--1, creating the database ( you need to specify the encoding that cannot be modified after creation GBK territory CN)
DB2 "CREATE DB Qydb_dev USING CODESETGBK Territory CN"
DB2 "UPDATE DB CFG for Qydb_dev usingapplheapsz 4096"
DB2 "UPDATE DB CFG for Qydb_dev USINGAPP_CTL_HEAP_SZ 1024"
DB2 "UPDATE DB CFG for Qydb_dev usingstmtheap 8192"
DB2 "UPDATE DB CFG for Qydb_dev usingdbheap 2400"
DB2 "UPDATE DB CFG for Qydb_dev usinglocklist 1000"
DB2 "UPDATE DB CFG for Qydb_dev usinglogfilsiz 1000"
DB2 "UPDATE DB CFG for Qydb_dev usinglogprimary 12"
DB2 "UPDATE DB CFG for Qydb_dev usinglogsecond 20"
DB2 "UPDATE DB CFG for Qydb_dev Usinglogbufsz 32"
DB2 "UPDATE DB CFG for Qydb_dev usingavg_appls 5"
DB2 "UPDATE DB CFG for Qydb_dev usinglocktimeout 30"
Db2start # #启动DB2数据库
Online backup command: DB2 BACKUP DATABASE DBname to/home/db2inst1/backup/compress
View Historical backups: DB2 list historybackup all for DBname compress
DB2 force application All//forcibly terminates all connections
DB2 terminate //Clear all DB2 background processes
DB2 Stop Force //Stop Database
DB2 start //Restart Database
This article is from "Linux learner" blog, reprint please contact the author!
CentOS 6.4 x64 DB2 Database installation