If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > internal error code

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-18-04, 09:03
redwolf redwolf is offline
Registered User
 
Join Date: Apr 2004
Posts: 179
internal error code

Can someone tell me what this internal error code [ FFFFB06E ] means. I can't find this one in the db2 manuals. I got this during a database backup.
Reply With Quote
  #2 (permalink)  
Old 06-18-04, 16:31
redwolf redwolf is offline
Registered User
 
Join Date: Apr 2004
Posts: 179
Addition Info

Here is part of the db2diag.log during the backup.

insert into APILIB.RSBADDR (BACONO,BAACCT,BAUDAT,BABAD1,BABAD2,BABCTY,BABSTA, BABZIP,BACNTN,BAPHON,BAUSER) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)ffff ÿÿ


2004-06-17-09.53.03.067432 Instance:db2fudd Node:000
PID:69532(perl) Appid:
call_level_interface CLI_sdaInitSqldaParm Probe:3

pcbValue = 0000 0000 ....


2004-06-17-09.53.03.192761 Instance:db2fudd Node:000
PID:69532(perl) Appid:
call_level_interface CLI_sdaInitSqldaParm Probe:4

hStmt = 0001 0001 ....


2004-06-17-09.53.03.317422 Instance:db2fudd Node:000
PID:69532(perl) Appid:
call_level_interface CLI_sdaInitSqldaParm Probe:4

pSqlda =
5351 4c44 4120 3220 0000 03d8 0016 000b SQLDA 2 ...Ø....
01e1 0008 203b 1a28 203b 19f8 0000 0000 .á.. ;.( ;.ø....
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 ....


2004-06-17-09.53.04.238976 Instance:db2fudd Node:000
PID:69532(perl) Appid:
call_level_interface CLI_sdaInitSqldaParm Probe:5


iTemp = 8 cbTemp = 14906 iSQLLen = 8 cbData = 8

iTempA = -99999; iTempB = -99999 fNewBoundParm = 1

ffff ÿÿ


2004-06-17-09.53.04.368247 Instance:db2fudd Node:000
PID:69532(perl) Appid:
call_level_interface CLI_sdaInitSqldaParm Probe:6

pRecAPD :
sConciseType=1 ; sIndex=1 ; uiLength = 0
iOctetLength=0 ; sPrecision=0 ; sScale = 0
sType=99 ; sSQLInd=0 ; uiFlag = 64
uiActualLength=0 ; fSQLType=99
ffff ÿÿ


2004-06-17-09.53.04.501612 Instance:db2fudd Node:000
PID:69532(perl) Appid:
call_level_interface CLI_sdaInitSqldaParm Probe:7

pRecIPD :
sConciseType=8 ; sIndex=1 ; uiLength = 0
iOctetLength=0 ; sPrecision=15 ; sScale = 0
sType=480 ; sSQLInd=0 ; uiFlag = 1
uiActualLength=0 ; fSQLType=99
ffff ÿÿ


2004-06-17-23.54.46.979288 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
oper_system_services sqloReadBlocks Probe:37

0000 006e ...n


2004-06-17-23.54.47.144566 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
oper_system_services sqloReadBlocks Probe:36

errno: 0000 006e ...n


2004-06-17-23.54.47.284427 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
oper_system_services sqloReadBlocks Probe:11

READ ERROR0000 0009 ....


2004-06-17-23.54.47.469055 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:790

DiagData
2ff2 17b4 0002 000d 0000 00dd 004e 1800 /............N..
0000 0080 0000 0000 0000 0001 0000 0000 ................
93f9 7200 2003 26d8 ..r. .&.


2004-06-17-23.54.47.710320 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:860
DIA9999E An internal error occurred. Report the following error code :
"FFFFB06E".

2004-06-17-23.54.47.760018 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
buffer_pool_services sqlbDMSDirectRead Probe:860

Obj={pool:15;obj:0;type:15} State=x0 Parent={0;0}, EM=0, PP0=0 Page=5117952 Cont=0 Offset=639745 BlkSize=12

Data TitleQLB_OBJECT_DESC PID:45046 Node:000
000f 0000 0000 0000 0f00 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0002 0000 0000 0000 0000 ................
0000 1000 0000 0100 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........


2004-06-17-23.54.48.035227 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
buffer_pool_services sqlbDirectRead Probe:820
DIA9999E An internal error occurred. Report the following error code :
"FFFFB06E".

2004-06-17-23.54.48.059943 Instance:db2fudd Node:000
PID:45046(db2pfchr) Appid:none
buffer_pool_services sqlbDirectRead Probe:820

Obj={pool:15;obj:0;type:15} State=x0 Parent={0;0}, EM=0, PP0=0

Data TitleQLB_OBJECT_DESC PID:45046 Node:000
000f 0000 0000 0000 0f00 0000 0000 0000 ................
0000 0000 0000 0000 0000 0000 0000 0000 ................
0000 0000 0000 0002 0000 0000 0000 0000 ................
0000 1000 0000 0100 0000 0000 0000 0000 ................
0000 0000 0000 0000 ........


2004-06-17-23.54.48.353281 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:9

DiagData
0051 2900 .Q).


2004-06-17-23.54.48.476861 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:10

DiagData
004e 18dc .N..


2004-06-17-23.54.48.602092 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:11

DiagData
000f ..


2004-06-17-23.54.48.760719 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:12

DiagData
0000 00ff ....


2004-06-17-23.54.48.885426 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:13

DiagData
004e 17de .N..


2004-06-17-23.54.49.010699 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:8

DiagData
ffff b06e ...n


2004-06-17-23.54.49.144030 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:8

DiagData
ffff fc7a ...z


2004-06-17-23.54.49.269262 Instance:db2fudd Node:000
PID:123696(db2bm.120166.0) Appid:none
database_utilities sqlubreaddms Probe:2208

ffff fc7a ...z


2004-06-17-23.56.09.123450 Instance:db2fudd Node:000
PID:120166(db2agent (RECORDS)) Appid:*LOCAL.db2fudd.040618000003
database_utilities sqlubcka Probe:0 Database:RECORDS

Backup terminated.
Reply With Quote
  #3 (permalink)  
Old 06-18-04, 18:44
bmujeeb bmujeeb is offline
Registered User
 
Join Date: Mar 2004
Posts: 448
FFFFB06E convert it from hexadecimal to decimal to get the
SQLCODE.
Note that this number does not always convert to a valid SQLCODE. If this is the case, you should contact DB2 Support.

regards,

mujeeb
Reply With Quote
  #4 (permalink)  
Old 06-21-04, 04:43
brat4 brat4 is offline
Registered User
 
Join Date: Apr 2003
Location: Singapore
Posts: 59
My apologies, the sql error B06E code is not available in the following link, but it is a good link for some other problem if any.

alternatively u can check this site for the last four digits of ur code

http://www-306.ibm.com/cgi-bin/db2ww...fn=db2p079.htm

hth
brat

Last edited by brat4; 06-21-04 at 04:47. Reason: update info
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On