Search found 830 matches

by mandyli
Mon Nov 24, 2014 1:15 pm
Forum: General
Topic: Access Denied - Project Lock issue
Replies: 7
Views: 5823

Thanks Lot.
smat -a is AIX level monitor commend .


Thanks
Man
by mandyli
Fri Nov 21, 2014 8:43 pm
Forum: General
Topic: Access Denied - Project Lock issue
Replies: 7
Views: 5823

Hi Thanks. already I have enabled deadlock services and also I have noticed that. If some one open designer and start compile one job and then open Director then immediately the same user getting "Access Denied - Project Lock issue" issue. But I am seeing only one connection for that user....
by mandyli
Tue Nov 18, 2014 1:58 pm
Forum: General
Topic: DataStage 9.1 comes with one other component
Replies: 3
Views: 2519

Thanks Ray & vmcburney .
by mandyli
Mon Nov 17, 2014 3:43 pm
Forum: General
Topic: DataStage 9.1 comes with one other component
Replies: 3
Views: 2519

DataStage 9.1 comes with one other component

Hi

We are in the process of rehost our Datastge server. But we are planning to install only Datastage.

I hope DataStage comes with one other component as part of the product.

Is there any other product is coming with Datastage?


Thanks
Man
by mandyli
Mon Aug 18, 2014 2:42 pm
Forum: General
Topic: Update DSparams file
Replies: 1
Views: 1471

Update DSparams file

Hi we are seeing one strange error while update DSParams file. we are updating database name and user id and password via Datastage admin. after updating some the DSparamas values has been duplicated if I try to view data from any of the job. I am not sure is this issue with DSParama file. I have ch...
by mandyli
Mon Jul 28, 2014 3:53 pm
Forum: General
Topic: xmeta.properiters
Replies: 2
Views: 2219

xmeta.properiters

Hi We are moving XMETA database from one Oracle ODA server into another ODA server. I know we have to update '/opt/IBM91/InformationServer/ASBServer/bin/sql/database.properties' file. But I there is some xmeta.properiters file need to change or update. Any way I have to update tnsnames.ora file. Is ...
by mandyli
Mon Jul 28, 2014 3:26 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata EE stage able to connect with TTU14
Replies: 4
Views: 2441

Thanks Ray.

Let us test it.


Thanks
Man
by mandyli
Thu Jul 24, 2014 2:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Teradata EE stage able to connect with TTU14
Replies: 4
Views: 2441

Teradata EE stage able to connect with TTU14

Hi At present we are using Teradata v13,but we are in the process of migrate TERADATA v13 to Teradata v14. Is this any impact from Datastage side? We just moved from Data stage 8.1 to Data stage 9.1 and using TTU13 to connect TTU13 version. I hope we have to install TTU14 to connect Teradata 14.10. ...
by mandyli
Tue Jul 22, 2014 12:06 pm
Forum: General
Topic: dssh hang and client not able to connect
Replies: 4
Views: 2667

Hi Ray,

I have fixed this issue. I asked AIX team to reboot the whole box.


Thanks
Man
by mandyli
Fri Jul 18, 2014 9:11 pm
Forum: General
Topic: dssh hang and client not able to connect
Replies: 4
Views: 2667

My network/firewall team saying

the rule permits all tcp and udp high-ports (1023-65535).

Thanks
Man
by mandyli
Fri Jul 18, 2014 9:09 pm
Forum: General
Topic: dssh hang and client not able to connect
Replies: 4
Views: 2667

What service do you have configured to listen on port number 31539 :

Sorry I am not able to get this. Are you referring telnet services?


Thanks

Man
by mandyli
Fri Jul 18, 2014 3:14 pm
Forum: General
Topic: dssh hang and client not able to connect
Replies: 4
Views: 2667

dssh hang and client not able to connect

Hi Past one day we are not able to connect datastage server. we are getting following error. Error message: We are getting following error when we try to connect from Datastage client Failed to connect to Information Server Engine: abcd:31539, project: aaaaa. (The connection has timed out (81015)) L...
by mandyli
Mon Jun 30, 2014 9:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Transformer stage strange Issue
Replies: 3
Views: 2043

Transformer stage strange Issue

Hi We are facing one strange issue from Transformer stage. We are in the process of migrating from Data stage 8.1 to Data stage 9.1. One of our DS job no data pass through after transformer stage. But the same job running and passing the data from 8.1 job Transformer stage. I did some fix and workar...
by mandyli
Tue Apr 15, 2014 2:05 pm
Forum: General
Topic: how & where to find @DATE variable in datastage
Replies: 9
Views: 6826

Hi Ray, I am getting oconv variable not defined error. Any way I have fixed this issue. I have disabling the Time/Date option from NLS tab at job and job sequence level. //----------------------------------------------- As noted in the documentation section "Correlative and Conversion Codes&quo...
by mandyli
Mon Apr 14, 2014 10:55 am
Forum: General
Topic: how & where to find @DATE variable in datastage
Replies: 9
Views: 6826

And also I am testing with following in 9.1 Transformer stage. but it is in Red color. It looks like some syntax issue.

Ereplace (oconv(CurrentDate()-1,"DYMD[4,2,2]")," ","")

Ereplace (oconv(@DATE-1,"DYMD[4,2,2]")," ","")

Thanks
Man