Hi all

Our server (DB2 UDB 9.1 fp4) crashed earlier today while running a job,
after a reboot everything looked fine again, except that now the database
is no longer accessible. The log files are missing in SQLOGDIR and I'm
unable to restore them.

The error I'm getting is this one:

[IBM][CLI Driver] SQL1036C An I/O error occurred while accessing the
database. SQLSTATE=58030

Only solution I could find was to do a database restore which I'm not
very keen on doing, since it's gonna rollback 5 days and I've done alot
of work on the database the past few days.

Please tell me there is a way to force DB2 to ignore or recreate those
logs so we can connect to the database again.

On a side note, I'm not very experienced with DB2, so be gentle :)

Thanks in advance
Jimmi


DB2 & UDB email list listserv db2-l LazyDBA home page