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

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