[
https://issues.apache.org/jira/browse/TRAFODION-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16686271#comment-16686271
]
ASF GitHub Bot commented on TRAFODION-3233:
-------------------------------------------
GitHub user SuJinpei opened a pull request:
https://github.com/apache/trafodion/pull/1745
[TRAFODION-3233] odb rows option not work when copying data in parallel
the cause is :
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/SuJinpei/incubator-trafodion trafodion-3233
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1745.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1745
----
commit 87bf65df82090fde10b7705cc4137b91d86f48f6
Author: SuJinpei <873118042@...>
Date: 2018-11-14T09:26:16Z
fix TRAFODION-3233
----
> 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)
