CLIENT MASTER
  SELECT * FROM ENTITY_MASTER WHERE ENTITY_CODE='SAJ12';

NET POSITION
  SELECT * FROM NET_POSITION_TABLE WHERE NPT_EXCH_ID='NSE' AND NPT_SEGMENT='C';
  SELECT * FROM NET_POSITION_TABLE WHERE NPT_SEGMENT='C' AND NPT_EXCH_ID='NSE';

ERROR LOG
  SELECT * FROM FILE_ERROR_LOG;

FILE UPLOADS
  SELECT * FROM RMS_PROCESS_LOG;

SYS PARAM
  SELECT * FROM SYS_PARAMETERS;

VIEW LIMIT
  SELECT * FROM RMS_FUND_LIMIT;
  SELECT * FROM RMS_FUND_LIMIT WHERE CLIENT_ID='AC103';
  SELECT * FROM VIEW_CLIENT_LIMIT;

LTP
  SELECT * FROM L1_WATCH_ACTIVE WHERE L1_SCRIP_CODE = 11536;
  SELECT * FROM EQ_L1_WATCH WHERE L1_SCRIP_CODE = "11536";

VOLUME
  SELECT * FROM DRV_L1_WATCH WHERE DL1_SCRIP_CODE =37834;
  SELECT * FROM SECURITY_MASTER WHERE SM_EXCH_SYMBOL = 'GOLDM';
  SELECT * FROM SECURITY_MASTER WHERE SM_SCRIP_CODE = 2169747;
  SELECT * FROM BHAV_COPY WHERE BC_SCRIP_CODE='3045';

HOLDINGS
  SELECT * FROM RMS_CLIENT_SECURITY_LIMIT;

DRV ORDER
  SELECT * FROM DRV_ORDERS WHERE DRV_ORDER_NO LIKE '%3715';

COM ORDER
  SELECT * FROM COMM_ORDERS WHERE COMM_ORDER_NO LIKE '%2771';

EQ ORDER
  SELECT * FROM EQ_ORDERS WHERE EQ_ORDER_NO LIKE '%2418%';

QL TEMPLATE
  SELECT * FROM RMS_RISK_PROFILE_DET;

EXPOSURE
  SELECT *,SM_EXPOSER_PERC, SM_SELL_EXPOSER_PERC FROM SECURITY_MASTER WHERE SM_SCRIP_CODE=59229;

SPAN
  SELECT * FROM RMS_FNO_SPAN_MARGIN WHERE RSM_SECURITY_ID = '40702';

VAR ELM
  SELECT * FROM RMS_EQ_VAR_ELM WHERE SCRIP_ID= '3045';

DELETE CF POSITION
  DELETE FROM DRV_ORDERS WHERE DRV_CF_FLAG=-1;
  SELECT * FROM DRV_ORDERS WHERE DRV_CF_FLAG=-1;

MRV
  SELECT * FROM MRV_ORDERS WHERE MRV_CF_FLAG=-1;

GOLANG MAIL ID
  SELECT * FROM GO_CLIENT_MAIL_INFO;

SURVEILLANCE SCRIPTS
  SELECT * FROM NSE_GSM_TEMP;
  SELECT * FROM BSE_GSM_TEMP;
  SELECT * FROM SECURITY_RMS_BLOCK_DETAIL WHERE SCRIP_CODE = '540519';

CONFIG
  SELECT * FROM RMS_SCREEN_COLUMN_CONFIG;
  SELECT * FROM RMS_SCRIP_MARGIN_BASKET WHERE RSMB_BASKET_CODE= 'HIT';
  SELECT * FROM RMS_SCRIP_MARGIN_BASKET WHERE RSMB_BASKET_CODE= 'HIT' AND RSMB_PRODUCT='F';
  SELECT * FROM RMS_SCRIP_MARGIN_BASKET_FNO;

EXCHANGE CONNECTION
  SELECT * FROM EXCH_ADMINISTRATION_MASTER;

MTF BUYBACK
  SELECT RPM_MTF_BUY_BACK FROM RMS_RISK_PROFILE_MAST WHERE RPM_NAME='KTEST';

SURVEILLANCE MESSAGES
  SELECT * FROM SURVEILLANCE_MSG_DETAILS;

CHANGE EXPIRY MANUALLY
  SELECT * FROM SECURITY_MASTER WHERE SM_SCRIP_CODE='839212';
  SELECT * FROM SEM_ACTIVE WHERE SM_SCRIP_CODE = '839212';
  SELECT * FROM RMS_FNO_SPAN_MARGIN WHERE RSM_SECURITY_ID = '839212';

T+5
  SELECT ENTITY_SQ_OFF_MODE FROM ENTITY_MASTER WHERE ENTITY_CODE='F102';

EARLY PAYIN
  SELECT * FROM RMS_EARLY_PAYIN;


 PUTTY
   -----

				
         OTP	 web ---enter	
	         wslo	
	         enter ll	
	         vi loginOTPcheck.log	
	              or	
	         tail -f loginOTPcheck.log	
		
		
       exit without saving	escape :q!	
       save & exit	:wq	
 
       DB password	ITI_OMS_UAT:/home/rsapp/RMS_DELIVERY > vi DBconf.txt	
		
		
		
       start ApacheTomcat	RS_TEST_BORIVALI:/home/rsapp/Application/ApacheTomcat/bin > wsb1	
	                        RS_TEST_BORIVALI:/home/rsapp/Application/ApacheTomcat1/bin > ./startup.sh	
		
       start redis		
		
       pkill -9 (process name)	
		
       log	lo> vi log.NseCMExchAdap	
		
       rsapp>	telnet 172.19.245.107 10262	
	
	
   KAFKA 	
       command to check kafka running or not   pf kafka
       PATH	                               cd /home/rsapp/Application/KafkaServer	
	                                       cd Application/KafkaServer	
       to start kafka	                       ./RestartKafka.sh	

       PATH	                               cd /home/rsapp/Application/Exec/ShellScripts	
	                                       cd Application/Exec/ShellScripts	
	Old data delete                        ./KafkaQueDelete.sh	
	Fetch from DB                          ./KafkaRecon.sh	
		
		
		
         go>	./InMemRedis MCX M