You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "苏锦佩 (JIRA)" <ji...@apache.org> on 2018/11/14 09:16:01 UTC
[jira] [Created] (TRAFODION-3233) odb rows option not work when
copying data in parallel
苏锦佩 created TRAFODION-3233:
------------------------------
Summary: odb rows option not work when copying data in parallel
Key: TRAFODION-3233
URL: https://issues.apache.org/jira/browse/TRAFODION-3233
Project: Apache Trafodion
Issue Type: Bug
Components: db-utility-odb
Reporter: 苏锦佩
from Oracle copy data with the odb tool, using ROWS parameter is 5000 rows fetch per.
But the parameter did not take effect，So the odb tool performance is bad.
reproduce:
[[trafodion@esgyndb02|mailto:trafodion@esgyndb02] ~]$ odb64luo -u v7poc:db__root -p v7poc:traf123 -d pocdb:traf -cp src=KCDA_PZJCXX:tgt=KCDA_PZJCXX:rows=5000:loadcmd=UL:parallel=6
Connected to Oracle
odb [2018-11-08 20:03:23]: starting ODBC connection(s)... 0 >1 >2 3 >4 >5 6 >7 >8 9 >10 >11 12 >13 >14 15 >16 >17
Connected to Trafodion
[17] 100 records copied [commit]
[11] 100 records copied [commit]
[2] 100 records copied [commit]
[5] 100 records copied [commit]
[16] 100 records copied [commit]
[8] 100 records copied [commit]
[13] 100 records copied [commit]
[11] 200 records copied [commit]
[2] 200 records copied [commit]
[5] 200 records copied [commit]
[16] 200 records copied [commit]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)