473,378 Members | 1,037 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,378 software developers and data experts.

DB2 Error Codes

Hi All:
I am using db2 udb 8.1 fixpack 3 on AIX 5

I am recieving ht e following message in my DIAGLOG :::

================================================== ============
2007-01-04-03.28.09.457980 Instance:db2inst1 Node:000
PID:1974324(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:20

errno:
0x2FF1BED0 : 0x00000011 ....

PID:1974324 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-01-04-03.28.09.622262 Instance:db2inst1 Node:000
PID:2179200(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:911
================================================== ==============
Can anyone plz help me on this .
I would also like to know how to find out the meaning of the hex values
for the internal error codes

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81360012".
and also any message refrences for them.

Regards,
Racerx

Jan 4 '07 #1
6 13488
Racerx wrote:
Hi All:
I am using db2 udb 8.1 fixpack 3 on AIX 5

I am recieving ht e following message in my DIAGLOG :::

================================================== ============
2007-01-04-03.28.09.457980 Instance:db2inst1 Node:000
PID:1974324(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:20

errno:
0x2FF1BED0 : 0x00000011 ....
errno is an operating system thing. You can have a look
at /usr/include/errno.h to find the meanings. 11 = EAGAIN = "Resource
temporarily unavailable"
PID:1974324 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-01-04-03.28.09.622262 Instance:db2inst1 Node:000
PID:2179200(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:911
================================================== ==============
Can anyone plz help me on this .
I would also like to know how to find out the meaning of the hex values
for the internal error codes

DIA0001E An internal error occurred. Report the following error code :
"ZRC=0x81360012".
Use the "db2diag" tool:

$ db2diag -rc 0x81360012

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 4 '07 #2

Knut Stolze wrote:
Racerx wrote:
Hi All:
I am using db2 udb 8.1 fixpack 3 on AIX 5

I am recieving ht e following message in my DIAGLOG :::

================================================== ============
2007-01-04-03.28.09.457980 Instance:db2inst1 Node:000
PID:1974324(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:20

errno:
0x2FF1BED0 : 0x00000011 ....

errno is an operating system thing. You can have a look
at /usr/include/errno.h to find the meanings. 11 = EAGAIN = "Resource
temporarily unavailable"
PID:1974324 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-01-04-03.28.09.622262 Instance:db2inst1 Node:000
PID:2179200(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:911
================================================== ============== Can anyone plz help me on this .
I would also like to know how to find out the meaning of the hex values
for the internal error codes

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

Use the "db2diag" tool:

$ db2diag -rc 0x81360012

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

I tried using the db2diag tool but it gives me an error that
"ksh: db2diag : not found."
how should i go about this now?

Jan 5 '07 #3

I tried using the "db2diag" tool:

$ db2diag -rc 0x81360012
but it gives the following error

ksh : db2diag : not found.

How should i go about this ?

Jan 5 '07 #4
Racerx wrote:
>
Knut Stolze wrote:
>Racerx wrote:
Hi All:
I am using db2 udb 8.1 fixpack 3 on AIX 5

I am recieving ht e following message in my DIAGLOG :::

================================================== ============
2007-01-04-03.28.09.457980 Instance:db2inst1 Node:000
PID:1974324(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:20

errno:
0x2FF1BED0 : 0x00000011 ....

errno is an operating system thing. You can have a look
at /usr/include/errno.h to find the meanings. 11 = EAGAIN = "Resource
temporarily unavailable"
PID:1974324 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-01-04-03.28.09.622262 Instance:db2inst1 Node:000
PID:2179200(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:911
================================================== ============== Can
anyone plz help me on this . I would also like to know how to find out
the meaning of the hex values for the internal error codes

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

Use the "db2diag" tool:

$ db2diag -rc 0x81360012


I tried using the db2diag tool but it gives me an error that
"ksh: db2diag : not found."
how should i go about this now?
Oh, I believe that db2diag was introduced in V8.2 = FP7. You may want to
upgrade to a more recent FixPak, especially because this might also take
care of your original problem.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 5 '07 #5

Knut Stolze wrote:
Racerx wrote:
Hi All:
I am using db2 udb 8.1 fixpack 3 on AIX 5

I am recieving ht e following message in my DIAGLOG :::

================================================== ============
2007-01-04-03.28.09.457980 Instance:db2inst1 Node:000
PID:1974324(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:20

errno:
0x2FF1BED0 : 0x00000011 ....

errno is an operating system thing. You can have a look
at /usr/include/errno.h to find the meanings. 11 = EAGAIN = "Resource
temporarily unavailable"
PID:1974324 TID:1 Node:000 Title: Path/Filename
/home/db2inst1/sqllib/spmlog/SPMLOG.LCF

2007-01-04-03.28.09.622262 Instance:db2inst1 Node:000
PID:2179200(db2star2) TID:1 Appid:none
base sys utilities startdbm Probe:911
================================================== ==============
Can anyone plz help me on this .
I would also like to know how to find out the meaning of the hex values
for the internal error codes

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

Use the "db2diag" tool:

$ db2diag -rc 0x81360012

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Hello,

Just a little clarification....

errno 0x11 == errno 17 == EEXIST on AIX

EEXIST: The O_CREAT and O_EXCL flags are set and the named file exists.

I think that this particular error is benign - if it's not causing any
other problems, you can likely just ignore it.

Cheers,
Liam.

Jan 5 '07 #6
Liam Finnie wrote:
>
Knut Stolze wrote:
>Racerx wrote:
Hi All:
I am using db2 udb 8.1 fixpack 3 on AIX 5

I am recieving ht e following message in my DIAGLOG :::

================================================== ============
2007-01-04-03.28.09.457980 Instance:db2inst1 Node:000
PID:1974324(db2spmrsy 0) TID:1 Appid:none
oper system services sqloopenp Probe:20

errno:
0x2FF1BED0 : 0x00000011 ....

errno is an operating system thing. You can have a look
at /usr/include/errno.h to find the meanings. 11 = EAGAIN = "Resource
temporarily unavailable"
Just a little clarification....

errno 0x11 == errno 17 == EEXIST on AIX

EEXIST: The O_CREAT and O_EXCL flags are set and the named file exists.
Thanks for the correction, Liam. I mixed up decimal and hexadecimal
systems...

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Jan 7 '07 #7

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

Similar topics

8
by: Shane Groff | last post by:
I know this is a recurring discussion (I've spent the last 3 days reading through threads on the topic), but I feel compelled to start it up again. After reading through the existing threads, I...
2
by: Gregory | last post by:
Hi, One of the disadvantages of using error handling with error codes instead of exception handling is that error codes retuned from a function can be forgotten to check thus leading to...
2
by: MLH | last post by:
I cut a mail function off the m'soft site. Has always worked. However, I would like to include error codes returned by the sendmail Fn and be able to understand what they mean. I had my first...
7
by: Spacen Jasset | last post by:
The main two desirable things I feel error handling should provide are these: 1) Debugging and diagnostic aid 2) User feedback One method that is used a fair amount it to 'say' that all...
0
by: HKSHK | last post by:
This list compares the error codes used in VB.NET 2003 with those used in VB6. Error Codes: ============ 3: This Error number is obsolete and no longer used. (Formerly: Return without GoSub)...
8
by: PW | last post by:
Hi, There is code in Alison Balter's excellant "Mastering Access 2003" to create a list of error codes and descriptions but it only generates error messages 3 through 94. Is there a website...
13
by: mike3 | last post by:
Hi. (crossposted because the program is in C++ and some C++-related elements are discussed, hence comp.lang.c++, plus general program design questions are asked, hence comp.programming.) I'm...
2
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
5
by: =?GB2312?B?17/HvyBaaHVvLCBRaWFuZw==?= | last post by:
Hi, I would like to have someone comments on what's the best practice defining error codes in C. Here's what I think: solution A: using enum pros: type safe. better for debug (some debugger...
0
hyperpau
by: hyperpau | last post by:
Before anything else, I am not a very technical expert when it comes to VBA coding. I learned most of what I know by the excellent Access/VBA forum from bytes.com (formerly thescripts.com). Ergo, I...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
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
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.