3.05 Collect Statistics on Oracle Repository Tables

Collect Statistics on Oracle Repository Tables   Collect statistics on your Power Centerrepository databases this will help to improve performance of fetches andwrites of repository data. Follow below steps.   Execute below queries: select ‘analyze table ‘, table_name, ‘ compute statistics;’ from user_tables wheretable_name like ‘OPB_%’ select ‘analyze index ‘, INDEX_NAME, ‘ compute statistics;’ from […]

3.10 How to Identify Throughput Issues

How to Identify Throughput Issues Ideally, how do you determine if your performance issues is due toread or write throughput of your session? Below are few typical issues thatresult in poor performance (low throughput values) TargetCommit Point is too small The default target commit point of 10000 is used when processinglarge data volumes. This results in commits […]

3.08 DTM Buffer Size

DTM Buffer Size Typically, the DTM Buffer Size is set to Auto, and the Auto MemorySettings are used to determine the value here. Occasionally it is useful to setthis higher, but never lower than the Auto Memory value of 512 MB. In olderversion of PowerCenter, or for sessions that are auto-generated, the value istypically set […]

3.09 Auto Memory Settings

Auto Memory Settings in Session Level   The session have settings for Maximum Memory Allowed for AutoMemory Attributes and Maximum Percentage Allowed for Auto Memory Attributes.Whichever is smaller is the amount used for items like the DTM buffer size,lookup cache, and other settings. The default is 512MB and 5% of the availableserver memory, whichever is […]

3.07 Informatica NFS File Systems

Informatica NFS File Systems Hello All,   As Informatica administrator, recommend admins to know information on file systems (Shared) on Informatica Servers, most of thejobs read/write on share shared file systems and this will cause Latency injobs and performance is degraded.   Below are few inputs on NFS from Informatica,please make sure to discuss with […]

EDF- Edifecs 9.0 Installation Steps on Linux Server.

Edifecs 9.0 Installation Steps on Linux Server. 1. XEngine Installation Steps. [user_efx@DEV2003 XE1]$./XEngineInstaller-linux-ix86_64Checking distribution…  [ OK ]Checking OS compatibility… [ OK ]Checking platform compatibility… [ OK ]Inspecting the system…Destination is /opt/Edifecs/9.0EDIFECS root is /opt/Edifecs/9.0Uninstalling older versions of XEngine… NOT FOUNDPerforming backup:Extracting files… [ OK ]Installing files… [ OK ]Setting environment variables:Updating [.profile]…  skipped (No such […]