Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004
    Location
    Inside Intel
    Posts
    165

    Unhappy Unanswered: Database damaged error - DB21034E

    Hi all,

    I am at 8.1.6 connect unlimited edition on Windows 2000 server with latest service packs.

    I have a database with 350 tables in it. When i try to create a procedure using the command center, i get the following error

    Code:

    CREATE PROCEDURE DPS.TEST (
    IN p_CONTACT_ID VARCHAR(20)
    ,IN p_DT TIMESTAMP
    ,OUT p_NAME VARCHAR(15)
    ,OUT p_AGE VARCHAR(15)
    ,OUT p_PHONE VARCHAR(15)
    )

    BEGIN /* HIDDEN BODY */ END

    Error:

    DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned: SQL1034C The database is damaged. All applications processing the database have been stopped. SQLSTATE=58031

    The database looks good and i can retrieve / update data. All other connected users are kicked out. Any suggestions ?

    Thanks in advance,

    Newbie

  2. #2
    Join Date
    Jan 2004
    Location
    Tallahassee, FL, USA
    Posts
    96
    run INSPECT CHECK command for database


    that will give if any

    also check you DB cfg

    db2 get db cfg for DBname

    for

    Database is consistent = YES

    if yes , you DB is inconsistent stats


    stop & start your instance


    db2stop
    db2start




    Thank You


    Lekharaju Ennam

Posting Permissions

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