A range-clustered table cannot be created in a database having more than one partition.
When creating a database, three table spaces are defined, including the SYSCATSPACE table space for the system catalog tables. The page size that becomes the default for all table spaces is set when the database is created. If a page size greater than 4096 or 4 K is chosen, the page size for the catalog tables is restricted to a row size that it would have if the catalog table space had a page size of 4 K. The default database page size is stored as an informational database configuration parameter called pagesize.
In Appendix B, "National language support (NLS)" in Administration Guide: Planning, the topic called "Supported territory codes and code pages" has tables for each territory. Two tables require updates:
The code page for the Linux GBK row in the "China (PRC), territory identifier: CN" table should be changed from 1383 to 1386.
That is, the row should now read:
1386 D-4 GBK 86 zh_CN.GBK Linux(R)
The table for " Japan, territory identifier: JP" has been revised.
The following locale name should be removed:
954 D-1 eucJP 81 japanese Solaris
Here is the revised table:
Code page | Group | Code set | Territory code | Locale | Operating system |
---|---|---|---|---|---|
932 | D-1 | IBM-932 | 81 | Ja_JP | AIX |
943 | D-1 | IBM-943 | 81 | Ja_JP | AIX |
954 | D-1 | IBM-eucJP | 81 | ja_JP | AIX |
1208 | N-1 | UTF-8 | 81 | JA_JP | AIX |
930 | D-1 | IBM-930 | 81 | - | Host |
939 | D-1 | IBM-939 | 81 | - | Host |
5026 | D-1 | IBM-5026 | 81 | - | Host |
5035 | D-1 | IBM-5035 | 81 | - | Host |
1390 | D-1 | 81 | - | Host | |
1399 | D-1 | 81 | - | Host | |
954 | D-1 | eucJP | 81 | ja_JP.eucJP | HP-UX |
5039 | D-1 | SJIS | 81 | ja_JP.SJIS | HP-UX |
954 | D-1 | EUC-JP | 81 | ja_JP | Linux |
932 | D-1 | IBM-932 | 81 | - | OS/2 |
942 | D-1 | IBM-942 | 81 | - | OS/2 |
943 | D-1 | IBM-943 | 81 | - | OS/2 |
954 | D-1 | eucJP | 81 | ja | SCO |
954 | D-1 | eucJP | 81 | ja_JP | SCO |
954 | D-1 | eucJP | 81 | ja_JP.EUC | SCO |
954 | D-1 | eucJP | 81 | ja_JP.eucJP | SCO |
943 | D-1 | IBM-943 | 81 | ja_JP.PCK | Solaris |
954 | D-1 | eucJP | 81 | ja | Solaris |
1208 | N-1 | UTF-8 | 81 | ja_JP.UTF-8 | Solaris |
943 | D-1 | IBM-943 | 81 | - | Windows |
1394 | D-1 | 81 | - |
DB2 Universal Database (UDB) supports the XA91 specification defined in X/Open CAE Specification Distributed Transaction Processing: The XA Specification, with the following exceptions:
The XA specification allows the interface to use asynchronous services, so that the result of a request can be checked at a later time. The database manager requires that the requests be invoked in synchronous mode.
The XA interface allows two ways to register an RM: static registration and dynamic registration. DB2 UDB supports both dynamic and static registration. DB2 UDB provides two switches:
DB2 UDB does not support transaction migration between threads of control.
As required by the XA interface, the database manager provides a db2xa_switch and a db2xa_switch_static external C variable of type xa_switch_t to return the XA switch structure to the TM. Other than the addresses of various XA functions, the following fields are returned:
Explicitly states that DB2 UDB uses dynamic registration, and that the TM should not use association migration. Implicitly states that asynchronous operation is not supported.
For db2xa_switch_static TMNOMIGRATE is set
Explicitly states that DB2 UDB uses dynamic registration, and that the TM should not use association migration. Implicitly states that asynchronous operation is not supported.
The XA architecture requires that a Resource Manager (RM) provide a switch that gives the XA Transaction Manager (TM) access to the RM's xa_ routines. An RM switch uses a structure called xa_switch_t. The switch contains the RM's name, non-NULL pointers to the RM's XA entry points, a flag, and a version number.
The switch for DB2 Universal Database (UDB) can be obtained through either of the following two ways:
#define db2xa_switch (*db2xa_switch) #define db2xa_switch_static (*db2xa_switch)prior to using db2xa_switch or db2xa_switch_static.
DB2 UDB provides these APIs, which return the address of the db2xa_switch or the db2xa_switch_static structure. This function is prototyped as:
struct xa_switch_t * SQL_API_FN db2xacic( ) struct xa_switch_t * SQL_API_FN db2xacicst( )
With either method, you must link your application with libdb2.
The pointer to the xa_switch structure, db2xa_switch, or db2xa_switch_static is exported as DLL data. This implies that a Windows NT application using this structure must reference it in one of three ways:
#define db2xa_switch (*db2xa_switch) #define db2xa_switch_static (*db2xa_switch)prior to using db2xa_switch or db2xa_switch_static.
extern __declspec(dllimport) struct xa_switch_t db2xa_switch extern __declspec(dllimport) struct xa_switch_t db2xa_switch_static
DB2 UDB provides this API, which returns the address of the db2xa_switch or db2xa_switch_static structure. This function is prototyped as:
struct xa_switch_t * SQL_API_FN db2xacic( ) struct xa_switch_t * SQL_API_FN db2xacicst( )
With any of these methods, you must link your application with db2api.lib.
The following code illustrates the different ways in which the db2xa_switch or db2xa_switch_static can be accessed via a C program on any DB2 UDB platform. Be sure to link your application with the appropriate library.
#include <stdio.h> #include <xa.h> struct xa_switch_t * SQL_API_FN db2xacic( ); #ifdef DECLSPEC_DEFN extern __declspec(dllimport) struct xa_switch_t db2xa_switch; #else #define db2xa_switch (*db2xa_switch) extern struct xa_switch_t db2xa_switch; #endif
main( ) { struct xa_switch_t *foo; printf ( "%s \n", db2xa_switch.name ); foo = db2xacic(); printf ( "%s \n", foo->name ); return ; }
The Internal settings column in the following table has been updated to reflect settings for the thread of control (TOC).
TOC is the entity to which all DB2 UDB XA connections are bound:
TPM value | TP monitor product | Internal settings |
---|---|---|
CICS | IBM TxSeries CICS |
AXLIB=libEncServer (for Windows) =/usr/lpp/encina/lib/libEncServer (for Linux and UNIX systems) HOLD_CURSOR=T CHAIN_END=T SUSPEND_CURSOR=F TOC=T |
ENCINA | IBM TxSeries Encina monitor |
AXLIB=libEncServer (for Windows) =/usr/lpp/encina/lib/libEncServer (for Linux and UNIX systems) HOLD_CURSOR=F CHAIN_END=T SUSPEND_CURSOR=F TOC=T |
MQ | IBM MQSeries |
AXLIB=mqmax (for Windows) =/usr/mqm/lib/libmqmax_r.a (for AIX threaded applications) =/usr/mqm/lib/libmqmax.a (for AIX non-threaded applications) =/opt/mqm/lib/libmqmax.so (for Solaris) =/opt/mqm/lib/libmqmax_r.sl (for HP threaded applications) =/opt/mqm/lib/libmqmax.sl (for HP non-threaded applications) =/opt/mqm/lib/libmqmax_r.so (for Linux threaded applications) =/opt/mqm/lib/libmqmax.so (for Linux non-threaded applications) HOLD_CURSOR=F CHAIN_END=F SUSPEND_CURSOR=F TOC=P |
CB | IBM Component Broker |
AXLIB=somtrx1i (for Windows) =libsomtrx1 (for Linux and UNIX systems) HOLD_CURSOR=F CHAIN_END=T SUSPEND_CURSOR=F TOC=T |
SF | IBM San Francisco |
AXLIB=ibmsfDB2 HOLD_CURSOR=F CHAIN_END=T SUSPEND_CURSOR=F TOC=T |
TUXEDO | BEA Tuxedo |
AXLIB=libtux HOLD_CURSOR=F CHAIN_END=F SUSPEND_CURSOR=F TOC=T |
MTS | Microsoft Transaction Server | It is not necessary to configure DB2 UDB for MTS. MTS is automatically detected by DB2 UDB's ODBC driver. |
JTA | Java Transaction API | It is not necessary to configure DB2 UDB for Enterprise Java Servers (EJS) such as IBM WebSphere. DB2 UDB's JDBC driver automatically detects this environment. Therefore this TPM value is ignored. |
The following table contains a list of all the code page conversion table files that are associated with code pages 923 and 924. Each file is of the form XXXXYYYY.cnv or ibmZZZZZ.ucs, where XXXXX is the source code page number and YYYY is the target code page number. The file ibmZZZZZ.ucs supports conversion between code page ZZZZZ and Unicode.
To activate a particular code page conversion table, rename or copy that conversion table file to its new name as shown in the second column.
For example, to support the euro symbol when connecting a 8859-1/15 (Latin 1/9) client to a Windows 1252 database, you need to rename or copy the following code page conversion table files in the sqllib/conv/ directory:
923 and 924 conversion table files in the sqllib/conv/ directory | New name |
---|---|
04370923.cnv | 04370819.cnv |
08500923.cnv | 08500819.cnv |
08600923.cnv | 08600819.cnv |
08630923.cnv | 08630819.cnv |
09230437.cnv | 08190437.cnv |
09230850.cnv | 08190850.cnv |
09230860.cnv | 08190860.cnv |
09231043.cnv | 08191043.cnv |
09231051.cnv | 08191051.cnv |
09231114.cnv | 08191114.cnv |
09231252.cnv | 08191252.cnv |
09231275.cnv | 08191275.cnv |
09241252.cnv | 10471252.cnv |
10430923.cnv | 10430819.cnv |
10510923.cnv | 10510819.cnv |
11140923.cnv | 11140819.cnv |
12520923.cnv | 12520819.cnv |
12750923.cnv | 12750819.cnv |
ibm00923.ucs | ibm00819.ucs |
The following tables list the conversion tables that have been enhanced to support the euro currency symbol. If you want to disable euro symbol support, download the conversion table file indicated in the column titled "Conversion table files".
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
864, 17248 | 1046, 9238 | 08641046.cnv, 10460864.cnv, IBM00864.ucs |
864, 17248 | 1256, 5352 | 08641256.cnv, 12560864.cnv, IBM00864.ucs |
864, 17248 | 1200, 1208, 13488, 17584 | IBM00864.ucs |
1046, 9238 | 864, 17248 | 10460864.cnv, 08641046.cnv, IBM01046.ucs |
1046, 9238 | 1089 | 10461089.cnv, 10891046.cnv, IBM01046.ucs |
1046, 9238 | 1256, 5352 | 10461256.cnv, 12561046.cnv, IBM01046.ucs |
1046, 9238 | 1200, 1208, 13488, 17584 | IBM01046.ucs |
1089 | 1046, 9238 | 10891046.cnv, 10461089.cnv |
1256, 5352 | 864, 17248 | 12560864.cnv, 08641256.cnv, IBM01256.ucs |
1256, 5352 | 1046, 9238 | 12561046.cnv, 10461256.cnv, IBM01256.ucs |
1256, 5352 | 1200, 1208, 13488, 17584 | IBM01256.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
921, 901 | 1257 | 09211257.cnv, 12570921.cnv, IBM00921.ucs |
921, 901 | 1200, 1208, 13488, 17584 | IBM00921.ucs |
1257, 5353 | 921, 901 | 12570921.cnv, 09211257.cnv, IBM01257.ucs |
1257, 5353 | 922, 902 | 12570922.cnv, 09221257.cnv, IBM01257.ucs |
1257, 5353 | 1200, 1208, 13488, 17584 | IBM01257.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
1131, 849 | 1251, 5347 | 11311251.cnv, 12511131.cnv |
1131, 849 | 1283 | 11311283.cnv |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
855, 872 | 866, 808 | 08550866.cnv, 08660855.cnv |
855, 872 | 1251, 5347 | 08551251.cnv, 12510855.cnv |
866, 808 | 855, 872 | 08660855.cnv, 08550866.cnv |
866, 808 | 1251, 5347 | 08661251.cnv, 12510866.cnv |
1251, 5347 | 855, 872 | 12510855.cnv, 08551251.cnv, IBM01251.ucs |
1251, 5347 | 866, 808 | 12510866.cnv, 08661251.cnv, IBM01251.ucs |
1251, 5347 | 1124 | 12511124.cnv, 11241251.cnv, IBM01251.ucs |
1251, 5347 | 1125, 848 | 12511125.cnv, 11251251.cnv, IBM01251.ucs |
1251, 5347 | 1131, 849 | 12511131.cnv, 11311251.cnv, IBM01251.ucs |
1251, 5347 | 1200, 1208, 13488, 17584 | IBM01251.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
922, 902 | 1257 | 09221257.cnv, 12570922.cnv, IBM00922.ucs |
922, 902 | 1200, 1208, 13488, 17584 | IBM00922.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
813, 4909 | 869, 9061 | 08130869.cnv, 08690813.cnv, IBM00813.ucs |
813, 4909 | 1253, 5349 | 08131253.cnv, 12530813.cnv, IBM00813.ucs |
813, 4909 | 1200, 1208, 13488, 17584 | IBM00813.ucs |
869, 9061 | 813, 4909 | 08690813.cnv, 08130869.cnv |
869, 9061 | 1253, 5349 | 08691253.cnv, 12530869.cnv |
1253, 5349 | 813, 4909 | 12530813.cnv, 08131253.cnv, IBM01253.ucs |
1253, 5349 | 869, 9061 | 12530869.cnv, 08691253.cnv, IBM01253.ucs |
1253, 5349 | 1200, 1208, 13488, 17584 | IBM01253.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
856, 9048 | 862, 867 | 08560862.cnv, 08620856.cnv, IBM0856.ucs |
856, 9048 | 916 | 08560916.cnv, 09160856.cnv, IBM0856.ucs |
856, 9048 | 1255, 5351 | 08561255.cnv, 12550856.cnv, IBM0856.ucs |
856, 9048 | 1200, 1208, 13488, 17584 | IBM0856.ucs |
862, 867 | 856, 9048 | 08620856.cnv, 08560862.cnv, IBM00862.ucs |
862, 867 | 916 | 08620916.cnv, 09160862.cnv, IBM00862.ucs |
862, 867 | 1255, 5351 | 08621255.cnv, 12550862.cnv, IBM00862.ucs |
862, 867 | 1200, 1208, 13488, 17584 | IBM00862.ucs |
916 | 856, 9048 | 09160856.cnv, 08560916.cnv |
916 | 862, 867 | 09160862.cnv, 08620916.cnv |
1255, 5351 | 856, 9048 | 12550856.cnv, 08561255.cnv, IBM01255.ucs |
1255, 5351 | 862, 867 | 12550862.cnv, 08621255.cnv, IBM01255.ucs |
1255, 5351 | 1200, 1208, 13488, 17584 | IBM01255.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
437 | 850, 858 | 04370850.cnv, 08500437.cnv |
850, 858 | 437 | 08500437.cnv, 04370850.cnv |
850, 858 | 860 | 08500860.cnv, 08600850.cnv |
850, 858 | 1114, 5210 | 08501114.cnv, 11140850.cnv |
850, 858 | 1275 | 08501275.cnv, 12750850.cnv |
860 | 850, 858 | 08600850.cnv, 08500860.cnv |
1275 | 850, 858 | 12750850.cnv, 08501275.cnv |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
852, 9044 | 1250, 5346 | 08521250.cnv, 12500852.cnv |
1250, 5346 | 852, 9044 | 12500852.cnv, 08521250.cnv, IBM01250.ucs |
1250, 5346 | 1200, 1208, 13488, 17584 | IBM01250.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
837, 935, 1388 | 1200, 1208, 13488, 17584 | 1388ucs2.cnv |
1386 | 1200, 1208, 13488, 17584 | 1386ucs2.cnv, ucs21386.cnv |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
937, 835, 1371 | 950, 1370 | 09370950.cnv, 0937ucs2.cnv |
937, 835, 1371 | 1200, 1208, 13488, 17584 | 0937ucs2.cnv |
1114, 5210 | 850, 858 | 11140850.cnv, 08501114.cnv |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
874, 1161 | 1200, 1208, 13488, 17584 | IBM00874.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
857, 9049 | 1254, 5350 | 08571254.cnv, 12540857.cnv |
1254, 5350 | 857, 9049 | 12540857.cnv, 08571254.cnv, IBM01254.ucs |
1254, 5350 | 1200, 1208, 13488, 17584 | IBM01254.ucs |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
1124 | 1251, 5347 | 11241251.cnv, 12511124.cnv |
1125, 848 | 1251, 5347 | 11251251.cnv, 12511125.cnv |
Database server CCSIDs/CPGIDs | Database client CCSIDs/CPGIDs | Conversion table files |
---|---|---|
1200, 1208, 13488, 17584 | 813, 4909 | IBM00813.ucs |
1200, 1208, 13488, 17584 | 862, 867 | IBM00862.ucs |
1200, 1208, 13488, 17584 | 864, 17248 | IBM00864.ucs |
1200, 1208, 13488, 17584 | 874, 1161 | IBM00874.ucs |
1200, 1208, 13488, 17584 | 921, 901 | IBM00921.ucs |
1200, 1208, 13488, 17584 | 922, 902 | IBM00922.ucs |
1200, 1208, 13488, 17584 | 1046, 9238 | IBM01046.ucs |
1200, 1208, 13488, 17584 | 1250, 5346 | IBM01250.ucs |
1200, 1208, 13488, 17584 | 1251, 5347 | IBM01251.ucs |
1200, 1208, 13488, 17584 | 1253, 5349 | IBM01253.ucs |
1200, 1208, 13488, 17584 | 1254, 5350 | IBM01254.ucs |
1200, 1208, 13488, 17584 | 1255, 5351 | IBM01255.ucs |
1200, 1208, 13488, 17584 | 1256, 5352 | IBM01256.ucs |
1200, 1208, 13488, 17584 | 1386 | ucs21386.cnv, 1386ucs2.cnv |