错误代码ZRC = 0x8031006D。 [英] Error code ZRC=0x8031006D.
问题描述
你好,
我们在AIX 5.1上运行了一个DB2 8.1.0,并且数据库记录了太多
锁定升级。
更改DIAGLEVEL以查看发生了什么,以下消息开始
显示在db2diag.log中:
---- -------------------------------------------------- -------
2004-05-01-13.23.52.990570实例:db2节点:000
PID:852190(db2tcpcm)TID:1 Appid:none
常见通信sqlcctcpconnmgr_child探测:103
DIA3421WTCPIP协议支持:环境变量值
" DB2SOSNDBUF" =" 65536"是接受。
2004-05-01-13.23.53.027426实例:db2节点:000
PID:852190(db2tcpcm)TID:1 Appid:none
常见通信sqlcctcpconnmgr_child探测:108
DIA3421WTCPIP协议支持:环境变量值
" DB2SORCVBUF" =" 65536"是接受。
2004-05-01-13.23.53.063290实例:db2节点:000
PID:852190(db2tcpcm)TID:1 Appid:none
常用通信sqlcctcpconnmgr_child探测:117
DIA3219I客户端从IP地址=10.10.10.1,端口=" 2627"连接。
2004-05-01-13.23.53.109511实例:db2节点:000
PID:1310860(db2agent(DATABASE))TID:1 Appid: GA0A0A01.K30A.00E581162516
访问计划经理sqlra_compile_var探测:20数据库:数据库
DIA0001E发生内部错误。报告以下错误代码:
" ZRC = 0x8031006D"。
PID:1310860 TID:1节点:000标题: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节点:000标题: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''
-------------------------- -------------------------------------
什么可能是错误代码ZRC = 0x8031006D???
谢谢你dvance。
Marcos Paulo Serafim
Orlandia - SP - 巴西
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
推荐答案
Marcos,
当您通过例如连接时CLP几个州政府自动执行
。
其中一个是您在db2diag.log中看到的SET LOCALE语句。
似乎就像它试图将en_US设置为区域设置一样,但是那不是可用的(在服务器上?)。
所以SET LOCALE变得暴躁。
您是否从CLP收到错误?
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
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
Marcos,
当您通过例如连接时CLP几个州政府自动执行
。
其中一个是您在db2diag.log中看到的SET LOCALE语句。
似乎就像它试图将en_US设置为区域设置一样,但是那不是可用的(在服务器上?)。
所以SET LOCALE变得暴躁。
您是否从CLP收到错误?
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
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
ZRC'列出这里:
http://www-306.ibm.com/software/data...eturncodes.pdf
如果你可以侧翻机器。
Marcos Paulo Serafim写道:
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:
您好,
我们在AIX 5.1上运行了DB2 8.1.0并且数据库记录太多
锁升级tions。
更改DIAGLEVEL以查看发生了什么,以下消息开始在db2diag.log中显示:
---------- -------------------------------------------------- -
2004-05-01-13.23.52.990570实例:db2节点:000
PID:852190(db2tcpcm)TID:1 Appid:none
常用通信sqlcctcpconnmgr_child探测:103
DIA3421WTCPIP协议支持:环境变量值
DB2SOSNDBUF =" 65536"是接受。
2004-05-01-13.23.53.027426实例:db2节点:000
PID:852190(db2tcpcm)TID:1 Appid:none
common通信sqlcctcpconnmgr_child探测:108
DIA3421WTCPIP协议支持:环境变量值
DB2SORCVBUF =" 65536"是接受。
2004-05-01-13.23.53.063290实例:db2节点:000
PID:852190(db2tcpcm)TID:1 Appid:none
common通信sqlcctcpconnmgr_child探测:117
DIA3219I客户端连接IP地址=" 10.10.10.1",port =" 2627"。
2004-05-01-13.23 .53.109511实例:db2节点:000
PID:1310860(db2agent(DATABASE))TID:1 Appid:GA0A0A01.K30A.00E581162516
访问计划管理器sqlra_compile_var探测:20数据库:数据库
DIA0001E发生内部错误。报告以下错误代码:
ZRC = 0x8031006D。
PID:1310860 TID:1节点:000标题: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节点:000标题: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''
-------------------------------- -------------------------------
什么可能是错误代码ZRC = 0x8031006D ; ???
提前致谢。
Marcos Paulo Serafim
Orlandi a - SP - 巴西
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
这篇关于错误代码ZRC = 0x8031006D。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!