Spreadsheet: daren_farmer__6518__Final_1-1-00
Sheet: DBA Notes

Refreshes by Global System and Interface
SAP
Global  : This interface is done via snapshots and stored procedures.  This refresh can only be done AFTER sap has refreshed their cross-reference server.
 | [NAME]: | moe
 | Refresh job:  /common/dba/server/oracle/bin/refresh_sap_gbl.ksh –g gdb –l GCP_LOGIN –g SAP_GROUP
 | Normal Refresh Schedule
 |  | 5AM, 2PM, 5PM – at 30 minutes past the hour
Global Counterparties
TAGG/ERMS:  These interfaces have both views and snapshots on their side.
Refresh host:  [NAME]
Refresh job:  /common/dba/server/oracle/bin/refresh_ss.ksh –s ermt –l GCP_REMOTE_LOGIN –n GCP_GROUP –m f –g
Normal Refresh Schedule:
 |  | 6AM – 9M,    at 20 and 50 minutes after the hour
 |  | 3AM, 5AM, 11PM – on the hour
DCAFII:  This interface has both views and snapshots on their side
 | Refresh host:  aurora
 | Refresh job:  /common/dba/server/oracle/bin/refresh_ss.ksh –s dcfprod –l GCP_REMOTE_LOGIN –n GCP_GROUP –m f –g
 | Normal Refresh Schedule:
 |  | 11AM, 8PM – at 15 minutes after the hour
*** For [NAME] certain users have the capability of performing this via their application
ENPOWER (Houston):  This interface utilizes views and poor-man’s replication
 | Refresh host:  neutron (pwrprod1)
 | Refresh job: /u301/home/dba/oracle/admin/pwrprod1/bin/refresh_lookup.ksh –s pwrprod1
 | Normal Refresh Schedule:
 |  | 3AM
 | Refresh host:  moe (pwrprod2)
 | Refresh job:  /u201/home/dba/oracle/admin/pwrprod2/bin/refresh_lookup.ksh –s pwprod2 –b NA
 | Normal Refresh Schedule:
 |  | 3AM – on the hour
ENPOWER (London):  This interface utilizes views and poor-man’s replication
 | Refresh host:  neutron (europwrp)
 | Refresh job: /u301/home/dba/oracle/admin/europwrp/bin/refresh_lookup.ksh –s europwrp
 | Normal Refresh Schedule:
 |  | 6PM – on the hour
Global Contracts
*** For [NAME] certain users have the capability of performing this via their application
This job for Enpower will refresh Counterparties and Contracts data (both)
ENPOWER (Houston):  This interface utilizes views and poor-man’s replication
 | Refresh host:  neutron (pwrprod1)
 | Refresh job: /u301/home/dba/oracle/admin/pwrprod1/bin/refresh_lookup.ksh –s pwrprod1
 | Normal Refresh Schedule:
 |  | 3AM
 | Refresh host:  moe (pwrprod2)
 | Refresh job:  /u201/home/dba/oracle/admin/pwrprod2/bin/refresh_lookup.ksh –s pwprod2 –b NA
 | Normal Refresh Schedule:
 |  | 3AM – on the hour
ENPOWER (London):  This interface utilizes views and poor-man’s replication
 | Refresh host:  neutron (europwrp)
 | Refresh job: /u301/home/dba/oracle/admin/europwrp/bin/refresh_lookup.ksh –s europwrp
 | Normal Refresh Schedule:
 |  | 6PM – on the hour
Global Facilities
TAGG/ERMS:  These interfaces have both views and snapshots on their side.
Refresh host:  [NAME]
Refresh job:  /common/dba/server/oracle/bin/refresh_ss.ksh –s ermt –l [NAME] –n GFD_GROUP –m f –g
Normal Refresh Schedule:
 |  | 6AM – 9M,    at 5 and 35 minutes after the hour
 |  | 3AM, 5AM, 11PM – at 40 minutes after the hour
*** For [NAME] certain users have the capability of performing this via their application
ENPOWER (Houston):  This interface utilizes snapshots
 | Refresh host:  neutron (pwrprod1)
 | Refresh job: /common/dba/server/oracle/bin/refresh_ss.ksh –s pwrprod1 –l PWR_LOGIN –n GFD_GROUP –m f –g
 | Normal Refresh Schedule:
 |  | 8PM
 | Refresh host:  moe (pwrprod2)
 | Refresh job: /common/dba/server/oracle/bin/refresh_ss.ksh –s pwrprod2 –l PWR_LOGIN –n GFD_GROUP –m f –g
 | Normal Refresh Schedule:
 |  | 8PM – on the hour
ENPOWER (London):  This interface utilizes snapshots
 | Refresh host:  neutron (europwrp)
 | Refresh job: //common/dba/server/oracle/bin/refresh_ss.ksh –s europwrp –l PWR_LOGIN –n GFD_GROUP –m f –g
 | Normal Refresh Schedule:
 |  | 7PM – on the hour
Trading Decision Support (TDS) :  This interface utilizes snapshots
 | Refresh host:  neutron (tdsprod)
 | Refresh job: //common/dba/server/oracle/bin/refresh_ss.ksh –s tdsprod –l CDS_LOGIN –n GFD_GROUP –m f –g
 | Normal Refresh Schedule:
 |  | 3AM – 30 minutes after the hour