[
https://issues.apache.org/jira/browse/TRAFODION-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
苏锦佩 reassigned TRAFODION-3233:
------------------------------
Assignee: 苏锦佩
> 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: 苏锦佩
> Assignee: 苏锦佩
> Priority: Major
>
> 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)
