Chinaunix

标题: 用onpladm,装数失败概率非常高? [打印本页]

作者: lutabo 时间: 2008-03-03 11:33
标题: 用onpladm,装数失败概率非常高?
用onpladm装载数据,发现失败概率非常高,到4%

测试装数15张表,重复30次->15*30
不管是并发用onpladm还是串行,出现失败的表是随机

失败是onpladm create job
好象是ompload什么游标出错...

用法如下:
装载数据xxtable
onpladm delete job    xxtablejob -fl
onpladm delete map xxtablejob -fl
onpladm delete format xxtablejob
onpladm delete device xxtablejob
onpladm create job    xxtablejob -d /dataPath/xxtable.unl -D xxdbName -t xxtable -fl
onpladm run    job    xxtablejob -fl
onpladm delete job    xxtablejob -fl
onpladm delete map xxtablejob -fl
onpladm delete format xxtablejob
onpladm delete device xxtablejob

作者: lutabo 时间: 2008-03-03 12:34
informix 10

出错信息

Invalid Map Name!
Invalid Job Name!
Invalid format!
Invalid Device Array Name!
Successfully created Job xxtable
Connecting to onpload, Please wait...
Error -244 on cursor fetch
Delete Map xxtablefailed!
Cannot delete xxtable, it is currently in use
Delete Job xxtablefailed!
Cannot delete active job xxtable
Delete Format xxtablefailed!
Cannot delete xxtable, it is currently in use
Successfully deleted Device-Array xxtable

作者: lutabo 时间: 2008-03-03 12:36
Invalid Map Name!
Invalid Job Name!
Invalid format!
Invalid Device Array Name!
Create Job failed!
Error -244 selecting record
Invalid Job Name!
Invalid Map Name!
Invalid Job Name!
Invalid format!
Invalid Device Array Name!

作者: lutabo 时间: 2008-03-11 15:35
大家onpladm怎么用的? 是不是我用错了

Invalid Map Name!
Invalid Job Name!
Invalid format!
Invalid Device Array Name!
Successfully created Job xxtable
Delete Map xxtablefailed!
Cannot delete xxtable, it is currently in use
Delete Job xxtablefailed!
Cannot delete active job xxtable
Delete Format xxtable failed!
Cannot delete xxtable, it is currently in use
Successfully deleted Device-Array xxtable

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)