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]
