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

    Unanswered: Unable to run Rebuild in db2 8.1 ..pls Help

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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Unable to run Rebuild in db2 8.1 ..pls Help

    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

    Originally posted by lmaheshkumar
    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.
    ========================
    Visit the new-look IDUG Website , register to gain access to the excellent content.

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

    Thumbs up

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

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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
    Visit the new-look IDUG Website , register to gain access to the excellent content.

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

    Thumbs up

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

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

    Red face

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

  7. #7
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    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

    Originally posted by lmaheshkumar
    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.
    =================
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  8. #8
    Join Date
    Oct 2003
    Location
    INDIA
    Posts
    16
    Originally posted by lmaheshkumar
    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
    ************************************************** ***

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