Hello Friends ..

I am facing the problem in rebuilding the sql stored procedure in db2 8.1 .

The problem is when i rebuild the sql stored procedure i am getting the following error

ADMINISTRATOR.MyProc1 - Build started.
Create stored procedure returns -7032.

-- LOG FILE P9021654.log FOR PROCEDURE ADMINISTRATOR.MYPROC1

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.sqc


LINE MESSAGES FOR P9021654.sqc

------ --------------------------------------------------------------------

SQL0060W The "C" precompiler is in progress.

SQL0091W Precompilation or binding was ended with "0"

errors and "0" warnings.


-- DB2_SQLROUTINE_COMPILER_PATH=MS

-- FAILED TO OPEN MS


-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.BAT

@echo on
set SQLROUTINE_FILENAME=P9021654
set db2path=C:\PROGRA~1\IBM\SQLLIB

-- COMPILATION COMMAND:

nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k


-- CONTENTS OF C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.def

LIBRARY P9021654
EXPORTS _pgsjmp@8
pgsjmp=_pgsjmp@8


-- COMPILATION MESSAGES FOR C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp\P9021654.c
-- C COMPILATION ERROR CODES: 0 0 1


C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp>set SQLROUTINE_FILENAME=P9021654



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp>set db2path=C:\PROGRA~1\IBM\SQLLIB



C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc\SA MPLE\ADMINISTRATOR\tmp>nmake /f C:\PROGRA~1\IBM\SQLLIB\function\routine\sqlproc.ma k

'nmake' is not recognized as an internal or external command,

operable program or batch file.


-- END OF LOG FILE (SQLCODE: -7032)

ADMINISTRATOR.MyProc1 - Build failed.
ADMINISTRATOR.MyProc1 - Roll back completed successfully.



Pls guide me .

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

Do you have a C compiler installed on the DB2 server?
You have to have one.

Andy

Andy ,

Thanks for your reply ..

I just installed db2 client and server on my PC . How I can find out whether I have one or not ? if I don't have how I can get and where to place it . Pls reply ..

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

Mahesh,
You have to install it separately. If you do not know, I would guess you do not have one. What OS is the Server?

Andy

Andy ,

Good Morning.

Mine OS is Windows 2000 Professional Edition.

If you have yahoo account , pls let me know I can come online and we can discuss the issue .

Mine Yahoo Id is :- lmaheshkumar2002@yahoo.co.in.

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

Mahesh,
Sorry, I do not have a yahoo account. You can goto this site that should inform you of all you need to do.

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

Andy

Hello Andy ,

As said by you ,I have used GNU C Compiler (GCC), a free ource C compiler which can be available from net ..

http://www7b.boulder.ibm.com/dmdd/l...0306haungs.html Having made all the correct settings, but still results the above said problem.


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

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.
=----------------------------------------------------------------

checked the db2diag.log file , here the details of the log ..

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


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".

2003-10-21-15.23.18.250000 InstanceB2 Node:000
PID:1460(db2syscs.exe) TID:1632 Appid:*LOCAL.DB2.013041095317
base sys utilities sqleTermDbConnect Probe:110

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

2003-10-21-15.23.18.390000 InstanceB2 Node:000
PID:1460(db2syscs.exe) TID:1632 Appid:none
DRDA Application Server sqljsCleanup Probe:60

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

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

Kindly help .

Thanks a ton in advance .

Mahesh L.
GO DIAMOND.

Mahesh,
You have a different error this time. It suggests that you report it to IBM. I would also suggest that you open a PMR with them over this error.

Andy

Andy ,

What u mean by PMR and How I can raise it ?

=====

Mahesh,
PMR is IBM's jargon for opening a support incident. Goto IBM siftware support on the web:
http://www-3.ibm.com/software/support/

Andy

Hello Andy ,

The problem is now resolved , as I have done some DB2GCC batch file settings .

Thanks a ton for your valuable time and help .