| Informatica PowerMart 3.5 Installation Guide
============================================
This file describes the PowerMart 3.5 release software. Please read
carefully for installation and configuration details.
PowerMart Installation
======================
Powermart 3.5 is shipped in a CD-ROM format. The CD-ROM must be mounted
onto the UNIX file system so that it appears under a standard path, for
example /cdrom. Mounting is performed differently depending on which
UNIX platform you are using :
Solaris : Insert the CD-ROM into an available drive. Shortly, the CD-ROM
will become auto-mounted over the /cdrom path.
HP-UX : The Powermart CD-ROM must be mounted using options '-F cdfs'
and '-o cdcase'. Otherwise all file and path names will
appear in upper case, with a ';1' suffix. For example, to mount
a SCSI CD-ROM with device designation /dev/dsk/c0t2d0, login as
root and issue the following command :
# mount -F cdfs -o cdcase /dev/dsk/c1t2d0 /cdrom
AIX : Login as root and use the SMIT management facility to mount
the CD-ROM over the /cdrom path.
Next, we recommend that you create a specific user account in order to
install and run PowerMart Server. Please refer to your operating
system documentation on how to create user accounts.
Execute the PowerMart instalation script as follows :
1. Login to the PowerMart user account
2. Locate the CDROM file structure mounted under /cdrom.
3. cd /cdrom/powermart*/srvunix/<os_type>
where os_type is one of solaris, hpux or aix
4. Now, execute ./pminst
4a. If you have problems trying to do (3), try 'sh pminst'
You will be prompted for installation type (PowerMart or PowerCapture),
and installation directory path. The following files will be installed in
the directory you specify, when PowerMart installation type is selected :
1. pmserver PowerMart Server executable
2. pmrejldr PowerMart Load Reject executable
3. pmcmd PowerMart session and batch launcher
4. pmserver.cfg Configuration file
5. pminst PowerMart installation script
6. pmconfig PowerMart configuration utility
7. pmverify Database client installation verification script
8. readme This file
9. Any required runtime libraries
Note : the pmserver.cfg file from any prior PowerMart installation will
be preserved and updated by the install process.
PowerCapture installation
=========================
Use the procedure described above, but select PowerCapture installation
type. All the above files will be installed, plus the following :
1. pmpcserver PowerCapture Server executable
2. ltm Sybase Log Transfer Manager executable
3. ltm.loc Sybase Log Transfer Manager localization file
4. ltm.cfg Sybase Log Transfer Manager configuration file
5. startltm Sybase Log Transfer Manager startup script example
6. cleanltm Sybase Log Transfer Manager cleanup script example
7. readme.ltm Sybase Log Transfer Manager readme notes
8. ccdbset.sql Oracle PowerCapture verification script
9. flush.sql Oracle PowerCapture verification script
10. opdbset.sql Oracle PowerCapture verification script
11. readme.ora Oracle PowerCapture verification readme notes
Configuration
=============
Always use the PowerMart configuration utility (pmconfig) to set parameters
in the configuration file (pmserver.cfg).
Change to the PowerMart installation directory (specified to pminst or
pmpcinst above), and issue command :
pmconfig <config file name> <enter>
- or just -
pmconfig <enter> (to use default pmserver.cfg)
This will take you through the list of configuration parameters, displaying
the default or current values in the selected configuration file.
To retain a parameter, hit <enter>.
To change a parameter, type in the new value and then hit <enter>.
Proceed through all parameters to the end. The configuration file will be
saved with any updated values.
The following parameters are mandatory:
1. ServerPort TCP/IP port number over which the PowerMart Server
and Server Manager communicate. This port number
should also be set in PowerMart Server Manager using
the Server Configuration | Network menu item.
2. UserName Database username to connect to the repository.
3. Password Password to connect to the repository.
4. DatabaseType Database containing repository. One of either
Oracle, Sybase or Informix
5. PlatformKey Platform (operating system) license key.
The following mandatory parameters must be specified if using PowerCapture
Server (pmpcserver)
6. CcServerPort TCP/IP port number used by PowerCapture Server to
receive command requests from PowerCapture Manager.
This port number should also be set in PowerCapture
Manager using the Server | Network menu item.
7. CcKey The license key for using PowerCapture service.
One of the following four parameters is a must. You may optionally
have more database keys specified:
1. OracleKey License key to access Oracle databases.
2. SybaseKey License key to access Sybase databases.
3. InformixKey License key to access Informix databases.
4. DB2Key License key to access DB2 databases.
The following parameters are optional in pmserver.cfg:
1. ConnectString If your repository resides on a different Unix
server than where the Server is installed, specify
the database connect string here. Otherwise
this must be left blank.
2. RepositoryName A symbolic name for the repository.
3. ErrorLogFile File where PowerMart Server errors are logged.
Default is pmserver.err
4. EventLogFile File where PowerMart Server events are logged.
Default is pmserver.log
5. PerformEventLogging
Enable/disable PowerMart Server event logging.
Default is No.
6. MaxSessions Maximum number of sessions that can be run/monitored
at any given time. Default is 10.
7. LMSharedMem Shared memory for use in PowerMart Server.
Default is 1000000 bytes.
8. RLSharedMem Shared memory for use in PowerMart Reject file loader.
Default is 6000000 bytes.
9. PMCacheDir Location used by PowerMart Server executables to
create temporary cache files. If the mapping uses
extensive aggregations, this location must point
to a directory in a filesystem with sufficient disk
space. Default is "." (current directory)
The following optional parameters are used if using PowerCapture
Server (pmpcserver). If not specified, the default value will be used.
Refer to he PowerCapture guide for a detailed descriptions of these
parameters.
10. CcmShmAllocMultiple The unit of allocation of shared memory by
pmpcserver. Default is 1000000
11. MaxCcInstances Maximum number of change capture instance.
Default is 10.
12. MaxMapPerInstance Maximum number of mappings associated with
an instance. Default is 10.
13. MaxSrcTblsPerMap Maximum number of source tables in a mapping.
Default is 10.
14. PrefetchCommitInterval The commit interval when prefetching rows
from non-primary source tables. Default is 100.
15. CcPerformEventLogging Enable/disable PowerCapture event logging.
Default is No.
16. CcEventLogFile File where PowerCapture events are logged.
Default is pmpc.log
17. CcErrorLogFile File where PowerCapture errors are logged.
Default is pmpc.err
18. ContinuousPowerCaptureSessionLogging
Enable/disable logging of PowerCapture sessions
running in continuous mode. Default is No.
The values for all these parameters can be specified using the pmconfig
utility. This utility is run as follows:
$ pmconfig [optional_configuration_file_name]
Database Verification
=====================
To check if the database client software needed to run PowerMart Server
is installed in your machine, you may use the pmverify utility. This
utility is run as follows:
$ pmverify
Bringing up PowerMart Server
============================
PowerMart Server is brought up by executing the command:
$ pmserver [[path]/config_file_name]
If no config_file_name is specified, pmserver will default to
pmserver.cfg. It is required that pmserver be seen in the PATH
environment variable of the user running pmserver.
Bringing up PowerCapture Server
===============================
$ pmpcserver <config_file_name>
If no config_file_name is specified, pmpcserver will use default
configuration file named pmserver.cfg.
Solaris Specific Information
============================
You must set the environment variable LD_LIBRARY_PATH to the directory where
PowerMart Server is installed. Assuming you have installed PowerMart
Server in $HOME/powermart, if you use bourne shell, this could be done
by:
$ LD_LIBRARY_PATH=$HOME/powermart; export LD_LIBRARY_PATH
or, if you use C shell, this could be done by:
% setenv LD_LIBRARY_PATH $HOME/powermart
AIX Specific Information
========================
You must set the environment variable LIBPATH to the directory where
PowerMart Server is installed. Assuming you have installed PowerMart
Server in $HOME/powermart, if you use bourne shell, this could be done
by:
$ LIBPATH=$HOME/powermart; export LIBPATH
or, if you use C shell, this could be done by:
% setenv LIBPATH $HOME/powermart
HP-UX Specific Information
==========================
You must set the environment variable SHLIB_PATH to the directory where
PowerMart Server is installed. Assuming you have installed PowerMart
Server in $HOME/powermart, if you use bourne shell, this could be done
by:
$ SHLIB_PATH=$HOME/powermart; export SHLIB_PATH
or, if you use C shell, this could be done by:
% setenv SHLIB_PATH $HOME/powermart
|