Prev: WBI Monitor
Next: The column name as com.ibm.db2.jcc.b.dc@1d5b3a
From: Serge Rielau on 25 Dec 2007 09:50
2803stan(a)gmail.com wrote:
> I know that you are snowed in; I don't know if you got clobbered as
> they did in Montr�al. I have friends in Montr�al who can't move. I
> am in South Florida and used to live (for 35 years) in Canada. Cheers
> and sympathy!
We got a warm spell. Whatever Montreal got as snow we got as rain.
As a result the driveway is an ice-rink.. a tilted ice rink :-(
The effect is the same - can't move.

W.r.t a re-install from scratch. Perhaps a good idea.
If nothing else it will exclude all the dubious scenarios.

I'm just coming out of a serious DB2 9.5 PMR with an ISV. Similar thing:
-440.
Swore they did not play with PATH.. until we found it in the CLI trace.
q.e.d.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
From: 2803stan on 26 Dec 2007 20:53
On Dec 23, 7:52 pm, Serge Rielau <srie...(a)ca.ibm.com> wrote:
> 2803s...(a)gmail.com wrote:
> > Anyway, the matter at hand . . .  After changing things in the
> > db2cli.ini file, I now have the stored procs back, but the UDFs can't
> > be found.  And just before writing this, I got my first ever (I've
> > been using db2 since version 2) SQLSTATE 56098 on an SP that has been
> > in use without a glitch for at least a year.  I'm the owner and am
> > signed on as such.
>
> SQLSTATE 56098: An error occurred during implicit rebind or prepare.
>
> There are multiple SQLCODEs that can get you there.
> What was the complete message? (May be echo-ed in the db2diag.log).
>
> > In order to keep business going, I'm going to reinstall Version 8.x
> > and wait this out.  (I did check the memory and HDD of my machines,
> > and no errors are found after full-day runs.)
>
> I doubt this is install related, and it sure isn't HDD related.
>
> Cheers
> Serge
>
> PS: I do not consider the windows registry a marvel of innovation.
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab

I have sent this to the appropriate forum, but no one as replied.

I have now tried this on two servers and two clients. Same results
both times. This is a bug with DB2. Or the different PATH variables
are so complicated that I can't figure them out. And I shouldn't have
to.

I tried re-installing V8.x, but get lots of errors, maybe related to
leftovers from 9.1 and 9.5. I don't have time for all this, it's two
weeks now -- I have a business to run and I have to feed my family.
And I know that SQL Server works . . .

With best wishes and tears in my eyes,

SS
From: Mark A on 26 Dec 2007 21:29
<2803stan(a)gmail.com> wrote in message
news:381c4ebd-cf57-4ece-a78f-c32c413e8f3f(a)e23g2000prf.googlegroups.com...
>I tried re-installing V8.x, but get lots of errors, maybe related to
>leftovers from 9.1 and 9.5. I don't have time for all this, it's two
>weeks now -- I have a business to run and I have to feed my family.
>And I know that SQL Server works . . .
>
>With best wishes and tears in my eyes,
>
>SS

Why would you install software (V9.5) that was just released and has no
fixpacks available yet? Are you from Mars?


From: Knut Stolze on 27 Dec 2007 05:08
Serge Rielau wrote:

> This has absolutely nothing to do with self managing databases.
> May I remind you that PATH is not a DB2 special. It's in PostgreSQL, SQL
> Server, oh.. and Unix, Windows, Linux, ....

Don't forget z/OS in the list... ;-)

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
From: Stefano P. on 27 Dec 2007 09:01
>> This has absolutely nothing to do with self managing databases.
>> May I remind you that PATH is not a DB2 special. It's in PostgreSQL, SQL
>> Server, oh.. and Unix, Windows, Linux, ....

> Don't forget z/OS in the list... ;-)

And i5/OS too: there it's usualy named as "library list" (and may be you
have to use "/" instead of "." to full qualify names) but it's the same
concept ;-)
(and DB2 for i5/OS is rather "self managing" :-)


Cheers
Stefano P.

--
"Niuna impresa, per minima che sia,
pu� avere cominciamento e fine senza queste tre cose:
e cio� senza sapere, senza potere, senza con amor volere"
[Anonimo fiorentino, XIV sec.]

(togliere le "pinzillacchere" dall'indirizzo email ;-)
First  |  Prev  |  Next  |  Last
Pages: 1 2 3 4 5
Prev: WBI Monitor
Next: The column name as com.ibm.db2.jcc.b.dc@1d5b3a