php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #31489 DB/2 communication problem
Submitted: 2005-01-11 10:05 UTC Modified: 2005-01-11 16:41 UTC
Votes:1
Avg. Score:5.0 ± 0.0
Reproduced:1 of 1 (100.0%)
Same Version:1 (100.0%)
Same OS:1 (100.0%)
From: reto dot baumann at ch dot ibm dot com Assigned:
Status: Not a bug Package: ODBC related
PHP Version: 4.3.10 OS: Suse Linux SuSE SLES-8
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
50 - 6 = ?
Subscribe to this entry?

 
 [2005-01-11 10:05 UTC] reto dot baumann at ch dot ibm dot com
Description:
------------
After an upgrade from DB/2 v8.1 fixpack3 to DB/2 v8.1 fixpack7a (which makes it a DB/2 v8.2) PHP can no longer communicate with DB/2.

Actual result:
--------------
PHP reports:
Warning: odbc_connect(): SQL error: [IBM][CLI Driver] SQL0902C A system error (reason code = "") occurred. Subsequent SQL statements cannot be processed. SQLSTATE=58005 , SQL state 58005 in SQLConnect in ...

The DB/2 log shows the following error:
2005-01-11-10.00.16.574105+060 I195099G405        LEVEL: Severe
PID     : 8937                 TID  : 1024        PROC : db2ipccm
INSTANCE: dinpsdb              NODE : 000
FUNCTION: DB2 UDB, common communication, sqlccGetIPCs, probe:20
RETCODE : ZRC=0x800F0067=-2146500505=SQLO_ID_2LONG
          "USERID/GROUPID is greater than the Shelby Supported size/length"
          DIA8111C Authorization failure.

2005-01-11-10.00.16.574324+060 I195505G278        LEVEL: Severe
PID     : 8937                 TID  : 1024        PROC : db2ipccm
INSTANCE: dinpsdb              NODE : 000
MESSAGE : User ID
DATA #1 : Hexdump, 4 bytes
0xBFFF6B14 : 0402 0000       

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2005-01-11 16:26 UTC] sniper@php.net
You update an external option and immediately think it's PHP bug? You didn't propably even try to recompile PHP either afterwards. No bug in PHP unless proven otherwise.

 [2005-01-11 16:41 UTC] reto dot baumann at ch dot ibm dot com
PHP was certainly recompiled.
Access via Perl and DBI still works, DB/2 CLI access does also work as expected. This leaves (at least to me) two options:
a) a problem within DB/2 handling requests coming from PHP
b) a problem within PHP (malformed/unsupported requests to DB/2)
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Fri Mar 29 06:01:29 2024 UTC