 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / DB2 Topics / April 2006SQL0902C - SQLSTATE=58005 - Reason Code = "14"
Greetings, I recently being bugged by the following error on my DB2. SQL0902C SQLSTATE = 58005 Reason Code = 14 This error comes out everytime i tried to insert some record to a table (consist of BLOB datatype) called BINSCHEMA.BINARYIMG. I use VB6 to do the insertion to several table and i found it, those table which does not have the BLOB column able to complete the transaction successfully. Whereas for this particular table, it will failed and prompt the above error whenever i attempt to insert BLOB value. If i set the BLOB column to null, then it can complete successfully. I manages to find out some simple explanation on this error. The SQLSTATE states that it was caused by my system error. The Reason Code 14 mean that Lock Violation which means some files of db2 has been locked. I can assured that there's no backup running at the background nor any anti-virus running. I also restarted the Server several times and the error still exist. I am currently using DB2 Version 7.1 which i had upgrade the fixpak from IBM site to Version 7.2. The odd thing about this problem is, my DB state is Normal. the TableSpace state also Normal. I am using DMS over here and i had created 3 tablespace to serve 3 different purpose. DATASPC - It was assigned to all the table that i'd created. IDXSPC - It assigned to all the table LOBSPC - It only assigned to one table which has BLOB column. (BINSCHEMA.BINARYIMG table) I had carried out several test to solve this problem. i will list the test case. 1. Reorg table BINSCHEMA.BINARYIMG. The reorg process will fail after about 1 minutes. the error code is the same as above. Reorg table on other tables were completed successfully. 2. Create new table. The create will failed if i specify the LOBSPC tablespace to this new table. 3. Simple VB6 program. I coded a simple vb6 program to do insert to this BLOB table. If i assigned some binary value to the column, it will fail. If i set the column to null, then it will insert successfully. For select and deleting, the transaction will complete successfully with the same method of code in the vb6 program. Updating will behave the same as the Insertion. Below, i had attached the db2diag.log file that i have. Please help me on this issue as i couldn't find much solution pertaining on this problem. Thanks a million. ================================================== DB2DIAG.LOG ================================================== 2006-03-25-16.58.54.656000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 buffer_pool_services sqlbDMSDirectWrite Probe:790 Database:MSCDB DiagData b081 bf00 0100 0000 0200 0000 a0e4 bc0a °.¿......... ä¼. a078 bb0a 0000 0000 0000 0000 0200 0000 x»............. 3040 6a19 0092 0a1a 1000 0000 0100 0000 0@j..'.......... 2006-03-25-16.58.54.921000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 buffer_pool_services sqlbDMSDirectWrite Probe:860 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.55.140000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 buffer_pool_services sqlbDMSDirectWrite Probe:860 Database:MSCDB Obj={pool:5;obj:4;type:3} State=x27 Parent={3;17}, EM=96, PP0=128 Page=180151456 Cont=4 Offset=36029632 BlkSize=10 Data Title:SQLB_OBJECT_DESC PID:4576 TID:4380 Node:000 0500 0400 0300 1100 0300 0000 0000 0053 ...............S 5ecd 0000 0000 0000 6000 0000 0000 0000 ^Í......`....... 8000 0000 0200 0000 2700 0000 0000 0000 ........'....... 0080 0000 2000 0000 0200 0000 0500 0403 .... ........... 6cdb 0d1a 3058 111a lÛ..0X.. 2006-03-25-16.58.55.531000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 buffer_pool_services sqlbDirectWrite Probe:820 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.55.750000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 buffer_pool_services sqlbDirectWrite Probe:820 Database:MSCDB Obj={pool:5;obj:4;type:3} State=x27 Parent={3;17}, EM=96, PP0=128 Data Title:SQLB_OBJECT_DESC PID:4576 TID:4380 Node:000 0500 0400 0300 1100 0300 0000 0000 0053 ...............S 5ecd 0000 0000 0000 6000 0000 0000 0000 ^Í......`....... 8000 0000 0200 0000 2700 0000 0000 0000 ........'....... 0080 0000 2000 0000 0200 0000 0500 0403 .... ........... 6cdb 0d1a 3058 111a lÛ..0X.. 2006-03-25-16.58.56.046000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_diskwrite Probe:10 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLB_OBJECT_DESC 2006-03-25-16.58.56.156000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_diskwrite Probe:105 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.56.234000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_diskwrite Probe:105 Database:MSCDB DATA1 a078 bb0a 0200 0000 0400 0000 x»......... 2006-03-25-16.58.56.359000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldxWriteLobData Probe:45 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.56.437000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldxWriteLobData Probe:100 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.56.531000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldxWriteLobData Probe:100 Database:MSCDB DATA1 8078 bb0a 0000 0000 1484 0000 0400 0000 .x»......,,...... 2006-03-25-16.58.56.703000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_replace_lob Probe:25 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.56.796000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_replace_lob Probe:200 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.56.875000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_replace_lob Probe:200 Database:MSCDB DATA1 0000 0000 1484 0000 0000 0000 .....,,...... 2006-03-25-16.58.57.031000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_replace_lob Probe:200 Database:MSCDB DATA2 4906 0200 0000 0000 1484 0000 0000 0000 I........,,...... 0000 0000 0105 5400 0200 0000 1404 0000 ......T......... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 8078 bb0a ffff ffff .........x».ÿÿÿÿ a078 bb0a ffff ffff ffff ffff ffff ffff x».ÿÿÿÿÿÿÿÿÿÿÿÿ ffff ffff ÿÿÿÿ 2006-03-25-16.58.57.359000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_append_lob Probe:35 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.57.515000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_append_lob Probe:200 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.57.687000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_append_lob Probe:200 Database:MSCDB DATA1 1484 0000 1484 0000 0200 0000 .,,...,,...... 2006-03-25-16.58.57.875000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_append_lob Probe:200 Database:MSCDB DATA2 4906 0200 0000 0000 1484 0000 0000 0000 I........,,...... 0000 0000 0105 5400 0200 0000 1404 0000 ......T......... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 8078 bb0a ffff ffff .........x».ÿÿÿÿ a078 bb0a ffff ffff ffff ffff ffff ffff x».ÿÿÿÿÿÿÿÿÿÿÿÿ ffff ffff ÿÿÿÿ 2006-03-25-16.58.58.046000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_internal_create_lob Probe:20 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.58.140000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 lob_manager sqldx_lob_create Probe:50 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.58.250000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldRowInsert Probe:871 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.58.328000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldRowInsert Probe:871 Database:MSCDB P=3, O=17, C=0, RID=1A0A8030, numvals=4, lockinfo:0300 1000 5443 0702 0000 0000 5200 0000 ....TC......R... 4c89 bf00 f41a 4d01 0500 0000 0200 0000 L¿.ô.M......... 0000 0000 0b00 0000 ff00 0000 0100 0000 ........ÿ....... 0000 0000 0000 0040 .......@ String Title:SQLD_TCB: PID:4576 Node:000 pool(TID)=3, obj(FID)=17, class=0 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_TCB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_COLUMN Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_COLINFO Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_IXCB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_IXCB 2006-03-25-16.58.58.718000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldRowInsert Probe:871 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.58.58.828000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldRowInsert Probe:871 Database:MSCDB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_AGENT_CB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_TRAN_CB Data Title:SQLD_AGENT_CB Pointer: PID:4576 TID:4380 Node:000 30c0 2c19 0À,. Data Title:SQLD_AGENT_CB PID:4576 TID:4380 Node:000 0000 0000 0000 0000 0000 0000 3881 2c19 ............8.,. 0000 0000 0080 0000 3000 6c19 0080 0000 ........0.l..... 3000 7019 0000 0000 0000 0000 0000 0000 0.p............. 0000 0000 0080 0000 3040 6a19 0010 0000 ........0@j..... 70ec 2c19 0000 0000 0000 0000 pì,......... Data Title:SQLD_TRAN_CB Pointer PID:4576 TID:4380 Node:000 b080 2c19 °.,. Data Title:SQLD_TRAN_CB PID:4576 TID:4380 Node:000 6000 6919 0000 0000 0000 0000 0000 0000 `.i............. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 b089 2c19 c08c 2c19 ........°,.À,. 0200 0000 0200 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0400 0000 409e e818 ............@è. 0200 0000 0000 0000 40cd 4819 0200 0000 ........@ÍH..... 0000 0000 d0e6 4819 0200 0000 0000 0000 ....ÐæH......... 4000 231a 0200 0000 0000 0000 0000 0000 @.#............. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 ........ String Title:>> Begin CURSOR dump: PID:4576 Node:000 OPEN PERM CURSORS: >> String Title:<< End CURSOR dump: PID:4576 Node:000 OPEN PERM CURSORS: << String Title:>> Begin CURSOR dump: PID:4576 Node:000 OPEN TEMP CURSORS: >> String Title:<< End CURSOR dump: PID:4576 Node:000 OPEN TEMP CURSORS: << String Title:>> Begin CURSOR dump: PID:4576 Node:000 CLOSED CURSORS: >> String Title:SQLD_CCB: PID:4576 Node:000 pool(TID)=0, obj(FID)=18, indexid(IID)=0, class=0 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_CCB String Title:SQLD_CCB: PID:4576 Node:000 pool(TID)=0, obj(FID)=3, indexid(IID)=0, class=0 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_CCB String Title:<< End CURSOR dump: PID:4576 Node:000 CLOSED CURSORS: << Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLI_CB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLE_ACB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLP_ACB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLP_DBCB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLP_TRTBL String Title:locklist PID:4576 Node:000 Check C:\PROGRA~1\SQLLIB\DB2\l55611.000 for additional data. String Title:sqleMarkDBad: PID:4576 Node:000 Marking the database bad. 2006-03-25-16.59.03.859000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 global_services sqlzerdm Probe:40 Database:MSCDB 0ef6 ffff .öÿÿ 2006-03-25-16.59.04.000000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 relation_data_serv sqlrr_dump_ffdc Probe:17 Database:MSCDB DIA3811C A locked file was encountered. 2006-03-25-16.59.04.062000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 relation_data_serv sqlrr_dump_ffdc Probe:17 Database:MSCDB DIA9999E An internal error occurred. Report the following error code : "0xFFFFF60E". Data Title:SQLCA PID:4576 TID:4380 Node:000 sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 2 sqlerrmc: 14 sqlerrp : sqlriisr ö sqlerrd : (1) 0xFFFFF60E (2) 0x0000000E (3) 0x00000000 (4) 0x00000000 (5) 0x00000000 (6) 0x00000000 sqlwarn : (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) sqlstate: Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLCA Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:DB2RA Data Title:CREATOR PID:4576 TID:4380 Node:000 4e55 4c4c 4944 2020 NULLID Data Title:PACKAGE PID:4576 TID:4380 Node:000 5351 4c4c 4630 3030 SQLLF000 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:CREATOR Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:PACKAGE Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:REQUEST TYPE Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:Recursive dump_sect Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:PACKAGE ENTRY Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:USED_IN_UOW BIT VECTOR Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SECTION NUMBER Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SECTION DIR ENTRY Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:cursor name Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:cache cb Data Title:section stmt PID:4576 TID:4380 Node:000 494e 5345 5254 2049 4e54 4f20 2253 4341 INSERT INTO "BIN 4e4e 494e 4722 2e22 4241 5443 4849 4d41 SCHEMA"."BINARYI 4745 2220 2822 424d 475f 4253 4554 4e41 MG" ("BIN_BSETNA 4d45 222c 2242 4d47 5f42 4154 4348 4944 ME","BIN_FILEIDS 222c 2242 4d47 5f50 4753 4551 222c 2242 ","BIN_SEQSN","B 4d47 5f50 4749 4d41 4745 2229 2056 414c IN_BLOBIMG") VAL 5545 5320 283f 2c3f 2c3f 2c3f 29 UES (?,?,?,?) Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:section stmt Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:Relocated section Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:sentptr Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:sentptr->sectlen Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:sentptr->cache_cb Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:sentptr->cache_cb->cached_sectptr Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:sentptr->cache_cb->cached_sectptr->thread_list Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:real_size(1) Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:real_size(2) Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:thd_table Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:thd_table->size Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:real_size(3) Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:the_section Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:section ptr Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:section size Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:dynamic ptr Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:dynamic size Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:shared dynamic ptr Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:shared dynamic size Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:dynamic section header Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:offset in section Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:opcode Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:agg_mode Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:section1 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:dynamic buffer 2006-03-25-16.59.07.109000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 relation_data_serv sqlrr_dump_ffdc Probe:902 Database:MSCDB DIA3811C A locked file was encountered. ZRC=FFFFF60E 2006-03-25-16.59.07.234000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 relation_data_serv sqlrr_dump_ffdc Probe:902 Database:MSCDB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_AGENT_CB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_TRAN_CB Data Title:SQLD_AGENT_CB Pointer: PID:4576 TID:4380 Node:000 30c0 2c19 0À,. Data Title:SQLD_AGENT_CB PID:4576 TID:4380 Node:000 0000 0000 0000 0000 0000 0000 3881 2c19 ............8.,. 0000 0000 0080 0000 3000 6c19 0080 0000 ........0.l..... 3000 7019 0000 0000 0000 0000 0000 0000 0.p............. 0000 0000 0080 0000 3040 6a19 0010 0000 ........0@j..... 70ec 2c19 0000 0000 0000 0000 pì,......... Data Title:SQLD_TRAN_CB Pointer PID:4576 TID:4380 Node:000 b080 2c19 °.,. Data Title:SQLD_TRAN_CB PID:4576 TID:4380 Node:000 6000 6919 0000 0000 0000 0000 0000 0000 `.i............. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 b089 2c19 c08c 2c19 ........°,.À,. 0200 0000 0200 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0400 0000 409e e818 ............@è. 0200 0000 0000 0000 40cd 4819 0200 0000 ........@ÍH..... 0000 0000 d0e6 4819 0200 0000 0000 0000 ....ÐæH......... 4000 231a 0200 0000 0000 0000 0000 0000 @.#............. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 ........ String Title:>> Begin CURSOR dump: PID:4576 Node:000 OPEN PERM CURSORS: >> String Title:<< End CURSOR dump: PID:4576 Node:000 OPEN PERM CURSORS: << String Title:>> Begin CURSOR dump: PID:4576 Node:000 OPEN TEMP CURSORS: >> String Title:<< End CURSOR dump: PID:4576 Node:000 OPEN TEMP CURSORS: << String Title:>> Begin CURSOR dump: PID:4576 Node:000 CLOSED CURSORS: >> String Title:SQLD_CCB: PID:4576 Node:000 pool(TID)=0, obj(FID)=18, indexid(IID)=0, class=0 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_CCB String Title:SQLD_CCB: PID:4576 Node:000 pool(TID)=0, obj(FID)=3, indexid(IID)=0, class=0 Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLD_CCB String Title:<< End CURSOR dump: PID:4576 Node:000 CLOSED CURSORS: << Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLI_CB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLE_ACB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLP_ACB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLP_DBCB Dump File:C:\PROGRA~1\SQLLIB\DB2\45764380.000 Data:SQLP_TRTBL String Title:locklist PID:4576 Node:000 Check C:\PROGRA~1\SQLLIB\DB2\l00491.000 for additional data. 2006-03-25-16.59.11.203000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 relation_data_serv sqlrrdi Probe:120 Database:MSCDB 0ef6 ffff .öÿÿ Data Title:rc_flags: PID:4576 TID:4380 Node:000 4000 0004 @... 2006-03-25-16.59.11.531000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqleflsr Probe:1 Database:MSCDB DiagData 6001 0004 `... 2006-03-25-16.59.11.875000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqleflsr Probe:1 Database:MSCDB RIDS/sqleflsr MS/DB_BAD_FAT PRCS/16001 0004 `... 2006-03-25-16.59.12.093000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqleflsr Probe:2 Database:MSCDB DiagData 5351 4c43 4120 2020 8800 0000 7afc ffff SQLCA ....züÿÿ 0200 3134 2020 2020 2020 2020 2020 2020 ..14 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 7371 6c72 6969 7372 sqlriisr 0ef6 ffff 0e00 0000 0000 0000 0000 0000 .öÿÿ............ 0000 0000 0000 0000 2020 2020 2020 2020 ........ 2020 2020 2020 2020 2006-03-25-16.59.12.312000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqleflsr Probe:2 Database:MSCDB RIDS/sqleflsr MS/DB_BAD_FAT PRCS/25351 4c43 4120 2020 8800 0000 7afc ffff SQLCA ....züÿÿ 0200 3134 2020 2020 2020 2020 2020 2020 ..14 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 7371 6c72 6969 7372 sqlriisr 0ef6 ffff 0e00 0000 0000 0000 0000 0000 .öÿÿ............ 0000 0000 0000 0000 2020 2020 2020 2020 ........ 2020 2020 2020 2020 2006-03-25-16.59.12.734000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqlesrsp Probe:9 Database:MSCDB DiagData f6fb ffff öûÿÿ 2006-03-25-16.59.12.921000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqlesrsp Probe:9 Database:MSCDB RIDS/sqlesrsp MS/DB_BAD_FAT PRCS/9f6fb ffff öûÿÿ 2006-03-25-16.59.13.046000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldTermTransaction Probe:148 Database:MSCDB DMS Transaction Termination: insert TCB still fixed. a0b3 e818 1200 0000 0300 0000 1000 0000 ³è............. 0000 0000 0400 0000 0300 0000 0800 0000 ................ 1c11 0000 20ff 4819 0300 1000 0300 1000 .... ÿH......... 0000 0000 0000 0052 c281 0000 0000 0000 .......RÂ....... a003 0000 0000 0000 c003 0000 0200 0000 .......À....... 2700 0000 0000 0000 0080 0000 2000 0000 '........... ... 0200 0000 0300 1000 6cdb 0d1a 3058 111a ........lÛ..0X.. 0400 0e00 0300 1000 0100 0000 0004 5cb8 ..............\¸ 5d7f 0000 0000 0000 e002 0000 0000 0000 ].......à....... 0003 0000 0200 0000 2700 0000 0000 0000 ........'....... 0080 0000 2000 0000 0200 0000 0400 0e01 .... ........... 6cdb 0d1a 3058 111a 0300 0000 0300 1000 lÛ..0X.......... 0200 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0300 0002 6cdb 0d1a 3058 111a ........lÛ..0X.. 0300 0000 0300 1000 0300 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0200 0000 4700 0000 0000 0000 ........G....... 0080 0000 2000 0000 0200 0000 0300 0003 .... ........... 6cdb 0d1a 3058 111a 0300 0000 0300 1000 lÛ..0X.......... 0400 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0300 0004 6cdb 0d1a 3058 111a ........lÛ..0X.. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0100 0000 0000 0000 ................ 0000 0000 c39d 0100 4307 0200 0103 0000 ....Ã...C....... 0080 0000 a57f 0000 7f00 0000 ff00 0000 ....¥.......ÿ... 0a00 0000 0000 0000 0000 0000 0000 0000 ................ 2c00 0000 c0fe 4819 0000 0000 0000 0000 ,...ÀþH......... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 1004 231a 7fcd 0000 0000 0000 ......#..Í...... 0000 0000 0003 0000 0000 0000 5f33 0200 ............_3.. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 c409 0000 840f 0000 ........Ä ..,,... 6f00 0000 0000 0000 0000 0000 0000 0000 o............... 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0500 0000 8000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 ........ 2006-03-25-16.59.14.140000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldTermTransaction Probe:148 Database:MSCDB DMS Transaction Termination: insert TCB still fixed. 0000 0000 1100 0000 0300 0000 0f00 0000 ................ 0000 0000 0400 0000 0300 0000 0800 0000 ................ 1c11 0000 30eb 4819 0300 0f00 0300 0f00 ....0ëH......... 0000 0000 0000 0052 1786 0000 0000 0000 .......R....... 6003 0000 0000 0000 8003 0000 0200 0000 `............... 2700 0000 0000 0000 0080 0000 2000 0000 '........... ... 0200 0000 0300 0f00 6cdb 0d1a 3058 111a ........lÛ..0X.. 0400 0d00 0300 0f00 0100 0000 0002 a1f7 ..............¡÷ 194f 0000 0000 0000 a002 0000 0000 0000 .O...... ....... c002 0000 0200 0000 2700 0000 0000 0000 À.......'....... 0080 0000 2000 0000 0200 0000 0400 0d01 .... ........... 6cdb 0d1a 3058 111a 0300 0000 0300 0f00 lÛ..0X.......... 0200 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0300 0002 6cdb 0d1a 3058 111a ........lÛ..0X.. 0300 0000 0300 0f00 0300 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0200 0000 4700 0000 0000 0000 ........G....... 0080 0000 2000 0000 0200 0000 0300 0003 .... ........... 6cdb 0d1a 3058 111a 0300 0000 0300 0f00 lÛ..0X.......... 0400 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0300 0004 6cdb 0d1a 3058 111a ........lÛ..0X.. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0100 0000 0000 0000 ................ 0000 0000 ae31 0000 6e06 0200 c102 0000 ....®1..n...Á... 0080 0000 a57f 0000 7f00 0000 ff00 0000 ....¥.......ÿ... 0f00 0000 0000 0000 0000 0000 0000 0000 ................ 4400 0000 a0ea 4819 0000 0000 0000 0000 D... êH......... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 70eb 4819 791b 0000 0000 0000 ....pëH.y....... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 6c01 0000 0000 0000 0000 0000 0000 0000 l............... 0000 0000 0000 0000 c409 0000 2468 0000 ........Ä ..$h.. 5900 0000 0000 0000 0000 0000 0000 0000 Y............... 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0500 0000 5900 0000 0000 0000 0000 0000 ....Y........... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 ........ 2006-03-25-16.59.15.437000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldTermTransaction Probe:148 Database:MSCDB DMS Transaction Termination: insert TCB still fixed. 0000 0000 1300 0000 0300 0000 1100 0000 ................ 0000 0000 0400 0000 0500 0000 0800 0001 ................ 1c11 0000 90d5 4819 0300 1100 0300 1100 .....ÕH......... 0000 0000 0000 0053 5aa1 0000 0000 0000 .......SZ¡...... e003 0000 0000 0000 0004 0000 0200 0000 à............... 2700 0000 0000 0000 0080 0000 2000 0000 '........... ... 0200 0000 0300 1100 6cdb 0d1a 3058 111a ........lÛ..0X.. 0400 0f00 0300 1100 0100 0000 0000 0053 ...............S a50a 0000 0000 0000 2003 0000 0000 0000 ¥....... ....... 4003 0000 0200 0000 2700 0000 0000 0000 @.......'....... 0080 0000 2000 0000 0200 0000 0400 0f01 .... ........... 6cdb 0d1a 3058 111a 0500 0000 0300 1100 lÛ..0X.......... 0200 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0500 0002 6cdb 0d1a 3058 111a ........lÛ..0X.. 0500 0400 0300 1100 0300 0000 0000 0053 ...............S 5ecd 0000 0000 0000 6000 0000 0000 0000 ^Í......`....... 8000 0000 0200 0000 2700 0000 0000 0000 ........'....... 0080 0000 2000 0000 0200 0000 0500 0403 .... ........... 6cdb 0d1a 3058 111a 0500 0400 0300 1100 lÛ..0X.......... 0400 0000 0000 0053 5ecd 0000 0000 0000 .......S^Í...... a000 0000 0000 0000 c000 0000 0200 0000 .......À....... 2700 0000 0000 0000 0080 0000 2000 0000 '........... ... 0200 0000 0500 0404 6cdb 0d1a 3058 111a ........lÛ..0X.. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0100 0000 0000 0000 ................ 0000 0000 1f34 0000 df05 0200 4103 0000 .....4..ß...A... 0080 0000 a57f 0000 7f00 0000 ff00 0000 ....¥.......ÿ... 0400 0000 0000 0000 0100 0000 0000 0000 ................ 0f00 0000 10d1 4819 30d1 4819 0000 0000 .....ÑH.0ÑH..... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0000 0c00 0d00 1000 0200 0000 ................ 0004 0000 4400 0000 0008 0000 0004 0000 ....D........... 0000 0004 0020 0000 0020 0000 00e0 ffff ..... ... ...àÿÿ 8c0c 0000 0800 0000 0002 0000 0000 0000 ............... 0000 0000 6202 0000 0000 0000 0000 0000 ....b........... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 c0d5 4819 bc1e 0000 0000 0000 ....ÀÕH.¼....... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 4601 0000 0000 0000 0000 0000 0000 0000 F............... 0000 0000 0000 0000 c409 0000 6461 0000 ........Ä ..da.. 3600 0000 0000 0000 0000 0000 0000 0000 6............... 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0500 0000 8500 0000 0000 0000 0000 0000 .................. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 ........ 2006-03-25-16.59.16.875000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 data_management sqldTermTransaction Probe:148 Database:MSCDB DMS Transaction Termination: insert TCB still fixed. 0000 0000 1000 0000 0300 0000 0e00 0000 ................ 0000 0000 0400 0000 0300 0000 0800 0000 ................ 1c11 0000 60a6 e818 0300 0e00 0300 0e00 ....`¦è......... 0000 0000 0000 0051 befb 0000 0000 0000 .......Q¾û...... 2003 0000 0000 0000 4003 0000 0200 0000 .......@....... 2700 0000 0000 0000 0080 0000 2000 0000 '........... ... 0200 0000 0300 0e00 6cdb 0d1a 3058 111a ........lÛ..0X.. 0400 0c00 0300 0e00 0100 0000 0000 0052 ...............R 0c82 0000 0000 0000 6002 0000 0000 0000 .,......`....... 8002 0000 0200 0000 2700 0000 0000 0000 ........'....... 0080 0000 2000 0000 0200 0000 0400 0c01 .... ........... 6cdb 0d1a 3058 111a 0300 0000 0300 0e00 lÛ..0X.......... 0200 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0300 0002 6cdb 0d1a 3058 111a ........lÛ..0X.. 0300 0000 0300 0e00 0300 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0200 0000 4700 0000 0000 0000 ........G....... 0080 0000 2000 0000 0200 0000 0300 0003 .... ........... 6cdb 0d1a 3058 111a 0300 0000 0300 0e00 lÛ..0X.......... 0400 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0200 0000 ................ 4700 0000 0000 0000 0080 0000 2000 0000 G........... ... 0200 0000 0300 0004 6cdb 0d1a 3058 111a ........lÛ..0X.. 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0100 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0100 0000 0000 0000 ................ 0000 0000 7f00 0000 df9e 0100 8102 0000 ........ß...... 0080 0000 a57f 0000 7f00 0000 ff00 0000 ....¥.......ÿ... 0800 0000 0000 0000 0000 0000 0000 0000 ................ 2100 0000 10a2 e818 0000 0000 0000 0000 !....¢è......... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 90a6 e818 4e00 0000 0000 0000 .....¦è.N....... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0100 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 7a00 0000 da9e 0100 ........z...Ú.. 3c41 0000 0000 0000 0100 0000 0100 0000 <A.............. 0000 0000 0000 0000 ffff ffff 0000 0000 ........ÿÿÿÿ.... 0500 0000 5900 0000 0000 0000 0000 0000 ....Y........... 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 0000 0000 0000 0000 ................ 0000 0000 0000 0000 ........ 2006-03-25-16.59.18.265000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 buffer_pool_services sqlbTerminateAgent Probe:837 Database:MSCDB DIA3727C The database has been marked as being damaged. ZRC=FFFFE11A 2006-03-25-16.59.18.375000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325085810 base_sys_utilities sqleTermDbConnect Probe:5 Database:MSCDB DIA3727C The database has been marked as being damaged. ZRC=FFFFE11A 2006-03-25-17.00.14.171000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325074615 base_sys_utilities sqledint Probe:0 Database:MSCDB Crash Recovery is needed. 2006-03-25-17.00.14.390000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325074615 recovery_manager sqlpresr Probe:1 Database:MSCDB DIA3908W Crash recovery has been initiated. Lowtran LSN is "00045E58E00C", Minbuff LSN is "00045E58E00C". 2006-03-25-17.00.14.515000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325074615 recovery_manager sqlprecm Probe:400 Database:MSCDB DIA3916W Forward phase of crash recovery has completed. Next LSN is "00045E5CD794". 2006-03-25-17.00.27.343000 Instance:DB2 Node:000 PID:4576(db2syscs.exe) TID:4380 Appid:*LOCAL.DB2.060325074615 recovery_manager sqlpresr Probe:170 Database:MSCDB DIA3909W Crash recovery completed. Next LSN is "00045E5FC754". ================================================== > Greetings, > [quoted text clipped - 23 lines] > DB state is Normal. the TableSpace state also Normal. I am using DMS > over here and i had created 3 tablespace to serve 3 different purpose. You might want to consider moving to V8, given that V7 is out of service for over a year now. And I'd have serious doubts if the problem would be fixed in DB2 (if it is a problem in DB2).  SignatureKnut Stolze DB2 Information Integration Development IBM Germany > And I'd have serious doubts if the problem would be > fixed in DB2 (if it is a problem in DB2). ... in V7. SignatureKnut Stolze DB2 Information Integration Development IBM Germany Thanks for the reply. Is there any alternative? Cause the cost to move to V8 is kinda expensive. > Thanks for the reply. > > Is there any alternative? Cause the cost to move to V8 is kinda > expensive. If you could post the code you're using and the complete error message, we might get some clues here. Also, the content of the db2diag.log would be interesting along with a CLI trace (assuming that VB uses CLI under the covers). p.s: The DB2 Express C edition is for free if the license terms apply to you. SignatureKnut Stolze DB2 Information Integration Development IBM Germany |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.