sqlnet 发表于 2010-08-26 23:36

SPL导入问题

1. 导出数据和 schema
informix@test2:/home/informix> onpladm create project test_pro2 -d /home/informix/pro -D test
Successfully created Project test_pro1
Successfully created jobs for 2 tables


informix@test2:/home/informix> onpladm run project test_pro2 -fu

informix@test2:/home/informix> dbschema -d test -t all -ss test.sql

DBSCHEMA Schema Utility       INFORMIX-SQL Version 11.50.UC3


2. 建库test1,导入schema
3. 导入报错
informix@test2:/home/informix> onpladm create project test_pro3 -d /home/informix/pro -D test1
Successfully created Project test_pro3
Successfully created jobs for 2 tables
informix@test2:/home/informix> cd pro
informix@test2:/home/informix/pro> l -rt
total 7
drwxr-xr-x2 informix informix112 2010-08-26 23:12 ./
drwxr-xr-x 54 informix informix 2776 2010-08-26 23:14 ../
-rw-rw----1 informix informix    0 2010-08-26 23:15 test_t.unl
-rw-rw----1 informix informix161 2010-08-26 23:15 test_t1.unl
informix@test2:/home/informix/pro> onpladm run project test_pro3 -fl
Connecting to onpload, Please wait...
Onpload cannot access devices/files for job
Connecting to onpload, Please wait...
Onpload cannot access devices/files for job

什么原因啊? suse10+i nformix11

liaosnet 发表于 2010-08-27 01:24

onpladmlist job

sqlnet 发表于 2010-08-27 21:28

informix@test2:/home/informix> onpladm create project test_pro4 -d /home/informix/pro -D test1
Successfully created Project test_pro4
Successfully created jobs for 2 tables
informix@test2:/home/informix> onpladm run project test_pro4 -fl
Connecting to onpload, Please wait...
Onpload cannot access devices/files for job
Connecting to onpload, Please wait...
Onpload cannot access devices/files for job
informix@test2:/home/informix> onpladm list job
There are noJobs in the Project
页: [1]
查看完整版本: SPL导入问题