2006-1-15 21:35
怕瓦落地
db2dart不成功
提示如下:
dwf80:db2gdb 8> db2dart GDB /DB
____________________________________________________________________
_____ D B 2 D A R T _____
Database Analysis Tool
I B M
DB2 6000
The DB2DART Tool is a utility for the analysis of databases,
tablespaces, and tables. DART's primary function is to
examine databases for their architectural correctness, and to
report any encountered errors.
____________________________________________________________________
_______ DART _______
D a t a b a s e A n a l y s i s a n d R e p o r t i n g T o o l
IBM DB2 6000
DART (V7.1.0) Report:
Sun Jan 15 21:24:05 2006 TAIST
Database Name: GDB
Report name: GDB.RPT
Database Subdirectory: /db2/GDB/db2gdb/NODE0000/SQL00001
Operational Mode: Database Inspection Only (INSPECT)
______________________________________________________________________________
Connecting to Buffer Pool Services...
Database inspection phase start.
Tablespace file inspection phase start.Segmentation fault (core dumped)
该数据库最近进行过表的迁移,原来所有的表空间的PAGE SIZE都是4K,后来将一个表(约2G)迁移到了一个新建的表空间(PAGE SIZE=8K),并且其索引也迁移到了新的索引表空间(PAGE SIZE=8K),并且针对新的表空间建立了PAGE SIZE=8K的临时表空间和缓冲池。请问DART不成功是不是与这个有关,该如何解决这个问题?
2006-2-13 10:19
smile_knight
应该没关系
你可以先查查表空间的状态等系统信息。db2diag.log报什么错误?
2006-2-23 21:19
怕瓦落地
2006-02-23-21.01.44.058099 Instance:db2gdb Node:000
PID:49936(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125317
buffer_pool_services sqlbTerminateAgent Probe:837 Database:GDB
DIA3727C The database has been marked as being damaged.
ZRC=0xFFFFE11A
2006-02-23-21.01.44.060052 Instance:db2gdb Node:000
PID:49936(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125317
base_sys_utilities sqleTermDbConnect Probe:5 Database:GDB
DIA3727C The database has been marked as being damaged.
ZRC=0xFFFFE11A
2006-02-23-21.01.47.484640 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
base_sys_utilities sqledint Probe:0 Database:GDB
Crash Recovery is needed.
2006-02-23-21.01.55.056725 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
recovery_manager sqlpresr Probe:1 Database:GDB
DIA3908W Crash recovery has been initiated. Lowtran LSN is "003D3DB3137A",
Minbuff LSN is "003D3DB3137A".
2006-02-23-21.01.55.064162 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
recovery_manager sqlprecm Probe:125 Database:GDB
Using parallel recovery with 3 agents 29 QSets 203 queues and 64 chunks
2006-02-23-21.01.55.507787 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
recovery_manager sqlprecm Probe:400 Database:GDB
DIA3916W Forward phase of crash recovery has completed. Next LSN is
"003D3DB7F536".
2006-02-23-21.01.55.568337 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
recovery_manager sqlpresr Probe:170 Database:GDB
Using parallel recovery with 3 agents 29 QSets 203 queues and 64 chunks
2006-02-23-21.01.55.507787 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
recovery_manager sqlprecm Probe:400 Database:GDB
DIA3916W Forward phase of crash recovery has completed. Next LSN is
"003D3DB7F536".
2006-02-23-21.01.55.568337 Instance:db2gdb Node:000
PID:18892(db2agent (GDB)) Appid:*LOCAL.db2gdb.060223125315
recovery_manager sqlpresr Probe:170 Database:GDB
DIA3909W Crash recovery completed. Next LSN is "003D3DBB0DCA".
上面是DB2DIAG.LOG里的报错,这种报错出现很久了,在数据库进行表的迁移前就有了。所以才想用DB2DART工具诊断一下的,谁想到DB2DART没执行成功。
2006-2-23 21:28
怕瓦落地
DART.ERR内容如下:
dwf80:db2gdb 2> more DART.ERR
=== ===
=== Error events occurred during DART processing! ===
=== ===
=== This file will list the location of each error ===
=== event. Note that some error events are always ===
=== generated under normal processing to mark ===
=== conditions such as EOF, or file not found. ===
=== ===
=== Current date and time: ===
Thu Feb 23 21:17:40 2006 TAIST
=== ===
==========================================================================
File Line DART Error DB Engn Function Called
Number (Dec) Error(HEX)
==========================================================================
drtutl.C 698 5 0 DART_ERR_PROMPT_DATA
drtutl.C 703 5 0 DART_ERR_PROMPT_DATA
drtdbmgr.C 3167 5 0 DartGetPromptedData(
drtdbmgr.C 3179 -76 0 DART_ERR_BAD_INPUT_P
drtutl.C 698 5 0 DART_ERR_PROMPT_DATA
drtutl.C 703 5 0 DART_ERR_PROMPT_DATA
drtdbmgr.C 3167 5 0 DartGetPromptedData(
drtdbmgr.C 3179 -76 0 DART_ERR_BAD_INPUT_P
db2dart.SQC 896 -76 0 DartMGRDumpDATInDEL(
db2dart.SQC 1406 -8 0 DartTerminate(iAppRC
2006-2-24 08:30
bpmf
DB2DIAG.LOG里面的信息是数据库在作crash recovery.说明数据库一致性出现问题
2006-2-24 09:25
怕瓦落地
请问我该如何解决这个问题呢?楼上兄台的大名好像在别的论坛看到过。
2006-4-6 15:48
怕瓦落地
UP!UP!
页:
[1]
Powered by Discuz! Archiver 5.5.0
© 2001-2006 Comsenz Inc.