主页 / dba / 问题 / 66612
Accepted
Senthil
Asked: 2014-06-05 22:22:04 +0800 CST

Spatial Loader DB2 在导入形状文件时出错

  • 772

当我尝试使用 db2se import_shape 文件实用程序导入 shapefile 时，

db2se import_shape <dbname> -userId <userid> -pw <password> -fileName U:\ShapeFiles\ShapeFilesMarch2014\SubLimits\Africa_Criteria_Data\AF-CIV.shp -inputAttrColumns N(FIPS_CNTRY) -srsName WGS84_SRS_1003 -tableSchema GEXPDBA -tableName TPOLYGON_STAGING -tableAttrColumns VC_FLD_1 -createTableFlag 0 -spatialColumn POLYGON_OB -typeSchema db2gse -typeName st_multipolygon -messagesFile C:\AF-CIV.txt -client 1

GSE0206N  A SELECT statement failed.  SQLERROR = "SQL0805N  Package    "DB2GSE.GSEIEIMP 0X4141414141644459" was not found.  SQLSTATE=51002".

知道为什么会发生此错误吗？我在所有论坛上都试过了，但无法调试它。

db2 spatial

1 个回答

  1. Best Answer

    我用db2level查看客户端版本，发现是客户端版本不匹配。

    Not working client version
--------------------------
DB21085I  Instance "DB2" uses "32" bits and DB2 code release "SQL09070" with
level identifier "08010107". Informational tokens are "DB2 v9.7.0.441", "s090521", "NT3297", and Fix Pack "0".

Working Client version
----------------------
DB21085I  Instance "DB2" uses "32" bits and DB2 code release "SQL09075" with
level identifier "08060107". Informational tokens are "DB2 v9.7.500.702", "s111017", "IP23286", and Fix Pack "5".
    • 1

相关问题