By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,939 Members | 1,600 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,939 IT Pros & Developers. It's quick & easy.

DB2 Error Codes

P: n/a
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
Share this Question
Share on Google+
6 Replies


P: n/a
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

P: n/a

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

P: n/a

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

P: n/a
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

P: n/a

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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.