autocommit 설정

by 바람바람 posted Jan 03, 2013

CUBRIDTransaction dbTrans = dbConn.BeginTransaction();

 

LOOP

     UPDATE TBL_POWER_NOW SET ????

 

dbTrans.Commit();

 

 

 

아래는 브로커 로그 입니다. 로그를 트랜잭션 기반으로  분석한건데 set_db_parameter auto_commit 1로 되어 있는거로 봐서는 위 프로그램

에서 트랜잭션을 쓰는 의미가 없을 듯 한데요 맞나요?

auto_commit 을 어떻게 off 시키나요? 

브로커마다 따로따로 설정 가능한가요?

 

 

C:CUBRID/log/broker/sql_log/xfra_broker_1.sql.log:32
01/02 15:32:43.921 (0) set_db_parameter auto_commit 1
01/02 15:32:43.921 (0) get_db_parameter isolation_level 1
01/02 15:32:43.921 (0) set_db_parameter isolation_level 1
01/02 15:32:43.921 (2) prepare 0 SELECT * FROM TBL_POWER_NOW
01/02 15:32:43.922 (2) prepare srv_h_id 1 (PC)
01/02 15:32:43.922 (2) set query timeout to 0 (no limit)
01/02 15:32:43.922 (2) execute srv_h_id 1 SELECT * FROM TBL_POWER_NOW
01/02 15:32:43.929 (2) execute 0 tuple 828 time 0.006
01/02 15:32:43.929 (2) fetch srv_h_id 1 cursor_pos 127 fetch_count 0
01/02 15:32:43.931 (2) fetch srv_h_id 1 cursor_pos 253 fetch_count 0
01/02 15:32:43.934 (2) fetch srv_h_id 1 cursor_pos 379 fetch_count 0
01/02 15:32:43.936 (2) fetch srv_h_id 1 cursor_pos 505 fetch_count 0
01/02 15:32:43.937 (2) fetch srv_h_id 1 cursor_pos 631 fetch_count 0
01/02 15:32:43.938 (2) fetch srv_h_id 1 cursor_pos 757 fetch_count 0
01/02 15:32:43.939 (2) next_result 1
01/02 15:32:43.939 (2) close_req_handle srv_h_id 1
01/02 15:32:43.940 (3) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=930, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=31
01/02 15:32:43.941 (3) prepare srv_h_id 1 (PC)
01/02 15:32:43.941 (3) set query timeout to 0 (no limit)
01/02 15:32:43.941 (3) execute srv_h_id 1 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=930, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=31
01/02 15:32:43.944 (3) execute 0 tuple 1 time 0.003
01/02 15:32:43.945 (4) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=937, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=937, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=32
01/02 15:32:43.945 (4) prepare srv_h_id 2 (PC)
01/02 15:32:43.945 (4) set query timeout to 0 (no limit)
01/02 15:32:43.945 (4) execute srv_h_id 2 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=937, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=937, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=32
01/02 15:32:43.948 (4) execute 0 tuple 1 time 0.003
01/02 15:32:43.949 (5) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=968, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=968, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=33
01/02 15:32:43.949 (5) prepare srv_h_id 3 (PC)
01/02 15:32:43.949 (5) set query timeout to 0 (no limit)
01/02 15:32:43.949 (5) execute srv_h_id 3 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=968, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=968, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=33
01/02 15:32:43.953 (5) execute 0 tuple 1 time 0.004
01/02 15:32:43.953 (6) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=34
01/02 15:32:43.954 (6) prepare srv_h_id 4 (PC)
01/02 15:32:43.954 (6) set query timeout to 0 (no limit)
01/02 15:32:43.954 (6) execute srv_h_id 4 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=34
01/02 15:32:43.957 (6) execute 0 tuple 1 time 0.003
01/02 15:32:43.957 (7) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=929, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=929, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=35
01/02 15:32:43.958 (7) prepare srv_h_id 5 (PC)
01/02 15:32:43.958 (7) set query timeout to 0 (no limit)
01/02 15:32:43.958 (7) execute srv_h_id 5 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=929, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=929, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=35
01/02 15:32:43.961 (7) execute 0 tuple 1 time 0.003
01/02 15:32:43.962 (8) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=950, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=36
01/02 15:32:43.962 (8) prepare srv_h_id 6 (PC)
01/02 15:32:43.962 (8) set query timeout to 0 (no limit)
01/02 15:32:43.962 (8) execute srv_h_id 6 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=950, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=36
01/02 15:32:43.966 (8) execute 0 tuple 1 time 0.004
01/02 15:32:43.966 (9) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=948, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=948, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=37
01/02 15:32:43.966 (9) prepare srv_h_id 7 (PC)
01/02 15:32:43.966 (9) set query timeout to 0 (no limit)
01/02 15:32:43.966 (9) execute srv_h_id 7 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=948, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=948, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=37
01/02 15:32:43.970 (9) execute 0 tuple 1 time 0.004
01/02 15:32:43.970 (10) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=902, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=902, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=38
01/02 15:32:43.971 (10) prepare srv_h_id 8 (PC)
01/02 15:32:43.971 (10) set query timeout to 0 (no limit)
01/02 15:32:43.971 (10) execute srv_h_id 8 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=902, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=902, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=38
01/02 15:32:43.974 (10) execute 0 tuple 1 time 0.003
01/02 15:32:43.974 (11) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=947, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=947, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=39
01/02 15:32:43.975 (11) prepare srv_h_id 9 (PC)
01/02 15:32:43.975 (11) set query timeout to 0 (no limit)
01/02 15:32:43.975 (11) execute srv_h_id 9 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=947, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=947, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=39
01/02 15:32:43.978 (11) execute 0 tuple 1 time 0.003
01/02 15:32:43.979 (12) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=965, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=40
01/02 15:32:43.979 (12) prepare srv_h_id 10 (PC)
01/02 15:32:43.979 (12) set query timeout to 0 (no limit)
01/02 15:32:43.979 (12) execute srv_h_id 10 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=965, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=40
01/02 15:32:43.983 (12) execute 0 tuple 1 time 0.004
01/02 15:32:43.983 (13) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=927, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=927, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=41
01/02 15:32:43.983 (13) prepare srv_h_id 11 (PC)
01/02 15:32:43.983 (13) set query timeout to 0 (no limit)
01/02 15:32:43.983 (13) execute srv_h_id 11 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=927, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=927, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=41
01/02 15:32:43.987 (13) execute 0 tuple 1 time 0.004
01/02 15:32:43.987 (14) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=954, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=954, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=42
01/02 15:32:43.987 (14) prepare srv_h_id 12 (PC)
01/02 15:32:43.988 (14) set query timeout to 0 (no limit)
01/02 15:32:43.988 (14) execute srv_h_id 12 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=954, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=954, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=42
01/02 15:32:43.991 (14) execute 0 tuple 1 time 0.003
01/02 15:32:43.991 (15) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=979, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=979, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=43
01/02 15:32:43.992 (15) prepare srv_h_id 13 (PC)
01/02 15:32:43.992 (15) set query timeout to 0 (no limit)
01/02 15:32:43.992 (15) execute srv_h_id 13 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=979, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=979, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=43
01/02 15:32:43.995 (15) execute 0 tuple 1 time 0.003
01/02 15:32:43.995 (16) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=44
01/02 15:32:43.996 (16) prepare srv_h_id 14 (PC)
01/02 15:32:43.996 (16) set query timeout to 0 (no limit)
01/02 15:32:43.996 (16) execute srv_h_id 14 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=935, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=935, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=44
01/02 15:32:43.999 (16) execute 0 tuple 1 time 0.003
01/02 15:32:43.999 (17) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=922, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=922, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=45
01/02 15:32:44.000 (17) prepare srv_h_id 15 (PC)
01/02 15:32:44.000 (17) set query timeout to 0 (no limit)
01/02 15:32:44.000 (17) execute srv_h_id 15 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=922, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=922, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=45
01/02 15:32:44.003 (17) execute 0 tuple 1 time 0.003
01/02 15:32:44.004 (18) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=920, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=920, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=46
01/02 15:32:44.004 (18) prepare srv_h_id 16 (PC)
01/02 15:32:44.004 (18) set query timeout to 0 (no limit)
01/02 15:32:44.004 (18) execute srv_h_id 16 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=920, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=920, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=46
01/02 15:32:44.008 (18) execute 0 tuple 1 time 0.004
01/02 15:32:44.008 (19) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=993, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=993, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=47
01/02 15:32:44.008 (19) prepare srv_h_id 17 (PC)
01/02 15:32:44.008 (19) set query timeout to 0 (no limit)
01/02 15:32:44.008 (19) execute srv_h_id 17 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=993, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=993, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=47
01/02 15:32:44.012 (19) execute 0 tuple 1 time 0.003
01/02 15:32:44.012 (20) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=957, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=957, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=48
01/02 15:32:44.013 (20) prepare srv_h_id 18 (PC)
01/02 15:32:44.013 (20) set query timeout to 0 (no limit)
01/02 15:32:44.013 (20) execute srv_h_id 18 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=957, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=957, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=48
01/02 15:32:44.016 (20) execute 0 tuple 1 time 0.003
01/02 15:32:44.016 (21) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=965, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=49
01/02 15:32:44.017 (21) prepare srv_h_id 19 (PC)
01/02 15:32:44.017 (21) set query timeout to 0 (no limit)
01/02 15:32:44.017 (21) execute srv_h_id 19 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=965, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=965, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=49
01/02 15:32:44.020 (21) execute 0 tuple 1 time 0.003
01/02 15:32:44.021 (22) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=951, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=951, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=50
01/02 15:32:44.021 (22) prepare srv_h_id 20 (PC)
01/02 15:32:44.021 (22) set query timeout to 0 (no limit)
01/02 15:32:44.021 (22) execute srv_h_id 20 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=951, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=951, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=50
01/02 15:32:44.025 (22) execute 0 tuple 1 time 0.004
01/02 15:32:44.025 (23) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=773, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=773, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=70
01/02 15:32:44.025 (23) prepare srv_h_id 21 (PC)
01/02 15:32:44.025 (23) set query timeout to 0 (no limit)
01/02 15:32:44.025 (23) execute srv_h_id 21 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=773, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=773, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=70
01/02 15:32:44.029 (23) execute 0 tuple 1 time 0.004
01/02 15:32:44.029 (24) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=790, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=790, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=71
01/02 15:32:44.029 (24) prepare srv_h_id 22 (PC)
01/02 15:32:44.030 (24) set query timeout to 0 (no limit)
01/02 15:32:44.030 (24) execute srv_h_id 22 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=790, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=790, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=71
01/02 15:32:44.033 (24) execute 0 tuple 1 time 0.003
01/02 15:32:44.033 (25) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=769, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=769, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=72
01/02 15:32:44.034 (25) prepare srv_h_id 23 (PC)
01/02 15:32:44.034 (25) set query timeout to 0 (no limit)
01/02 15:32:44.034 (25) execute srv_h_id 23 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=769, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=769, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=72
01/02 15:32:44.037 (25) execute 0 tuple 1 time 0.003
01/02 15:32:44.037 (26) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=945, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=945, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=1
01/02 15:32:44.038 (26) prepare srv_h_id 24 (PC)
01/02 15:32:44.038 (26) set query timeout to 0 (no limit)
01/02 15:32:44.038 (26) execute srv_h_id 24 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=945, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=945, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=1
01/02 15:32:44.041 (26) execute 0 tuple 1 time 0.003
01/02 15:32:44.042 (27) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=886, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=886, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=2
01/02 15:32:44.042 (27) prepare srv_h_id 25 (PC)
01/02 15:32:44.042 (27) set query timeout to 0 (no limit)
01/02 15:32:44.042 (27) execute srv_h_id 25 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=886, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=886, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=2
01/02 15:32:44.046 (27) execute 0 tuple 1 time 0.004
01/02 15:32:44.046 (28) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=950, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=3
01/02 15:32:44.046 (28) prepare srv_h_id 26 (PC)
01/02 15:32:44.046 (28) set query timeout to 0 (no limit)
01/02 15:32:44.046 (28) execute srv_h_id 26 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=950, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=3
01/02 15:32:44.050 (28) execute 0 tuple 1 time 0.004
01/02 15:32:44.050 (29) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=950, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=4
01/02 15:32:44.050 (29) prepare srv_h_id 27 (PC)
01/02 15:32:44.051 (29) set query timeout to 0 (no limit)
01/02 15:32:44.051 (29) execute srv_h_id 27 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=950, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=950, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=4
01/02 15:32:44.054 (29) execute 0 tuple 1 time 0.003
01/02 15:32:44.054 (30) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=959, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=5
01/02 15:32:44.055 (30) prepare srv_h_id 28 (PC)
01/02 15:32:44.055 (30) set query timeout to 0 (no limit)
01/02 15:32:44.055 (30) execute srv_h_id 28 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=959, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=5
01/02 15:32:44.058 (30) execute 0 tuple 1 time 0.003
01/02 15:32:44.058 (31) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=984, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=984, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=6
01/02 15:32:44.059 (31) prepare srv_h_id 29 (PC)
01/02 15:32:44.059 (31) set query timeout to 0 (no limit)
01/02 15:32:44.059 (31) execute srv_h_id 29 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=984, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=984, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=6
01/02 15:32:44.062 (31) execute 0 tuple 1 time 0.003
01/02 15:32:44.062 (32) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=921, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=921, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=7
01/02 15:32:44.063 (32) prepare srv_h_id 30 (PC)
01/02 15:32:44.063 (32) set query timeout to 0 (no limit)
01/02 15:32:44.063 (32) execute srv_h_id 30 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=921, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=921, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=7
01/02 15:32:44.066 (32) execute 0 tuple 1 time 0.003
01/02 15:32:44.066 (33) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=938, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=938, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=8
01/02 15:32:44.067 (33) prepare srv_h_id 31 (PC)
01/02 15:32:44.067 (33) set query timeout to 0 (no limit)
01/02 15:32:44.067 (33) execute srv_h_id 31 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=938, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=938, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=8
01/02 15:32:44.070 (33) execute 0 tuple 1 time 0.003
01/02 15:32:44.071 (34) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=973, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=973, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=9
01/02 15:32:44.071 (34) prepare srv_h_id 32 (PC)
01/02 15:32:44.071 (34) set query timeout to 0 (no limit)
01/02 15:32:44.071 (34) execute srv_h_id 32 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=973, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=973, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=9
01/02 15:32:44.075 (34) execute 0 tuple 1 time 0.004
01/02 15:32:44.075 (35) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=930, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=10
01/02 15:32:44.076 (35) prepare srv_h_id 33 (PC)
01/02 15:32:44.076 (35) set query timeout to 0 (no limit)
01/02 15:32:44.076 (35) execute srv_h_id 33 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=0, ACTIVE_POWER=0, POWER_ACT=930, APPARENT_POWER=0, REACTIVE_POWER=0, POWER_REA=930, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=10
01/02 15:32:44.079 (35) execute 0 tuple 1 time 0.003
01/02 15:32:44.079 (36) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=959, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=11
01/02 15:32:44.080 (36) prepare srv_h_id 34 (PC)
01/02 15:32:44.080 (36) set query timeout to 0 (no limit)
01/02 15:32:44.080 (36) execute srv_h_id 34 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=959, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=959, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=11
01/02 15:32:44.083 (36) execute 0 tuple 1 time 0.003
01/02 15:32:44.083 (37) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=961, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=961, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=12
01/02 15:32:44.084 (37) prepare srv_h_id 35 (PC)
01/02 15:32:44.084 (37) set query timeout to 0 (no limit)
01/02 15:32:44.084 (37) execute srv_h_id 35 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=961, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=961, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=12
01/02 15:32:44.087 (37) execute 0 tuple 1 time 0.003
01/02 15:32:44.088 (38) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=977, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=977, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=13
01/02 15:32:44.088 (38) prepare srv_h_id 36 (PC)
01/02 15:32:44.088 (38) set query timeout to 0 (no limit)
01/02 15:32:44.088 (38) execute srv_h_id 36 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=977, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=977, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=13
01/02 15:32:44.092 (38) execute 0 tuple 1 time 0.004
01/02 15:32:44.092 (39) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=982, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=982, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=14
01/02 15:32:44.092 (39) prepare srv_h_id 37 (PC)
01/02 15:32:44.092 (39) set query timeout to 0 (no limit)
01/02 15:32:44.092 (39) execute srv_h_id 37 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=982, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=982, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=14
01/02 15:32:44.096 (39) execute 0 tuple 1 time 0.004
01/02 15:32:44.096 (40) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=932, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=932, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=15
01/02 15:32:44.096 (40) prepare srv_h_id 38 (PC)
01/02 15:32:44.096 (40) set query timeout to 0 (no limit)
01/02 15:32:44.096 (40) execute srv_h_id 38 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=932, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=932, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=15
01/02 15:32:44.100 (40) execute 0 tuple 1 time 0.004
01/02 15:32:44.100 (41) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=899, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=899, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=16
01/02 15:32:44.100 (41) prepare srv_h_id 39 (PC)
01/02 15:32:44.100 (41) set query timeout to 0 (no limit)
01/02 15:32:44.100 (41) execute srv_h_id 39 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=16, ACTIVE_POWER=3318, POWER_ACT=899, APPARENT_POWER=3475, REACTIVE_POWER=979, POWER_REA=899, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=16
01/02 15:32:44.104 (41) execute 0 tuple 1 time 0.004
01/02 15:32:44.104 (42) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=934, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=934, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=17
01/02 15:32:44.104 (42) prepare srv_h_id 40 (PC)
01/02 15:32:44.105 (42) set query timeout to 0 (no limit)
01/02 15:32:44.105 (42) execute srv_h_id 40 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=13.16, ACTIVE_POWER=2268, POWER_ACT=934, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=934, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=17
01/02 15:32:44.108 (42) execute 0 tuple 1 time 0.003
01/02 15:32:44.108 (43) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=962, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=962, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=18
01/02 15:32:44.109 (43) prepare srv_h_id 41 (PC)
01/02 15:32:44.109 (43) set query timeout to 0 (no limit)
01/02 15:32:44.109 (43) execute srv_h_id 41 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=962, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=962, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=18
01/02 15:32:44.112 (43) execute 0 tuple 1 time 0.003
01/02 15:32:44.112 (44) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=996, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=996, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=19
01/02 15:32:44.113 (44) prepare srv_h_id 42 (PC)
01/02 15:32:44.113 (44) set query timeout to 0 (no limit)
01/02 15:32:44.113 (44) execute srv_h_id 42 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=4.56, ACTIVE_POWER=942, POWER_ACT=996, APPARENT_POWER=964, REACTIVE_POWER=294, POWER_REA=996, SYSTEM_STATUS=1000, FREQUENCY=59.7, POWER_FACTOR=0.95, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=19
01/02 15:32:44.116 (44) execute 0 tuple 1 time 0.003
01/02 15:32:44.116 (45) prepare 0 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=926, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=926, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=20
01/02 15:32:44.117 (45) prepare srv_h_id 43 (PC)
01/02 15:32:44.117 (45) set query timeout to 0 (no limit)
01/02 15:32:44.117 (45) execute srv_h_id 43 UPDATE TBL_POWER_NOW SET REG_DATE='2013-01-02 15:02:01', AMPERE=43.16, ACTIVE_POWER=2268, POWER_ACT=926, APPARENT_POWER=2804, REACTIVE_POWER=972, POWER_REA=926, SYSTEM_STATUS=1000, FREQUENCY=59.6, POWER_FACTOR=0.94, POWER_STATUS=0, VOLTAGE=101.1 WHERE PDMU_ID=640 AND CHANNEL_NUM=20
01/02 15:32:44.120 (45) execute 0 tuple 1 time 0.003
01/02 15:32:44.120 (0) end_tran COMMIT
01/02 15:32:44.120 (0) end_tran 0 time 0.000

 

 

 



 

 

 


Articles