碰到一个问题:在导出包含lobs对象的时候,报错如下:
求指点,在线等。
SQL3104N The Export utility is beginning to export data to file
"CMOBJPROPS14.ixf".
SQL3015N An SQL error "-501" occurred during processing.
SQL0501N The cursor specified in a FETCH or CLOSE statement is not open.
SQLSTATE=24501
SQL3105N The Export utility has finished exporting "0" rows.
表结构:
P570_D_1:/CUBEDATA/LVCUBDAT1/backup/db2mvlist >db2 "describe table PPDB_COG.CMOBJPROPS14"
Data type Column
Column name schema Data type name Length Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
CMID SYSIBM INTEGER 4 0 No
RELATED SYSIBM CLOB 1073741824 0 Yes
MYPAGE SYSIBM CLOB 1073741824 0 Yes
RETENTION SYSIBM CLOB 1073741824 0 Yes
RECIPSEMAIL SYSIBM CLOB 1073741824 0 Yes
5 record(s) selected.
导出语句如下,其他内容导出都成功,唯独有几张表数据无法导出。
export to CMOBJPROPS14.ixf of ixf lobs to /CUBEDATA/LVCUBDAT1/backup/db2mvlist/lobs lobfile CMOBJPROPS14 modified by lobsinfile select * from PPDB_COG.CMOBJPROPS14
数据库版本信息:
P570_D_1:/CUBEDATA/LVCUBDAT1/backup/db2mvlist >db2level
DB21085I Instance "ppdb_cog" uses "64" bits and DB2 code release "SQL09057"
with level identifier "06080107".
Informational tokens are "DB2 v9.5.0.7", "special_27196", "IP23136_27196", and
Fix Pack "7".
Product is installed at "/opt/IBM/db2/V9.5".
收起