Search found 26 matches

by ayadav77
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: 16185

Re: Join Stage slowness in parallel job

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?
by ayadav77
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: 16185

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?
by ayadav77
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: 16185

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...
by ayadav77
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: 11712

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 ...
by ayadav77
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: 11712

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...
by ayadav77
Mon Jun 05, 2017 12:29 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

Tried above command but doesn't worked.
by ayadav77
Mon Jun 05, 2017 12:04 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

Hi chulett,

Please help me on the issue.
by ayadav77
Fri Jun 02, 2017 7:06 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

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...
by ayadav77
Fri Jun 02, 2017 3:23 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

Yes, I am able to login Designer and can see the job.

Tried all possible way but dsjob -ljobs is not working.
dsjob -domain dname:9080 -server sname:31538 -user abc -password xyz -ljobs projectname
by ayadav77
Thu Jun 01, 2017 8:02 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

I guess i have the permission because all other options of dsjob are working only -ljobs isnot working.
by ayadav77
Thu Jun 01, 2017 7:20 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

Yes, it works.
by ayadav77
Thu Jun 01, 2017 5:50 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

Treid the above command and it is working fine for -lprojects, but when i do -ljobs it doesn't give any output.

Below command is not working:
dsjob -domain domainname:port -server servername:31538 -user youruser -password yourpassword -ljobs <Projectname>
by ayadav77
Thu Jun 01, 2017 3:35 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

Yes!

dsjob -lprojects is working.
by ayadav77
Thu Jun 01, 2017 1:55 am
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

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...
by ayadav77
Wed May 31, 2017 1:35 pm
Forum: General
Topic: Datastage command using dsjob -ljobs does not display jobs
Replies: 18
Views: 11837

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!!!!!!