ITPUB??ì3
12月微软Hyper-V虚拟化沙龙主题征集
ITPUB论坛 » IBM数据库产品 » 新手提问关于SQL1444N

标题: [有问必答活动] 新手提问关于SQL1444N
离线 zzjjww
一般会员



精华贴数 0
个人空间 0
技术积分 294 (6761)
社区积分 4 (17006)
注册日期 2002-8-9
论坛徽章:0
      
      

发表于 2008-10-9 14:49 
新手提问关于SQL1444N

在使用DB2数据库的过程中,碰到如下问题:
环境:两台win2000 vm,分别安装db2客户端和服务器端;
使用:在客户端访问服务器端,利用control center访问都正常,但是在登陆软件时,利用administrator用户登陆时,报如下信息:
SQL1444N The application context cannot be destroyed because it it in use
在网上查了半天也没有查到解决方法。
由于自己是新手,对db2的概念也不是很清楚,不知道如何下手,请各位大虾帮助分析一下,谢谢啦。


__________________
数据仓库&数据挖掘_zjw@163.com---------------------------------我知道什么?我思,故我在。
只看该作者    顶部
离线 zzjjww
一般会员



精华贴数 0
个人空间 0
技术积分 294 (6761)
社区积分 4 (17006)
注册日期 2002-8-9
论坛徽章:0
      
      

发表于 2008-10-9 14:50 
另外,根据错误信息,好像是由于没有释放相关的资源,可是我把两台vm都重新启动了,结果还是不行。


__________________
数据仓库&数据挖掘_zjw@163.com---------------------------------我知道什么?我思,故我在。
只看该作者    顶部
离线 zzjjww
一般会员



精华贴数 0
个人空间 0
技术积分 294 (6761)
社区积分 4 (17006)
注册日期 2002-8-9
论坛徽章:0
      
      

发表于 2008-10-9 14:52 
下面附上我查到的有关信息:

SQL1444N
不能破坏应用程序上下文,因为它正在使用。

说明
用户试图破坏仍在使用的应用程序上下文。或者有一个线程已与上下文相连,或者该上下文有 CONNECT 或 ATTACH 与它相关联。在可以破坏上下文之前,必须完成 CONNECT RESET 或 DETACH(如果已完成了 CONNECT 或 ATTACH),并且所有线程必须与该上下文拆离。

用户响应
确保对上下文的连接的所有调用都有相应的拆离、所有 CONNECTS 都有相应的 CONNECT RESET,并且所有 ATTACHES 都有相应的 DETACH。

父主题: SQL 消息


__________________
数据仓库&数据挖掘_zjw@163.com---------------------------------我知道什么?我思,故我在。
只看该作者    顶部
离线 DB2Viper
DB2 FANS


精华贴数 0
个人空间 0
技术积分 216 (8969)
社区积分 182 (2561)
注册日期 2006-9-21
论坛徽章:1
ITPUB新首页上线纪念徽章     
      

发表于 2008-10-10 09:44 
db2diag.log


__________________
只看该作者    顶部
离线 zzjjww
一般会员



精华贴数 0
个人空间 0
技术积分 294 (6761)
社区积分 4 (17006)
注册日期 2002-8-9
论坛徽章:0
      
      

发表于 2008-10-10 17:15 
不好意思,刚刚回到办公室,文件信息如下:

2006-02-06-12.04.17.359000   InstanceB2   Node:000
PID:2296(db2syscs.exe)   TID:2284   Appid:none
base sys utilities  startdbm Probe:911

ADM7513W  Database manager has started.

2006-02-06-12.10.36.343000   InstanceB2   Node:000
PID:2296(db2syscs.exe)   TID:3856   Appid:none
base sys utilities  stopdbm Probe:78

DIA8411C A file "" could not be found.
ZRC=0x860F000A

2006-02-06-12.36.39.203000   InstanceB2   Node:000
PID:392(db2syscs.exe)   TID:180   Appid:none
base sys utilities  startdbm Probe:911

ADM7513W  Database manager has started.

2006-02-06-13.07.25.968000   InstanceB2   Node:000
PID:392(db2syscs.exe)   TID:1200   Appid:none
base sys utilities  stopdbm Probe:78

DIA8411C A file "" could not be found.
ZRC=0x860F000A

2008-10-10-04.16.08.507000   InstanceB2   Node:000
PID:1652(db2syscs.exe)   TID:1692   Appid:none
base sys utilities  startdbm Probe:911

ADM7513W  Database manager has started.

2008-10-10-05.09.30.225000   InstanceB2   Node:000
PID:1652(db2syscs.exe)   TID:2164   Appid:none
base sys utilities  stopdbm Probe:504

Active Db:[TOOLSDB ] [RetCode=-1025] [Reason=1] [AppGrpCnt=2] [QsAttemptCnt=0] [DbActivated=0] [UseCnt=2] [DbQuiesced=0]

2008-10-10-05.09.30.491000   InstanceB2   Node:000
PID:796(db2stop.exe)   TID:1064   Appid:none
base sys utilities  sqlePrintFinalMessage Probe:10

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

2008-10-10-09.52.00.015000   InstanceB2   Node:000
PID:3508(javaw.exe)   TID:2060   Appid:none
common communication  sqlcctcpconnr Probe:110

DIA3202C The TCP/IP call "connect" returned an errno="10065".

2008-10-10-09.52.00.093000   InstanceB2   Node:000
PID:3508(javaw.exe)   TID:2060   Appid:none
base sys utilities  sqledscvr_getinfo Probe:20

DIA3013E DB2 function "sqleatin" failed: rc = "-30081".

2008-10-10-09.53.29.125000   InstanceB2   Node:000
PID:3508(javaw.exe)   TID:2376   Appid:none
common communication  sqlcctcpconnr Probe:110

DIA3202C The TCP/IP call "connect" returned an errno="10065".

2008-10-10-09.53.29.140000   Instance:DB2   Node:000
PID:3508(javaw.exe)   TID:2376   Appid:none
base sys utilities  sqledscvr_getinfo Probe:20

DIA3013E DB2 function "sqleatin" failed: rc = "-30081".

2008-10-10-09.54.31.187000   Instance:DB2   Node:000
PID:3508(javaw.exe)   TID:2432   Appid:none
common communication  sqlcctcpconnr Probe:110

DIA3202C The TCP/IP call "connect" returned an errno="10065".

2008-10-10-09.54.31.203000   Instance:DB2   Node:000
PID:3508(javaw.exe)   TID:2432   Appid:none
base sys utilities  sqledscvr_getinfo Probe:20

DIA3013E DB2 function "sqleatin" failed: rc = "-30081".

2008-10-10-09.59.32.937000   Instance:DB2   Node:000
PID:3508(javaw.exe)   TID:2056   Appid:none
common communication  sqlcctcpconnr Probe:110

DIA3202C The TCP/IP call "connect" returned an errno="10065".

2008-10-10-09.59.32.953000   Instance:DB2   Node:000
PID:3508(javaw.exe)   TID:2056   Appid:none
base sys utilities  sqledscvr_getinfo Probe:20

DIA3013E DB2 function "sqleatin" failed: rc = "-30081".

2008-10-10-11.07.07.562000   Instance:DB2   Node:000
PID:2508(javaw.exe)   TID:2780   Appid:none
common communication  sqlcctcpconnr Probe:110

DIA3202C The TCP/IP call "connect" returned an errno="10065".

2008-10-10-11.07.07.593000   Instance:DB2   Node:000
PID:2508(javaw.exe)   TID:2780   Appid:none
base sys utilities  sqledscvr_getinfo Probe:20

DIA3013E DB2 function "sqleatin" failed: rc = "-30081".

2008-10-10-11.09.10.218000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N50C.081010090911
base sys utilities  sqleSetupCodePageInfo Probe:200   Database:TOOLSDB

DIA8102C Conversion table not loaded. Source code page "", Target code page "",
method "", handle "".
ZRC=0x800F005B

2008-10-10-11.09.10.249000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N50C.081010090911
base sys utilities  sqleSetupCodePageInfo Probe:200   Database:TOOLSDB

Conversion table not available. Source code page = 1114, Target code page = 1252

2008-10-10-11.09.10.281000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N50C.081010090911
base sys utilities  sqlesrsu Probe:20   Database:TOOLSDB

DiagData
b4fe ffff                                     ´þÿÿ               

2008-10-10-11.09.10.343000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N50C.081010090911
base sys utilities  sqlelost Probe:40

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

2008-10-10-11.09.10.374000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N50C.081010090911
DRDA Application Server  sqljsPostProcessingConnectAttach Probe:150

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

2008-10-10-11.09.10.406000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N50C.081010090911
DRDA Application Server  sqljsPostProcessingConnectAttach Probe:649

DIA5000C A DRDA AS token "RECOVERABLE" was detected.  The diagnostic data
returned is (SRVDGN): "FUNCTION ID = 0011 , PROBE POINT = 0649 , TRACE POINT =
0150 , SUBCODE1 = 8005006D, SUBCODE2 = FFFFFEB4, SUBCODE3 = 00000000, ERROR MSG
= SQLAM: CONNECT failed. CCSID specified on ACCRDB not supported".


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** DRDA ASCB ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** DRDA CMNMGR CB ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** RECEIVE BUFFER ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** SEND BUFFERS ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** CONNECTION HANDLE ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** DRDA ATTRIBUTES ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** AS UCINTERFACE ****

2008-10-10-11.09.10.499000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N60C.081010090912
base sys utilities  sqleSetupCodePageInfo Probe:200

DIA8102C Conversion table not loaded. Source code page "", Target code page "",
method "", handle "".
ZRC=0x800F005B

2008-10-10-11.09.10.515000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N60C.081010090912
base sys utilities  sqleSetupCodePageInfo Probe:200

Conversion table not available. Source code page = 1114, Target code page = 1252

2008-10-10-11.09.10.515001   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N60C.081010090912
base sys utilities  sqlesrsu Probe:20

DiagData
b4fe ffff                                     ´þÿÿ               

2008-10-10-11.09.10.531000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N60C.081010090912
base sys utilities  sqlelost Probe:40

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

2008-10-10-11.09.10.531001   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N60C.081010090912
DRDA Application Server  sqljsPostProcessingConnectAttach Probe:150

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

2008-10-10-11.09.10.546000   Instance:DB2   Node:000
PID:1652(db2syscs.exe)   TID:1420   Appid:C0A8F201.N60C.081010090912
DRDA Application Server  sqljsPostProcessingConnectAttach Probe:649

DIA5000C A DRDA AS token "RECOVERABLE" was detected.  The diagnostic data
returned is (SRVDGN): "FUNCTION ID = 0011 , PROBE POINT = 0649 , TRACE POINT =
0150 , SUBCODE1 = 8005006D, SUBCODE2 = FFFFFEB4, SUBCODE3 = 00000000, ERROR MSG
= SQLAM: CONNECT failed. CCSID specified on ACCRDB not supported".


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** DRDA ASCB ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** DRDA CMNMGR CB ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** RECEIVE BUFFER ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** SEND BUFFERS ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** CONNECTION HANDLE ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** DRDA ATTRIBUTES ****


Dump File:C:\PROGRA~1\IBM\SQLLIB\DB2\16521420.000 Data:**** AS UCINTERFACE ****


__________________
数据仓库&数据挖掘_zjw@163.com---------------------------------我知道什么?我思,故我在。
只看该作者    顶部
离线 DB2Viper
DB2 FANS


精华贴数 0
个人空间 0
技术积分 216 (8969)
社区积分 182 (2561)
注册日期 2006-9-21
论坛徽章:1
ITPUB新首页上线纪念徽章     
      

发表于 2008-10-12 00:16 
检查db2set -all

db2codepage 是否是目标数据库的 codeset


__________________
只看该作者    顶部
 
    

相关内容


CopyRight 1999-2006 itpub.net All Right Reserved.
北京皓辰广域网络信息技术有限公司. 版权所有
E-mail:Webmaster@itpub.net
京ICP证:010037号 联系我们 法律顾问