Bug #44627 for DBD-DB2: DBD-DB2 V1.3 use with DB2 V9

Fri Mar 27 14:02:01 2009 rainer.schmied [...] imcons.de - Ticket created

Subject:	DBD-DB2 V1.3 use with DB2 V9
Date:	Fri, 27 Mar 2009 19:01:37 +0100
To:	<bug-DBD-DB2 [...] rt.cpan.org>
From:	"Rainer Schmied" <rainer.schmied [...] imcons.de>

Download image001.jpg
image/jpeg 2.6k

Hi rt cpan I am using DBD-DB2 V1.3 in an OTRS environment with DB2 V8, this works fine. But IBM needs to upgrade the database to DB2 V9, so now I am testing the environment again. At the first step I have installed DB2 V9 over a existing version 8. Here I get no errors. So in the next step I installed the DB2 V9 in separately VM and make a initial schema create and a load of the tablecontents. At this time I get the following errors: even when the application stores data in a clob field with size of 199680 the content will stored at the table. But retrieving the content brings only the first 50 Bytes back. So the application dont get the full information of the content and the processing stops. However there must be a different in the handling of clob form DB2 V8 to DB2 V9. So my question is: is this a known problem of the package or must there be a customization by the application? Thanks in advance Kand Regards/Mit freundlichen Grüßen Rainer Schmied Senior Consultant IMCons® GmbH Lyoner Str. 20 60528 Frankfurt Telefon: ++49 (0)69 660538-22 Telefax: ++49 (0)69 660538-10 Web-Präsenz: <http://www.imcons.de/> www.imcons.de zuständiges Registergericht: Frankfurt am Main, HRB: 53928, Ust.-ID Nr.: DE813439879 Geschäftsführer: Manfred Lepschy Bankverbindung: Frankfurter Sparkasse, BLZ 500 502 01, Konto-Nr. 0200227297 Diese E-Mail enthält vertrauliche oder rechtlich geschützte Informationen. Wenn Sie nicht der beabsichtigte Empfänger sind, informieren Sie bitte sofort den Absender und löschen Sie diese E-Mail. Das unbefugte Kopieren dieser E-Mail oder die unbefugte Weitergabe der enthaltenen Informationen ist nicht gestattet. The information contained in this message is confidential or protected by law. If you are not the intended recipient, please contact the sender and delete this message. Any unauthorised copying of this message or unauthorised distribution of the information contained herein is prohibited.

Sat Mar 28 00:49:32 2009 opendev [...] us.ibm.com - Status changed from 'new' to 'open'

Sat Mar 28 00:49:47 2009 opendev [...] us.ibm.com - Taken

Sat Mar 28 01:51:55 2009 opendev [...] us.ibm.com - Correspondence added

RT-Send-CC:

opendev [...] us.ibm.com

Hi Rainer Thank you for reporting this bug. I would request you to either try the following things. 1. Upgrade your distribution to DBD::DB2-1.71 (latest). This has many changes for fetching LONG/LOB types. 2. If the error still exists, please provide me with a test case so that I can try to reproduce the same scenario. -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Mon Mar 30 09:17:32 2009 rainer.schmied [...] imcons.de - Correspondence added

CC:	<friedmar [...] acm.org>
Subject:	AW: [rt.cpan.org #44627] DBD-DB2 V1.3 use with DB2 V9
Date:	Mon, 30 Mar 2009 15:17:09 +0200
To:	<bug-DBD-DB2 [...] rt.cpan.org>
From:	"Rainer Schmied" <rainer.schmied [...] imcons.de>

Hi Tarun, now I have verified my installations and can isolate the problems. The clob errors come definitive from the 1.7 Version of the cpan repository. In the attachment I have a little perl script who is using the otrs Environment and creates, drop, insert and read a table with clob fields. With using the 1.7 Version I get only 50 Bytes left by reading. If I use the 1.3 Version I get 91 Bytes left. As a workaround I could use the 1.3 Version. But however there is no more download provided for ppm at cpan.org. So my request for friedmar (who is a developer for connecting OTRS to db2) could you please verify this version? Many thanks Rainer Show quoted text

-----Ursprüngliche Nachricht----- Von: IBM OpenDev via RT [mailto:bug-DBD-DB2@rt.cpan.org] Gesendet: Samstag, 28. März 2009 06:52 An: rainer.schmied@imcons.de Betreff: [rt.cpan.org #44627] DBD-DB2 V1.3 use with DB2 V9 <URL: https://rt.cpan.org/Ticket/Display.html?id=44627 > Hi Rainer Thank you for reporting this bug. I would request you to either try the following things. 1. Upgrade your distribution to DBD::DB2-1.71 (latest). This has many changes for fetching LONG/LOB types. 2. If the error still exists, please provide me with a test case so that I can try to reproduce the same scenario. -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Download test_db_04.zip
application/x-zip-compressed 1.6k

Message body not shown because it is not plain text.

Wed Apr 01 14:54:20 2009 opendev [...] us.ibm.com - Correspondence added

RT-Send-CC:

friedmar [...] acm.org, opendev [...] us.ibm.com

Hi Reiner There was some CLOB truncation that I had noticed in versions before 1.71. I had fixed those and did intensive testing too before the release. It might be possible that I missed a use-case where you guys are stuck. The sample that you have sent me, looks like a wrapper over the driver to facilitate the OTRS environment. Unfortunately, it is pretty hard for me to repro the same environment. Thus I would suggest you to try out the following. 1. Update to the latest DB2 driver 1.71. CPAN has it updated. http://theoryx5.uwinnipeg.ca/ppms/ http://cpan.uwinnipeg.ca/PPMPackages/10xx/ If it does not work with this then I request you to do the following 2. Please send me a repro of the sample test case that connects directly to the database. This would help me to repro the same environment. Since I ran simple perl test cases of inserting and retrieving atleast 10 MB of CLOB data, things worked okay for me. If it is possible for you, then please send me the DBI Trace and CLI Trace for better debugging Steps to take DBI Trace $ DBI_TRACE=3 perl test.pl 2> DBITrace.log Steps to take CLI Trace Turing CLI trace On/Off using CLP: * Make an environment variable named DB2CLIINIPATH and set it to some directory where your local db2cli.ini will reside. eg. in bash, do Setting DB2CLIINIPATH (Bash) export DB2CLIINIPATH=<dir name> On Windows, do Setting DB2CLIINIPATH (Windows) set DB2CLIINIPATH=<dir name> * issue the following commands ( in windows run these commands in the DB2 command prompt, issue db2cmd for the same) db2 update cli cfg for section COMMON using trace 1 db2 update cli cfg for section COMMON using tracepathname <dir name> * Local db2cli.ini file should be generated in mentioned directory. * Run the application using db2. New traces will be generated inside mentioned directory. * To disable the CLI trace issue the following command db2 update cli cfg for section COMMON using trace 0 -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Tue Apr 07 04:30:06 2009 rainer.schmied [...] imcons.de - Correspondence added

CC:	"'Friedmar Moch'" <friedmar [...] friedmar-moch.de>
Subject:	AW: [rt.cpan.org #44627] DBD-DB2 V1.3 use with DB2 V9
Date:	Tue, 7 Apr 2009 10:29:44 +0200
To:	<bug-DBD-DB2 [...] rt.cpan.org>
From:	"Rainer Schmied" <rainer.schmied [...] imcons.de>

Hallo Tarun, sorry for my late response, but I have had many to do's the last week. So now I have verified your latest version 1.71. With my test program and the installed otrs environment I must say it works very fine. So many thanks for your readiness for action and your fast response. Thanks a lot Rainer Show quoted text

-----Ursprüngliche Nachricht----- Von: IBM OpenDev via RT [mailto:bug-DBD-DB2@rt.cpan.org] Gesendet: Mittwoch, 1. April 2009 20:54 An: rainer.schmied@imcons.de Betreff: [rt.cpan.org #44627] DBD-DB2 V1.3 use with DB2 V9 <URL: https://rt.cpan.org/Ticket/Display.html?id=44627 > Hi Reiner There was some CLOB truncation that I had noticed in versions before 1.71. I had fixed those and did intensive testing too before the release. It might be possible that I missed a use-case where you guys are stuck. The sample that you have sent me, looks like a wrapper over the driver to facilitate the OTRS environment. Unfortunately, it is pretty hard for me to repro the same environment. Thus I would suggest you to try out the following. 1. Update to the latest DB2 driver 1.71. CPAN has it updated. http://theoryx5.uwinnipeg.ca/ppms/ http://cpan.uwinnipeg.ca/PPMPackages/10xx/ If it does not work with this then I request you to do the following 2. Please send me a repro of the sample test case that connects directly to the database. This would help me to repro the same environment. Since I ran simple perl test cases of inserting and retrieving atleast 10 MB of CLOB data, things worked okay for me. If it is possible for you, then please send me the DBI Trace and CLI Trace for better debugging Steps to take DBI Trace $ DBI_TRACE=3 perl test.pl 2> DBITrace.log Steps to take CLI Trace Turing CLI trace On/Off using CLP: * Make an environment variable named DB2CLIINIPATH and set it to some directory where your local db2cli.ini will reside. eg. in bash, do Setting DB2CLIINIPATH (Bash) export DB2CLIINIPATH=<dir name> On Windows, do Setting DB2CLIINIPATH (Windows) set DB2CLIINIPATH=<dir name> * issue the following commands ( in windows run these commands in the DB2 command prompt, issue db2cmd for the same) db2 update cli cfg for section COMMON using trace 1 db2 update cli cfg for section COMMON using tracepathname <dir name> * Local db2cli.ini file should be generated in mentioned directory. * Run the application using db2. New traces will be generated inside mentioned directory. * To disable the CLI trace issue the following command db2 update cli cfg for section COMMON using trace 0 -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Thu Apr 09 10:57:30 2009 opendev [...] us.ibm.com - Correspondence added

RT-Send-CC:

opendev [...] us.ibm.com

Hi Rainer Thanks a lot for your response. Glad to hear that it works fine with version 1.71. Closing this issue now. Thanks and Regards Tarun Pasrija

Fri Apr 10 00:55:26 2009 opendev [...] us.ibm.com - Correspondence added

Closing this issue now. -- Thanks Tarun Pasrija IBM OpenSource Application Development Team India Software Labs, Bangalore (India)

Fri Apr 10 00:55:27 2009 opendev [...] us.ibm.com - Status changed from 'open' to 'resolved'