CRT.SHK

Question 1

How to perform Seahawk FeedCutoff?

Answer 1

1. Stop env - fm.py DCRM_LIVE1 -s
2. Run feed cutoff - EagleMaintenance.exe -PFC -D YYYYMMDD
3. Adjust Feed Cutoff: adjustfeedcutoff DCRM_LIVE1
4. Validate Feed Cutoff: SELECT * FROM Core..FeedSet
5. Start env: fm.py DCRM_LIVE1 -S

Question 2

2 tables to retrieve Cparty data

Answer 2

SELECT * FROM SDSCopy.Cparty WHERE Id = XXX

SELECT * FROM Core..ParcelCparty WHERE CpartyId = XXX

Question 3

2 tables for trade investigation using CpartyID and FeedID

Answer 3

SELECT * from Core..TradeDetail where CpartyId = XX AND FeedSetID = YY

SELECT * FROM Core..TradeValuationDetail WHERE NettingCpartyId = XX AND FeedSetID = YY

Question 4

Where to get the FeedID?

Answer 4

SELECT * FROM Core..FeedSet WHERE BusDate = XX

Question 5

3 things to check for QARisk2Engine Valuation errors

Answer 5

1. Disable PV Caching on grid
   SELECT * FROM dbo.PDSRiskCachePP WHERE CpartyId = XX
2. Batch using lesser market state
   SELECT * FROM dbo.CpartyRiskMetricTaskBatching WHERE CpartyId = XX
3. HPC Distribution
   SELECT * FROM Core..CpartyHPCQANumberOfBatchesConf WHERE CpartyId = XX