I tried that; it still gives an I/O error when you try to connect to the database. However, if you carefully sector-edit the S00000 files, and change the path names of the log files, I was able to reduce the error to:
PID:... (db2loggr) data_protection sqlpgole Probe:200 A problem occurred while opening database log extend 0: 0605 0000 Still won't let you connect to the database, however.. -turgut On Tue, 5 Feb 2002, Reys, Ellen wrote: > This might work: > > Bring the instance down > Deactivate database (if this fails, continue) > Create default 3/2 primary/secondary log files on /tmp - really small ones > (update db cfg .... ) > Bring the instance up > Activate database > Try to connect > > Ellen Reys > Data Management Services > Inovant - a Visa Solutions Company > [EMAIL PROTECTED]/650-432-1746 m/s: 3125-1D > > > > -----Original Message----- > From: Turgut Kalfaoglu [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, February 05, 2002 7:13 AM > To: [EMAIL PROTECTED] > Subject: [DB2EUG] Hellp; deleted log files! > > > > I dont know how I could do a such stupid thing; I deleted the primary and > secondary log files of a UDB 6.1 Linux database (the S0000000x.LOG > files); and the SQLLPATH.TAG file! No decent backup, I am wondering if > there is a way of fooling DB2 to re-create those log files? > > Now when I try to connect the database, this is what I get: > > [db2@db2 findit1]$ db2 connect to findit1 > SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030 > > and in the db2diag.log: > 2002-02-05-17.06.52.743964 Instance:db2 Node:000 > PID:10663(db2loggr) Appid:none > data_protection sqlpgicl Probe:130 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.06.52.757349 Instance:db2 Node:000 > PID:10663(db2loggr) Appid:none > data_protection sqlpgilt Probe:50 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.06.52.766332 Instance:db2 Node:000 > PID:10663(db2loggr) Appid:none > data_protection sqlpgasn Probe:200 > > Logging can not continue due to an error. 0000 0000 > .... > > 2002-02-05-17.06.52.817481 Instance:db2 Node:000 > PID:10596(db2agent (FINDIT1)) Appid:*LOCAL.db2.020205145946 > data_protection sqlpgint Probe:126 Database:FINDIT1 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.07.02.590127 Instance:db2 Node:000 > PID:10668(db2loggr) Appid:none > data_protection sqlpgicl Probe:130 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.07.02.595882 Instance:db2 Node:000 > PID:10668(db2loggr) Appid:none > data_protection sqlpgilt Probe:50 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.07.02.603522 Instance:db2 Node:000 > PID:10668(db2loggr) Appid:none > 2002-02-05-17.07.02.609965 Instance:db2 Node:000 > PID:10596(db2agent (FINDIT1)) Appid:D4AFC907.44EC.020205150055 > data_protection sqlpgint Probe:126 Database:FINDIT1 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.07.03.264170 Instance:db2 Node:000 > PID:10670(db2loggr) Appid:none > data_protection sqlpgicl Probe:130 > DIA3711C A file "" could not be found. > > ZRC=FFFFE60A > > 2002-02-05-17.07.03.269953 Instance:db2 Node:000 > PID:10670(db2loggr) Appid:none > data_protection sqlpgilt Probe:50 > > > > hellp:) -t > > > > > > ----- > Turgut Kalfaoglu: http://www.kalfaoglu.com > EgeNet Internet Services: http://www.egenet.com.tr > > > > > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** You are subscribed to [EMAIL PROTECTED] > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > - > ::: When replying to the list, please use 'Reply-All' and make sure > ::: a copy goes to the list ([EMAIL PROTECTED]). > *** You are subscribed to [EMAIL PROTECTED] > *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] > ----- Turgut Kalfaoglu: http://www.kalfaoglu.com EgeNet Internet Services: http://www.egenet.com.tr - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** You are subscribed to [EMAIL PROTECTED] *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
