473,386 Members | 1,699 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

SQL0902C - 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".

==================================================

Apr 6 '06 #1
4 14756
ja********@gmail.com wrote:
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.


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).

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 6 '06 #2
Knut Stolze wrote:
And I'd have serious doubts if the problem would be
fixed in DB2 (if it is a problem in DB2).


.... in V7.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 6 '06 #3
Thanks for the reply.

Is there any alternative? Cause the cost to move to V8 is kinda
expensive.

Apr 7 '06 #4
Jason KS wrote:
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.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 7 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Larry Menard | last post by:
Test code: $dbconn = odbc_connect($dbname, $username, $password); $path = "C:\Temp\myJar.jar"; $statement = "CALL SQLJ.INSTALL_JAR('file://$path', 'myJarId')"; $result = odbc_exec($dbconn,...
3
by: Jurgen Haan | last post by:
Hi hi. I'd like to gain some knowledge on packages. We're getting an error "SQL0805N Package "NULLID.SYSLH214 0X5359534C564C3031" was not found. SQLSTATE=51002" On our production database....
1
by: Rudolf Bargholz | last post by:
Hi, We have created triggers to log modifications to tables in our application. The triggers work fine, just on one of the tables in our database the triggers fail with the error message...
0
by: HARVEER | last post by:
Hi, My procedure compiles perfectly, but sometimes when I execute it. I receive following error: DB2 Database Error: ERROR SQL0901N The SQL statement failed because of a non-severe system...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.