Just for your information.
I have taken the length of row from table schema i.e. sum of the length defined in table for each columns.
Is this correct?
Search found 26 matches
- Wed Jul 14, 2021 10:38 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage slowness in parallel job
- Replies: 6
- Views: 16682
- Wed Jul 14, 2021 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage slowness in parallel job
- Replies: 6
- Views: 16682
Re: Join Stage slowness in parallel job
Thanks For Reply!!!
I tried making Array size to 70000, but couldn't find any success.
row length=200
total number of rows=14000000
Do I need to set APT_DEFAULT_TRANSPORT_BLOCK_SIZE as well?
I tried making Array size to 70000, but couldn't find any success.
row length=200
total number of rows=14000000
Do I need to set APT_DEFAULT_TRANSPORT_BLOCK_SIZE as well?
- Sun Jul 11, 2021 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Join Stage slowness in parallel job
- Replies: 6
- Views: 16682
Join Stage slowness in parallel job
I am trying to migrate data from SQL Server to Postgres DB using DataStage parallel job, but join stage is very i.e. it is joining record as 100 row/sec [db2 refernce data]db2 Connector | rlink | | [SQL Server]-------------plink--------[Join Stg]-------------------[Postgres db] ODBC connector ODBC c...
- Sat Aug 01, 2020 10:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: web services transformer stage generating huge log
- Replies: 2
- Views: 12193
Re: web services transformer stage generating huge log
Hi Team, web services transformer stage is generating huge log from SOAP response. I tried change Error handling option from 'Warn' to 'Fatal' , but could not get any much difference in log size. This is causing DS server to hang with huge log. Note: we are storing log of only three day. Could you ...
- Fri Jul 31, 2020 5:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: web services transformer stage generating huge log
- Replies: 2
- Views: 12193
web services transformer stage generating huge log
Hi Team, web services transformer stage is generating huge log from SOAP response. I tried change Error handling option from 'Warn' to 'Fatal' , but could not get any much difference in log size. This is causing DS server to hang with huge log. Note: we are storing log of only three day. Could you p...
- Mon Jun 05, 2017 12:29 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Mon Jun 05, 2017 12:04 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Fri Jun 02, 2017 7:06 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
Hi chulett, Please help in below issue. When using dsjob -ljobs to display job in a project you receive the following output: $dsjob -ljobs projectname <none> Status code = 0 Also tried using below format , but did not worked dsjob -domain domainname:port -server servername:31538 -user abc -password...
- Fri Jun 02, 2017 3:23 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Thu Jun 01, 2017 8:02 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Thu Jun 01, 2017 7:20 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Thu Jun 01, 2017 5:50 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Thu Jun 01, 2017 3:35 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
- Thu Jun 01, 2017 1:55 am
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
In .profile file of the user through which i have logged in contain dsenv file execution. Please give the proper syntax for 'start with -lprojects' I tried once again, opt/IBM/InformationServer/Server/DSEngine > . /opt/IBM/InformationServer/Server/DSEngine/dsenv opt/IBM/InformationServer/Server/DSEn...
- Wed May 31, 2017 1:35 pm
- Forum: General
- Topic: Datastage command using dsjob -ljobs does not display jobs
- Replies: 18
- Views: 11890
Datastage command using dsjob -ljobs does not display jobs
When using dsjob -ljobs to display job in a project you receive the following output: <none> Status code = 0 Also tried using below format , but did not worked dsjob -domain <>:9080 -server <>:31538 -user dsdev3 -password dsdev3 -ljobs projectname !!!!!Quick response is really appreciated!!!!!!