社区导航: 企业IT安全   网络技术   存储技术   服务器   数据中心   数据库技术   SOA   CIO论坛   IT大家谈   

技术论坛数据库技术IBM数据库产品 数据库坏了,请高手指教!谢谢!

1  /  1  页   1 跳转 查看:11317
发表新主题 回复该主题

数据库坏了,请高手指教!谢谢!

数据库坏了,请高手指教!谢谢!

数据突然就不正常了,重启后也不行,下面是db2diag.log的部分内容。谢谢大家!
2006-11-15-09.13.24.528000+480 I3468507661H357    LEVEL: Warning
PID    : 1532                TID  : 2356        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, Client Config, cfgReadNodeDirectory, probe:17
MESSAGE : NODE:
DATA #1 : Hexdump, 11 bytes
0x0C51D73C : 456E 7472 7920 6E6F 2E20 30                Entry no. 0

2006-11-15-09.13.24.544000+480 I3468508020H232    LEVEL: Warning
PID    : 1532                TID  : 2356        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000
MESSAGE : Sqlcode
DATA #1 : String, 9 bytes
SQL 1014

2006-11-15-09.13.38.778000+480 I3468508254H362    LEVEL: Warning
PID    : 1532                TID  : 2356        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, Client Config, cfgReadDbcDirectory, probe:5
MESSAGE : DB_CONFIG:
DATA #1 : Hexdump, 13 bytes
0x0C3195B0 : 456E 7469 7265 2044 4243 4647 00          Entire DBCFG.

2006-11-15-09.13.38.778000+480 I3468508618H232    LEVEL: Error
PID    : 1532                TID  : 2356        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000
MESSAGE : Sqlcode
DATA #1 : String, 10 bytes
SQL -1013

2006-11-15-09.16.13.715000+480 I3468508852H213    LEVEL: Error
PID    : 1404                TID : 1112
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : Sint32, 4 bytes
-1031

2006-11-15-09.16.42.918000+480 I3468509067H213    LEVEL: Error
PID    : 2480                TID : 2192
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : Sint32, 4 bytes
-1031

2006-11-15-09.17.18.839000+480 I3468509282H362    LEVEL: Warning
PID    : 396                  TID  : 1368        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, Client Config, cfgReadDbcDirectory, probe:5
MESSAGE : DB_CONFIG:
DATA #1 : Hexdump, 13 bytes
0x0C3295B0 : 456E 7469 7265 2044 4243 4647 00          Entire DBCFG.

2006-11-15-09.17.18.839000+480 I3468509646H232    LEVEL: Error
PID    : 396                  TID  : 1368        PROC : javaw.exe
INSTANCE: DB2                  NODE : 000
MESSAGE : Sqlcode
DATA #1 : String, 10 bytes
SQL -1013

2006-11-15-09.17.47.542000+480 I3468509880H213    LEVEL: Error
PID    : 2264                TID : 1132
FUNCTION: DB2 Tools, DB2 administration server, handleRunCmd, probe:85
DATA #1 : Sint32, 4 bytes
-1031

2006-11-15-09.18.36.589000+480 E3468510095H430    LEVEL: Error
PID    : 3972                TID  : 332        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:125
MESSAGE : ADM7009E  An error was encountered in the "TCPIP" protocol support. 
          A possible cause is that the maximum number of agents has been
          exceeded.

2006-11-15-09.18.36.589000+480 I3468510527H387    LEVEL: Error
PID    : 3972                TID  : 332        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe:126
MESSAGE : Return code from sqleGetAgent =
DATA #1 : Hexdump, 4 bytes
0x01A8F9E0 : 6CE8 FFFF                                  l...

2006-11-15-09.21.15.812000+480 E3468510916H399    LEVEL: Error (OS)
PID    : 668                  TID  : 792        PROC : db2dasstm.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED  : OS, -, unspecified_system_function      OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER
          Invalid parameter

2006-11-15-09.21.15.828000+480 E3468511317H399    LEVEL: Error (OS)
PID    : 668                  TID  : 792        PROC : db2dasstm.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED  : OS, -, unspecified_system_function      OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER
          Invalid parameter

2006-11-15-09.21.15.828000+480 E3468511718H399    LEVEL: Error (OS)
PID    : 668                  TID  : 792        PROC : db2dasstm.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloSSemClose, probe:20
CALLED  : OS, -, unspecified_system_function      OSERR: 6
RETCODE : ECF=0x9000000C=-1879048180=ECF_INVALID_PARAMETER
          Invalid parameter
 

回复:数据库坏了,请高手指教!谢谢!

2006-11-15-15.33.14.093000+480 E3471211213H794    LEVEL: Event
PID    : 1352                TID  : 1468        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W  Database manager has started.
START  : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.7.445", "s040812", "WR21342", FixPak "7".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT DBSERVER2 Service Pack 1 5.2 x86 Family 15, model 4, stepping 1
CPU: total:4 online:4
Physical Memory: total:4096 free:3786 available:1914
Virtual  Memory: total:5973 free:5735
Swap    Memory: total:1877 free:1949

2006-11-15-16.09.07.546000+480 I3471212009H405    LEVEL: Warning
PID    : 1352                TID  : 1472        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0127F944 : 0000 0000                                  ....

2006-11-15-16.09.07.750000+480 E3471212416H311    LEVEL: Event
PID    : 1352                TID  : 2460        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W  Database manager has stopped.
STOP    : DB2 DBM

2006-11-15-16.09.11.265000+480 I3471212729H320    LEVEL: Event
PID    : 1272                TID  : 3852        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE  : CFG DBM: "Instance_Memory" <automatic> From: "6504" To: "6504"

2006-11-15-16.09.11.296000+480 E3471213051H924    LEVEL: Warning
PID    : 1272                TID  : 3852        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, LicCheckProcessors, probe:20
MESSAGE : ADM12017E  The number of processors on this machine exceeds the
          defined entitlement of "1" for the product "DB2 企业服务器版". The
          number of processors on this machine is "2". You should purchase
          additional processor based entitlements from your IBM representative
          or authorized dealer and update your license using the License Center
          or the db2licm command line utility. For more information on updating
          processor based licenses, refer to the Quick Beginnings manual for
          your platform. For more information on the db2licm utility, refer to
          the DB2 Command Reference.

2006-11-15-16.09.14.921000+480 E3471213977H794    LEVEL: Event
PID    : 1272                TID  : 3852        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W  Database manager has started.
START  : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.7.445", "s040812", "WR21342", FixPak "7".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT DBSERVER2 Service Pack 1 5.2 x86 Family 15, model 4, stepping 1
CPU: total:4 online:4
Physical Memory: total:4096 free:3769 available:1917
Virtual  Memory: total:5973 free:5672
Swap    Memory: total:1877 free:1903

2006-11-15-16.09.49.609000+480 I3471214773H292    LEVEL: Error
PID    : 1272                TID  : 3028        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInitRecoverable, probe:1370
MESSAGE : Log file S0000488.LOG not found.

2006-11-15-16.09.49.625000+480 I3471215067H160    LEVEL: Error
PID:1272 TID:3028 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\12723028.000

2006-11-15-16.09.49.625000+480 I3471215229H381    LEVEL: Severe
PID    : 1272                TID  : 3028        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x0205E594 : 0000 0000                                  ....

2006-11-15-16.09.49.640000+480 I3471215612H436    LEVEL: Severe
PID    : 1272                TID  : 1560        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-7                  APPID: *LOCAL.DB2.061115080949
FUNCTION: DB2 UDB, data protection, sqlpgint, probe:3640
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.
 

回复:数据库坏了,请高手指教!谢谢!

2006-11-15-16.09.49.687000+480 I3471216050H440    LEVEL: Severe
PID    : 1272                TID  : 1560        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-7                  APPID: *LOCAL.DB2.061115080949
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x019F3054 : F4FB FFFF                                  ....

2006-11-15-16.11.27.156000+480 I3471216492H292    LEVEL: Error
PID    : 1272                TID  : 2252        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgInitRecoverable, probe:1370
MESSAGE : Log file S0000488.LOG not found.

2006-11-15-16.11.27.156000+480 I3471216786H160    LEVEL: Error
PID:1272 TID:2252 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\12722252.000

2006-11-15-16.11.27.156000+480 I3471216948H381    LEVEL: Severe
PID    : 1272                TID  : 2252        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x0205DF94 : 0000 0000                                  ....

2006-11-15-16.11.27.156000+480 I3471217331H436    LEVEL: Severe
PID    : 1272                TID  : 1560        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-8                  APPID: *LOCAL.DB2.061115081127
FUNCTION: DB2 UDB, data protection, sqlpgint, probe:3640
RETCODE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.

2006-11-15-16.11.27.156000+480 I3471217769H440    LEVEL: Severe
PID    : 1272                TID  : 1560        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-8                  APPID: *LOCAL.DB2.061115081127
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x019F3054 : F4FB FFFF                                  ....

2006-11-15-16.20.25.656000+480 I3471218211H405    LEVEL: Warning
PID    : 1272                TID  : 524        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerKillAllFmps, probe:5
MESSAGE : Bringing down all db2fmp processes as part of db2stop
DATA #1 : Hexdump, 4 bytes
0x0127F944 : 0000 0000                                  ....

2006-11-15-16.20.25.828000+480 E3471218618H311    LEVEL: Event
PID    : 1272                TID  : 3220        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StopMain, probe:911
MESSAGE : ADM7514W  Database manager has stopped.
STOP    : DB2 DBM

2006-11-15-16.20.26.421000+480 I3471218931H320    LEVEL: Event
PID    : 3952                TID  : 2896        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE  : CFG DBM: "Instance_Memory" <automatic> From: "6504" To: "6504"

2006-11-15-16.20.26.453000+480 E3471219253H924    LEVEL: Warning
PID    : 3952                TID  : 2896        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, LicCheckProcessors, probe:20
MESSAGE : ADM12017E  The number of processors on this machine exceeds the
          defined entitlement of "1" for the product "DB2 企业服务器版". The
          number of processors on this machine is "2". You should purchase
          additional processor based entitlements from your IBM representative
          or authorized dealer and update your license using the License Center
          or the db2licm command line utility. For more information on updating
          processor based licenses, refer to the Quick Beginnings manual for
          your platform. For more information on the db2licm utility, refer to
          the DB2 Command Reference.

2006-11-15-16.20.28.031000+480 E3471220179H794    LEVEL: Event
PID    : 3952                TID  : 2896        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, base sys utilities, DB2StartMain, probe:911
MESSAGE : ADM7513W  Database manager has started.
START  : DB2 DBM
DATA #1 : Build Level, 124 bytes
Instance "DB2" uses "32" bits and DB2 code release "SQL08020"
with level identifier "03010106".
Informational tokens are "DB2 v8.1.7.445", "s040812", "WR21342", FixPak "7".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT DBSERVER2 Service Pack 1 5.2 x86 Family 15, model 4, stepping 1
CPU: total:4 online:4
Physical Memory: total:4096 free:3764 available:1917
Virtual  Memory: total:5973 free:5671
Swap    Memory: total:1877 free:1907

2006-11-15-16.20.45.875000+480 I3471220975H295    LEVEL: Error
PID    : 3952                TID  : 2164        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:3200
MESSAGE : Error 118489302 opening database log extent 4:

2006-11-15-16.20.45.875000+480 I3471221272H371    LEVEL: Error
PID    : 3952                TID  : 2164        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgicl, probe:2130
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.20.45.890000+480 I3471221645H377    LEVEL: Error
PID    : 3952                TID  : 2164        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgLoggrInit, probe:1150
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.20.45.890000+480 I3471222024H160    LEVEL: Error
PID:3952 TID:2164 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\39522164.000
 

回复:数据库坏了,请高手指教!谢谢!

2006-11-15-16.20.45.890000+480 I3471222186H381    LEVEL: Severe
PID    : 3952                TID  : 2164        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x01FCE994 : 0000 0000                                  ....

2006-11-15-16.20.45.890000+480 I3471222569H435    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-7                  APPID: C0020106.O805.023705081601
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.20.45.890000+480 I3471223006H414    LEVEL: Error
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-7                  APPID: C0020106.O805.023705081601
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.20.45.890000+480 E3471223422H372    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-7                  APPID: C0020106.O805.023705081601
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C  "PBS1    " marked bad.

2006-11-15-16.20.45.921000+480 I3471223796H443    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-7                  APPID: C0020106.O805.023705081601
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x019F3054 : EEFB FFFF                                  ....

2006-11-15-16.20.46.046000+480 I3471224241H295    LEVEL: Error
PID    : 3952                TID  : 1356        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:3200
MESSAGE : Error 118489302 opening database log extent 4:

2006-11-15-16.20.46.046000+480 I3471224538H371    LEVEL: Error
PID    : 3952                TID  : 1356        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgicl, probe:2130
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.20.46.046000+480 I3471224911H377    LEVEL: Error
PID    : 3952                TID  : 1356        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgLoggrInit, probe:1150
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.20.46.046000+480 I3471225290H160    LEVEL: Error
PID:3952 TID:1356 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\39521356.000

2006-11-15-16.20.46.062000+480 I3471225452H381    LEVEL: Severe
PID    : 3952                TID  : 1356        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x01FEE794 : 0000 0000                                  ....

2006-11-15-16.20.46.062000+480 I3471225835H432    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-8                  APPID: *LOCAL.DB2.061115082046
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.20.46.062000+480 I3471226269H411    LEVEL: Error
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-8                  APPID: *LOCAL.DB2.061115082046
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.20.46.062000+480 E3471226682H369    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-8                  APPID: *LOCAL.DB2.061115082046
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C  "PBS1    " marked bad.

2006-11-15-16.20.46.062000+480 I3471227053H440    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-8                  APPID: *LOCAL.DB2.061115082046
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x019F3054 : EEFB FFFF                                  ....

2006-11-15-16.22.02.609000+480 I3471227495H295    LEVEL: Error
PID    : 3952                TID  : 1624        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:3200
MESSAGE : Error 118489302 opening database log extent 4:

2006-11-15-16.22.02.609000+480 I3471227792H371    LEVEL: Error
PID    : 3952                TID  : 1624        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgicl, probe:2130
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.22.02.609000+480 I3471228165H377    LEVEL: Error
PID    : 3952                TID  : 1624        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgLoggrInit, probe:1150
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.22.02.609000+480 I3471228544H160    LEVEL: Error
PID:3952 TID:1624 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\39521624.000

2006-11-15-16.22.02.609000+480 I3471228706H381    LEVEL: Severe
PID    : 3952                TID  : 1624        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x01FCE594 : 0000 0000                                  ....

2006-11-15-16.22.02.609000+480 I3471229089H435    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-9                  APPID: C0020106.OF05.020045081731
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.22.02.609000+480 I3471229526H414    LEVEL: Error
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-9                  APPID: C0020106.OF05.020045081731
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.22.02.609000+480 E3471229942H372    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-9                  APPID: C0020106.OF05.020045081731
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C  "PBS1    " marked bad.

2006-11-15-16.22.02.625000+480 I3471230316H443    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-9                  APPID: C0020106.OF05.020045081731
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x019F3054 : EEFB FFFF                                  ....
 

回复:数据库坏了,请高手指教!谢谢!

2006-11-15-16.22.04.531000+480 I3471230761H295    LEVEL: Error
PID    : 3952                TID  : 456        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgole, probe:3200
MESSAGE : Error 118489302 opening database log extent 4:

2006-11-15-16.22.04.531000+480 I3471231058H371    LEVEL: Error
PID    : 3952                TID  : 456        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgicl, probe:2130
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.22.04.531000+480 I3471231431H377    LEVEL: Error
PID    : 3952                TID  : 456        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgLoggrInit, probe:1150
RETCODE : ZRC=0x071000D6=118489302=SQLP_EXT_DBID_INCORR
          "Database ID does not match Extent probably for another database."

2006-11-15-16.22.04.531000+480 I3471231810H158    LEVEL: Error
PID:3952 TID:456 NODE:000 Title: SQLP_DBCB
Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\3952456.000

2006-11-15-16.22.04.531000+480 I3471231970H381    LEVEL: Severe
PID    : 3952                TID  : 456        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000
FUNCTION: DB2 UDB, data protection, sqlpgasn, probe:4000
MESSAGE : Logging can not continue due to an error.
DATA #1 : Hexdump, 4 bytes
0x01FEE394 : 0000 0000                                  ....

2006-11-15-16.22.04.531000+480 I3471232353H432    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-10                APPID: *LOCAL.DB2.061115082204
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.22.04.531000+480 I3471232787H411    LEVEL: Error
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-10                APPID: *LOCAL.DB2.061115082204
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:120
DATA #1 : Hexdump, 4 bytes
0x01BE82CC : D600 1007                                  ....

2006-11-15-16.22.04.531000+480 E3471233200H369    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-10                APPID: *LOCAL.DB2.061115082204
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C  "PBS1    " marked bad.

2006-11-15-16.22.04.546000+480 I3471233571H440    LEVEL: Severe
PID    : 3952                TID  : 2384        PROC : db2syscs.exe
INSTANCE: DB2                  NODE : 000        DB  : PBS1
APPHDL  : 0-10                APPID: *LOCAL.DB2.061115082204
FUNCTION: DB2 UDB, base sys utilities, sqleFirstConnect, probe:100
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x019F3054 : EEFB FFFF
 

回复:数据库坏了,请高手指教!谢谢!

楼主有备份过数据库么?
企业彩信平台www.infotoall.com
 

回复:数据库坏了,请高手指教!谢谢!

楼主看看这个问题是不是和你的相似http://bbs.landingbj.com/t-0-243814-1.html
 
1  /  1  页   1 跳转
发表新主题 回复该主题

版权所有 TechTarget中国   Sitemap

Powered by Discuz!NT 2.0.1214    Copyright © 2001-2017 Comsenz Inc.
Processed in 0.046875 second(s) , 3 queries.
返顶部