Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Error code ZRC=0x8031006D.

82 views
Skip to first unread message

Marcos Paulo Serafim

unread,
May 3, 2004, 9:08:46 AM5/3/04
to
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

unread,
May 3, 2004, 2:18:48 PM5/3/04
to
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

unread,
May 3, 2004, 3:27:31 PM5/3/04
to
ZRC's are listed here:
http://www-306.ibm.com/software/data/db2/udb/winos2unix/support/techatt/returncodes.pdf

If you can turn your machine sideways.

@cgocable.ca PM (pm3iinc-nospam) CGO

unread,
May 3, 2004, 10:33:53 PM5/3/04
to
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

unread,
May 4, 2004, 6:53:47 AM5/4/04
to
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 <sri...@ca.eye-be-em.com> wrote in message news:<c762ef$p6t$1...@hanover.torolab.ibm.com>...

Marcos Paulo Serafim

unread,
May 4, 2004, 6:54:47 AM5/4/04
to
Thanks!

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

Marcos Paulo Serafim
Orlandia - SP - Brazil


Blair Adamache <bada...@2muchspam.yahoo.com> wrote in message news:<c766c8$pja$1...@hanover.torolab.ibm.com>...

Serge Rielau

unread,
May 4, 2004, 7:59:24 AM5/4/04
to
DB2 Development internal.. Don't worry about that.

Blair Adamache

unread,
May 4, 2004, 9:55:59 AM5/4/04
to
Sorry PM - command line guys don't touch icons.

Jan M. Nelken

unread,
May 4, 2004, 12:57:21 PM5/4/04
to
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

unread,
May 4, 2004, 2:43:10 PM5/4/04
to
Ok!

Thanks again!

Marcos Paulo Serafim
Orlandia - SP - Brazil


Serge Rielau <sri...@ca.eye-be-em.com> wrote in message news:<c780j1$3qe$1...@hanover.torolab.ibm.com>...

0 new messages