ingest（国外英文资料）.docVIP

ingest（国外英文资料） DB2 10 new features: Continue Data Ingest client tools Introduction: the INGEST application is a new concept in DB2 Galileo (the development code for DB2 10), which is a client-side tool. Users can IMPORT data from INGEST, which has similar functions to LOAD, IMPORT. It is easy to install and can connect and operate with a low version of the database Server. The introduction INGEST is DB2 Galileo (DB2 10 development code) of the new features, is in order to have a lot of ongoing data flow to the real-time and concurrent import data quickly and introduce a new concept. This prevents the data from being locked and can operate on the database for 24 hours. INGEST has a data repair function that can find a breakpoint when data is interrupted and can continue to import data. INGEST supports complex SQL expression syntax and is a more useful client-side software. Users can use INGEST for Insert, Update, Delete, Replace, and Merge operations to facilitate customer service. INGEST introduction INGEST support files and two types of input pipe, two data format support DEL, ASC, support SQL expressions, support Insert, Update, Replace, Delete, and Merge operations, support the concurrent changes, Insert, Delete, can according to the interval number to submit the data or data bar. INGEST inserts unplugged data into files, tables, or simply discarded, supporting fixes and restarts. INGEST supports ESE, PureScale, DPF environment. The INGEST and data engine USES standardized external interfaces, a multi-threaded tool that is fast and efficient. INGEST supports a wide variety of tables, but does not support AQT (accelerated query tables), CGTT/DGTT (created or declared global temporary tables, typed tables) and typed views. At the same time, INGEST does not support LOB (BLOB, CLOB, DBCLOB), XML, structured types, and based on these custom data types. The INGEST tool has the following commands: ? INGEST for data import, the simplest syntax is: The is - DATA - -- |