Помогите пожалуйста!!!

DB2 V8

При попытке соединения с БД происходит остановка db2.

При попытке копирования выдается сообщение:

необходима перезагрузка базы данных, поскольку предыдущий сеанс не завершен нормально

RESTART DATABASE не проходит - также приводит к остановке Db2.

На этом экземпляре висят еще 2 базы, с ними все нормально.

Очень прошу, может кто-то из знающих людей поможет советом как быть?

Mark Barinstein, на

db2diag -H 1d

сообщение - SQL1024N отсутствует соединение с базой данных.

db2diag.log:

2011-04-04-16.18.49.928000+240 E13102155H373 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "CSERVICE" marked bad.

2011-04-04-16.18.49.928000+240 I13102530H386 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

GVF112GVF, полностью с момента ATTACH TO:

2011-04-04-16.18.17.424000+240 I13082438H322 LEVEL: Event
PID : 6572 TID : 4324 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-16.18.19.028000+240 E13082762H801 LEVEL: Event
PID : 6572 TID : 4324 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6842 available:3934
Virtual Memory: total:16425 free:15126
Swap Memory: total:8238 free:8284

2011-04-04-16.18.36.104000+240 I13083565H364 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2011-04-04-16.18.37.507000+240 I13083931H390 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, SQO Memory Management, sqloGetMemChunks, probe:10
DATA #1 : <preformatted>
Error from VirtualAlloc: 8

2011-04-04-16.18.37.640000+240 I13084323H465 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:500
MESSAGE : BufferPool memory allocation failed
DATA #1 : Hexdump, 4 bytes
0x029D3E24 : 1000 0F8B ....

2011-04-04-16.18.37.645000+240 E13084790H717 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.18.37.647000+240 E13085509H716 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TEMPSPACE1" (ID "1") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.18.37.648000+240 E13086227H716 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "USERSPACE1" (ID "2") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.18.37.650000+240 E13086945H718 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "3") is configured to
use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.18.37.650000+240 E13087665H722 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "4") is configured
to use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.18.37.651000+240 E13088389H717 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0000" (ID "5") is configured to use
buffer pool ID "2", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.18.37.653000+240 E13089108H720 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0000" (ID "6") is configured to
use buffer pool ID "2", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.18.37.654000+240 E13089830H717 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0001" (ID "7") is configured to use
buffer pool ID "3", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.18.37.655000+240 E13090549H720 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0001" (ID "8") is configured to
use buffer pool ID "3", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.18.37.656000+240 I13091271H522 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
DATA #1 : String, 70 bytes
Database will come up with hidden buffer pools.
totalBufferPoolPages:
DATA #2 : Hexdump, 8 bytes
0x029D3E1C : 4000 0000 0000 0000 @.......

2011-04-04-16.18.37.657000+240 I13091795H428 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000031E2F757916 MinbuffLSN
0000031E2F757916

2011-04-04-16.18.37.659000+240 I13092225H406 LEVEL: Warning
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 9 QSets 27 queues and 2 chunks

2011-04-04-16.18.49.476000+240 E13092633H402 LEVEL: Error
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.

2011-04-04-16.18.49.476000+240 I13093037H311 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
DATA #1 : String, 89 bytes
Could not fix page for objID=6, tbspaceID=2, objType=1, parentObjID=6 parentTbspaceID=2.

2011-04-04-16.18.49.476000+240 I13093350H266 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2011-04-04-16.18.49.477000+240 I13093618H342 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, index manager, sqlifix, probe:371
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.18.49.477000+240 I13093962H302 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : pageid
DATA #1 : Hexdump, 4 bytes
0x040FDF9C : 9190 0000 ....

2011-04-04-16.18.49.477000+240 I13094266H306 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : latch_mode
DATA #1 : Hexdump, 4 bytes
0x040FDFA0 : 2300 0000 #...

2011-04-04-16.18.49.477000+240 I13094574H157 LEVEL: Severe
PID:6572 TID:5544 NODE:000 Title: SQLI_PAGE_DESC
Dump File:D:\IBM\SQLLIB\DB2\65725544.000

2011-04-04-16.18.49.477000+240 I13094733H150 LEVEL: Severe
PID:6572 TID:5544 NODE:000 Title: SQLI_CB
Dump File:D:\IBM\SQLLIB\DB2\65725544.000

2011-04-04-16.18.49.478000+240 I13094885H266 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : SQLD_IXCB:
DATA #1 : String, 20 bytes
rootPage=2, itoken=0

2011-04-04-16.18.49.478000+240 I13095153H152 LEVEL: Severe
PID:6572 TID:5544 NODE:000 Title: SQLD_IXCB
Dump File:D:\IBM\SQLLIB\DB2\65725544.000

2011-04-04-16.18.49.478000+240 I13095307H152 LEVEL: Severe
PID:6572 TID:5544 NODE:000 Title: SQLD_IDEF
Dump File:D:\IBM\SQLLIB\DB2\65725544.000

2011-04-04-16.18.49.478000+240 I13095461H343 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:262
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.18.49.478000+240 I13095806H306 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x0427E642 : 031E 2F81 4B38 ../.K8

2011-04-04-16.18.49.478000+240 I13096114H317 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : SQLI_LRH
DATA #1 : Hexdump, 16 bytes
0x0427E680 : 0265 0200 0600 0200 0600 0100 0200 0000 .e..............

2011-04-04-16.18.49.478000+240 I13096433H345 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.18.49.478000+240 I13096780H381 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of LSN:
DATA #1 : Hexdump, 6 bytes
0x0427E642 : 031E 2F81 4B38 ../.K8

2011-04-04-16.18.49.479000+240 I13097163H544 LEVEL: Severe
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of log record:
DATA #1 : Hexdump, 47 bytes
0x0427E680 : 0265 0200 0600 0200 0600 0100 0200 0000 .e..............
0x0427E690 : 9190 0000 0100 0000 4100 0004 252E 2900 ........A...%.).
0x0427E6A0 : 0200 0000 0B00 00F0 7E0E 0000 0000 00 ........~......

2011-04-04-16.18.49.479000+240 I13097709H485 LEVEL: Error
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : REDO returns -2063466452 on log record:
DATA #1 : Hexdump, 32 bytes
0x0427E648 : 2F00 0000 4E00 0000 031E 2F81 4AF5 0000 /...N...../.J...
0x0427E658 : 0C0C 0C02 0000 0000 0000 0000 0000 0000 ................

2011-04-04-16.18.49.479000+240 I13098196H530 LEVEL: Error
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : extra info:
DATA #1 : Hexdump, 47 bytes
0x0427E680 : 0265 0200 0600 0200 0600 0100 0200 0000 .e..............
0x0427E690 : 9190 0000 0100 0000 4100 0004 252E 2900 ........A...%.).
0x0427E6A0 : 0200 0000 0B00 00F0 7E0E 0000 0000 00 ........~......

2011-04-04-16.18.49.479000+240 I13098728H352 LEVEL: Error
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.18.49.479000+240 I13099082H539 LEVEL: Error
PID : 6572 TID : 5544 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
MESSAGE : qEntry for 0000031E2F814B38entryFlags 1 queueId 1 waitOthers 00000000 numBlocked 0 lrHeader:
DATA #1 : Hexdump, 32 bytes
0x0427E648 : 2F00 0000 4E00 0000 031E 2F81 4AF5 0000 /...N...../.J...
0x0427E658 : 0C0C 0C02 0000 0000 0000 0000 0000 0000 ................

2011-04-04-16.18.49.479000+240 I13099623H393 LEVEL: Error
PID : 6572 TID : 8088 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlprProcDpsQEntry, probe:20
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-16.18.49.479000+240 I13100018H392 LEVEL: Error
PID : 6572 TID : 8088 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1100
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-16.18.49.851000+240 I13100412H496 LEVEL: Error
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 142 bytes
Crash recovery failed with rc -2063466452
LowtranLSN 0000031E2F80AD8B MinbuffLSN 0000031E2F80C111
Recovery started on log file S0000002.LOG.

2011-04-04-16.18.49.927000+240 I13100910H434 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x029D9A5C : 2C00 0285 ,...

2011-04-04-16.18.49.927000+240 I13101346H413 LEVEL: Error
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #1 : Hexdump, 4 bytes
0x029D9A5C : 2C00 0285 ,...

2011-04-04-16.18.49.928000+240 E13101761H392 LEVEL: Error
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".

2011-04-04-16.18.49.928000+240 E13102155H373 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "CSERVICE" marked bad.

2011-04-04-16.18.49.928000+240 I13102530H386 LEVEL: Severe
PID : 6572 TID : 7988 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404121834
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

пожалуйста, помогите, все рушится уже из-за этого!!!

Есть ли варианты разблокировать базу?

mustaccio, пробую

выполнила

db2set DB2_OVERRIDE_BPF=1,1000;2,1000;3,1000
db2stop
db2start

дальше после connect to db снова остановка db2

Mark Barinstein,


2011-04-04-16.44.33.991000+240 I13104724H364 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2011-04-04-16.44.35.377000+240 I13105090H390 LEVEL: Severe
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, SQO Memory Management, sqloGetMemChunks, probe:10
DATA #1 : <preformatted>
Error from VirtualAlloc: 8

2011-04-04-16.44.35.512000+240 I13105482H465 LEVEL: Severe
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:500
MESSAGE : BufferPool memory allocation failed
DATA #1 : Hexdump, 4 bytes
0x027D3E24 : 1000 0F8B ....

2011-04-04-16.44.35.517000+240 E13105949H717 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.44.35.519000+240 E13106668H716 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TEMPSPACE1" (ID "1") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.44.35.521000+240 E13107386H716 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "USERSPACE1" (ID "2") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.44.35.522000+240 E13108104H718 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "3") is configured to
use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.44.35.524000+240 E13108824H722 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "4") is configured
to use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.44.35.525000+240 E13109548H717 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0000" (ID "5") is configured to use
buffer pool ID "2", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.44.35.526000+240 E13110267H720 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0000" (ID "6") is configured to
use buffer pool ID "2", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.44.35.527000+240 E13110989H717 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0001" (ID "7") is configured to use
buffer pool ID "3", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-16.44.35.529000+240 E13111708H720 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0001" (ID "8") is configured to
use buffer pool ID "3", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-16.44.35.530000+240 I13112430H522 LEVEL: Severe
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
DATA #1 : String, 70 bytes
Database will come up with hidden buffer pools.
totalBufferPoolPages:
DATA #2 : Hexdump, 8 bytes
0x027D3E1C : 4000 0000 0000 0000 @.......

2011-04-04-16.44.35.532000+240 I13112954H428 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000031E2F757916 MinbuffLSN
0000031E2F757916

2011-04-04-16.44.35.533000+240 I13113384H406 LEVEL: Warning
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 9 QSets 27 queues and 2 chunks

2011-04-04-16.44.37.553000+240 E13113792H402 LEVEL: Error
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.

2011-04-04-16.44.37.553000+240 I13114196H311 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
DATA #1 : String, 89 bytes
Could not fix page for objID=6, tbspaceID=2, objType=1, parentObjID=6 parentTbspaceID=2.

2011-04-04-16.44.37.554000+240 I13114509H266 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2011-04-04-16.44.37.554000+240 I13114777H342 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, index manager, sqlifix, probe:371
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.44.37.554000+240 I13115121H302 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : pageid
DATA #1 : Hexdump, 4 bytes
0x03FCDF9C : FC0A 0000 ....

2011-04-04-16.44.37.554000+240 I13115425H306 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : latch_mode
DATA #1 : Hexdump, 4 bytes
0x03FCDFA0 : 2300 0000 #...

2011-04-04-16.44.37.554000+240 I13115733H157 LEVEL: Severe
PID:3464 TID:9724 NODE:000 Title: SQLI_PAGE_DESC
Dump File:D:\IBM\SQLLIB\DB2\34649724.000

2011-04-04-16.44.37.555000+240 I13115892H150 LEVEL: Severe
PID:3464 TID:9724 NODE:000 Title: SQLI_CB
Dump File:D:\IBM\SQLLIB\DB2\34649724.000

2011-04-04-16.44.37.555000+240 I13116044H269 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLD_IXCB:
DATA #1 : String, 23 bytes
rootPage=2382, itoken=0

2011-04-04-16.44.37.555000+240 I13116315H152 LEVEL: Severe
PID:3464 TID:9724 NODE:000 Title: SQLD_IXCB
Dump File:D:\IBM\SQLLIB\DB2\34649724.000

2011-04-04-16.44.37.555000+240 I13116469H152 LEVEL: Severe
PID:3464 TID:9724 NODE:000 Title: SQLD_IDEF
Dump File:D:\IBM\SQLLIB\DB2\34649724.000

2011-04-04-16.44.37.555000+240 I13116623H343 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:262
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.44.37.555000+240 I13116968H306 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x04168282 : 031E 2F78 714C ../xqL

2011-04-04-16.44.37.556000+240 I13117276H317 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLI_LRH
DATA #1 : Hexdump, 16 bytes
0x041682C0 : 0265 0200 0600 0200 0600 0100 4E09 0000 .e..........N...

2011-04-04-16.44.37.556000+240 I13117595H345 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.44.37.556000+240 I13117942H381 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of LSN:
DATA #1 : Hexdump, 6 bytes
0x04168282 : 031E 2F78 714C ../xqL

2011-04-04-16.44.37.556000+240 I13118325H611 LEVEL: Severe
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of log record:
DATA #1 : Hexdump, 56 bytes
0x041682C0 : 0265 0200 0600 0200 0600 0100 4E09 0000 .e..........N...
0x041682D0 : FC0A 0000 3000 1400 0200 0004 0D25 2900 ....0........%).
0x041682E0 : 0200 0000 1400 00A0 6806 0000 0000 0000 ........h.......
0x041682F0 : 1B19 0000 0000 0000 ........

2011-04-04-16.44.37.556000+240 I13118938H485 LEVEL: Error
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : REDO returns -2063466452 on log record:
DATA #1 : Hexdump, 32 bytes
0x04168288 : 3800 0000 4E00 0000 031E 2F78 7101 0000 8...N...../xq...
0x04168298 : 0C0B F597 0000 0000 0000 0000 0000 0000 ................

2011-04-04-16.44.37.556000+240 I13119425H597 LEVEL: Error
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : extra info:
DATA #1 : Hexdump, 56 bytes
0x041682C0 : 0265 0200 0600 0200 0600 0100 4E09 0000 .e..........N...
0x041682D0 : FC0A 0000 3000 1400 0200 0004 0D25 2900 ....0........%).
0x041682E0 : 0200 0000 1400 00A0 6806 0000 0000 0000 ........h.......
0x041682F0 : 1B19 0000 0000 0000 ........

2011-04-04-16.44.37.556000+240 I13120024H352 LEVEL: Error
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-16.44.37.556000+240 I13120378H539 LEVEL: Error
PID : 3464 TID : 9724 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
MESSAGE : qEntry for 0000031E2F78714CentryFlags 1 queueId 1 waitOthers 00000000 numBlocked 0 lrHeader:
DATA #1 : Hexdump, 32 bytes
0x04168288 : 3800 0000 4E00 0000 031E 2F78 7101 0000 8...N...../xq...
0x04168298 : 0C0B F597 0000 0000 0000 0000 0000 0000 ................

2011-04-04-16.44.37.557000+240 I13120919H393 LEVEL: Error
PID : 3464 TID : 932 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlprProcDpsQEntry, probe:20
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-16.44.37.557000+240 I13121314H392 LEVEL: Error
PID : 3464 TID : 932 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1100
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-16.44.37.832000+240 I13121708H496 LEVEL: Error
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 142 bytes
Crash recovery failed with rc -2063466452
LowtranLSN 0000031E2F76EB78 MinbuffLSN 0000031E2F770355
Recovery started on log file S0000002.LOG.

2011-04-04-16.44.37.832000+240 I13122206H434 LEVEL: Severe
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x027D9A5C : 2C00 0285 ,...

2011-04-04-16.44.37.832000+240 I13122642H413 LEVEL: Error
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #1 : Hexdump, 4 bytes
0x027D9A5C : 2C00 0285 ,...

2011-04-04-16.44.37.833000+240 E13123057H392 LEVEL: Error
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".

2011-04-04-16.44.37.833000+240 E13123451H373 LEVEL: Severe
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "CSERVICE" marked bad.

2011-04-04-16.44.37.834000+240 I13123826H386 LEVEL: Severe
PID : 3464 TID : 1840 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404124432
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

2011-04-04-17.02.19.902000+240 I13124214H322 LEVEL: Event
PID : 7308 TID : 9944 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-17.02.21.553000+240 E13124538H801 LEVEL: Event
PID : 7308 TID : 9944 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6852 available:3934
Virtual Memory: total:16425 free:15160
Swap Memory: total:8238 free:8308

2011-04-04-17.03.23.704000+240 I13125341H317 LEVEL: Event
PID : 7908 TID : 9952 PROC : db2set.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, oper system services, db2set_main, probe:40
CHANGE : CFG DB2SET: DB2_OVERRIDE_BPF: From: "" To: "1,1000;2,1000,3,1000"

2011-04-04-17.03.38.707000+240 I13125660H322 LEVEL: Event
PID : 9860 TID : 10020 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-17.04.34.423000+240 E13125984H801 LEVEL: Event
PID : 9860 TID : 10020 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6939 available:3934
Virtual Memory: total:16425 free:15241
Swap Memory: total:8238 free:8302

2011-04-04-17.05.04.687000+240 I13126787H301 LEVEL: Warning
PID : 9860 TID : 4656 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, routine_infrastructure, sqlerQueryHmonExistence, probe:99
MESSAGE : Health Monitor Process crashed.

2011-04-04-17.05.11.020000+240 I13127090H322 LEVEL: Event
PID : 8864 TID : 6944 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-17.05.12.658000+240 E13127414H801 LEVEL: Event
PID : 8864 TID : 6944 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6941 available:3934
Virtual Memory: total:16425 free:15244
Swap Memory: total:8238 free:8303

2011-04-04-17.05.25.762000+240 E13128217H494 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ROS
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130525
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.05.26.979000+240 E13128713H494 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : ROS
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130525
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.05.34.108000+240 E13129209H499 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.05.35.387000+240 I13129710H364 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2011-04-04-17.05.35.387000+240 E13130076H499 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.05.36.760000+240 I13130577H390 LEVEL: Severe
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, SQO Memory Management, sqloGetMemChunks, probe:10
DATA #1 : <preformatted>
Error from VirtualAlloc: 8

2011-04-04-17.05.36.869000+240 I13130969H465 LEVEL: Severe
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:500
MESSAGE : BufferPool memory allocation failed
DATA #1 : Hexdump, 4 bytes
0x027A3E24 : 1000 0F8B ....

2011-04-04-17.05.36.885000+240 E13131436H717 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13132155H716 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TEMPSPACE1" (ID "1") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13132873H716 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "USERSPACE1" (ID "2") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13133591H718 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "3") is configured to
use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13134311H722 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "4") is configured
to use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13135035H717 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0000" (ID "5") is configured to use
buffer pool ID "2", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13135754H720 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0000" (ID "6") is configured to
use buffer pool ID "2", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13136476H717 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0001" (ID "7") is configured to use
buffer pool ID "3", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.05.36.885000+240 E13137195H720 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0001" (ID "8") is configured to
use buffer pool ID "3", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.05.36.901000+240 I13137917H522 LEVEL: Severe
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
DATA #1 : String, 70 bytes
Database will come up with hidden buffer pools.
totalBufferPoolPages:
DATA #2 : Hexdump, 8 bytes
0x027A3E1C : 4000 0000 0000 0000 @.......

2011-04-04-17.05.36.901000+240 I13138441H428 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000031E2F757916 MinbuffLSN
0000031E2F757916

2011-04-04-17.05.36.901000+240 I13138871H406 LEVEL: Warning
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 9 QSets 27 queues and 2 chunks

2011-04-04-17.05.56.759000+240 E13139279H402 LEVEL: Error
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.

2011-04-04-17.05.56.759000+240 I13139683H311 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
DATA #1 : String, 89 bytes
Could not fix page for objID=6, tbspaceID=2, objType=1, parentObjID=6 parentTbspaceID=2.

2011-04-04-17.05.56.759000+240 I13139996H266 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2011-04-04-17.05.56.759000+240 I13140264H342 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, index manager, sqlifix, probe:371
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.05.56.759000+240 I13140608H302 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : pageid
DATA #1 : Hexdump, 4 bytes
0x046BDF9C : 1799 0000 ....

2011-04-04-17.05.56.759000+240 I13140912H306 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : latch_mode
DATA #1 : Hexdump, 4 bytes
0x046BDFA0 : 2300 0000 #...

2011-04-04-17.05.56.759000+240 I13141220H157 LEVEL: Severe
PID:8864 TID:5348 NODE:000 Title: SQLI_PAGE_DESC
Dump File:D:\IBM\SQLLIB\DB2\88645348.000

2011-04-04-17.05.56.759000+240 I13141379H150 LEVEL: Severe
PID:8864 TID:5348 NODE:000 Title: SQLI_CB
Dump File:D:\IBM\SQLLIB\DB2\88645348.000

2011-04-04-17.05.56.759000+240 I13141531H268 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : SQLD_IXCB:
DATA #1 : String, 22 bytes
rootPage=443, itoken=0

2011-04-04-17.05.56.759000+240 I13141801H152 LEVEL: Severe
PID:8864 TID:5348 NODE:000 Title: SQLD_IXCB
Dump File:D:\IBM\SQLLIB\DB2\88645348.000

2011-04-04-17.05.56.759000+240 I13141955H152 LEVEL: Severe
PID:8864 TID:5348 NODE:000 Title: SQLD_IDEF
Dump File:D:\IBM\SQLLIB\DB2\88645348.000

2011-04-04-17.05.56.759000+240 I13142109H343 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:262
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.05.56.759000+240 I13142454H306 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x04877102 : 031E 2F84 283D ../.(=

2011-04-04-17.05.56.759000+240 I13142762H317 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
MESSAGE : SQLI_LRH
DATA #1 : Hexdump, 16 bytes
0x04877140 : 0265 0200 0600 0200 0600 0100 BB01 0000 .e..............

2011-04-04-17.05.56.759000+240 I13143081H345 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.05.56.759000+240 I13143428H381 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of LSN:
DATA #1 : Hexdump, 6 bytes
0x04877102 : 031E 2F84 283D ../.(=

2011-04-04-17.05.56.759000+240 I13143811H539 LEVEL: Severe
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of log record:
DATA #1 : Hexdump, 42 bytes
0x04877140 : 0265 0200 0600 0200 0600 0100 BB01 0000 .e..............
0x04877150 : 1799 0000 0100 0000 4100 0004 1731 2900 ........A....1).
0x04877160 : 0200 0000 0600 0100 0034 .........4

2011-04-04-17.05.56.759000+240 I13144352H485 LEVEL: Error
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : REDO returns -2063466452 on log record:
DATA #1 : Hexdump, 32 bytes
0x04877108 : 2A00 0000 4E00 0000 031E 2F84 27FB 0000 *...N...../.'...
0x04877118 : 0C0C 0CBA 0000 0000 0000 0000 0000 0000 ................

2011-04-04-17.05.56.759000+240 I13144839H525 LEVEL: Error
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : extra info:
DATA #1 : Hexdump, 42 bytes
0x04877140 : 0265 0200 0600 0200 0600 0100 BB01 0000 .e..............
0x04877150 : 1799 0000 0100 0000 4100 0004 1731 2900 ........A....1).
0x04877160 : 0200 0000 0600 0100 0034 .........4

2011-04-04-17.05.56.759000+240 I13145366H352 LEVEL: Error
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.05.56.759000+240 I13145720H539 LEVEL: Error
PID : 8864 TID : 5348 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
MESSAGE : qEntry for 0000031E2F84283DentryFlags 1 queueId 2 waitOthers 00000000 numBlocked 0 lrHeader:
DATA #1 : Hexdump, 32 bytes
0x04877108 : 2A00 0000 4E00 0000 031E 2F84 27FB 0000 *...N...../.'...
0x04877118 : 0C0C 0CBA 0000 0000 0000 0000 0000 0000 ................

2011-04-04-17.05.56.759000+240 I13146261H393 LEVEL: Error
PID : 8864 TID : 1556 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlprProcDpsQEntry, probe:20
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-17.05.56.759000+240 I13146656H392 LEVEL: Error
PID : 8864 TID : 1556 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-8
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1100
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-17.05.57.071000+240 I13147050H496 LEVEL: Error
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 142 bytes
Crash recovery failed with rc -2063466452
LowtranLSN 0000031E2F8232AF MinbuffLSN 0000031E2F82370B
Recovery started on log file S0000002.LOG.

2011-04-04-17.05.57.071000+240 I13147548H434 LEVEL: Severe
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x027A9A5C : 2C00 0285 ,...

2011-04-04-17.05.57.071000+240 I13147984H413 LEVEL: Error
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #1 : Hexdump, 4 bytes
0x027A9A5C : 2C00 0285 ,...

2011-04-04-17.05.57.071000+240 E13148399H392 LEVEL: Error
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".

2011-04-04-17.05.57.071000+240 E13148793H373 LEVEL: Severe
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "CSERVICE" marked bad.

2011-04-04-17.05.57.071000+240 I13149168H386 LEVEL: Severe
PID : 8864 TID : 7768 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-8 APPID: *LOCAL.DB2.110404130534
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

2011-04-04-17.09.13.663000+240 I13149556H322 LEVEL: Event
PID : 1488 TID : 5380 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-17.09.15.269000+240 E13149880H801 LEVEL: Event
PID : 1488 TID : 5380 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6937 available:3934
Virtual Memory: total:16425 free:15240
Swap Memory: total:8238 free:8303

2011-04-04-17.09.35.664000+240 E13150683H499 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.09.37.045000+240 I13151184H364 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2011-04-04-17.09.37.047000+240 E13151550H499 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.09.38.447000+240 I13152051H390 LEVEL: Severe
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, SQO Memory Management, sqloGetMemChunks, probe:10
DATA #1 : <preformatted>
Error from VirtualAlloc: 8

2011-04-04-17.09.38.575000+240 I13152443H465 LEVEL: Severe
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:500
MESSAGE : BufferPool memory allocation failed
DATA #1 : Hexdump, 4 bytes
0x027F3E24 : 1000 0F8B ....

2011-04-04-17.09.38.579000+240 E13152910H717 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.09.38.582000+240 E13153629H716 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TEMPSPACE1" (ID "1") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.09.38.583000+240 E13154347H716 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "USERSPACE1" (ID "2") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.09.38.585000+240 E13155065H718 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "3") is configured to
use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.09.38.587000+240 E13155785H722 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "4") is configured
to use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.09.38.588000+240 E13156509H717 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0000" (ID "5") is configured to use
buffer pool ID "2", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.09.38.590000+240 E13157228H720 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0000" (ID "6") is configured to
use buffer pool ID "2", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.09.38.591000+240 E13157950H717 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0001" (ID "7") is configured to use
buffer pool ID "3", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.09.38.592000+240 E13158669H720 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0001" (ID "8") is configured to
use buffer pool ID "3", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.09.38.593000+240 I13159391H522 LEVEL: Severe
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
DATA #1 : String, 70 bytes
Database will come up with hidden buffer pools.
totalBufferPoolPages:
DATA #2 : Hexdump, 8 bytes
0x027F3E1C : 4000 0000 0000 0000 @.......

2011-04-04-17.09.38.595000+240 I13159915H428 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000031E2F757916 MinbuffLSN
0000031E2F757916

2011-04-04-17.09.38.596000+240 I13160345H406 LEVEL: Warning
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 9 QSets 27 queues and 2 chunks

2011-04-04-17.09.40.557000+240 E13160753H402 LEVEL: Error
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.

2011-04-04-17.09.40.558000+240 I13161157H311 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
DATA #1 : String, 89 bytes
Could not fix page for objID=6, tbspaceID=2, objType=1, parentObjID=6 parentTbspaceID=2.

2011-04-04-17.09.40.558000+240 I13161470H266 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2011-04-04-17.09.40.558000+240 I13161738H342 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, index manager, sqlifix, probe:371
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.09.40.558000+240 I13162082H302 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : pageid
DATA #1 : Hexdump, 4 bytes
0x03FDDF9C : 9415 0000 ....

2011-04-04-17.09.40.558000+240 I13162386H306 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : latch_mode
DATA #1 : Hexdump, 4 bytes
0x03FDDFA0 : 2300 0000 #...

2011-04-04-17.09.40.558000+240 I13162694H157 LEVEL: Severe
PID:1488 TID:5912 NODE:000 Title: SQLI_PAGE_DESC
Dump File:D:\IBM\SQLLIB\DB2\14885912.000

2011-04-04-17.09.40.559000+240 I13162853H150 LEVEL: Severe
PID:1488 TID:5912 NODE:000 Title: SQLI_CB
Dump File:D:\IBM\SQLLIB\DB2\14885912.000

2011-04-04-17.09.40.559000+240 I13163005H266 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLD_IXCB:
DATA #1 : String, 20 bytes
rootPage=2, itoken=0

2011-04-04-17.09.40.559000+240 I13163273H152 LEVEL: Severe
PID:1488 TID:5912 NODE:000 Title: SQLD_IXCB
Dump File:D:\IBM\SQLLIB\DB2\14885912.000

2011-04-04-17.09.40.559000+240 I13163427H152 LEVEL: Severe
PID:1488 TID:5912 NODE:000 Title: SQLD_IDEF
Dump File:D:\IBM\SQLLIB\DB2\14885912.000

2011-04-04-17.09.40.560000+240 I13163581H343 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:262
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.09.40.560000+240 I13163926H306 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x041DB702 : 031E 2F79 07F7 ../y..

2011-04-04-17.09.40.560000+240 I13164234H317 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLI_LRH
DATA #1 : Hexdump, 16 bytes
0x041DB740 : 0265 0200 0600 0200 0600 0100 0200 0000 .e..............

2011-04-04-17.09.40.560000+240 I13164553H345 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.09.40.560000+240 I13164900H381 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of LSN:
DATA #1 : Hexdump, 6 bytes
0x041DB702 : 031E 2F79 07F7 ../y..

2011-04-04-17.09.40.560000+240 I13165283H544 LEVEL: Severe
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of log record:
DATA #1 : Hexdump, 47 bytes
0x041DB740 : 0265 0200 0600 0200 0600 0100 0200 0000 .e..............
0x041DB750 : 9415 0000 0100 0B00 0100 0004 4625 2900 ............F%).
0x041DB760 : 0200 0000 0B00 0078 C71A 0000 0000 00 .......x.......

2011-04-04-17.09.40.560000+240 I13165829H485 LEVEL: Error
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : REDO returns -2063466452 on log record:
DATA #1 : Hexdump, 32 bytes
0x041DB708 : 2F00 0000 4E00 0000 031E 2F79 07B4 0000 /...N...../y....
0x041DB718 : 0C0B F6ED 0000 0000 0000 0000 0000 0000 ................

2011-04-04-17.09.40.560000+240 I13166316H530 LEVEL: Error
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : extra info:
DATA #1 : Hexdump, 47 bytes
0x041DB740 : 0265 0200 0600 0200 0600 0100 0200 0000 .e..............
0x041DB750 : 9415 0000 0100 0B00 0100 0004 4625 2900 ............F%).
0x041DB760 : 0200 0000 0B00 0078 C71A 0000 0000 00 .......x.......

2011-04-04-17.09.40.560000+240 I13166848H352 LEVEL: Error
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.09.40.561000+240 I13167202H539 LEVEL: Error
PID : 1488 TID : 5912 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
MESSAGE : qEntry for 0000031E2F7907F7entryFlags 1 queueId 1 waitOthers 00000000 numBlocked 0 lrHeader:
DATA #1 : Hexdump, 32 bytes
0x041DB708 : 2F00 0000 4E00 0000 031E 2F79 07B4 0000 /...N...../y....
0x041DB718 : 0C0B F6ED 0000 0000 0000 0000 0000 0000 ................

2011-04-04-17.09.40.562000+240 I13167743H393 LEVEL: Error
PID : 1488 TID : 7720 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlprProcDpsQEntry, probe:20
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-17.09.40.562000+240 I13168138H392 LEVEL: Error
PID : 1488 TID : 7720 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1100
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-17.09.40.762000+240 I13168532H496 LEVEL: Error
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 142 bytes
Crash recovery failed with rc -2063466452
LowtranLSN 0000031E2F789035 MinbuffLSN 0000031E2F78ADB1
Recovery started on log file S0000002.LOG.

2011-04-04-17.09.40.763000+240 I13169030H434 LEVEL: Severe
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x027F9A5C : 2C00 0285 ,...

2011-04-04-17.09.40.763000+240 I13169466H413 LEVEL: Error
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #1 : Hexdump, 4 bytes
0x027F9A5C : 2C00 0285 ,...

2011-04-04-17.09.40.764000+240 E13169881H392 LEVEL: Error
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".

2011-04-04-17.09.40.764000+240 E13170275H373 LEVEL: Severe
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "CSERVICE" marked bad.

2011-04-04-17.09.40.765000+240 I13170650H386 LEVEL: Severe
PID : 1488 TID : 6128 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404130935
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

2011-04-04-17.10.39.091000+240 I13171038H322 LEVEL: Event
PID : 6256 TID : 4684 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-17.10.40.735000+240 E13171362H801 LEVEL: Event
PID : 6256 TID : 4684 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6880 available:3934
Virtual Memory: total:16425 free:15201
Swap Memory: total:8238 free:8321

2011-04-04-17.11.00.844000+240 I13172165H322 LEVEL: Event
PID : 7908 TID : 3844 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, config/install, sqlfLogUpdateCfgParam, probe:30
CHANGE : CFG DBM: "Instance_Memory" <automatic> From: "13652" To: "13652"

2011-04-04-17.11.02.424000+240 E13172489H801 LEVEL: Event
PID : 7908 TID : 3844 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 "SQL08021"
with level identifier "03020106".
Informational tokens are "DB2 v8.1.8.762", "s041221", "WR21348", FixPak "8".
DATA #2 : System Info, 1304 bytes
System: WIN32_NT SW07100008061 Service Pack 2 6.0 x86 Family 6, model 15, stepping 11
CPU: total:2 online:2
Physical Memory: total:8187 free:6883 available:3934
Virtual Memory: total:16425 free:15203
Swap Memory: total:8238 free:8320

2011-04-04-17.11.35.894000+240 E13173292H499 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.11.37.161000+240 I13173793H364 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, base sys utilities, sqledint, probe:30
MESSAGE : Crash Recovery is needed.

2011-04-04-17.11.37.163000+240 E13174159H499 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbParseRegistryVar, probe:20
MESSAGE : ADM6029W The registry variable setting ("DB2_OVERRIDE_BPF=1,1000;2,
1000,3,1000") was ignored because the specified setting is invalid.

2011-04-04-17.11.38.580000+240 I13174660H390 LEVEL: Severe
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, SQO Memory Management, sqloGetMemChunks, probe:10
DATA #1 : <preformatted>
Error from VirtualAlloc: 8

2011-04-04-17.11.38.729000+240 I13175052H465 LEVEL: Severe
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:500
MESSAGE : BufferPool memory allocation failed
DATA #1 : Hexdump, 4 bytes
0x02793E24 : 1000 0F8B ....

2011-04-04-17.11.38.734000+240 E13175519H717 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSCATSPACE" (ID "0") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.11.38.736000+240 E13176238H716 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TEMPSPACE1" (ID "1") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.11.38.737000+240 E13176956H716 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "USERSPACE1" (ID "2") is configured to use
buffer pool ID "1", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4096". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.11.38.739000+240 E13177674H718 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSPACE" (ID "3") is configured to
use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.11.38.740000+240 E13178394H722 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "SYSTOOLSTMPSPACE" (ID "4") is configured
to use buffer pool ID "1", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4096".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.11.38.741000+240 E13179118H717 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0000" (ID "5") is configured to use
buffer pool ID "2", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.11.38.742000+240 E13179837H720 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0000" (ID "6") is configured to
use buffer pool ID "2", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.11.38.743000+240 E13180559H717 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32K0001" (ID "7") is configured to use
buffer pool ID "3", but this buffer pool is not active at this time.
In the interim the table space will use buffer pool ID "4099". The
inactive buffer pool should become available at next database startup
provided that the required memory is available.

2011-04-04-17.11.38.744000+240 E13181278H720 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbStartPools, probe:2
MESSAGE : ADM6073W The table space "TBSP32KTMP0001" (ID "8") is configured to
use buffer pool ID "3", but this buffer pool is not active at this
time. In the interim the table space will use buffer pool ID "4099".
The inactive buffer pool should become available at next database
startup provided that the required memory is available.

2011-04-04-17.11.38.745000+240 I13182000H522 LEVEL: Severe
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, buffer pool services, sqlbinit, probe:620
DATA #1 : String, 70 bytes
Database will come up with hidden buffer pools.
totalBufferPoolPages:
DATA #2 : Hexdump, 8 bytes
0x02793E1C : 4000 0000 0000 0000 @.......

2011-04-04-17.11.38.747000+240 I13182524H428 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
MESSAGE : Crash recovery started. LowtranLSN 0000031E2F757916 MinbuffLSN
0000031E2F757916

2011-04-04-17.11.38.749000+240 I13182954H406 LEVEL: Warning
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:2000
MESSAGE : Using parallel recovery with 3 agents 9 QSets 27 queues and 2 chunks

2011-04-04-17.11.56.918000+240 E13183362H387 LEVEL: Error
PID : 7908 TID : 5220 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.

2011-04-04-17.11.56.919000+240 I13183751H296 LEVEL: Severe
PID : 7908 TID : 5220 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
DATA #1 : String, 89 bytes
Could not fix page for objID=6, tbspaceID=2, objType=0, parentObjID=6 parentTbspaceID=2.

2011-04-04-17.11.56.919000+240 I13184049H251 LEVEL: Severe
PID : 7908 TID : 5220 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2011-04-04-17.11.57.783000+240 E13184302H402 LEVEL: Error
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, Common Trace API, sqlbFreeUpSlot, probe:122
MESSAGE : ADM6019E All pages in buffer pool "IBMHIDDENBP4K" (ID "4096") are in
use. Refer to the documentation for SQLCODE -1218.

2011-04-04-17.11.57.783000+240 I13184706H311 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
DATA #1 : String, 89 bytes
Could not fix page for objID=6, tbspaceID=2, objType=1, parentObjID=6 parentTbspaceID=2.

2011-04-04-17.11.57.783000+240 I13185019H266 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
DATA #1 : String, 44 bytes
Current size of bufferpool #4096: 16 slots.

2011-04-04-17.11.57.784000+240 I13185287H342 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, index manager, sqlifix, probe:371
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.11.57.784000+240 I13185631H302 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : pageid
DATA #1 : Hexdump, 4 bytes
0x040DDF9C : 4A9E 0000 J...

2011-04-04-17.11.57.784000+240 I13185935H306 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : latch_mode
DATA #1 : Hexdump, 4 bytes
0x040DDFA0 : 2300 0000 #...

2011-04-04-17.11.57.784000+240 I13186243H157 LEVEL: Severe
PID:7908 TID:5192 NODE:000 Title: SQLI_PAGE_DESC
Dump File:D:\IBM\SQLLIB\DB2\79085192.000

2011-04-04-17.11.57.784000+240 I13186402H150 LEVEL: Severe
PID:7908 TID:5192 NODE:000 Title: SQLI_CB
Dump File:D:\IBM\SQLLIB\DB2\79085192.000

2011-04-04-17.11.57.785000+240 I13186554H269 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLD_IXCB:
DATA #1 : String, 23 bytes
rootPage=3427, itoken=0

2011-04-04-17.11.57.785000+240 I13186825H152 LEVEL: Severe
PID:7908 TID:5192 NODE:000 Title: SQLD_IXCB
Dump File:D:\IBM\SQLLIB\DB2\79085192.000

2011-04-04-17.11.57.785000+240 I13186979H152 LEVEL: Severe
PID:7908 TID:5192 NODE:000 Title: SQLD_IDEF
Dump File:D:\IBM\SQLLIB\DB2\79085192.000

2011-04-04-17.11.57.785000+240 I13187133H343 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, index manager, sqliRedo, probe:262
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.11.57.785000+240 I13187478H306 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLP_LSN
DATA #1 : Hexdump, 6 bytes
0x041802C2 : 031E 2F8A D282 ../...

2011-04-04-17.11.57.785000+240 I13187786H317 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
MESSAGE : SQLI_LRH
DATA #1 : Hexdump, 16 bytes
0x04180300 : 0265 0200 0600 0200 0600 0100 630D 0000 .e..........c...

2011-04-04-17.11.57.785000+240 I13188105H345 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.11.57.785000+240 I13188452H381 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of LSN:
DATA #1 : Hexdump, 6 bytes
0x041802C2 : 031E 2F8A D282 ../...

2011-04-04-17.11.57.785000+240 I13188835H610 LEVEL: Severe
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, data management, sqldmrdo, probe:788
MESSAGE : Error during REDO of log record:
DATA #1 : Hexdump, 55 bytes
0x04180300 : 0265 0200 0600 0200 0600 0100 630D 0000 .e..........c...
0x04180310 : 4A9E 0000 1800 0000 4200 000C 1038 2900 J.......B....8).
0x04180320 : 0200 0000 1300 D414 1200 0000 0000 00A8 ................
0x04180330 : D202 0000 0000 00 .......

2011-04-04-17.11.57.786000+240 I13189447H485 LEVEL: Error
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : REDO returns -2063466452 on log record:
DATA #1 : Hexdump, 32 bytes
0x041802C8 : 3700 0000 4E00 0000 031E 2F8A D235 0000 7...N...../..5..
0x041802D8 : 0C0C 1812 0000 0000 0000 0000 0000 0000 ................

2011-04-04-17.11.57.786000+240 I13189934H596 LEVEL: Error
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpRecDbRedo, probe:160
MESSAGE : extra info:
DATA #1 : Hexdump, 55 bytes
0x04180300 : 0265 0200 0600 0200 0600 0100 630D 0000 .e..........c...
0x04180310 : 4A9E 0000 1800 0000 4200 000C 1038 2900 J.......B....8).
0x04180320 : 0200 0000 1300 D414 1200 0000 0000 00A8 ................
0x04180330 : D202 0000 0000 00 .......

2011-04-04-17.11.57.786000+240 I13190532H352 LEVEL: Error
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
RETCODE : ZRC=0x8502002C=-2063466452=SQLB_BPFULL
"no available buffer pool pages"

2011-04-04-17.11.57.786000+240 I13190886H539 LEVEL: Error
PID : 7908 TID : 5192 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:250
MESSAGE : qEntry for 0000031E2F8AD282entryFlags 1 queueId 1 waitOthers 00000000 numBlocked 0 lrHeader:
DATA #1 : Hexdump, 32 bytes
0x041802C8 : 3700 0000 4E00 0000 031E 2F8A D235 0000 7...N...../..5..
0x041802D8 : 0C0C 1812 0000 0000 0000 0000 0000 0000 ................

2011-04-04-17.11.57.786000+240 I13191427H393 LEVEL: Error
PID : 7908 TID : 1624 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlprProcDpsQEntry, probe:20
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-17.11.57.786000+240 I13191822H392 LEVEL: Error
PID : 7908 TID : 1624 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000
APPHDL : 0-7
FUNCTION: DB2 UDB, recovery manager, sqlpPRecReadLog, probe:1100
RETCODE : ZRC=0x071000E2=118489314=SQLPR_PR_PROC_DONE
"parallel recovery: error condition detected by some other agent."

2011-04-04-17.11.58.028000+240 I13192216H496 LEVEL: Error
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:640
DATA #1 : String, 142 bytes
Crash recovery failed with rc -2063466452
LowtranLSN 0000031E2F8A7BD5 MinbuffLSN 0000031E2F8A81B0
Recovery started on log file S0000002.LOG.

2011-04-04-17.11.58.028000+240 I13192714H434 LEVEL: Severe
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x02799A5C : 2C00 0285 ,...

2011-04-04-17.11.58.028000+240 I13193150H413 LEVEL: Error
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, base sys utilities, recover, probe:16
DATA #1 : Hexdump, 4 bytes
0x02799A5C : 2C00 0285 ,...

2011-04-04-17.11.58.029000+240 E13193565H392 LEVEL: Error
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, base sys utilities, recover, probe:60
MESSAGE : ADM1532E Crash recovery has failed with SQLCODE "-1042".

2011-04-04-17.11.58.030000+240 E13193959H373 LEVEL: Severe
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:10
MESSAGE : ADM7518C "CSERVICE" marked bad.

2011-04-04-17.11.58.030000+240 I13194334H386 LEVEL: Severe
PID : 7908 TID : 5920 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : CSERVICE
APPHDL : 0-7 APPID: *LOCAL.DB2.110404131135
FUNCTION: DB2 UDB, base sys utilities, sqleMarkDBad, probe:210
MESSAGE : Database logging stopped due to mark db bad.

Пришлось восстанавливаться из копии, не успела применить все советы! Большое спасибо за участие, вы очень добры. Все возьму на вооружение. К тому же боюсь, ситуация может повториться...