CRT2013 Support Flashcards
List the 3 steps to check valuation failures
- Which parcel in a batch is failing?
SELECT * FROM dbo.NormalizedParcelTaskStatus
JOIN dbo.parcel on ParcelID
WHERE P.BELID and NP.ValuationSuccessfulFlag = F - Check parcel lifecycle
SELECT * FROM dbo.ParcelStep WHERE ParcelID - Check failing parcel history
SELECT * FROM dbo.NormalizedParcelTaskStatusHistory WHERE ParcelID
How to check the simulation override due to market data
- Check which subtask failing
SELECT * FROM dbo.NormalizdParcelTaskStatus WHERE ParcelID = XX - Simulation overriden?
SELECT * FROM dbo.ParcelValMsg WHERE ParcelID = XX - Market Data used?
SELECT * FROM dbo.ParcelValMsg
JOIN dboValMsgRisk ON ValMsgID
WHERE PV.SubTaskIndex = 3, 4, 5 AND ParcelID
How to get the baseline parcel count
SELECT PAR.BatchRunID, P.BatchExecutionLogId, P.ParcelID
FROM Core..Parcel JOIN Core..ParcelAutoRun
WHERE P.BusDate
How to get the subtask info for baseline
SELECT PAR.BatchRunIDm P.BatchExecutionLogID, NPTS. SubTaskIndex
FROM Core..Parel
JOIN Core..ParcelAutoRun ON ParcelID
JOIN Core..NormalizedParcelTaskStatus ON ParcelID
WHERE P.BusDate
How to get business date & pre date automatically
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]
How to check a table existence and delete it
IF Object_Id(‘TempDB..#tablename’) IS NULL
BEGIN
DROP TABLE #tablename
END
How to check the isCommitted message in Repube
SELECT * FROM SecDervisFeeds.Seahawk.Message
WHERE IsCommitted AND BatchExecutionLogID
How to get batch related info for each COB run
SELECT * FROM BatchConfig..BatchExecutionLog
WHERE BusinessDate
How to check active parcels grouped by farm
SELECT * FROM BatchConfig.BatchExecutionLog
JOIN Parcel ON BatchExecutionLogID
JOIN Static.System.MachineGroup ON P.AllocatedSystemEnvironmentID
WHERE P.BatchExecutionLogID and P.StatusID = 2
How to check for parcels with no allocated environment
SELECT * FROM dbo.Parcel
JOIN dbo.ParcelStatus ON ParcelID
WHERE BusDate, P.StateID = 2, P.AutomatedRunFlag = 1,
P.AllocatedSystemEnvID = NULL
How to check inconsistent baseline parcels based on names between 2 run IDs
SELECT PC.CpartyID, COUNT(PC.CpartyID)
FROM dbo.Parcel JOIN dbo.ParcelCparty ON ParcelID
WHERE BatchExecutionLogID
how to kill seahawk batch
Batchexecute.exe /env DCRM_LIVE1 /ID 8029 /logid 506323 /kill
how to kill seahawk batch
Batchexecute.exe /env DCRM_LIVE1 /ID 8029 /logid 506323 /kill
how to monitor tempdb
DBCC SQLPERF(LOGSPACE)
how to rebuild indexes and update statistics
ALTER INDEX ALL ON SecDervisFeed.Seahawk.MarketData REBUILD
UPDATE STATISTICS SecDerivFeeds.Seahawk.MarketData
how to find directories which have exceeded 50M
DIRUSE.EXE /* /M /Q:50M c:\
how to search for a text in commandline
find /I “oracle error” <filename></filename>
List out the machine name for LIVE1, PROD2, SD DB
LIVE1 = LDNPCM05099V05A PROD2 = LDNPCM05241V05A OWL = LDNPCM05880V05A
how to find more details on a SPID
dbcc inputbuffer(SPID)
how to check for open transactions
For all databases:
SELECT * FROM sysprocesses WHERE open_tran = 1
For current db:
DBCC OPENTRAN
List the tables to locate official curves and b-curves
[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)
How to stop, query, start up, stop a particular machine using fm.py
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
how to enable controllers
fm.py LIVE1 -e SeahawkController -m ldnpsmXXX ldnpsmYYY
how to the credit spread curve built for a name
EXEC CreditSpread.GetCreditSpreadCurve
@loadDate = YYYYMMDD,
@CpartyID = XXX
@pin_CreditCurveCategoryID = 2
