aoma=# select count(*) from aoma.amp.client_object_map; count -------- 129944 (1 row) aoma=# select count(*) from aoma.amp.request_entities; count ------- 47 (1 row) aoma=# select count(*) from aoma.amp.requests; count ------- 11627 (1 row) aoma=# select count(*) from aoma.amp.client_systems; count ------- 11 (1 row) aoma=# select * from aoma.amp.sym_table_reload_request order by last_update_time; target_node_id | source_node_id | trigger_id | router_id | reload_select | reload_time | create_time | last_update_by | last_update_time | create_table | delete_first | before_custom_sql | load_id | processed | channel_id ----------------+----------------+-----------------------------+-------------+---------------+---------------------------+---------------------------+----------------+------------------------+--------------+--------------+-------------------+---------+-----------+-------------- 001 | 000 | gras_trig_client_object_map | gras_router | | 13-FEB-18 23:30:19.214176 | 13-FEB-18 23:00:21.08906 | | 13-FEB-18 23:00:22.286 | 0 | 0 | | 5 | 1 | gras_channel 001 | 000 | gras_trig_request_entities | gras_router | | 13-FEB-18 23:30:19.214176 | 13-FEB-18 23:28:13.35091 | | 13-FEB-18 23:28:13.935 | 0 | 0 | | 6 | 1 | gras_channel 001 | 000 | gras_trig_requests | gras_router | | 13-FEB-18 23:30:19.214176 | 13-FEB-18 23:28:13.352735 | | 13-FEB-18 23:28:13.977 | 0 | 0 | | 7 | 1 | gras_channel 001 | 000 | gras_trig_client_systems | gras_router | | 13-FEB-18 23:30:19.214176 | 13-FEB-18 23:28:13.34328 | | 13-FEB-18 23:28:14.012 | 0 | 0 | | 8 | 1 | gras_channel 001 | 000 | gras_trig_client_object_map | gras_router | | 13-FEB-18 23:30:19.214176 | 13-FEB-18 23:28:13.354527 | | 13-FEB-18 23:28:14.023 | 0 | 0 | | 9 | 1 | gras_channel (5 rows) aoma=# select * from aoma.amp.sym_outgoing_batch where load_id in (select load_id from aoma.amp.sym_table_reload_request) ; batch_id | node_id | channel_id | status | error_flag | sql_state | sql_code | sql_message | last_update_hostname | last_update_time | create_time | summary | ignore_count | byte_count | load_flag | extract_count | sent_count | load_count | reload_row_count | other_row_count | data_row_count | extract_row_count | load_row_count | data_insert_row_count | data_update_row_count | data_delete_row_count | extract_insert_row_count | extract_update_row_count | extract_delete_row_count | load_insert_row_count | load_update_row_count | load_delete_row_count | network_millis | filter_millis | load_millis | router_millis | extract_millis | transform_extract_millis | transform_load_millis | load_id | common_flag | fallback_insert_count | fallback_update_count | ignore_row_count | missing_delete_count | skip_count | total_extract_millis | total_load_millis | extract_job_flag | extract_start_time | transfer_start_time | load_start_time | failed_data_id | failed_line_number | create_by ----------+---------+------------+--------+------------+-----------+----------+-------------+--------------------------------------+---------------------------+---------------------------+-------------------+--------------+------------+-----------+---------------+------------+------------+------------------+-----------------+----------------+-------------------+----------------+-----------------------+-----------------------+-----------------------+--------------------------+--------------------------+--------------------------+-----------------------+-----------------------+-----------------------+----------------+---------------+-------------+---------------+----------------+--------------------------+-----------------------+---------+-------------+-----------------------+-----------------------+------------------+----------------------+------------+----------------------+-------------------+------------------+------------------------+------------------------+------------------------+----------------+--------------------+----------- 13702 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:00:25.150748 | 13-FEB-18 23:00:22.28216 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 3 | 0 | 5 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:00:25.105 | 13-FEB-18 23:00:25.111 | 13-FEB-18 23:00:25.123 | 0 | 0 | 13703 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:00:25.203313 | 13-FEB-18 23:00:22.285696 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 2 | 0 | 4 | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:00:25.169 | 13-FEB-18 23:00:25.173 | 13-FEB-18 23:00:25.181 | 0 | 0 | 13713 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.39967 | 13-FEB-18 23:28:13.930891 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 3 | 10 | 0 | 8 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.346 | 13-FEB-18 23:28:15.354 | 13-FEB-18 23:28:15.37 | 0 | 0 | 13714 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.455605 | 13-FEB-18 23:28:13.935247 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 4 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.41 | 13-FEB-18 23:28:15.414 | 13-FEB-18 23:28:15.439 | 0 | 0 | 13715 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.496813 | 13-FEB-18 23:28:13.973486 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 4 | 0 | 3 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.466 | 13-FEB-18 23:28:15.469 | 13-FEB-18 23:28:15.478 | 0 | 0 | 13716 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.535395 | 13-FEB-18 23:28:13.976653 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.506 | 13-FEB-18 23:28:15.51 | 13-FEB-18 23:28:15.519 | 0 | 0 | 13717 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.575468 | 13-FEB-18 23:28:14.008192 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 3 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.546 | 13-FEB-18 23:28:15.549 | 13-FEB-18 23:28:15.558 | 0 | 0 | 13718 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.613084 | 13-FEB-18 23:28:14.011799 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.584 | 13-FEB-18 23:28:15.586 | 13-FEB-18 23:28:15.593 | 0 | 0 | 13719 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.654577 | 13-FEB-18 23:28:14.020722 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.625 | 13-FEB-18 23:28:15.627 | 13-FEB-18 23:28:15.637 | 0 | 0 | 13720 | 001 | reload | OK | 0 | | 0 | | degtlun5843.server.arvato-systems.de | 13-FEB-18 23:28:15.695883 | 13-FEB-18 23:28:14.023122 | sym_node_security | 0 | 484 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 3 | 0 | 3 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13-FEB-18 23:28:15.665 | 13-FEB-18 23:28:15.668 | 13-FEB-18 23:28:15.677 | 0 | 0 | (10 rows) aoma=# select * from aoma.amp.sym_channel order by 1; channel_id | processing_order | max_batch_size | max_batch_to_send | max_data_to_route | extract_period_millis | enabled | use_old_data_to_route | use_row_data_to_route | use_pk_data_to_route | reload_flag | file_sync_flag | contains_big_lob | batch_algorithm | data_loader_type | description | create_time | last_update_by | last_update_time | queue | max_network_kbps | data_event_action -----------------+------------------+----------------+-------------------+-------------------+-----------------------+---------+-----------------------+-----------------------+----------------------+-------------+----------------+------------------+------------------+------------------+------------------+---------------------------+----------------+---------------------------+---------+------------------+------------------- config | 0 | 2000 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | default | default | | 05-FEB-18 17:20:55.04 | | 05-FEB-18 17:20:55.032 | default | 0.000 | default | 99999 | 1000 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | default | default | | 05-FEB-18 17:20:55.047 | | 05-FEB-18 17:20:55.046 | default | 0.000 | dynamic | 99999 | 1000 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | default | default | | 05-FEB-18 17:20:55.049 | | 05-FEB-18 17:20:55.047 | default | 0.000 | filesync | 3 | 100 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | nontransactional | default | | 05-FEB-18 17:20:55.05 | | 05-FEB-18 17:20:55.049 | default | 0.000 | filesync_reload | 1 | 100 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | nontransactional | default | | 05-FEB-18 17:20:55.051 | | 05-FEB-18 17:20:55.051 | default | 0.000 | gras_channel | 1 | 100000 | 60 | 100000 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | transactional | default | AMP GRAS Channel | 05-FEB-18 17:25:06.434179 | svangal | 05-FEB-18 17:25:06.434179 | default | 0.000 | monitor | 2 | 100 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | default | default | | 12-FEB-18 12:41:06.32 | | 12-FEB-18 12:41:06.316 | default | 0.000 | heartbeat | 2 | 100 | 100 | 10000 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | default | default | | 05-FEB-18 17:20:55.044 | | 05-FEB-18 17:20:55.043 | default | 0.000 | reload | 1 | 1 | 1 | 10000 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | default | default | | 05-FEB-18 17:20:55.042 | | 05-FEB-18 17:20:55.042 | default | 0.000 | (9 rows)