We did open PMRs, IBM has admitted there are issues and are working on
them.
As I said, our entire app has been coded in stored procs (1800 SQL procs &
200 External proc) & UDFs.
We have used IBM Migration toolkit for most part.
We have actually crashed it while just compiling a SQL stored proc....IBM
told us that we have put 'DECLARE'
statements at wrong places and advised to reorder the statments in the proc
and it solved the crash problem.
I guess it is definitely a bug, as I expect a syntax error if I put a
DECLARE statement at a wrong place
and not a server crash.
Some times, the server crashes when we try to debug procs using
Developement Center which is very easy
to reproduce. We opened another PMR and IBM is working on it.
As multiple developers keep working sometimes it is difficult to figure out
who and what crashed the server.
"Mark A" <ma@switchboard.net> wrote in message
news:bH******************@news.uswest.net...
Serge Rielau wrote: In DB2 V8 SQL Procedures run always UNFENCED because they are not
supposed to crash. Did you open an PMR to get teh crash investigated?
Cheers
Serge
You mean there are things in DB2 that ARE supposed to crash? ;-)
--
Daniel Morgan
Daniel, this just proves that you are nothing but troll. A rather sad and
pathetic example for a teacher to his students.