Error code ZRC=0x8031006D.

[Marcos Paulo Serafim]

Hello,

We have a DB2 8.1.0 running on AIX 5.1 and the database is logging too many
lock escalations.
Changing the DIAGLEVEL to see what's happening, the following messages begin
to show in db2diag.log:

-------------------------------------------------------------
2004-05-01-13.23.52.990570 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:103

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBUF" = "65536" is "accepted".

2004-05-01-13.23.53.027426 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:108

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBUF" = "65536" is "accepted".

2004-05-01-13.23.53.063290 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:117

DIA3219I Client connecting from IP address = "10.10.10.1", port = "2627".

2004-05-01-13.23.53.109511 Instance:db2 Node:000
PID:1310860(db2agent (DATABASE)) TID:1 Appid:GA0A0A01.K30A.00E581162516
access plan manager sqlra_compile_var Probe:20 Database:DATABASE

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

PID:1310860 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1415 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLNQ720?
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:1310860 TID:1 Node:000 Title: stmt
5345 5420 4355 5252 454e 5420 4c4f 4341 SET CURRENT LOCA
4c45 204c 435f 4354 5950 4520 3d20 2765 LE LC_CTYPE = 'e
6e5f 5553 27 n_US'
---------------------------------------------------------------

What could be the error code "ZRC=0x8031006D"???

Thanks in advance.

Marcos Paulo Serafim
Orlandia - SP - Brazil

[Serge Rielau]

Marcos,

When you connect through e.g. CLP a few statemenst are executed
automatically.
One of them being the SET LOCALE statement you see in the db2diag.log.
It seems like it was trying to set en_US as a locale, but that's not
available (on the server?).
So SET LOCALE got cranky.
Did you get an error back from CLP?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Serge Rielau]

Marcos,

When you connect through e.g. CLP a few statemenst are executed
automatically.
One of them being the SET LOCALE statement you see in the db2diag.log.
It seems like it was trying to set en_US as a locale, but that's not
available (on the server?).
So SET LOCALE got cranky.
Did you get an error back from CLP?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Blair Adamache]

ZRC's are listed here:
http://www-306.ibm.com/software/data...eturncodes.pdf

If you can turn your machine sideways.

Marcos Paulo Serafim wrote:

Hello,

We have a DB2 8.1.0 running on AIX 5.1 and the database is logging too many
lock escalations.
Changing the DIAGLEVEL to see what's happening, the following messages begin
to show in db2diag.log:

-------------------------------------------------------------
2004-05-01-13.23.52.990570 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:103

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBUF" = "65536" is "accepted".

2004-05-01-13.23.53.027426 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:108

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBUF" = "65536" is "accepted".

2004-05-01-13.23.53.063290 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:117

DIA3219I Client connecting from IP address = "10.10.10.1", port = "2627".

2004-05-01-13.23.53.109511 Instance:db2 Node:000
PID:1310860(db2agent (DATABASE)) TID:1 Appid:GA0A0A01.K30A.00E581162516
access plan manager sqlra_compile_var Probe:20 Database:DATABASE

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

PID:1310860 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1415 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLNQ720?
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:1310860 TID:1 Node:000 Title: stmt
5345 5420 4355 5252 454e 5420 4c4f 4341 SET CURRENT LOCA
4c45 204c 435f 4354 5950 4520 3d20 2765 LE LC_CTYPE = 'e
6e5f 5553 27 n_US'
---------------------------------------------------------------

What could be the error code "ZRC=0x8031006D"???

Thanks in advance.

Marcos Paulo Serafim
Orlandia - SP - Brazil

[Blair Adamache]

ZRC's are listed here:
http://www-306.ibm.com/software/data...eturncodes.pdf

If you can turn your machine sideways.

Marcos Paulo Serafim wrote:

Hello,

We have a DB2 8.1.0 running on AIX 5.1 and the database is logging too many
lock escalations.
Changing the DIAGLEVEL to see what's happening, the following messages begin
to show in db2diag.log:

-------------------------------------------------------------
2004-05-01-13.23.52.990570 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:103

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SOSNDBUF" = "65536" is "accepted".

2004-05-01-13.23.53.027426 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:108

DIA3421W "TCPIP" protocol support: Environment Variable value
"DB2SORCVBUF" = "65536" is "accepted".

2004-05-01-13.23.53.063290 Instance:db2 Node:000
PID:852190(db2tcpcm) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:117

DIA3219I Client connecting from IP address = "10.10.10.1", port = "2627".

2004-05-01-13.23.53.109511 Instance:db2 Node:000
PID:1310860(db2agent (DATABASE)) TID:1 Appid:GA0A0A01.K30A.00E581162516
access plan manager sqlra_compile_var Probe:20 Database:DATABASE

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

PID:1310860 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1415 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLNQ720?
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:1310860 TID:1 Node:000 Title: stmt
5345 5420 4355 5252 454e 5420 4c4f 4341 SET CURRENT LOCA
4c45 204c 435f 4354 5950 4520 3d20 2765 LE LC_CTYPE = 'e
6e5f 5553 27 n_US'
---------------------------------------------------------------

What could be the error code "ZRC=0x8031006D"???

Thanks in advance.

Marcos Paulo Serafim
Orlandia - SP - Brazil

[PM \(pm3iinc-nospam\) CGO]

I don't want to say that my solution is better but
acrobat reader has an icon that does Rotate View Clockwise.

;-)

PM

[PM \(pm3iinc-nospam\) CGO]

I don't want to say that my solution is better but
acrobat reader has an icon that does Rotate View Clockwise.

;-)

PM

[Marcos Paulo Serafim]

Hello Serge,

Thanks for reply.

No, the CPL returns with success (the messages change, look below) and
every statement we run also terminate ok.

-----------------------
2004-05-01-12.55.40.907231 Instance:db2 Node:000
PID:2318342(db2agent (DATABASE)) TID:1
Appid:*LOCAL.db2.0C0A71150209
access plan manager sqlra_compile_var Probe:20 Database:DATABASE

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

PID:2318342 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1415 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLNQ719€
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:2318342 TID:1 Node:000 Title: stmt
5345 5420 5155 4552 5920 5041 5452 4f4c SET QUERY PATROL
4c45 5220 4259 5041 5353 203d 2027 5452 LER BYPASS = 'TR
5545 27 UE'
-----------------------

Any suggestion?
Marcos Paulo Serafim
Orlandia - SP - Brazil
Serge Rielau <sr*****@ca.eye-be-em.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>...

Marcos,

When you connect through e.g. CLP a few statemenst are executed
automatically.
One of them being the SET LOCALE statement you see in the db2diag.log.
It seems like it was trying to set en_US as a locale, but that's not
available (on the server?).
So SET LOCALE got cranky.
Did you get an error back from CLP?

Cheers
Serge

[Marcos Paulo Serafim]

Hello Serge,

Thanks for reply.

No, the CPL returns with success (the messages change, look below) and
every statement we run also terminate ok.

-----------------------
2004-05-01-12.55.40.907231 Instance:db2 Node:000
PID:2318342(db2agent (DATABASE)) TID:1
Appid:*LOCAL.db2.0C0A71150209
access plan manager sqlra_compile_var Probe:20 Database:DATABASE

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

PID:2318342 TID:1 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -1415 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLNQ719€
sqlerrd : (1) 0x8012007E (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF9C (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate:
PID:2318342 TID:1 Node:000 Title: stmt
5345 5420 5155 4552 5920 5041 5452 4f4c SET QUERY PATROL
4c45 5220 4259 5041 5353 203d 2027 5452 LER BYPASS = 'TR
5545 27 UE'
-----------------------

Any suggestion?
Marcos Paulo Serafim
Orlandia - SP - Brazil
Serge Rielau <sr*****@ca.eye-be-em.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>...

Marcos,

When you connect through e.g. CLP a few statemenst are executed
automatically.
One of them being the SET LOCALE statement you see in the db2diag.log.
It seems like it was trying to set en_US as a locale, but that's not
available (on the server?).
So SET LOCALE got cranky.
Did you get an error back from CLP?

Cheers
Serge

[Marcos Paulo Serafim]

Thanks!

....
"SQLCA has already been built" ???
....

Marcos Paulo Serafim
Orlandia - SP - Brazil
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>...

ZRC's are listed here:
http://www-306.ibm.com/software/data...eturncodes.pdf

If you can turn your machine sideways.

[Marcos Paulo Serafim]

Thanks!

....
"SQLCA has already been built" ???
....

Marcos Paulo Serafim
Orlandia - SP - Brazil
Blair Adamache <ba*******@2muchspam.yahoo.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>...

ZRC's are listed here:
http://www-306.ibm.com/software/data...eturncodes.pdf

If you can turn your machine sideways.

[Serge Rielau]

DB2 Development internal.. Don't worry about that.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Serge Rielau]

DB2 Development internal.. Don't worry about that.
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Blair Adamache]

Sorry PM - command line guys don't touch icons.

PM (pm3iinc-nospam) CGO wrote:

I don't want to say that my solution is better but
acrobat reader has an icon that does Rotate View Clockwise.

;-)

PM

[Blair Adamache]

Sorry PM - command line guys don't touch icons.

PM (pm3iinc-nospam) CGO wrote:

I don't want to say that my solution is better but
acrobat reader has an icon that does Rotate View Clockwise.

;-)

PM

[Jan M. Nelken]

PM (pm3iinc-nospam) CGO wrote:

I don't want to say that my solution is better but
acrobat reader has an icon that does Rotate View Clockwise.

Considering orientation of the document I can probably improve
performance of your rotation by at least 300%:

Click ONCE on Rotate View Counter Clockwise (one click, 90 degrees
rotation);
vs
Click THREE times on Rotate View Clockwise (three clicks, 270 degrees
rotation).

Jan M. Nelken

[Jan M. Nelken]

PM (pm3iinc-nospam) CGO wrote:

I don't want to say that my solution is better but
acrobat reader has an icon that does Rotate View Clockwise.

Considering orientation of the document I can probably improve
performance of your rotation by at least 300%:

Click ONCE on Rotate View Counter Clockwise (one click, 90 degrees
rotation);
vs
Click THREE times on Rotate View Clockwise (three clicks, 270 degrees
rotation).

Jan M. Nelken

[Marcos Paulo Serafim]

Ok!

Thanks again!

Marcos Paulo Serafim
Orlandia - SP - Brazil
Serge Rielau <sr*****@ca.eye-be-em.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>...

DB2 Development internal.. Don't worry about that.

[Marcos Paulo Serafim]

Ok!

Thanks again!

Marcos Paulo Serafim
Orlandia - SP - Brazil
Serge Rielau <sr*****@ca.eye-be-em.com> wrote in message news:<c7**********@hanover.torolab.ibm.com>...

DB2 Development internal.. Don't worry about that.