DARI (Stored Procedure) process has been terminated abnormally

DARI (Stored Procedure) process has been terminated abnormally

Post by Marco Angel » Thu, 15 Mar 2001 19:51:49



Hi to all,
    After a succesfull installation of DB2 onto a Linux machine
I tried to create a database, create some tables, fill up the tables
and of course send some sql retrivial requests to it.
All works well. The stored procedures instead returns me this
error during the create command:

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL1131N  DARI (Stored Procedure) process has been terminated abnormally.
SQLSTATE=38503

Do you have any suggestion?
Thanks in advance for any help you may give.

Marco Angeli

 
 
 

DARI (Stored Procedure) process has been terminated abnormally

Post by Sean McKeoug » Thu, 15 Mar 2001 23:22:01


I presume this is an SQL procedure you're creating?

If you're running EEE make sure that the create procedure is being done on the catalog node. If EE, or you're doing this already you should collect a trace of the create procedure, and contact service.

  Hi to all,
      After a succesfull installation of DB2 onto a Linux machine
  I tried to create a database, create some tables, fill up the tables
  and of course send some sql retrivial requests to it.
  All works well. The stored procedures instead returns me this
  error during the create command:

  DB21034E  The command was processed as an SQL statement because it was not a
  valid Command Line Processor command.  During SQL processing it returned:
  SQL1131N  DARI (Stored Procedure) process has been terminated abnormally.
  SQLSTATE=38503

  Do you have any suggestion?
  Thanks in advance for any help you may give.

  Marco Angeli

 
 
 

DARI (Stored Procedure) process has been terminated abnormally

Post by Marco Angel » Fri, 16 Mar 2001 20:55:48


Thanks you very much,
    but in fact I just re-installed and now it works fine.
The unique thing I changed during the installation is the automatic
creation of the sample db.... maybe this is the reason, maybe not,
the essential is that now it works!

Cheers
Marco

 
 
 

1. SQL1131N DARI (Stored Procedure) process has been terminated abnormally

I have a java application that calls a DB2 stored procedure. The stored
procedure is also written in java.
When I run my application under WindowsNT, the stored procedure works fine,
but when I try it under Windows2000 I got the following error messages :

"db2dari.exe a gnr des erreurs et sera ferm par Windows. Vous devez
redemarrer le Programme. Un journal des erreurs est en cour de cration."
(db2dari has generated errors and will be closed by Windows. You must
restart the programm. A log file will be created.")

COM.ibm.db2.jdbc.app.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1131N Un
processus DARI (procdure mmorise) s'est termin de manire anormale.
SQLSTATE=38503

        at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGe
nerator.java,
 Compiled Code)
        at
COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGen
erator.java:3
70)
        at
COM.ibm.db2.jdbc.app.DB2CallableStatement.execute2(DB2CallableStatement.java
:926)
        at
COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatement.java:
2128)

The DB2 db2diag.log file contains :

"
2001-03-14-14.33.21.959000   Instance:DB2   Node:000
PID:2644(db2dari.exe)   TID:2080   Appid:
BSU Java support  sqlejJVMstart    Probe:20

Error from sqlejSuffixEnv. RC:
11f6 ffff                                     ....

2001-03-14-14.33.21.979000   Instance:DB2   Node:000
PID:2644(db2dari.exe)   TID:2080   Appid:
BSU Java support  sqlejAttach    Probe:5

JVM startup failed.  RC:
33ef ffff                                     3...

2001-03-14-14.33.21.979001   Instance:DB2   Node:000
PID:2644(db2dari.exe)   TID:2080   Appid:
BSU Java support  sqlejCallSTP_dll    Probe:10

Error from attach. rc:33ef ffff                                     3...
"

The two machines (WInNT & Win2000) have DB2 6.1 installed with jre 1.1.7

Thaks for your help.

Aura

2. Are FMP Dev Ed 4.0 bind solutoins as good as Solutions created in regular FM

3. SQLMerge creates orphaned processes if terminated abnormally

4. Please read this... It may be of importance to you!

5. process has been terminated abnormally. SQLSTATE=38503

6. Question about AddNew record or Update record though ODBC?Thank you!!

7. Dari stored procedure call fails on OS/2 v7.1

8. "Restore operation terminating abnormally"

9. Restore database is terminating abnormally

10. RESTORE LOG is terminating abnormally

11. Backup terminating abnormally

12. Restore Database terminated abnormally