IBM DB2 LUW DBA Tutorial -- database creation

/**

声明：此随笔为在youtube上学习‘ IBM DB2 LUW/UDB DBA Tutorial for Beginners' 课程笔记.

YouTube视频连接：https://www.youtube.com/watch?v=Pjvwm4rC5Ok&list=PLCNIKwM6iuv7g1hDWDcNkc66vZuVJmvZg

**/

1. Check database

　　db2 list db directory

2. Login as instance user

3. Create database

　　i: db2 create database testdb1

　　　　db2 get -dbm cfg | grep DFTDBPATH

　　　　sqldbdir (local db directory)

　　　　<DBNAME> ==> Storage

　　　　SQLxxxxx ==> DB ID ==> Configuration Information ==> Integrity

　　ii: db2 "create database testdb2 on '/mnt/storage/testdb2/testdb2_storeage' DBPATH ON '/mnt/storage/testdb2/testdb2_dbpath'"