Dear Comrades ,

Good Day .

I am using db2 8.1 client ( db2 application developer) and server .

Have written sql stored procedure but could not able to build it , I mean

compile it , it is resulting in some errors .. Pls do see below .


=======================================

ADMINISTRATOR.MyProc1 - Build started.
Create stored procedure returns -1034.
[IBM][CLI Driver][DB2/NT] SQL1034C The database is damaged. All applications processing the database have been stopped. SQLSTATE=58031


ADMINISTRATOR.MyProc1 - Build failed.
[IBM][CLI Driver] SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command. SQLSTATE=55032


ADMINISTRATOR.MyProc1 - Roll back failed.
=----------------------------------------------------------------

I am using GNU C Compiler (GCC), a free open-source C compiler which can be available from net ..

http://www7b.boulder.ibm.com/dmdd/li...306haungs.html

Having made all the correct settings, but still results the above said problem.

Kindly help .

Thanks a ton in advance .

Mahesh L.
GO DIAMOND.
========================

This seems to be a problem with your database itself ...

Can you retry the compilation ?

Check the db2diag.log on the server to find out the database problem

Cheers
Sathyaram

Hello Sathya ,

I have again recompiled but still the problem persists.

The db2diag.log file has following error .....>>>>

======================================
2003-10-21-15.23.18.234000 InstanceB2 Node:000
PID:1460(db2syscs.exe) TID:1632 Appid:*LOCAL.DB2.013041095317
buffer pool services sqlbTerminateAgent Probe:837 DatabaseAMPLE

DIA8427C The database has been marked as being damaged.
ZRC=0x8602001A

2003-10-21-15.23.18.234001 InstanceB2 Node:000
PID:1460(db2syscs.exe) TID:1632 Appid:*LOCAL.DB2.013041095317
base sys utilities sqleAgentDissociate Probe:90 DatabaseAMPLE

DIA0001E An internal error occurred. Report the following error code : "ZRC=0x
6000000".
==================================

Pls guide me accorindly.

Thanks
Mahesh L
************************************************** ***

Have you tried the usual stuff like :

1) Restarting the instance
2) Rebooting the machine

IF these do not fix the problem, for production system, contact IBM support ...

Looks like yours is a dev system ...

If you think the data in the database is important, run the db2dart utility to identify the problem and see if you can get most, if not all the data back ... IBM support may be used if needed ...

If you are not bothered about the data, drop the database and recreate another one with the same name ... If you take this route, you do not have the root cause of the problem, but you just fix it ...

HTH

Sathyaram

Hello Satyaram ,

I have done the two things what u have said , but still could not able to

compile the sql stored procedure .

Shall I reinstall again the database ? what I should now .

Thanks for your immediate replys ..

Hello Sathya ,

I have reinstalled the DB2 CLIENT and SERVER , BUT STILL THE PROBLEM PERSISTS. Can you pls suggest me the compiler for the problem with the url to download and install .

Thanks
Mahesh L.
=================

Personally I do not see this as a SP Creation Problem ... It is a problem caused by database corruption ...

Why not try creating a new database and testing the same procedure creation there ?

Cheers

Sathyaram

Friends ,

The problem is resolved now , Since the setting in DB2GCC batch file setttings are not correct ,I faced the above said problem .
Thanks for all your time and help .

Mahesh L.
=============