CRT2013 Support

Question 0

List the 3 steps to check valuation failures

Answer 0

1. Which parcel in a batch is failing?
   SELECT * FROM dbo.NormalizedParcelTaskStatus
   JOIN dbo.parcel on ParcelID
   WHERE P.BELID and NP.ValuationSuccessfulFlag = F
2. Check parcel lifecycle
   SELECT * FROM dbo.ParcelStep WHERE ParcelID
3. Check failing parcel history
   SELECT * FROM dbo.NormalizedParcelTaskStatusHistory WHERE ParcelID

Question 1

How to check the simulation override due to market data

Answer 1

1. Check which subtask failing
   SELECT * FROM dbo.NormalizdParcelTaskStatus WHERE ParcelID = XX
2. Simulation overriden?
   SELECT * FROM dbo.ParcelValMsg WHERE ParcelID = XX
3. Market Data used?
   SELECT * FROM dbo.ParcelValMsg
   JOIN dboValMsgRisk ON ValMsgID
   WHERE PV.SubTaskIndex = 3, 4, 5 AND ParcelID

Question 2

How to get the baseline parcel count

Answer 2

SELECT PAR.BatchRunID, P.BatchExecutionLogId, P.ParcelID
FROM Core..Parcel JOIN Core..ParcelAutoRun
WHERE P.BusDate

Question 3

How to get the subtask info for baseline

Answer 3

SELECT PAR.BatchRunIDm P.BatchExecutionLogID, NPTS. SubTaskIndex
FROM Core..Parel
JOIN Core..ParcelAutoRun ON ParcelID
JOIN Core..NormalizedParcelTaskStatus ON ParcelID
WHERE P.BusDate

Question 4

How to get business date & pre date automatically

Answer 4

DECLARE @busdate DATETIME
DECLARE @predate DATETIME
SET @busdate = SELECT busdate from Core..BusDate
SET @predate = SELECT MAX(busdate) from Parcel WHERE BusDate < @busdate
SELECT CONVERT(VARCHAR, @predate, 112) AS [PRE DATE]

Question 5

How to check a table existence and delete it

Answer 5

IF Object_Id(‘TempDB..#tablename’) IS NULL
BEGIN
DROP TABLE #tablename
END

Question 6

How to check the isCommitted message in Repube

Answer 6

SELECT * FROM SecDervisFeeds.Seahawk.Message

WHERE IsCommitted AND BatchExecutionLogID

Question 7

How to get batch related info for each COB run

Answer 7

SELECT * FROM BatchConfig..BatchExecutionLog

WHERE BusinessDate

Question 8

How to check active parcels grouped by farm

Answer 8

SELECT * FROM BatchConfig.BatchExecutionLog
JOIN Parcel ON BatchExecutionLogID
JOIN Static.System.MachineGroup ON P.AllocatedSystemEnvironmentID
WHERE P.BatchExecutionLogID and P.StatusID = 2

Question 9

How to check for parcels with no allocated environment

Answer 9

SELECT * FROM dbo.Parcel
JOIN dbo.ParcelStatus ON ParcelID
WHERE BusDate, P.StateID = 2, P.AutomatedRunFlag = 1,
P.AllocatedSystemEnvID = NULL

Question 10

How to check inconsistent baseline parcels based on names between 2 run IDs

Answer 10

SELECT PC.CpartyID, COUNT(PC.CpartyID)
FROM dbo.Parcel JOIN dbo.ParcelCparty ON ParcelID
WHERE BatchExecutionLogID

Question 11

how to kill seahawk batch

Answer 11

Batchexecute.exe /env DCRM_LIVE1 /ID 8029 /logid 506323 /kill

Question 11

how to kill seahawk batch

Answer 11

Batchexecute.exe /env DCRM_LIVE1 /ID 8029 /logid 506323 /kill

Question 12

how to monitor tempdb

Answer 12

DBCC SQLPERF(LOGSPACE)

Question 13

how to rebuild indexes and update statistics

Answer 13

ALTER INDEX ALL ON SecDervisFeed.Seahawk.MarketData REBUILD

UPDATE STATISTICS SecDerivFeeds.Seahawk.MarketData

Question 14

how to find directories which have exceeded 50M

Answer 14

DIRUSE.EXE /* /M /Q:50M c:\

Question 15

how to search for a text in commandline

Answer 15

find /I “oracle error” <filename></filename>

Question 16

List out the machine name for LIVE1, PROD2, SD DB

Answer 16

LIVE1 = LDNPCM05099V05A
PROD2 = LDNPCM05241V05A
OWL = LDNPCM05880V05A

Question 17

how to find more details on a SPID

Answer 17

dbcc inputbuffer(SPID)

Question 18

how to check for open transactions

Answer 18

For all databases:
SELECT * FROM sysprocesses WHERE open_tran = 1
For current db:
DBCC OPENTRAN

Question 19

List the tables to locate official curves and b-curves

Answer 19

[BCurves]

SELECT COUNT(*) FROM CreditSpread.RT.DefaultSpreadCurve
WHERE LoadDate = (SELECT BusDate FROM Core.dbo.BusDate)

[Official Curves]

SELECT COUNT(*) FROM CreditSpread.dbo.CreditSpreadCurve
WHERE CurveDate = (SELECT BusDate FROM Core.dbo.BusDate)

Question 20

How to stop, query, start up, stop a particular machine using fm.py

Answer 20

To stop:
   fm.py LIVE1 -S
To startup 
   fm.py LIVE1 -s
To query:
   fm.py -i 
To stop a machne:
   fm.py LIVE1 -m ldnpsmXXX -S

Question 21

how to enable controllers

Answer 21

fm.py LIVE1 -e SeahawkController -m ldnpsmXXX ldnpsmYYY

Question 22

how to the credit spread curve built for a name

Answer 22

EXEC CreditSpread.GetCreditSpreadCurve
@loadDate = YYYYMMDD,
@CpartyID = XXX
@pin_CreditCurveCategoryID = 2

Question 23

Machine name for FAT controller

Answer 23

Ldnpsm020006306

Question 23

SQL 2008 CRT DB

Answer 23

Ldnpcm05069v05a\ DCRM_MAIN_LIVE

Question 24

Machine name for ETS

Answer 24

\ldnpsm028853\EnterpriseTradeStore

Question 25

Flat file for Market POD - no of files and what are they

Answer 25

11 files - 2 sets of CVA and FVA for Weekly, Daily and All, plus BCurves, credit curves and it’s definition, leader follower

Question 26

What are the flat files for ABSA?

Answer 26

6 files for Liquid and Illiquid with each set of FVA contingent, FVA non contingent and FC CVA

Question 27

What are the mars feeds?

Answer 27

Mars 5300 and 5305 in //dcrmfeedlive1/feeds/data
dcsenrtb_seahawk_d_yyyymmdd (dc sensitivity RTB)
dcrmpvbp_seahawk_d_yyyymmdd (dc rm pvbp)

Question 28

Machine name for dcrmfeedlive1

Answer 28

Ldnpsm020010449 ( 2001 0449 )

Question 29

While construct in SQL

Answer 29

While 1 = 1
Begin 
   Delete top (1000) from TableName 
   If @@rowcount < 1 break;
End

Question 30

Update stats command

Answer 30

Update statistics Tablename

Question 31

Index rebuild command

Answer 31

Alter index [IndexName] on [TableName] reorganize with ( lob_compaction = on )

Question 32

What happened when CVA straddle is zero, below 20k and greater than 20k.

Answer 32

When CVA straddle = zero, name is placed in inactive portfolio and run in new name
When CVA straddle less than 20k, the name runs in 100 batch
When CVA straddle greater than 20k, the name runs in low batch

Question 33

How to calculate CVA straddle?

Answer 33

Abs (( 2 x unilateral CVA) - Bilateral CVA

Question 34

Name the 2 table names used as a start when querying SecDerivFeeds

Answer 34

SecDerivFeeds.Seahawk.Message Join core.batchconfig.BatchExecutionLog On BatchExecutionLogID

Question 35

Name the 2 tables in SecDerivFeeds to find out CVA

Answer 35

SDF.seahawk.PDSMetrics and PDSMetricsTenor

Where PSDM.batchdate, PSDM.dirty = 0, PSDM,PDSMetricstype = CVA, PSDM.PDSMetricssubtype = bilateral

Question 36

Name the 2 tables in SDF to check if we got market data issue

Answer 36

SDF.seahawk.marketdata join SDF.seahawk.marketdatatenor on marketdataid
Where md.dataobjectid = ‘yield curve/usd\bma’

Question 37

How to find out which feeds were used by a particular FeedSet

Answer 37

Exec Core.ets.getTradeFeedCutoff @timestamp = ‘2013-05-25T18:36:17’,

Question 40

Which table stores trade activity summary

Answer 40

Billing.TradeaActivitySummary

Question 41

Which 3 tables stores the trade exclusion, whatif change and break clauses

Answer 41

For trade exclusion - Core.cpartyexcludedtradehistsory (deldatetime, cpartyid)
For whatif changes - Core.cpartyseahawktradehistory (eventdatetime, cpartyid)
For break clauses - Core.cpartybreakclausetradehistory (eventdatetime, cpartyid)

Question 42

Which table store the daily snapshot of netting data

Answer 42

Core.Netting