You can subscribe to this list here.
2003 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(6) |
Nov
(3) |
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(8) |
Feb
(9) |
Mar
(2) |
Apr
|
May
(12) |
Jun
|
Jul
|
Aug
|
Sep
(3) |
Oct
|
Nov
|
Dec
(6) |
2005 |
Jan
(10) |
Feb
|
Mar
(4) |
Apr
|
May
|
Jun
|
Jul
(4) |
Aug
|
Sep
(2) |
Oct
(2) |
Nov
|
Dec
|
2006 |
Jan
(3) |
Feb
|
Mar
|
Apr
(3) |
May
|
Jun
(21) |
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
(1) |
Dec
|
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(3) |
Jun
|
Jul
(2) |
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
2008 |
Jan
|
Feb
(13) |
Mar
(5) |
Apr
|
May
(1) |
Jun
(2) |
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
(1) |
2009 |
Jan
|
Feb
(3) |
Mar
|
Apr
(6) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
(2) |
Oct
|
Nov
|
Dec
|
From: David K. <ka...@us...> - 2006-06-24 15:11:31
|
On windows/XP, trying to connect to OS mainframe domain with import DB2 con = DB2.Connection('btvmanr.btv.ibm.com:446/BYDB2MFG','user','pw') get: Traceback (most recent call last): File "<interactive input>", line 1, in ? File "DB2.py", line 271, in __init__ self._db = _db2.connect(*args, **kwargs) DatabaseError: ('HY009', -99999, '[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009') Obviously I'm not passing the right dsn. I'm using the same dsn as on AIX java, without the jdbc:db2: prefix, but the same port. I successfully connected to btvmanr using config mgr with db2 8.1. -Dave Katcoff 802-769-4162 |
From: Yuval T. <yu...@su...> - 2006-06-24 09:55:40
|
=D7=A6=D7=99=D7=98=D7=95=D7=98 David Katcoff: > Well, I bought VS2003, installed it, then ran "python setup.py build" a= nd > it went - only one warning (_db2_modile.c(2087) : warning C4018: '<' : > signed/unsigned mismatch) - which I assume is innocuous (I hope). > Now, I need to figure out how to use it, but I have not been able to lo= cate > any docs. I click docs/viw documantation in sourceforge.net and get > nothing. Can anyone guide me to get user doc info? Thx. > =20 The API is (mostly) compliant with python's PEP 249 -- *Python* Database=20 *API* Specification v2.0. <http://www.python.org/dev/peps/pep-0249/> Use it as a reference, and if you need any help, mail the list. :-) Thanks Yuval. |
From: David K. <ka...@us...> - 2006-06-24 02:26:13
|
Well, I bought VS2003, installed it, then ran "python setup.py build" and it went - only one warning (_db2_modile.c(2087) : warning C4018: '<' : signed/unsigned mismatch) - which I assume is innocuous (I hope). Now, I need to figure out how to use it, but I have not been able to locate any docs. I click docs/viw documantation in sourceforge.net and get nothing. Can anyone guide me to get user doc info? Thx. -Dave Katcoff 802-769-4162 |
From: Leons P. <le...@ca...> - 2006-06-22 20:59:42
|
Hi, To install PyDB2, I had to make the following changes in setup.py: - added '/opt/ibm/db2' as a possible path to get_db2_root() Admittedly, I may have installed it to a non-default directory. Not sure. More important is the library dir change: - made library_dirs=[db2_root_dir+'lib', db2_root_dir+'lib32'] Viper Express-C stores its libraries in 'lib32', not 'lib'. The build fails without 'lib32' on my machine. Having both does not cause any errors while building from a clean slate. Take care, -- /* Leons Petrazickis * Database Technology Advocate * Developer Programs, IBM Information Management * Work: 905-413-2332 Mobile: 416-712-2042 * le...@ca... * IBM Certified Solution Developer - XML and Related Technologies */ |
From: Yuval T. <yu...@ad...> - 2006-06-12 13:53:47
|
Alisdair Tullo wrote: > > On Mon, 12 Jun 2006, Yuval Turgeman wrote: >> Use "file _db2.so" and paste back the output. :-) > > I just thought of that :) I can confirm that it is a 64-bit binary. > > I'm also in the process of finding out that I have a 64-bit Python and > so building a 32-bit module for it won't work. I think my best bet > will be to create a 64-bit DB instance. Yep - you have to run everything (db instance, python, and pydb2) either in 32 or 64 bit mode. You can't mix them (db instance 32 bit and python 64 bit for example) |
From: Alisdair T. <ali...@ep...> - 2006-06-12 13:40:44
|
On Mon, 12 Jun 2006, Yuval Turgeman wrote: > Use "file _db2.so" and paste back the output. :-) I just thought of that :) I can confirm that it is a 64-bit binary. I'm also in the process of finding out that I have a 64-bit Python and so building a 32-bit module for it won't work. I think my best bet will be to create a 64-bit DB instance. Thanks for your help, Alisdair | Alisdair Tullo :: epcc :: University of Edinburgh | | ---------------------- :: ali...@ep... | |
From: Yuval T. <yu...@ad...> - 2006-06-12 13:32:36
|
Alisdair Tullo wrote: > When I compiled let setup.py do what it does by default. Looking at > the output, it seems that gcc was given the -m64 option, so it will be > a 64-bit binary. I'll try -m32 and report back. Use "file _db2.so" and paste back the output. :-) |
From: Alisdair T. <ali...@ep...> - 2006-06-12 13:26:02
|
Hi, > Alisdair Tullo wrote: >> I've installed PyDB2 on an Opteron machine running Fedora Core 5 x64. The >> database is DB2 Express-C. .... On Mon, 12 Jun 2006, Yuval Turgeman wrote: > Is your module compiled for 32 or 64 bit ? I should have checked this first, apologies. When I compiled let setup.py do what it does by default. Looking at the output, it seems that gcc was given the -m64 option, so it will be a 64-bit binary. I'll try -m32 and report back. Cheers, Alisdair | Alisdair Tullo :: epcc :: University of Edinburgh | | ---------------------- :: ali...@ep... | |
From: Yuval T. <yu...@ad...> - 2006-06-12 13:20:12
|
Alisdair Tullo wrote: > Hi, > > I've installed PyDB2 on an Opteron machine running Fedora Core 5 x64. The > database is DB2 Express-C. > > When I try to connect from python I get the following error: > > alisdair@xxxx ~: python > Python 2.4.2 (#1, Feb 12 2006, 03:45:41) > [GCC 4.1.0 20060210 (Red Hat 4.1.0-0.24)] on linux2 > Type "help", "copyright", "credits" or "license" for more information. > >>>> import DB2 >>>> DB2.connect(dsn="onetest", uid="alisdair", pwd="xxxx") >>>> > Traceback (most recent call last): > File "<stdin>", line 1, in ? > File "/usr/lib64/python2.4/site-packages/DB2.py", line 271, in __init__ > self._db = _db2.connect(*args, **kwargs) > _db2.DatabaseError: ('HY000', -1042, '[IBM][CLI Driver] SQL1042C An > unexpected system error occurred. SQLSTATE=58004\n') > > and in the db2diag.log I get some warnings of the form: > > 2006-06-09-17.13.52.251413+060 E220936G303 LEVEL: Warning (OS) > PID : 3935 TID : 4069239712 PROC : java > INSTANCE: db2inst1 NODE : 000 > FUNCTION: DB2 UDB, oper system services, sqloclose, probe:110 > CALLED : OS, -, unspecified_system_function OSERR: EBADF (9) > > and one error: > > 2006-06-12-13.54.22.605271+060 I265406E425 LEVEL: Error > PID : 28127 TID : 47166186442352 > FUNCTION: DB2 Common, Cryptography, cryptContextRealInit, probe:40 > MESSAGE : ECF=0x90000403 Unexpected cryptographic error > DATA #1 : Hex, 4 bytes > 0x0 > DATA #2 : Hex, 4 bytes > 0x0 > DATA #3 : Hex, 4 bytes > 0x0 > DATA #4 : String, 78 bytes > /home/db2inst1/sqllib/lib/icc/icclib/libicclib.so: wrong ELF class: > ELFCLASS32 > > This seems to indicate a 64/32 bit problem. I changed the lib and include > paths in db2profile to lib64 and include64 and restarted the database. The > warnings went away but not the error. (It surprised me that this made any > difference since it is a 32-bit instance of the database). > > Any suggestions on how I can diagnose this, or things to try to get it > working, would be much appreciated. Is your module compiled for 32 or 64 bit ? |
From: Alisdair T. <ali...@ep...> - 2006-06-12 13:12:24
|
Hi, I've installed PyDB2 on an Opteron machine running Fedora Core 5 x64. The database is DB2 Express-C. When I try to connect from python I get the following error: alisdair@xxxx ~: python Python 2.4.2 (#1, Feb 12 2006, 03:45:41) [GCC 4.1.0 20060210 (Red Hat 4.1.0-0.24)] on linux2 Type "help", "copyright", "credits" or "license" for more information. >>> import DB2 >>> DB2.connect(dsn="onetest", uid="alisdair", pwd="xxxx") Traceback (most recent call last): File "<stdin>", line 1, in ? File "/usr/lib64/python2.4/site-packages/DB2.py", line 271, in __init__ self._db = _db2.connect(*args, **kwargs) _db2.DatabaseError: ('HY000', -1042, '[IBM][CLI Driver] SQL1042C An unexpected system error occurred. SQLSTATE=58004\n') and in the db2diag.log I get some warnings of the form: 2006-06-09-17.13.52.251413+060 E220936G303 LEVEL: Warning (OS) PID : 3935 TID : 4069239712 PROC : java INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, oper system services, sqloclose, probe:110 CALLED : OS, -, unspecified_system_function OSERR: EBADF (9) and one error: 2006-06-12-13.54.22.605271+060 I265406E425 LEVEL: Error PID : 28127 TID : 47166186442352 FUNCTION: DB2 Common, Cryptography, cryptContextRealInit, probe:40 MESSAGE : ECF=0x90000403 Unexpected cryptographic error DATA #1 : Hex, 4 bytes 0x0 DATA #2 : Hex, 4 bytes 0x0 DATA #3 : Hex, 4 bytes 0x0 DATA #4 : String, 78 bytes /home/db2inst1/sqllib/lib/icc/icclib/libicclib.so: wrong ELF class: ELFCLASS32 This seems to indicate a 64/32 bit problem. I changed the lib and include paths in db2profile to lib64 and include64 and restarted the database. The warnings went away but not the error. (It surprised me that this made any difference since it is a 32-bit instance of the database). Any suggestions on how I can diagnose this, or things to try to get it working, would be much appreciated. Thanks, Alisdair | Alisdair Tullo :: epcc :: University of Edinburgh | | ---------------------- :: ali...@ep... | |
From: Dan S. <de...@gm...> - 2006-06-07 21:42:53
|
Hi David: If you're trying to do all of this with the freely available MS VC++ compilers, I wish you the best of luck. If I recall correctly from my own attempts to accomplish this around December 2005, the problem is that the core Python team decided that they weren't interested in making Python itself compilable with either the free MS VC++ command-line-only compiler or the free version of MS Visual Studio (2005?)... which trickles down to making it really damned hard to compile PyDB2 itself. If you can compile core Python with your setup, then you're probably well on your way (and certainly further ahead than I was!). Dan On 06/06/06, David Katcoff <ka...@us...> wrote: > After reading some forum entries I finally think I'm on the right track. I > simple type in "python setup.py build". After editing _db2_module.c to > change (void *) to (char*) I get the message: error: "The .NET Framework > SDK has to be installed before building extensions for Python". > I then installed the Framwork, but now it's telling me that I need to use > V7.1 of the compiler, so I downloaded an SDK from 2003 which has a VC7 > subdir, but it's complaining about not having V7.1 installed. > > -Dave Katcoff 802-766-4162 > > > > > > _______________________________________________ > PyDB2-discuss mailing list > PyD...@li... > https://lists.sourceforge.net/lists/listinfo/pydb2-discuss > |
From: Yuval T. <yu...@ad...> - 2006-06-07 09:21:17
|
David Katcoff wrote: > After reading some forum entries I finally think I'm on the right track. I > simple type in "python setup.py build". After editing _db2_module.c to > change (void *) to (char*) I get the message: error: "The .NET Framework > SDK has to be installed before building extensions for Python". > I then installed the Framwork, but now it's telling me that I need to use > V7.1 of the compiler, so I downloaded an SDK from 2003 which has a VC7 > subdir, but it's complaining about not having V7.1 installed. > It seems like the problem is with python's distutils - try to play with distutils\msvccompiler.py and see if you can modify the file to fit your current compiler. Yuval. |
From: David K. <ka...@us...> - 2006-06-06 21:15:35
|
After reading some forum entries I finally think I'm on the right track. I simple type in "python setup.py build". After editing _db2_module.c to change (void *) to (char*) I get the message: error: "The .NET Framework SDK has to be installed before building extensions for Python". I then installed the Framwork, but now it's telling me that I need to use V7.1 of the compiler, so I downloaded an SDK from 2003 which has a VC7 subdir, but it's complaining about not having V7.1 installed. -Dave Katcoff 802-766-4162 |
From: David K. <ka...@us...> - 2006-06-06 16:24:41
|
Now I got around the error re not finding python24_d.lib by copying python24.lib to that name. Next, I'm getting a lot of unresolved external symbol msgs from _db2_connect: __imp___Py_Dealloc referenced in function __db2_connect __imp___Py_NegativeRefcount referenced in function __db2_connect _SQLFreeHandle@8 referenced in function __db2_connect ..as a sample: -Dave Katcoff 802-766-4162 |
From: David K. <ka...@us...> - 2006-06-05 18:33:29
|
Two issue: 1) I had the problem mentioned in the forum re SQLPOINTER, so I changed void * -> char * on line 1855. Is that right? 2) Now I'm getting : LINK : fatal error LNK1104: cannot open file 'python24_d.lib' -Dave Katcoff 8-446-4162 |
From: David K. <ka...@us...> - 2006-06-05 16:38:09
|
Dear Bryan and friends, As per my Compile problem, I got the line 1855 error about SQLPOINTER and size. I corrected that by changing (void *) to (char *). Is that right? My link error is: LINK : fatal error LNK1104: cannot open file 'python24_d.lib' -Dave Katcoff 802-769-4162 |
From: Yuval T. <yu...@ad...> - 2006-04-27 08:10:15
|
DAVID ARAKELIAN wrote: >Thank you for your answer, sorry for my late answer :) >I searched what you told me, found how to catalog a remote server >had some problem with "code page" searched and used DB2SET >now it works like a charm! I can finally use the pydb2 lib. > > Great to hear! Why was the code page relevant? Yuval. |
From: Yuval T. <yu...@ad...> - 2006-04-25 14:25:47
|
Patrick K. O'Brien wrote: >David, > >I'm forwarding your question to the pydb2 mailing list where I think you >have a better chance of getting a reply. Feel free to join as well. > >Pat > > The assumption is that your database is cataloged locally. If you can connect using a simple "db2 conncet to <db-alias> user <dbuser>", than you can connect using the db2 module by simply putting the 3 arguments mentioned above in the object's constructor. For further details, search for "db2 catalog database". If you still experience problems, the list is here. :-) Yuval. |
From: Patrick K. O'B. <po...@or...> - 2006-04-25 12:28:47
|
David, I'm forwarding your question to the pydb2 mailing list where I think you have a better chance of getting a reply. Feel free to join as well. Pat -- Patrick K. O'Brien Orbtech http://www.orbtech.com Schevo http://www.schevo.org Louie http://www.pylouie.org -------- Original Message -------- Subject: pydb2 dsn question Date: Tue, 25 Apr 2006 10:34:08 +0200 From: DAVID ARAKELIAN <dav...@et...> To: po...@or..., man...@gm... hello I read https://www6.software.ibm.com/dw/education/dm/db2pylnx a quick little question about the DSN. I am really new to db2, so here is my question I have a IBM db2 server running at : SERVER on PORT and the dns='DBSCXXXX' I instaled the pydb2 module, installation worked fine. the import DB2 too. but when I try to do conn = DB2.connect(dsn='SERVER:PORT/DBSCXXXX',uid='myuser', pwd='mypassword') I obtain: File "/usr/lib/python2.3/site-packages/DB2.py", line 271, in __init__ self._db = _db2.connect(*args, **kwargs) _db2.DatabaseError: ('I', -1, 'Invalid Handle') I think i didn't understodd how the DSN exactly works. could you explain me if I run the server on other port/machine how should I bind the dsn? best regards A.David |
From: frank b. <fb...@ki...> - 2006-01-19 21:07:23
|
Hi Yuval, > I don't understand the following changes, though... > > 1. Calls to Py_DECREF right after PyErr_SetObject were removed. > > 2. In _DB2CursorObj_get_Cursor_Error, Py_BuildValue was changed to > PyTuple* calls. > > 3. In *_dealloc, the calls were changed from PyObject_Del to PyMem_DEL. > Argh!. I fear I'd based my changes on PyDB2-1.1.0-2.tar.gz and not on the actual CVS release. So rollbacked some changes. Frank |
From: Yuval T. <yu...@ad...> - 2006-01-19 11:16:28
|
On Fri, 2006-01-13 at 12:40 -0500, frank balzer wrote: > Hi *, > > I 've just checked in a new version for DB2.py, _db2_module.c, and setup.py. > I added support for multiple result sets and fixed some bugs ( please refer to > CVS). > > Please let me know, if you have any concerns. Hi, First of all, thanks for the help! I don't understand the following changes, though... 1. Calls to Py_DECREF right after PyErr_SetObject were removed. 2. In _DB2CursorObj_get_Cursor_Error, Py_BuildValue was changed to PyTuple* calls. 3. In *_dealloc, the calls were changed from PyObject_Del to PyMem_DEL. Thanks, Yuval. |
From: frank b. <fb...@ki...> - 2006-01-13 17:40:55
|
Hi *, I 've just checked in a new version for DB2.py, _db2_module.c, and setup.py. I added support for multiple result sets and fixed some bugs ( please refer to CVS). Please let me know, if you have any concerns. Frank |
From: Yuval T. <yu...@ad...> - 2005-10-11 07:56:58
|
On Mon, 2005-10-10 at 16:06 -0500, Ines Sombra wrote: > Hello Everyone, > > I've found about PyDB2 by a lucky chance while looking for ways to > connect to a DB2 on iSeries. > I saw that in the mailing list someone asked about this kind of support > already. Well... has there been any decisions on this? are there any > possible attempts to get this going? It shouldn't be a problem. If you can fix me up with access to a machine with the devel packages installed, I'd be more than happy to do it. Thanks, Yuval. |
From: Ines S. <in...@dr...> - 2005-10-10 21:03:52
|
Hello Everyone, I've found about PyDB2 by a lucky chance while looking for ways to connect to a DB2 on iSeries. I saw that in the mailing list someone asked about this kind of support already. Well... has there been any decisions on this? are there any possible attempts to get this going? Thank you very much, Ines -- **************************************************** (o_ (define (Pix-signature foo)(cond ((zero? foo)()) //\ (else (cons 'IS-THIS-ANNOYING??? (Pix-signature (- foo 1)))))) V_/_ (Pix-signature 42) **************************************************** |
From: ??? <yo...@ne...> - 2005-09-20 01:02:14
|
SGkgUHJhdGlrLA0KDQpQbGVhc2UgdHJ5IHRvIGNoYW5nZSBTUUxQT0lOVEVSIHRvIGNoYXIgKiBh dCBsaW5lIDE4NTUuDQpGb3Igbm93IEkgZG9uJ3Qga25vdyB3aHkgTWljcm9zb2Z0IGNvbXBpbGVy IGNvbXBsYWlucyBhYm91dCB0aGUgc2l6ZSBvZiB2b2lkICouDQpTbyBJJ3ZlIG5vdCBjb21taXR0 ZWQgdGhlIHNvdXJjZSB5ZXQuDQpEb2VzIGFueWJvZHkga25vdyB0aGUgcmVhc29uIHdoeT8NCg0K UmVnYXJkcywNCkJyeWFuDQogIC0tLS0tIE9yaWdpbmFsIE1lc3NhZ2UgLS0tLS0gDQogIEZyb206 IFByYXRpayBNZWh0YSANCiAgVG86IHB5ZGIyLWRpc2N1c3NAbGlzdHMuc291cmNlZm9yZ2UubmV0 IA0KICBTZW50OiBUdWVzZGF5LCBTZXB0ZW1iZXIgMjAsIDIwMDUgNzo0OSBBTQ0KICBTdWJqZWN0 OiBbUHlEQjItZGlzY3Vzc10gRXJyb3IgYnVpbGRpbmcgUHlEQjItMS4xLjANCg0KDQogIEhpLA0K DQogICANCg0KICBJIGRvd25sb2FkZWQgYW5kIHVudGFycmVkICh1c2luZyBDeWd3aW4pIFB5REIy LTEuMS4wIGF2YWlsYWJsZSBvbiBTb3VyY2Vmb3JnZSBvbiBhIFdpbmRvd3MgWFAgc3lzdGVtIGFu ZCB0aGVuIHJhbiAncHl0aG9uIHNldHVwLnB5IGJ1aWxkJw0KDQogICANCg0KICBJIGdldCB0aGUg Zm9sbG93aW5nIG1lc3NhZ2Ugd2hpY2ggaXMgdGhlIHNhbWUgYXMgcG9zdGVkIG9uIHNvdXJjZWZv cmdlIGJ1Z3MgbGlzdCBieSBzb21lb25lIGVsc2UgYSBtb250aCBhZ28uDQoNCiAgIA0KDQogICQg cHl0aG9uIHNldHVwLnB5IGJ1aWxkDQoNCiAgWW91ciBEQjIgcm9vdCBpczogQzpcUHJvZ3JhbSBG aWxlc1xJQk1cU1FMTElCXA0KDQogIHJ1bm5pbmcgYnVpbGQNCg0KICBydW5uaW5nIGJ1aWxkX3B5 DQoNCiAgcnVubmluZyBidWlsZF9leHQNCg0KICBidWlsZGluZyAnX2RiMicgZXh0ZW5zaW9uDQoN CiAgQzpcUHJvZ3JhbSBGaWxlc1xNaWNyb3NvZnQgVmlzdWFsIFN0dWRpbyAuTkVUIDIwMDNcVmM3 XGJpblxjbC5leGUgL2MgL25vbG9nbyAvT3ggL01EIC9XMyAvR1ggL0ROREVCVUcgIi1JQzpcUHJv Z3JhbSBGaWxlc1xJQk1cU1FMTElCXGluY2x1ZGUiIC1JYzpcUHl0aG9uMjRcaW5jbHVkZSAtSWM6 XFB5dGhvbjI0XFBDIC9UY19kYjJfbW9kdWxlLmMgL0ZvYnVpbGRcdGVtcC53aW4zMi0yLjRcUmVs ZWFzZVxfZGIyX21vZHVsZS5vYmoNCg0KICBfZGIyX21vZHVsZS5jDQoNCiAgX2RiMl9tb2R1bGUu YygxODU1KSA6IGVycm9yIEMyMDM2OiAnU1FMUE9JTlRFUicgOiB1bmtub3duIHNpemUNCg0KICBf ZGIyX21vZHVsZS5jKDIwODcpIDogd2FybmluZyBDNDAxODogJzwnIDogc2lnbmVkL3Vuc2lnbmVk IG1pc21hdGNoDQoNCiAgIA0KDQogIEFueSBpZGVhcyBhcyB0byBob3cgdG8gcmVzb2x2ZSB0aGlz IGlzc3VlLg0KDQogICANCg0KICBCZXN0IHJlZ2FyZHMsDQoNCiAgIA0KDQogIFByYXRpayBNZWh0 YQ0K |