Skip to Content
0
Former Member
Aug 13, 2013 at 07:23 AM

db2 error occurred while accessing the database

428 Views

Hi All,

I have problem db2 in dev server.

When I want to connect to database below message will occurred

SQL1036C An I/O error occurred while accessing the database. SQLSTATE=58030

Seems S0002213.LOG has been missing

db2diag ()

2013-08-13-11.54.09.503077+420 I198513A513 LEVEL: Severe

PID : 13904 TID : 12 PROC : db2sysc 0

INSTANCE: db2eca NODE : 000 DB : ECD

APPHDL : 0-64 APPID: *LOCAL.db2ecd.130813045409

AUTHID : ECDADM

EDUID : 12 EDUNAME: db2agent (ECD) 0

FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:3600

RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."

DIA8411C A file "" could not be found.

.................

2013-08-13-13.18.50.782140+420 I200002A384 LEVEL: Error

PID : 13904 TID : 40 PROC : db2sysc 0

INSTANCE: db2ecd NODE : 000 DB : ECD

EDUID : 40 EDUNAME: db2loggr (ECD) 0

FUNCTION: DB2 UDB, data protection services, sqlpgInitRecoverable,

probe:1370

DATA #1 : <preformatted>

Log file S0002213.LOG not found.

Jika harus restore mgkn ada data backup dev 2 bulan yang lalu, terlalu jauh.

Saya terpikir utk system copy dari QA ke DEV, atau ada solusi lainnya?