Results 1 to 11 of 11
  1. #1
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16

    Question Unanswered: db2 sql stored procedure rebuild problems.. pls help

    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.
    ===========================
    L.Mahesh Kumar
    Pls keep mailing in DBFORUMS.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Do you have a C compiler installed on the DB2 server?
    You have to have one.

    Andy

  3. #3
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16

    Question

    Originally posted by ARWinner
    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.
    ===========
    L.Mahesh Kumar
    Pls keep mailing in DBFORUMS.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

    Originally posted by lmaheshkumar
    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.
    ===========

  5. #5
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16
    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.
    ===========
    L.Mahesh Kumar
    Pls keep mailing in DBFORUMS.

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

    Originally posted by lmaheshkumar
    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.
    ===========

  7. #7
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16

    Thumbs up

    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.
    L.Mahesh Kumar
    Pls keep mailing in DBFORUMS.

  8. #8
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

    Originally posted by lmaheshkumar
    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.

  9. #9
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16

    Thumbs up

    Andy ,

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

    =====
    L.Mahesh Kumar
    Pls keep mailing in DBFORUMS.

  10. #10
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

    Originally posted by lmaheshkumar
    Andy ,

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

    =====

  11. #11
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16
    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 .
    L.Mahesh Kumar
    Pls keep mailing in DBFORUMS.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •