执行操作，提示如下：
[db2inst@localhost ~]$ db2 deactivate db necc_db
SQL1120N A connection to or activation of database "NECC_DB" cannot be made
because a previous backup or restore is incomplete. SQLSTATE=57019
根据 https://www.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.messages.sql.doc/doc/msql01120n.html 描述：“因为先前备份或复原不完整，所以不能连接或激活数据库 名称。”
直接删除了数据，再执行还原该数据库
[db2inst@localhost ~]$ db2 drop db necc_db
DB20000I The DROP DATABASE command completed successfully.
从备份中恢复DB2数据库（本例是指“NECC_DB”）的拷贝到新的DB2服务器（本例是指“NECC_DBA”）。 用户已创建一个新的数据库连接（指向这个新的数据库副本），当试图连接这个新的数据库时，提示如下错误:
[db2inst@localhost ~]$ db2 connect to necc_db
SQL1117N A connection to or activation of database "NECC_DB" cannot be made
because of ROLL-FORWARD PENDING. SQLSTATE=57019
出现SQL1117N 由于 ROLL-FORWARD PENDING，不能连接或激活数据库 "NECC_DBA"。
将数据库前滚。
执行:
db2 rollforward db <database> complete
如：
[db2inst@localhost ~]$ db2 rollforward db necc_dba complete
Rollforward Status
Input database alias = necc_dba
Number of members have returned status = 1
Member ID = 0
Rollforward status = not pending
Next log file to be read =
Log files processed = -
Last committed transaction = 2016-04-27-09.18.11.000000 UTC
DB20000I The ROLLFORWARD command completed successfully.
[db2inst@localhost ~]$
执行 db2 语句创建或者删除数据库操作，均出现如下提示
SQL1004C There is not enough storage on the file system to process the command.
用户的磁盘不够了。增加用户磁盘，或者删除一些数据，来增大用户能使用的空间。
删除了没有用的数据库和老旧的数据库备份文件。
执行 db2 语句创建数据库索引、或者执行修改操作，均出现如下提示
DB2 Database Error: ERROR [57011] [IBM][DB2/LINUXX8664] SQL0964C The transaction log for the database is full.
事务日志已满。
通过 db2 => get db cfg 语句来查看日志文件的配置：
Log file size (4KB) (LOGFILSIZ) = 1024
Number of primary log files (LOGPRIMARY) = 13
Number of secondary log files (LOGSECOND) = 12
把日志文件的大小和日志文件的数量扩充。
db2 => update db cfg using LOGFILSIZ 10240
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W Database must be deactivated and reactivated before the changes to
one or more of the configuration parameters will be effective.
db2 => update db cfg using LOGPRIMARY 100
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
SQL1363W Database must be deactivated and reactivated before the changes to
one or more of the configuration parameters will be effective.
db2 => update db cfg using LOGSECOND 100
DB20000I The UPDATE DATABASE CONFIGURATION command completed successfully.
db2 =>
连接到数据库时，出现如下提示
ERROR [57019] [IBM] SQL1084C The database manager failed to allocate shared memory because an operating system kernel memory limit has been reached. SQLSTATE=57019
创建字段时，varchar 设置为 500 ，报错
SQL 错误 [42727]: A table space could not be found with a page size of at least "8192" that authorization ID "DB2INST" is authorized to use.. SQLCODE=-286, SQLSTATE=42727, DRIVER=4.16.53
com.ibm.db2.jcc.am.SqlSyntaxErrorException: A table space could not be found with a page size of at least "8192" that authorization ID "DB2INST" is authorized to use.. SQLCODE=-286, SQLSTATE=42727, DRIVER=4.16.53
- http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.dbobj.doc/doc/c0061057.html
- http://www.db2china.net/Question/39301
- http://www.west.cn/www/info/28275-1.htm
db2 => connect to necc_db
Database Connection Information
Database server = DB2/LINUXX8664 10.1.0
SQL authorization ID = DB2INST
Local database alias = NECC_DB
db2 => LIST TABLESPACES SHOW DETAIL
Tablespaces for Current Database
Tablespace ID = 0
Name = SYSCATSPACE
Type = Database managed space
Contents = All permanent data. Regular table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 32768
Useable pages = 32764
Used pages = 32244
Free pages = 520
High water mark (pages) = 32244
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
Tablespace ID = 1
Name = TEMPSPACE1
Type = System managed space
Contents = System Temporary data
State = 0x0000
Detailed explanation:
Normal
Total pages = 1
Useable pages = 1
Used pages = 1
Free pages = Not applicable
High water mark (pages) = Not applicable
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 2
Name = USERSPACE1
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 16384
Useable pages = 16352
Used pages = 14048
Free pages = 2304
High water mark (pages) = 14048
Page size (bytes) = 4096
Extent size (pages) = 32
Prefetch size (pages) = 32
Number of containers = 1
Tablespace ID = 3
Name = SYSTOOLSPACE
Type = Database managed space
Contents = All permanent data. Large table space.
State = 0x0000
Detailed explanation:
Normal
Total pages = 8192
Useable pages = 8188
Used pages = 192
Free pages = 7996
High water mark (pages) = 192
Page size (bytes) = 4096
Extent size (pages) = 4
Prefetch size (pages) = 4
Number of containers = 1
db2 =>
ALTER TABLESPACE tablespacename CONVERT TO LARGE