错误现象:
db2 => select * from a
SQL0901N The SQL statement or command failed because of a database system error. (Reason "bad Default".) SQLSTATE=58004
db2 => drop table a
DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:SQL0901N The SQL statement or command failed because of a database system error. (Reason "bad Default".) SQLSTATE=58004
系统信息:
[db2inst1@localhost ~]$ db2ls
Install Path Level Fix Pack Special Install Number Install Date Installer UID
/opt/ibm/db2/V10.1 10.1.0.0 0 Tue Apr 5 13:44:30 2016 CST 500
[db2inst1@localhost ~]$ db2licm -l
Product name: "DB2 Express-C"
License type: "Unwarranted"
Expiry date: "Permanent"
Product identifier: "db2expc"
Version information: "10.1"
Max number of CPUs: "2"
Max amount of memory (GB): "4"
Enforcement policy: "Soft Stop"
收起