under the direction of ibm, I was told to modify a .LHF file (SQLOGMIR.LFH
or SQLOGCTL.LFH) to force the database open. Afterwards, I had to do a
db2move (export/load) to restore the integrity of the system. This was
several years ago. Maybe someone has done this recently.

NOTICE TO RECIPIENT: If you are not the intended recipient of this
e-mail, you are prohibited from sharing, copying, or otherwise using or
disclosing its contents. If you have received this e-mail in error,
please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or
saving them. Thank you.




"Jimmi Køhl Larsen "
<db2udbdba-ezmlmshield-x77748382.[Email address protected]
03/27/2008 06:45 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
Can't connect to database, missing log files






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



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



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