SQL1131N DARI (Stored Procedure) process has been terminated abnormally

SQL1131N DARI (Stored Procedure) process has been terminated abnormally

Post by Aurelia Horva » Thu, 15 Mar 2001 23:25:28



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

 
 
 

SQL1131N DARI (Stored Procedure) process has been terminated abnormally

Post by Sean McKeoug » Fri, 16 Mar 2001 23:47:37


The error is "path not found" do you have your classpath set? Try setting
the diaglevel of your instance to 4 and re-running...this gives some more
detailed information.


Quote:> 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
Quote:> nerator.java,
>  Compiled Code)
>         at

COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGen
Quote:> erator.java:3
> 70)
>         at

COM.ibm.db2.jdbc.app.DB2CallableStatement.execute2(DB2CallableStatement.java
Quote:> :926)
>         at

COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute(DB2PreparedStatement.java:

- Show quoted text -

Quote:> 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


 
 
 

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

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

2. DTS Task name

3. SQLMerge creates orphaned processes if terminated abnormally

4. DBCC Shrinkdatabase in 7.0

5. process has been terminated abnormally. SQLSTATE=38503

6. SQL Utility tools and programs

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