-
rwisser made 1 file-release changes.
2009-11-10 12:40:01 UTC by rwisser
-
rwisser made 2 file-release changes.
2009-11-10 12:32:01 UTC by rwisser
-
rwisser committed revision 694 to the Jailer SVN repository, changing 6 files.
2009-11-10 12:22:54 UTC by rwisser
-
good idea, I will do that, thanks again
Diann.
2009-10-23 12:50:32 UTC by diann
-
Maybe it's the best to work with more than one Jailer instance in your case, one for LUW, one for Mainframe DB2 and so on. This way, the different data models (settings) would not interfere with each other.
Ralf.
2009-10-23 12:45:28 UTC by rwisser
-
the last schema I introspected was a LUW instance but the schema I wanted to work with was not. Is it possible the LUW settings get left over if I didnt re-introspect the mainframe schema? As you can tell, we have a mix of technologies, LUW, Mainframe DB2 and Oracle.....
Thanks :)
2009-10-23 12:07:24 UTC by diann
-
Hi Diann,
the keys of the tool's specific tables are composed of the keys found in schema that has been analyzed (aka introspected). Is it possible that the schema you've analyzed differs from the schema from which you want to export data? If the only difference is the BIGINT vs. INTEGER typing, the easiest way to make the tool work is to change the key types in the file...
2009-10-23 08:14:34 UTC by rwisser
-
I just found out from my DBA that BIGINT is not a valid data type for z/os DB2 version 8, so if you want this tool to work with this version of DB2 it needs to go back to integer when creating the jailer specific tables and their keys.
Thanks....
2009-10-22 13:50:26 UTC by diann
-
I just downloaded the latest version an am getting the following error when attempting to extract data from mainframe DB2 tables, I can send the sql.log file if that helps
2009-10-22 09:36:38,515 [jailer-main] ERROR - DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=BIGINT, DRIVER=3.53.70
com.ibm.db2.jcc.b.co: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=BIGINT, DRIVER=3.53.70.
2009-10-22 13:40:54 UTC by nobody
-
rwisser made 1 file-release changes.
2009-10-12 10:02:01 UTC by rwisser
