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 2019/07/26 10:11:00 UTC
[jira] [Resolved] (TRAFODION-3233) odb rows option not work when
copying data in parallel
[ https://issues.apache.org/jira/browse/TRAFODION-3233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
苏锦佩 resolved TRAFODION-3233.
----------------------------
Resolution: Fixed
> 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.14#76016)