Record Of A Day

연관데이터

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 SELECT TBL.OBJECT_NAME AS NAME, BIZ.OBJ_RMK9 AS BUSINESS, TBL.ABBR_NAME AS GLOBALNAME, SYS.ABBR_NAME AS SYSTEM, DOM.PARENT_ID AS PARENT_ID FROM ( SELECT DOM.* , SEC.ABBR_NAME AS SECNAME , BIZ.OBJECT_NAME AS BIZ_NAME , MPI.ID AS PARENT_ID FROM META_OBJECT DOM LEFT OUTER JOIN META_OBJECT SEC ON DOM.OBJ_IND12 = SEC.OBJECT_NAME AND SEC.CLASS_ID = 1304 LEFT OUTER JOIN META_OBJECT BIZ ON BIZ.OBJ_RMK2 = DOM.OBJECT_NAME AND BIZ.CLASS_ID = 13 LEFT OUTER JOIN metastream_domain_parent_info MPI ON DOM.OBJECT_ID::text = MPI. ID::text WHERE DOM.CLASS_ID = 5 ) DOM , META_OBJECT TBL , META_OBJECT COL , META_OBJECT SYS , META_OBJECT BIZ WHERE TBL.CLASS_ID = 210 AND TBL.OBJ_IND1 = '1' AND COL.CLASS_ID = 220 AND TBL.OBJECT_ID = COL.ORG_OBJECT_ID AND COL.OBJ_RMK2 = DOM.OBJECT_NAME AND DOM.BIZ_NAME = COL.OBJECT_NAME AND TBL.SYS_ID = SYS.OBJECT_NAME AND SYS.CLASS_ID = 1028 AND TBL.OBJ_RMK1 = BIZ.OBJ_RMK4 AND TBL.SYS_ID = BIZ.OBJ_RMK1 AND BIZ.CLASS_ID = 1018 cs

인덱싱설정

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 SELECT A.OBJECT_ID AS ID ,A.OBJECT_ID AS OBJECT_ID ,A.OBJECT_NAME AS NAME ,A.ABBR_NAME AS GLOBAL_NAME ,A.OBJ_RMK1 || '(' || A.OBJ_NO1 || ')' AS DOMAIN_DATA_TYPE ,CASE WHEN A.OBJ_RMK2 IS NULL THEN '-' ELSE A.OBJ_RMK2 END AS DOMAIN_NAME ,SYS.ABBR_NAME AS system ,BIZ.OBJ_RMK9 AS business ,A.CREATE_DT AS created ,A.MODIFY_DT AS updated ,'p' as ORDER_FIELD ,CASE WHEN COALESCE(B.PROPERTY_VAL, B. PROPERTY_LVAL) IS NULL THEN '-' ELSE COALESCE(B.PROPERTY_VAL, B. PROPERTY_LVAL) END AS definition ,CASE WHEN DPI.OBJ_RMK5 IS NULL THEN '-' ELSE DPI.OBJ_RMK5 END AS protection ,'Term' AS data_type ,'DBMS' AS DATA_STRUCTURE ,'Standard' AS TERM_TYPE ,'/standard/term/termMain.page?objid='|| A.OBJECT_ID AS META_TERM_URL FROM META_OBJECT A LEFT OUTER JOIN META_OBJECT SYS ON SYS.CLASS_ID = 1028 AND A.SYS_ID = SYS.OBJECT_NAME LEFT OUTER JOIN META_OBJECT BIZ ON BIZ.CLASS_ID = 1018 AND A.SYS_ID = BIZ.OBJ_RMK1 AND A.OBJ_RMK4 = BIZ.OBJ_RMK4 LEFT OUTER JOIN MOBJ_DESC B ON A.OBJECT_ID = B.OBJECT_ID AND B.PROPERTY_ID = 1303 LEFT OUTER JOIN MOBJ_INV DPI ON DPI.CLASS_ID = 20131150 AND DPI.OBJECT_ID2 = A.OBJECT_ID WHERE A.CLASS_ID = 1013 cs

프로세스 확인

alias pps='ps -ef | egrep '\''tomcat|opensearch|nginx'\'' | egrep -v '\''grep|tail -'\'' | cut -c1-180 | sort -k8; ss -an | egrep "8180|8280|8380|8480" | grep LISTEN'

디자인 바꿔라 AI딸깍으로 만들지 말고 괜찮은 템플릿 찾아서 똑같이 적용해라

ㅈㄱㄴ 지금 개구림;