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".