 |
Forums |
Admin  Start New Thread
By: Alex Pitigoi
 RE: Any testing on DB2EC 912? [ reply ]
2007-11-30 21:01
|
|
Steven, the IBM_DB-0.9.2 refresh now available is fixing the error handling for metadata retrieval (tables, columns, index), and should be also address the "swallowing" of SQL error code -805.
|
By: Steven Parkes
RE: Any testing on DB2EC 912? [ reply ]
2007-08-09 18:47
|
Fresh db2 install, freshly created instance.
It may be parts of this are db2 orthogonally related to ibm_db. It'd be nice if someone else could try to replicate.
But there is the other issue that ibm_db is swallowing the error, leading to a higher level error from Rails. Seems like ibm_db shouldn't swallow the error but should probably throw an exception.
|
By: Alex Pitigoi
RE: Any testing on DB2EC 912? [ reply ]
2007-08-09 18:34
|
Oh, this becomes even more interesting...
We only encountered such SQL0805 error message previously while connecting to i5 and z/OS servers.
In theory the bindings on LUW were expected to be handled automatically during version upgrade. I'll probably need to dig a bit more to see what conditions were not satisfied for this to happen while running on Linux.
|
By: Salvador Ledezma
RE: Any testing on DB2EC 912? [ reply ]
2007-07-17 19:15
|
Steven,
one more file to bind...sorry I should have listed it previously.
db2 terminate
db2 connect to <database-name>
db2 bind <db2-path>/sqllib/bnd/db2schema.bnd blocking all grant public sqlerror continue
db2 terminate
Please try this and let us know how it goes.
|
By: Manas Dadarkar
RE: Any testing on DB2EC 912? [ reply ]
2007-07-16 13:29
|
Steven,
I am suspecting that this is a setup issue so I will walk you through some of the options for fixing this. The first thing we need to try is setting the DB2 APPLHEAPSZ database config parameter. Can you do the following
1) Connect to the database you are using in your Rails application using the db2 command line processor. For e.g. you need to run something like
db2 connect to TESTDB using testusr using secret
2) Run this command
db2 get db cfg
In the output of this command, search for the value of APPLHEAPSZ (Default application heap). If this is less than 1024, please run this command
3)db2 update db cfg for <database_name> using APPLHEAPSZ 1024
4) Restart your DB2 instance. This can typically be done with db2stop/db2start.
Please let me know if this fixed your problem.
Thanks,
-Manas
|
By: Steven Parkes
RE: Any testing on DB2EC 912? [ reply ]
2007-07-13 18:42
|
Yes, on 912 (having reinstalled it) I see what I've seen before.
db2level: Informational tokens are "DB2 v9.1.0.2", "special_17369", "MI00183_17369", and
Fix Pack "2".
I dumped my db under 910 and restored under 912 (but had this happen under start-from-scratch with 912 as well).
The problem is that the SQLColumns call is failing (and this failure is getting swallowed!) I made the code print the error string and it's:
[IBM][CLI Driver][DB2/LINUXX8664] SQL0443N Routine "SYSIBM.SQLCOLUMNS" (specific name "COLUMNS") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-805". SQLSTATE=38553 SQLCODE=-443
I'm not expert enough in db2 to know either why this is happening now or what to do about it.
|
By: Steven Parkes
RE: Any testing on DB2EC 912? [ reply ]
2007-07-11 20:14
|
Responding to comments:
1) I've never set DB2INSTANCE
2) My current (working) install is
Informational tokens are "DB2 v9.1.0.0", "s060629", "LINUXAMD64", and Fix Pack
"0".
I don't have the failed install up now (had to get it working, so manged to my old download of 910 and installed that. I'll reinstall 912 and confirm (or retract) the failure.
3) I didn't follow any of the steps in the README. It's a gem. Who looks at READMEs? Who even knows they're there? (Who knows what magic gem install ibm_db does?)
That said, I don't see anything relevant to the issue here. I did reinstall the gem with 912 installed to make sure that wasn't an issue but it didn't seem to be. I also recreated the database in case there was something 912 didn't like about 910 databases. All still no go.
Perhaps it's a corner case for x86_64 with 912? Anyone else running that?
Also, can I humbly suggest you split the changelog out from the readme? Most(?) people will stop reading when they see that stuff at the top.
|
By: Manas Dadarkar
RE: Any testing on DB2EC 912? [ reply ]
2007-07-11 11:52
|
Steven,
You can find the fixpack level of any particular DB2 version by running the db2level command. That should give you detailed information about the version and fixpack level you are running.
Thanks,
-Manas
|
By: Steven Parkes
RE: Any testing on DB2EC 912? [ reply ]
2007-07-11 02:25
|
I'm using the 9.1.2 download. Whether that equates to FP2 or not, I don't know.
This is a regression from 9.1.0 which I have running on another pretty identically configured machine.
I tracked it as far as receiving a null (apparently) back from the ruby call to the shared library asking for the columns object.
There are no errors shown in the log or elsewhere. Just nil returned.
|
|
|
