Hi,
We’re having problems with connection failures from Informatica to GP/PG. there’s nothing in the GP/PG log.
We’ve turned on the commlog trace in the odbc settings.
Can someone tell me where I can find the log location?
We’re running PsqlODBC 8.0.4 on solaris 10 sparc 64bit.
Our odbc.ini file
[GreenplumProd_Write]
Driver=/infa/GreenPlum/greenplum-connectivity/drivers/odbc/psqlodbc-08.02.0500/datadirect-52_32/psqlodbcw.so
#Driver=/infa/GreenPlum/connectivity-3.2-build-9981/drivers/odbc/psqlodbc-08.03.0400/unixodbc-2.2.12/psqlodbcw.so
#Driver=/infa/GreenPlum/connectivity-3.2-build-9981/psqlodbcw.so
Description=Greenplum Production - Read_Write
Servername=eggpdbvip.prod.orbitz.net
Port=5432
Database=p1gp1
Username=infa_write
Password=infagpwrite
UseDeclareFetch=0
Fetch=20000
Protocol=7.4-1
Trace=0
Debug=0
Readonly=No
Add
COMMLOG=1
Thanks
Doug Little
Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide
500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741
Douglas.Little@orbitz.com
orbitz.com | ebookers.com | hotelclub.com | cheaptickets.com | ratestogo.com | asiahotels.com