金融其它
load之后表为空的异常
db2move xxx load -lo replace
load状态显示成功，commited了若干行
LOAD: table "db2inst6"."hello"
-Rows read: 1
-Loaded: 1
-Rejected: 0
-Deleted: 0
-Committed: 1
* LOAD: table "db2inst6"."mask"
-Rows read: 30
-Loaded: 30
-Rejected: 0
-Deleted: 0
-Committed: 30
load query也显示normal
表空间状态也正常没有暂挂
但是select却显示没有数据，明明导入了几十行数据
db2inst6@lserver:~/wisglx> db2 "select * from mask";
a b c d e
---------------- -------------------------------------------------------------------------------------------------------------------------------- ------- ---------------------------------------------------------------- --------------
0 record(s) selected.
请问大家这是什么问题呢？
load状态显示成功，commited了若干行
LOAD: table "db2inst6"."hello"
-Rows read: 1
-Loaded: 1
-Rejected: 0
-Deleted: 0
-Committed: 1
* LOAD: table "db2inst6"."mask"
-Rows read: 30
-Loaded: 30
-Rejected: 0
-Deleted: 0
-Committed: 30
load query也显示normal
表空间状态也正常没有暂挂
但是select却显示没有数据，明明导入了几十行数据
db2inst6@lserver:~/wisglx> db2 "select * from mask";
a b c d e
---------------- -------------------------------------------------------------------------------------------------------------------------------- ------- ---------------------------------------------------------------- --------------
0 record(s) selected.
请问大家这是什么问题呢？
16同行回答
你会不会在建表的时候用双引号了？DB2的数据库对象默认使用大写，如果用双引号引起表名，表示你希望表名区分大小写。
试试db2 "select * from \"db2inst6\".\"mask\""
或者进入到DB2命令窗口避免转义双引号，执行select * from "db2inst6"."mask".
给你个例子：
db2 => create table "inst95"."test"(id int)
DB20000I The SQL command completed successfully.
db2 => select * from inst95.test
SQL0204N "INST95.TEST" is an undefined name. SQLSTATE=42704
db2 => select * from INST95.TEST
SQL0204N "INST95.TEST" is an undefined name. SQLSTATE=42704
db2 => select * from "inst95"."test"
ID
-----------
0 record(s) selected.
db2 =>收起
试试db2 "select * from \"db2inst6\".\"mask\""
或者进入到DB2命令窗口避免转义双引号，执行select * from "db2inst6"."mask".
给你个例子：
db2 => create table "inst95"."test"(id int)
DB20000I The SQL command completed successfully.
db2 => select * from inst95.test
SQL0204N "INST95.TEST" is an undefined name. SQLSTATE=42704
db2 => select * from INST95.TEST
SQL0204N "INST95.TEST" is an undefined name. SQLSTATE=42704
db2 => select * from "inst95"."test"
ID
-----------
0 record(s) selected.
db2 =>收起
浏览764
浏览742
浏览739
在developer workbench里面能看到表数据load之后，也显示了成功多少条记录了啊
你不会后面还有个load语句把这个给清空了吧？ljbupc 发表于 2012-7-26 17:08 浏览852
浏览863
查询语句中带上schema看看收起
浏览833