1

While I am trying to import a shapefile using db2se import_shape file utility, 

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

Any idea why this error happens? I tried in all forums and not able to debug it.

Improve this question
4
  • Looks like a botched or incomplete installation. Does the test program (described here: www-01.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/…) run successfully?
    – mustaccio
    Commented Jun 5, 2014 at 12:34
  • Yes it did. In fact, from another db2 client, the same statement works successfully
    – Senthil
    Commented Jun 6, 2014 at 2:49
  • 1
    Is that another db2 client of the same version? Do both client versions match the server version?
    – mustaccio
    Commented Jun 6, 2014 at 11:35
  • Thanks for the tip. I used db2level to find the client version and the client version which was working was DB2 v9.7.500.702 and the one that was not working as DB2 v9.7.0.441
    – Senthil
    Commented Jun 6, 2014 at 11:55

1 Answer 1

Reset to default
1

I used db2level to check the client version and found that the client version was the mismatch.

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".
Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.