SQL0980C A disk error occurred. Subsequent SQL statements cannot be
MallaKishore
Hi Kamal,
Here is the error we are discussed about and thanks for all your support in over coming that
SQL0980C A disk error occurred. Subsequent SQL
statements cannot be
processed. SQLSTATE=58005
As per your suggestion did the restore using the
REBUILD TABLESPACE OPTION
EX:
db2 "restore db test rebuild with all tablespaces in
database from /db2/db2backup/db2inst1/test/ taken at
20071115164648 to /db2/db2inst1/db without prompting"
and then rollforward
db2 rollforward db test to end of logs
db2 rollforward db test stop
Thanks once again
Ref:http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/c0022419.htm
Thanks & Regards
KishoreMalla,
DB2 DBA,
ODW Team,
Prestige Towers,
99,Residency Road,
Banglore-56025,
INDIA
Tel-0-9916084285
Ramesh B Chejarla
The error explaination tells us that we need to do it
$ db2 ? sql0980C
SQL0980C A disk error occurred. Subsequent SQL statements
cannot be processed.
Explanation:
A disk error occurred that prevented successful execution of the
current and subsequent SQL statements. The application program
is not permitted to issue additional SQL statements. For example,
a recovery routine associated with the application program cannot
issue additional SQL statements. The database is marked as
needing recovery and all applications using the database are
prevented from accessing the database.
The statement cannot be processed.
User Response:
Record all error information from the SQLCA, if possible.
Terminate all applications using the database. Determine if the
error is a hardware error. Restart the database. If recovery is
not possible, restore the database from a backup copy.
If installing the sample database, drop it and install the
sample database again.
sqlcode : -980
sqlstate : 58005
Thanks,
Ramesh B Chejarla,
Sr.DB Administrator,
Ph:248-233-1818.
------- Original Message -------
From : MallaKishore[mailto:kma...@miraclesoft.com]
Sent : 11/20/2007 4:35:50 AM
To : kne...@miraclesoft.com
Cc : mirac...@googlegroups.com
Subject : RE: SQL0980C A disk error occurred. Subsequent SQL statements cannot be