DB2 升级v10后dprop脚本运行不成功
Hi 大家好,我又来了,这次的问题是这样的.最近在生产库做了DB2的版本升级,从v9.5-v10.1.4. 升级过程中数据库组件什么都没有报错.因为升级后dprop也必须要升级,所以一概升级到了相应的版本. 之前有在其他测试库上做过升级测试.升级后一切运转正常.但是在生产库上问题还是...显示全部
Hi 大家好,
我又来了,这次的问题是这样的.最近在生产库做了DB2的版本升级,从v9.5-v10.1.4. 升级过程中数据库组件什么都没有报错.因为升级后dprop也必须要升级,所以一概升级到了相应的版本. 之前有在其他测试库上做过升级测试.升级后一切运转正常.但是在生产库上问题还是就这么出现了!
升级后进行了cold start和loadx_type=6+loadxit=y模式进行了一波同步(全都是以命令行形式). 确认dprop sync之后停止,备份数据库.期间没有做任何更改.然后再以脚本进行warm start的时候, 问题来了. Capture端可以以脚本正常启动,启动后的命令模式是:
asncap capture_server=xxxxx capture_schema=ASN 其他参数默认
apply端启动时就遇见了以下的error:
Program start_apply ended at Sun Aug 17 18:11:42 GMT 2014
2014-08-17-18.11.42.552927 ASN0513E "Apply":"" : "Initial": The program could not open the message file named 'db2asn.mo', Reason: SQL10007N Message "600" could not be retrieved. Reason code: "3".
2014-08-17-18.11.42.552071 ASN0553W "Apply" : "" : "Initial" : An internal error "4" occurred for message number "600" containing "9" substitution fields: "Apply", "" : "Initial", "apply 10.1.3 (Build 10.1.0.4 Level s140509, PTF IP23586)", " ", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631182 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "552" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "CONNECT", "N/A", "-1390", " ", "*", "SQLEUCCM"
2014-08-17-18.11.42.631373 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "530" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "N/A", "-1390", " ", " ", " ", " "
2014-08-17-18.11.42.631427 ASN8013D "Apply" : "apply_qual" : "Initial" : Error "-9" from asnGetPwd for User "N/A" on DB2 "xxxx" using password file "/dbdata/db2inst1/torun/asnpwd.aut".
2014-08-17-18.11.42.631445 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "1982" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "/dbdata/db2inst1/torun/asnpwd.aut", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631493 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "589" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "907", "dbConnectionnit::dbConnectCtx", "*", "*", "*", "*", "*"
2014-08-17-18.11.42.631529 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "1097" containing "9" substitution fields: "apply_qual" : "Initial", " ", " ", " ", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631685 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "552" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "CONNECT", "N/A", "-1390", " ", "*", "SQLEUCCM"
2014-08-17-18.11.42.631724 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "530" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "N/A", "-1390", " ", " ", " ", " "
2014-08-17-18.11.42.631772 ASN8013D "Apply" : "apply_qual" : "Initial" : Error "-9" from asnGetPwd for User "N/A" on DB2 "xxxxx" using password file "/dbdata/db2inst1/torun/asnpwd.aut".
2014-08-17-18.11.42.631787 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "1982" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "/dbdata/db2inst1/torun/asnpwd.aut", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631824 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "589" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "907", "dbConnection::dbSwapCtx", "*", "*", "*", "*", "*"
2014-08-17-18.11.42.631858 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "589" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "907", "asnThred::disconnect", "*", "*", "*", "*", "*"
脚本内部命令是这样的
asnapply control_server=xxxx apply_qual=apply_qual pwdfile=asnpwd.aut logreuse=y logstdout=y loadxit=n inamsg=y notify=n copyonce=n trlreuse=n term=n
于是apply跪掉.启动不起来.
诡异的事情就在于,如果不用脚本,使用上面的命令以命令行形式启动的话, dprop的apply是可以正常启动而且没有任何错误的.
不知道有没有大神遇到过类似的问题?感激不尽...收起
我又来了,这次的问题是这样的.最近在生产库做了DB2的版本升级,从v9.5-v10.1.4. 升级过程中数据库组件什么都没有报错.因为升级后dprop也必须要升级,所以一概升级到了相应的版本. 之前有在其他测试库上做过升级测试.升级后一切运转正常.但是在生产库上问题还是就这么出现了!
升级后进行了cold start和loadx_type=6+loadxit=y模式进行了一波同步(全都是以命令行形式). 确认dprop sync之后停止,备份数据库.期间没有做任何更改.然后再以脚本进行warm start的时候, 问题来了. Capture端可以以脚本正常启动,启动后的命令模式是:
asncap capture_server=xxxxx capture_schema=ASN 其他参数默认
apply端启动时就遇见了以下的error:
Program start_apply ended at Sun Aug 17 18:11:42 GMT 2014
2014-08-17-18.11.42.552927 ASN0513E "Apply":"" : "Initial": The program could not open the message file named 'db2asn.mo', Reason: SQL10007N Message "600" could not be retrieved. Reason code: "3".
2014-08-17-18.11.42.552071 ASN0553W "Apply" : "" : "Initial" : An internal error "4" occurred for message number "600" containing "9" substitution fields: "Apply", "" : "Initial", "apply 10.1.3 (Build 10.1.0.4 Level s140509, PTF IP23586)", " ", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631182 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "552" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "CONNECT", "N/A", "-1390", " ", "*", "SQLEUCCM"
2014-08-17-18.11.42.631373 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "530" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "N/A", "-1390", " ", " ", " ", " "
2014-08-17-18.11.42.631427 ASN8013D "Apply" : "apply_qual" : "Initial" : Error "-9" from asnGetPwd for User "N/A" on DB2 "xxxx" using password file "/dbdata/db2inst1/torun/asnpwd.aut".
2014-08-17-18.11.42.631445 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "1982" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "/dbdata/db2inst1/torun/asnpwd.aut", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631493 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "589" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "907", "dbConnectionnit::dbConnectCtx", "*", "*", "*", "*", "*"
2014-08-17-18.11.42.631529 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "1097" containing "9" substitution fields: "apply_qual" : "Initial", " ", " ", " ", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631685 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "552" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "CONNECT", "N/A", "-1390", " ", "*", "SQLEUCCM"
2014-08-17-18.11.42.631724 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "530" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "N/A", "-1390", " ", " ", " ", " "
2014-08-17-18.11.42.631772 ASN8013D "Apply" : "apply_qual" : "Initial" : Error "-9" from asnGetPwd for User "N/A" on DB2 "xxxxx" using password file "/dbdata/db2inst1/torun/asnpwd.aut".
2014-08-17-18.11.42.631787 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "1982" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "xxxx", "/dbdata/db2inst1/torun/asnpwd.aut", " ", " ", " ", " ", " "
2014-08-17-18.11.42.631824 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "589" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "907", "dbConnection::dbSwapCtx", "*", "*", "*", "*", "*"
2014-08-17-18.11.42.631858 ASN0553W "Apply" : "apply_qual" : "Initial" : An internal error "4" occurred for message number "589" containing "9" substitution fields: "Apply", "apply_qual" : "Initial", "907", "asnThred::disconnect", "*", "*", "*", "*", "*"
脚本内部命令是这样的
asnapply control_server=xxxx apply_qual=apply_qual pwdfile=asnpwd.aut logreuse=y logstdout=y loadxit=n inamsg=y notify=n copyonce=n trlreuse=n term=n
于是apply跪掉.启动不起来.
诡异的事情就在于,如果不用脚本,使用上面的命令以命令行形式启动的话, dprop的apply是可以正常启动而且没有任何错误的.
不知道有没有大神遇到过类似的问题?感激不尽...收起