ProfileStage connection problem

This forum contains ProfileStage posts and now focuses at newer versions Infosphere Information Analyzer.

Moderators: chulett, rschirm

Post Reply
RAJEEV KATTA
Participant
Posts: 103
Joined: Wed Jul 06, 2005 12:29 am

ProfileStage connection problem

Post by RAJEEV KATTA »

I couldnot find the Analysis Server hostname in the Connection manager so that i could assign dsn to the repository under it and work on analysis.The ProfileStage was installed properly.These are the things i have done.
1)Installed Analysis Server,Message Switch,DataDirect drivers on same sun-os box.
2)Installed PSDB on different sun-os box.
3)Established the connection between PSDB and Analysis Server through odbc.ini
4)Started the services(Analysis Server,Message Switch)
5)Tested the connection between PSDB and Analysis Server using example.
6)Created dsn on windows client to PSDB and logged on to ProfileStage.

Now I could not see the Analysis Server icon in connection manager.Am i missing anything,does anything needs to be done to establish connection.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Yes, you need to define within ProfileStage where the Analysis Server is (or even multiple Analysis Servers).
When you open ProfileStage's Connection Manager you identify not only the PSDB but also the Analysis Server(s) as well as any associated data sources and details.
The first time you access a new database in the PSDB, you will be prompted to initialize the database.
The initialization process establishes various configuration settings that govern the behavior of data analysis and prepares internal tables to receive the results of data analysis.
1 Select your database name from the Select a database drop-down box.
2 Select the analysis server from the Select a server drop-down list.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
RAJEEV KATTA
Participant
Posts: 103
Joined: Wed Jul 06, 2005 12:29 am

Post by RAJEEV KATTA »

I know what you are saying you meant how to establish connection from repository but my problem is not that,i am unable to view the Analysis Server icon & icon for the Repository in the connection manager window tree.I am unable to trace out the problem.
lstsaur
Participant
Posts: 1139
Joined: Thu Oct 21, 2004 9:59 pm

Post by lstsaur »

You can check the MGXPgmInit.log file for evidence of handshake between your Mesaage Switch and Analysis Server. You will see "Sent PISERVER message to Message Switch" if the Analysis server is up and working correctly. However, after you saw that message, you still couldn't see the Anaysis Server's icon in the Connection Manager, contact IBM support.
Post Reply