import into db2 fails

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Christian Welzel
    #1

    import into db2 fails

    Hi there,

    currently i'm trying to migrate a mysql-db to db2 express-c.
    therefor i use the data migration toolkit and all seems just
    fine until the point where mtk tries to import the data.
    the tables are created just fine, at least i can see them in
    the db2cc. but while importing data i get these exceptions:

    Fri Mar 28 23:39:38 GMT+01:00 2008 ERROR VERIFICATIONITE M \
    SQL error -668 on SELECT COUNT(*) FROM "DB2INST1"."ALL IANCE_APPLICATI ONS" \
    : com.ibm.db2.jcc .b.SqlException : DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, \
    SQLERRMC=3;DB2I NST1.ALLIANCE_A PPLICATIONS, DRIVER=3.50.152
    com.ibm.db2.jcc .b.SqlException : DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=3; \
    DB2INST1.ALLIAN CE_APPLICATIONS , DRIVER=3.50.152
    at com.ibm.db2.jcc .b.wc.a(wc.java :55)
    at com.ibm.db2.jcc .b.wc.a(wc.java :126)
    at com.ibm.db2.jcc .b.jk.b(jk.java :3578)
    at com.ibm.db2.jcc .b.jk.a(jk.java :3560)
    at com.ibm.db2.jcc .t4.db.a(db.jav a:730)
    at com.ibm.db2.jcc .t4.db.m(db.jav a:719)
    at com.ibm.db2.jcc .t4.db.i(db.jav a:244)
    at com.ibm.db2.jcc .t4.db.c(db.jav a:52)
    at com.ibm.db2.jcc .t4.t.c(t.java: 44)
    at com.ibm.db2.jcc .t4.sb.i(sb.jav a:153)
    at com.ibm.db2.jcc .b.tk.P(tk.java :1438)
    at com.ibm.db2.jcc .b.tk.a(tk.java :2217)
    at com.ibm.db2.jcc .b.tk.a(tk.java :557)
    at com.ibm.db2.jcc .b.tk.executeQu ery(tk.java:541 )
    at com.ibm.mtk.mod el.verification .MTKVerificatio nItemExtension. verify(MTKVerif icationItemExte nsion.java:2113 )
    at com.ibm.mtk.mod el.verification .MTKVerificatio n.verify(MTKVer ification.java: 1224)
    at com.ibm.mtk.mod el.deployment.M TKDeploymentMod elElement.deplo y(MTKDeployment ModelElement.ja va:879)
    at com.ibm.mtk.ui. deployment.MTKD eploymentView$1 1.run(MTKDeploy mentView.java:1 015)

    Why does this happen?
    The database is installed on a remote server (linux), mtk is running
    on my desktop pc (linux).

    In Deploy_ETS.log there are some messages like this:

    SQL2036N Der Pfad für die Datei oder Einheit
    "/home/gawain/mtk/projects/B/DataOutScripts/ETS_admin_agb_d elict.out" ist
    ungültig.

    What does this mean?
    I can access this file just fine with cat or more.

    --
    MfG, Christian Welzel aka Gawain@Regenbog en

    GPG-Key: http://www.camlann.de/key.asc
    Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15
    Tags: None
    • Christian Welzel
      #2
      Re: import into db2 fails

      Serge Rielau wrote:
      Anyway since all this happens on your desktop, if all else fails just
      make the directory path and file accessible to everyone...
      I made my whole user dir rwx to all (chown -R a+rwx) and tried
      again... same messages. I dropped the db2 database and created
      it again... next try... same -668 error message.
      I will try to reinstall the whole db2 thingy on the server from scratch,
      perhaps something changes after that.

      --
      MfG, Christian Welzel

      GPG-Key: http://www.camlann.de/key.asc
      Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15

        Comment

        • Serge Rielau
          #3
          Re: import into db2 fails

          Christian Welzel wrote:
          Serge Rielau wrote:
          >
          >Anyway since all this happens on your desktop, if all else fails just
          >make the directory path and file accessible to everyone...
          >
          I made my whole user dir rwx to all (chown -R a+rwx) and tried
          again... same messages. I dropped the db2 database and created
          it again... next try... same -668 error message.
          I will try to reinstall the whole db2 thingy on the server from scratch,
          perhaps something changes after that.
          >
          Have you sent a note to the MTK folks?
          I have my doubts that reinstalling DB2 will help.
          It must be something obvious - in hindsight.

          Cheers
          Serge
          --
          Serge Rielau
          DB2 Solutions Development
          IBM Toronto Lab

            Comment

            • Christian Welzel
              #4
              Re: import into db2 fails

              Serge Rielau wrote:
              Have you sent a note to the MTK folks?
              I think so.
              I have my doubts that reinstalling DB2 will help.
              You are right. It didnt help.
              At least now i get more exceptions... but not because of the
              new installation but i extracted the data a second time.
              Now MTK is complaining about the missing MySqlCatalog database...
              again.
              Unfortunately i cannot rememeber how i made this error go away
              the last time. damn.
              It must be something obvious - in hindsight.
              i didnt hope so. This would mean i wasted a lot of time and it
              would me my fault ... NEVER! :)

              --
              MfG, Christian Welzel aka Gawain@Regenbog en

              GPG-Key: http://www.camlann.de/key.asc
              Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15

                Comment

                • Serge Rielau
                  #5
                  Re: import into db2 fails

                  Christian Welzel wrote:
                  Serge Rielau wrote:
                  >
                  >Have you sent a note to the MTK folks?
                  >
                  I think so.
                  >
                  >I have my doubts that reinstalling DB2 will help.
                  >
                  You are right. It didnt help.
                  At least now i get more exceptions... but not because of the
                  new installation but i extracted the data a second time.
                  Now MTK is complaining about the missing MySqlCatalog database...
                  again.
                  Unfortunately i cannot rememeber how i made this error go away
                  the last time. damn.
                  >
                  >It must be something obvious - in hindsight.
                  >
                  i didnt hope so. This would mean i wasted a lot of time and it
                  would me my fault ... NEVER! :)
                  >
                  Hmmm.. Have you tried posting in the DB2 Express C forum?
                  - IBM TechXchange Community
                  http://www.ibm.com/developerworks/forums/forum.jspa?forumID=805

                  I'd guess that most expertise on MySQL -DB2 enablement will be
                  concentrated there.

                  Cheers
                  Serge

                  --
                  Serge Rielau
                  DB2 Solutions Development
                  IBM Toronto Lab

                    Comment

                    • Christian Welzel
                      #6
                      Re: import into db2 fails

                      Serge Rielau schrieb:
                      >>Have you sent a note to the MTK folks?
                      Got some answer. They tell me, that i'm using JCC T4 driver but MTK requires a
                      JCC T2 driver. I will try to switch the drivers this evening and try again.
                      If you could figure out how to do that as the driver i'm using is the default
                      one of my local db2 client installation...
                      Hmmm.. Have you tried posting in the DB2 Express C forum?
                      Nope. I didnt know about this one.
                      I will try the other jdbc driver and ask there thereafter.

                      Bye, Christian

                        Comment

                        Previous template Next
                        Working...