Search found 160 matches

by xinhuang66
Mon Feb 04, 2013 10:02 pm
Forum: General
Topic: Operations Console
Replies: 2
Views: 1984

Operations Console

We have IIS 8.7 installed, all works fine but the new Operations console.

When log into Ops Console web page, after a while, it pops up error message, couldn't connect to service tier....

But all others like Web admin works, so service tier can be connected

Does anyone have an idea ?
by xinhuang66
Sun Feb 03, 2013 9:02 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Add IA component to Existing Datastage
Replies: 4
Views: 4748

Only using existing Websphere and xmeta

We plan to keep the possibility to reboot only IA engine other than Datastage engine, since we expect IA crashes more often.

Install IA engine on a separated server, but using the same Websphere and Xmeta Database .

Has anyone done so, any particular points to be aware of ?
by xinhuang66
Mon Aug 27, 2012 5:24 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: No percent value in FD
Replies: 4
Views: 4113

This is a bit weird, I do need percent.

Is it possible to change the xsd file to get the percent ?
by xinhuang66
Thu Aug 23, 2012 11:55 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: No percent value in FD
Replies: 4
Views: 4113

No percent value in FD

I use Information Analyzer http api command line to export FD result.

However the csv file I get is like as following.

The value for percent is all empty..

Does anyone know why ? is it a bug ?

value,frequency,percent
2,1,
1,1,
3,1,
by xinhuang66
Tue Aug 21, 2012 9:56 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to export IA pdf report from command line
Replies: 4
Views: 4115

Based on my research, I believe it is not possible either.

But https interface can help to dump column analysis and FD, that might be enought.

Thanks
by xinhuang66
Mon Aug 20, 2012 10:16 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: How to export IA pdf report from command line
Replies: 4
Views: 4115

How to export IA pdf report from command line

I have created some reports inside IA based on their templates.

Just want to know if it is possible to export these reports from command line ?
by xinhuang66
Sun Aug 12, 2012 11:34 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: IA: Invalid File Path in External Bundle Location
Replies: 8
Views: 8255

I had the same issue before.

Finally, i found the directory I input need to be a local directory other than a server directory..

I put a local directory, and it worked.
by xinhuang66
Mon Feb 20, 2012 9:33 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Remove tables from Project Property
Replies: 3
Views: 3594

Firstly, I tried to remove them from data source, and it failed.

then tried to remove them from project.

This looks to me like a bug, may need a fix pack.
by xinhuang66
Thu Feb 16, 2012 4:27 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Remove tables from Project Property
Replies: 3
Views: 3594

Remove tables from Project Property

I am working on an IA project, which was set up by others. There are 20 tables in the project data sources, however, I am only interested in 10 of them, therefore I want to delete 10 of them from Project Property-> data sources interface. I can remove these 10 tables, save all. However some of these...
by xinhuang66
Tue Nov 08, 2011 9:28 pm
Forum: General
Topic: DS.TOOS is not in your VOC
Replies: 1
Views: 1415

DS.TOOS is not in your VOC

I try to access DS.TOOLS, What I did is 1) putty to datastage server as dsadm 2) cd $DSHOME 3) . .dsenv 4) ./bin/uvsh After that, I can see uvsh > Then I input DS.TOOLS, I get DS.TOOLS is not in your VOC. However, if I login into administrator, select project, then run commands DS.TOOLS, I can get t...
by xinhuang66
Thu Nov 03, 2011 7:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How oracle enterprise stage upsert works ?
Replies: 2
Views: 1372

How oracle enterprise stage upsert works ?

I have a job using oracle enterprise stage upsert to write back to Oracle table. Update first then insert. Just wondering how upsert works, my understanding, Oracle will run a generated update statement for all incoming rows, then insert those which not found match in update. If so, does it mean if ...
by xinhuang66
Tue Oct 25, 2011 9:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Enterprise vs Oracle Connector
Replies: 0
Views: 1582

Oracle Enterprise vs Oracle Connector

What are these fundamental difference between them. I had issues by swapping them. Oracle Enterprise stage, I had a select 1 as col1 from dual statement, and set col1 as integer 10 Not null, datastage throwing warnings say implicit convert decimal(38,10) to int, null to not null, etc. Change to orac...
by xinhuang66
Sun Sep 18, 2011 11:20 pm
Forum: General
Topic: Does Datastage installation bring a shell environment
Replies: 8
Views: 2763

SURA wrote:In KSH all the commands may not work.
What it means by "all the commands may not work" ?

Does it mean MSK may not suport full suite of Ksh ?
by xinhuang66
Sun Sep 18, 2011 7:36 pm
Forum: General
Topic: Does Datastage installation bring a shell environment
Replies: 8
Views: 2763

As noted, the PX product ships with the MKS Toolkit which allows emulation of UNIX under Windows. MKS is not shipped with DS Server version. Am I right. The problem I am having now is setup framework, I need to decide which script I should use. KSH is ideal if it is supported, if not, I have to use...
by xinhuang66
Thu Sep 15, 2011 6:08 pm
Forum: General
Topic: Does Datastage installation bring a shell environment
Replies: 8
Views: 2763

Does Datastage installation bring a shell environment

I suddenly realized I can run KSH on my WinXp after I installed DS8.5 client.

Does anyone know why it is that ? does DS client contain a shell environment support ? Is it the same across different version ? I mean from Server 7.5 to Enterprise 8.5 .