数据库宕了，麻烦帮忙分析下db2diag

回复 11# weiruan85


    没有做db2dart
重启服务器后
系统自己做崩溃恢复收起

回复 8# tongjixianing


    磁盘空间34个G收起

回复 8# tongjixianing


    本地磁盘空间还有34个G收起

回复 13# weiruan85


    great！db2用了windows的api WriteFile，应该是这个原因导致的。lz的 container size有多大?收起

回复 12# tongjixianing


    http://www-01.ibm.com/support/docview.wss?uid=swg21223949

Problem details
The db2diag.log message will have the following format:

xxxx-xx-xx-xx.xx.xx.xxxxxx Instance:xxx Node:xxx
PID:xxxx(db2syscs.exe) TID:xxxx Appid:xxxxxxxxxxxxxxxxxxxxxxx
buffer pool services sqlbReadPageFromContainer Probe:20
Database:xxxxxxxx

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x870F00F2".

Answer

The error can be prevented from occurring--at least temporarily--by rebooting the machine, thereby clearing the Windows file system cache.

You can use the DB2 registry variable DB2NTNOCACHE to avoid use of the Windows file system cache. Follow these steps to set it:
db2stop
db2set DB2NTNOCACHE=ON
db2start

The DB2NTNOCACHE registry variable specifies whether DB2 on Windows opens
database files with a NOCACHE option. If DB2NTNOCACHE=ON, file system
caching is eliminated. If DB2NTNOCACHE=OFF, the operating system caches
DB2 files. This applies to all data except for files that contain long
fields or LOBs. Eliminating system caching allows more memory to be
available to the database so that the buffer pool or sortheap can be
increased.

不知道跟这个有没有关联收起

回复 11# weiruan85

  page应该是有问题了。不过可能是OS的问题的导致的，那个no resource的报错有些不清楚。收起

2012-04-22-11.03.49.812000+480 I358924H655        LEVEL: Severe
PID     : 3224                 TID  : 3912        PROC : db2syscs.exe
INSTANCE: ITIMLDAP             NODE : 000         DB   : LDAPDB2
APPHDL  : 0-78                 APPID: *LOCAL.ITIMLDAP.120421054608
AUTHID  : ITIMLDAP
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string, probe:0
DATA #1 : String, 157 bytes
Running the following command before and after restart database
may provide useful problem determination information.
Replace DBNAME with the real DB name.
DATA #2 : String, 83 bytes
db2dart DBNAME /di /tsi 3 /oi 2 /ps 84p /np 1 /v y /scr n /rptn iTsi3oi2pg84p+0.rpt

db2dart 做了没，啥结果收起

把db2pd -winx的结果贴出来。收起

MESSAGE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
          "no resources to create process or thread"

好像还是资源收起

和内存没关系，不得不说db2的这个报错有些误导人。是索引页有问题

2012-04-22-11.03.49.968000+480 I426577H1198       LEVEL: Severe
PID     : 3224                 TID  : 3964        PROC : db2syscs.exe
INSTANCE: ITIMLDAP             NODE : 000         DB   : LDAPDB2
APPHDL  : 0-73                 APPID: *LOCAL.ITIMLDAP.120421054603
AUTHID  : ITIMLDAP
FUNCTION: DB2 UDB, buffer pool services, sqlbWritePage, probe:90
MESSAGE : ZRC=0x870F00F2=-2029059854=SQLO_NORES
          "no resources to create process or thread"
DATA #1 : Object control block, PD_TYPE_SQLB_OBJECT, 68 bytes
Obj: {pool:3;obj:2;type:1} Parent={3;2}
DATA #2 : String, 16 bytes
poolPageNumber =
DATA #3 : unsigned integer, 4 bytes
100
DATA #4 : String, 13 bytes
pagePointer =
DATA #5 : Pointer, 4 bytes
0x0ca48000
DATA #6 : Page header, PD_TYPE_SQLB_PAGE_HEAD, 48 bytes
pageHead: {pool:3;obj:2;type:1} PPNum:100 OPNum:100
  begoff:              48
  datlen:           32720
  pagebinx:           721
  revnum:            1024
  pagelsn:     000000000000  flag:                 2
  signature:   1338121810
  cbits1to31:           0
  cbits32to63:          0
DATA #7 : String, 9 bytes
SQLB_PAGE

建议：
1. 试着drop table ITIMLDAP.LDAP_ENTRY 索引，
2. 如果drop不了，db2dart LDAPDB2 /MI /OI 2 /TSI 3

还有你的磁盘空间还有多大？收起