Доброго времени суток.
Проблема следующая: после отключения питания (ИБП сдох) не подключается к базе дает ошибку

Ошибка при выполнении операции с информационной базой
Ошибка СУБД:
htype=SQL_HANDLE_DBC hndl=0x1, line=2448, file=Src\DB2Connection.cpp
SQLSTATE=HY000, native=-1042, '[IBM][CLI Driver] SQL1042C Произошла непредвиденная системная ошибка. SQLSTATE=58004
'

ни какими средствами не подключается

попробовал:
db2dart torg 2014
говорит:
Warning: The database state is not consistent/
Warning: Errors reported about reorg rows may be due to the inconsistent state of the database


Что делать?

Дал результат

в db2diag.log такое сообщение
2014-06-13-11.27.16.250000+240 I92540575F328 LEVEL: Event
PID : 4328 TID : 5220 PROC : DB2STOP.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5220
FUNCTION: DB2 UDB, base sys utilities, sqlestp.C::main, probe:399
DATA #1 : <preformatted>
argv[1]=[NOMSG]

2014-06-13-11.27.16.250000+240 I92540905F327 LEVEL: Event
PID : 4328 TID : 5220 PROC : DB2STOP.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5220
FUNCTION: DB2 UDB, base sys utilities, sqlestp.C::main, probe:399
DATA #1 : <preformatted>
argv[2]=[DATA]

2014-06-13-11.27.16.250000+240 I92541234F427 LEVEL: Event
PID : 4328 TID : 5220 PROC : DB2STOP.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5220
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:12741
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 53 bytes
C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\ctrl\db2strst.lck

2014-06-13-11.27.16.250000+240 I92541663F1696 LEVEL: Event
PID : 4328 TID : 5220 PROC : DB2STOP.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5220
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 30 bytes
C:\IBM\SQLLIB\bin\DB2STOP2.EXE
DATA #2 : Hexdump, 256 bytes
0x0000000000182FFF : 433A 5C49 424D 5C53 514C 4C49 425C 6269 C:\IBM\SQLLIB\bi
0x000000000018300F : 6E5C 4442 3253 544F 5032 2E45 5845 004E n\DB2STOP2.EXE.N
0x000000000018301F : 4F4D 5347 0053 4E00 0000 0000 0000 0000 OMSG.SN.........
0x000000000018302F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018303F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018304F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018305F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018306F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018307F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018308F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x000000000018309F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001830AF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001830BF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001830CF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001830DF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001830EF : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2014-06-13-11.27.16.265000+240 I92543361F428 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:12741
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 53 bytes
C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\ctrl\db2stst.0000

2014-06-13-11.27.16.265000+240 I92543791F355 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:210
DATA #1 : String, 43 bytes
Deactivate phase is bypassed. singleStop: 1

2014-06-13-11.27.16.265000+240 I92544148F375 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:230
DATA #1 : String, 63 bytes
Deactivate phase is completed, preparing to stop. singleStop: 1

2014-06-13-11.27.16.265000+240 I92544525F338 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:240
DATA #1 : String, 26 bytes
Stop phase is in progress.

2014-06-13-11.27.16.265000+240 I92544865F353 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:250
DATA #1 : String, 41 bytes
Requesting system controller termination.

2014-06-13-11.27.17.108000+240 I92545220F355 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:260
DATA #1 : String, 43 bytes
System controller termination is completed.

2014-06-13-11.27.17.108000+240 I92545577F376 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:280
DATA #1 : String, 24 bytes
There is no active EDUs.
DATA #2 : unsigned integer, 4 bytes
0

2014-06-13-11.27.17.108000+240 I92545955F331 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:3117
DATA #1 : <preformatted>
Eventlog terminated.

2014-06-13-11.27.17.108000+240 E92546288F352 LEVEL: Event
PID : 5932 TID : 4712 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 4712
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W Database manager has stopped.
STOP : DB2 DBM

2014-06-13-11.27.17.326000+240 I92546642F345 LEVEL: Event
PID : 4328 TID : 5220 PROC : DB2STOP.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5220
FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop, probe:8818
DATA #1 : <preformatted>
Single node stopped [-1064].

2014-06-13-11.27.21.117000+240 I92546989F428 LEVEL: Event
PID : 6832 TID : 3216 PROC : DB2START.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 3216
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:12741
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 53 bytes
C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\ctrl\db2strst.lck

2014-06-13-11.27.21.117000+240 I92547419F1697 LEVEL: Event
PID : 6832 TID : 3216 PROC : DB2START.EXE
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 3216
FUNCTION: DB2 UDB, base sys utilities, sqleStartStopSingleNode, probe:1130
DATA #1 : String, 30 bytes
C:\IBM\SQLLIB\bin\DB2STAR2.EXE
DATA #2 : Hexdump, 256 bytes
0x00000000001C31FF : 433A 5C49 424D 5C53 514C 4C49 425C 6269 C:\IBM\SQLLIB\bi
0x00000000001C320F : 6E5C 4442 3253 5441 5232 2E45 5845 004E n\DB2STAR2.EXE.N
0x00000000001C321F : 4F4D 5347 0000 0000 0000 0000 0000 0000 OMSG............
0x00000000001C322F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C323F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C324F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C325F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C326F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C327F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C328F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C329F : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C32AF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C32BF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C32CF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C32DF : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000001C32EF : 0000 0000 0000 0000 0000 0000 0000 0000 ................

2014-06-13-11.27.21.164000+240 I92549118F427 LEVEL: Event
PID : 3240 TID : 468 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 468
FUNCTION: DB2 UDB, base sys utilities, sqleGetStStLockFile, probe:12741
MESSAGE : Obtained exclusive mode lock on the file:
DATA #1 : String, 53 bytes
C:\PROGRAMDATA\IBM\DB2\DB2COPY1\DB2\ctrl\db2stst.0000

2014-06-13-11.27.21.179000+240 E92549547F904 LEVEL: Warning
PID : 3240 TID : 468 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 468
FUNCTION: DB2 UDB, license manager, sqllcRequestAccess, probe:1
MESSAGE : ADM12007E There are "8" day(s) left in the evaluation period for the
product "DB2 Advanced Enterprise Server Edition". For evaluation
license terms and conditions, refer to the IBM License Acceptance and
License Information document located in the license directory in the
installation path of this product. If you have licensed this product,
ensure the license key is properly registered. You can register the
license using the db2licm command line utility. The license file can
be obtained from your licensed product CD.

2014-06-13-11.27.23.426000+240 I92550453F572 LEVEL: Event
PID : 3240 TID : 5860 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5860 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfBufferManager::initBufferManager, probe:10
START : Starting FCM Buffer Manager
1 resource group(s).
6400 buffers allocated.
Maximum number of buffers supported is 8192.
Total buffer manager memory required for 1 logical and 0 fail-over partition(s) is 27910160 bytes.

2014-06-13-11.27.23.426000+240 I92551027F576 LEVEL: Event
PID : 3240 TID : 5860 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5860 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfChannelManager::initChannelManager, probe:10
START : Starting FCM Channel Manager
1 resource group(s).
128 channels allocated.
Maximum number of channels supported is 8192.
Total channel manager memory required for 1 logical and 0 fail-over partitions(s) is 512024 bytes.

2014-06-13-11.27.23.426000+240 I92551605F575 LEVEL: Event
PID : 3240 TID : 5860 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5860 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqkfSessionManager::initSessionManager, probe:10
START : Starting FCM Session Manager
1 resource group(s).
128 sessions allocated.
Maximum number of sessions supported is 64000.
Total session manager memory required for 1 logical and 0 fail-over partitions is 1949696 bytes.

2014-06-13-11.27.23.426000+240 I92552182F453 LEVEL: Event
PID : 3240 TID : 5860 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 5860 EDUNAME: db2sysc 0
FUNCTION: DB2 UDB, fast comm manager, sqlkf_init_allocate_shared, probe:500
START : FCM infrastructure started
FCM running in non-shared mode; FCM parallelism degree: 1; comm protocol: TCP/IPv4

2014-06-13-11.27.24.580000+240 E92552637F909 LEVEL: Event
PID : 3240 TID : 468 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
HOSTNAME: base-serv
EDUID : 468
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W Database manager has started.
START : DB2 DBM
DATA #1 : Build Level, 152 bytes
Instance "DB2" uses "64" bits and DB2 code release "SQL10010"
with level identifier "0201010E".
Informational tokens are "DB2 v10.1.0.872", "s120403", "NTX64101", Fix Pack "0".
DATA #2 : System Info, 1568 bytes
System: WIN32_NT BASE-SERV Service Pack 1 6.1 AMD64 Family 6, model 45, stepping 7
CPU: total:12 online:12 Cores per socket:16 Threading degree per core:1
Physical Memory(MB): total:32741 free:28505 available:28505
Virtual Memory(MB): total:65480 free:61244
Swap Memory(MB): total:32739 free:32739

и


2014-06-13-11.31.40.358000+240 I92553548F689 LEVEL: Event
PID : 3240 TID : 6644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TORG2014
APPHDL : 0-7 APPID: ::1.49627.140613073140
AUTHID : ADMIN HOSTNAME: base-serv
EDUID : 6644 EDUNAME: db2agent (TORG2014) 0
FUNCTION: DB2 UDB, base sys utilities, sqleCalculateDbHeaps, probe:70
MESSAGE : RLMS - DB Memory Set for Resident Member
DATA #1 : String, 10 bytes
totalBytes
DATA #2 : unsigned integer, 8 bytes
10179379200
DATA #3 : String, 11 bytes
dbHeapBytes
DATA #4 : unsigned integer, 8 bytes
424280064

2014-06-13-11.31.40.748000+240 I92554239F593 LEVEL: Severe
PID : 3240 TID : 6644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TORG2014
APPHDL : 0-7 APPID: ::1.49627.140613073140
AUTHID : ADMIN HOSTNAME: base-serv
EDUID : 6644 EDUNAME: db2agent (TORG2014) 0
FUNCTION: DB2 UDB, global services, sqzEDUObj::StartEDU, probe:20
RETCODE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error"
DIA8526C A fatal error occurred in data protection services.

2014-06-13-11.31.40.748000+240 I92554834F699 LEVEL: Severe
PID : 3240 TID : 6644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TORG2014
APPHDL : 0-7 APPID: ::1.49627.140613073140
AUTHID : ADMIN HOSTNAME: base-serv
EDUID : 6644 EDUNAME: db2agent (TORG2014) 0
FUNCTION: DB2 UDB, base sys utilities, sqeDbEduServices::CreateDBEdu, probe:297
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error"
DIA8526C A fatal error occurred in data protection services.
DATA #1 : String, 22 bytes
Error starting BSU EDU
DATA #2 : unsigned integer, 8 bytes
5

2014-06-13-11.31.40.748000+240 I92555535F587 LEVEL: Severe
PID : 3240 TID : 6644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TORG2014
APPHDL : 0-7 APPID: ::1.49627.140613073140
AUTHID : ADMIN HOSTNAME: base-serv
EDUID : 6644 EDUNAME: db2agent (TORG2014) 0
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:5041
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error"
DIA8526C A fatal error occurred in data protection services.

2014-06-13-11.31.40.748000+240 I92556124F897 LEVEL: Severe
PID : 3240 TID : 6644 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : TORG2014
APPHDL : 0-7 APPID: ::1.49627.140613073140
AUTHID : ADMIN HOSTNAME: base-serv
EDUID : 6644 EDUNAME: db2agent (TORG2014) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:8716
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1042 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLEDINT
sqlerrd : (1) 0x00000000 (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:

Попытка восстановления тоже ничего не дает


Ошибка CONNECT TO "torg2014"
Failed to execute command. DAS returned the following error: sqlcode=SQL22220N output=SQL01042C Произошла непредвиденная системная ошибка. SQLSTATE=58004



ОООЧЕНЬ БОЛЬШАЯ ПРОБЛЕМА - ПОМОГИТЕ!!!

Резервной копии по факту нет

отправил на почту-размер упакованного файла большой

по новой сделал db2dart torg2014 /db
выкладываю и его

нет-ругается на отсутствие соединения с базой

db2 inspect check database results torg2014

db2 restart torg2014

sql1042C произошла непредвиденная системная ошибка. sqlstate=58004

Uzden Ham
нет-ругается на отсутствие соединения с базой

Давайте с цитатами.


SQL1024N отсутствует соединение с базой данных. sqlstate=00000

pomoev.u,
Уже делаю.

скачка будет идти около часа, потом установка - полчаса где-то. Если что, на почту можно написать?

Mark Barinstein,
отправил на почту

Установил fix2-результат тот же

Дело в том, что вчера и сегодня утром все работало до некорректного отключения ИБП(он умер). Включил, сделал проверку дисков (chkdsk нашел ошибки и исправил), и все-база умерла. тут же были и Backup- тоже умерли .

db2dart torg2014 /db видит и базу и не видит ошибок

при просмотре list tablespaces 2 табл. пространства в состоянии отключено.
Как их перевести в нормальное состояние?