work:asics

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- work:asics [2018/03/09 06:10] – [서버] taekgu
+++ work:asics [2025/04/15 10:05] (현재) – 바깥 편집 127.0.0.1
@@ 줄 1: / 줄 1: @@
 ===== PIM & 고도화 =====
+==== 서버들 ====
-==== 서버 ====
+  * EC2-Dev : 13.124.6.106 : 172.22.245.28
-  - EC2-Dev : 13.124.6.106 : 172.22.245.28
+  * EC2-A1 : 13.124.112.148 : 172.22.246.23
-  - EC2-A1 : 13.124.112.148 : 172.22.246.23
+  * EC2-A2 : 13.124.39.254 : 172.22.246.61
-  - EC2-A2 : 13.124.39.254 : 172.22.246.61
+  * EC2-B1 : 13.124.78.150 : 172.22.246.24
-  - EC2-B1 : 13.124.78.150 : 172.22.246.24
+  * EC2-B2 : 52.78.226.92 : 172.22.246.60
-  - EC2-B2 : 52.78.226.92 : 172.22.246.60
+  * EC2-C1 : 52.78.16.109 : 172.22.246.5
-  - EC2-C1 : 52.78.16.109 : 172.22.246.5
+=== IP ===
+  * IP : 175.113.254.82
 === Server Group - C1 ===
@@ 줄 28: / 줄 29: @@
 if [ $CNT = 1 ] ; then
-	SERVER_INFO=$1
+ SERVER_INFO=$1
 fi
@@ 줄 66: / 줄 67: @@
 젠킨스 admin/adminq123
+==== Interface ====
+<code sql>
+ SELECT *
+ FROM IF_DOCD_BIZ@hanjin_ifdb
+ WHERE DOCH_NUM= 'HC201803140000000535'
+ AND WRK_DT='20180314'
+ AND  QTY = 0
+ and ord_num='2018031300595'
+</code>
+<code sql>
+ SELECT *
+ FROM IF_DOCD_BIZ@sinter_asics
+ WHERE DOCH_NUM= 'HC201803140000000535'
+ AND WRK_DT='20180314'
+ AND  QTY = 0
+ and ord_num='2018031300595'
+</code>

work/asics.1520575812.txt.gz · 마지막으로 수정됨: 2025/04/15 10:05 (바깥 편집)