import into db2 fails

[Christian Welzel]

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 VERIFICATIONITEM \
SQL error -668 on SELECT COUNT(*) FROM "DB2INST1"."ALLIANCE_APPLICATIONS" \
: com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, \
SQLERRMC=3;DB2INST1.ALLIANCE_APPLICATIONS, DRIVER=3.50.152
com.ibm.db2.jcc.b.SqlException: DB2 SQL Error: SQLCODE=-668, SQLSTATE=57016, SQLERRMC=3; \
DB2INST1.ALLIANCE_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.java:730)
at com.ibm.db2.jcc.t4.db.m(db.java:719)
at com.ibm.db2.jcc.t4.db.i(db.java:244)
at com.ibm.db2.jcc.t4.db.c(db.java:52)
at com.ibm.db2.jcc.t4.t.c(t.java:44)
at com.ibm.db2.jcc.t4.sb.i(sb.java: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.executeQuery(tk.java:541)
at com.ibm.mtk.model.verification.MTKVerificationItem Extension.verify(MTKVerificationItemExtension.java :2113)
at com.ibm.mtk.model.verification.MTKVerification.ver ify(MTKVerification.java:1224)
at com.ibm.mtk.model.deployment.MTKDeploymentModelEle ment.deploy(MTKDeploymentModelElement.java:879)
at com.ibm.mtk.ui.deployment.MTKDeploymentView$11.run (MTKDeploymentView.java:1015)

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_delict.out" ist
ungültig.

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

--
MfG, Christian Welzel aka Gawain@Regenbogen

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

[Christian Welzel]

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

[Serge Rielau]

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

[Christian Welzel]

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@Regenbogen

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

[Serge Rielau]

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?
http://www.ibm.com/developerworks/fo...pa?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

[Christian Welzel]

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