The semantics of type 2 connection management are determined by a set of precompiler options. These are summarized briefly below with the defaults indicated by bold and underlined text. For details refer to the Command Reference or Administrative API Reference manuals.
Specifies whether CONNECT statements are to be processed as type 1 or type 2.
Specifies whether type 2 CONNECTs should be processed according to the DB2 rules which allow CONNECT to switch to a dormant connection, or the SQL92 Standard (STD) rules which do not allow this.
Specifies what database connections are disconnected when a commit operation occurs. They are either:
Specifies how commits or rollbacks are to be coordinated among multiple database connections.
Any of the above options can be overridden at run time using a special SET CLIENT application programming interface (API). Their current settings can be obtained using the special QUERY CLIENT API. Note that these are not SQL statements; they are APIs defined in the various host languages and in the Command Line Processor. These are defined in the Command Reference and Administrative API Reference manuals.
Different systems represent data in different ways. When data is moved from one system to another, data conversion sometimes must be performed. Products supporting DRDA will automatically perform any necessary conversions at the receiving system.
With numeric data, the information needed to perform the conversion is the data type of the data and how that data type is represented by the sending system. With character data, additional information is needed to convert character strings. String conversion depends on both the code page of the data and the operation that is to be performed with that data. Character conversions are performed in accordance with the IBM Character Data Representation Architecture (CDRA). For more information on character conversion, refer to Character Data Representation Architecture Reference SC09-1390.