Appendix B. National language support Ordering printed DB2 books Accessing online help 28 National language versions 225 Finding topics by accessing he DB2 Supported territory codes and code pages 225 Information Center from a browser Enabling and disabling euro symbol support 245 Finding product information by accessing Conversion table files for euro-enabled code the DB2 Information Center from the administration tools Conversion tables for code pages 923 and Viewing technical documentation online 924. 256 directly from the DB2 HTML Documentation Choosing a language for your database 294 Locale setting for the DB2 Administration Updating the HTML documentation installed on your machine Enabling bidirectional support 258 Copying files from the DB2 HTML Bidirectional-specific CCSIDs 259 Documentation CD to a Web server Bidirectional support ith dB2 Connect Troubleshooting DB2 documentation search Collating Thai characters 66 Searching the DB2 documentation Date and time formats by territory code 66 Online DB2 troubleshooting information Unicode character encoding 269 Accessibility Keyboard Input and Navigation UTF-8 Accessible Display UTF-16 Alternative Alert Cues Unicode implementation in DB Compatibility with Assistive Technologies 300 Code Page/CCSID Numbers Accessible documentation Unicode handling of data types DB2 tutorials Creating a Unicode database DB2 Information Center accessed from a Unicode literals 276br owser String comparisons in a Unicode database Appendix D. Notices 303 ppendix c DB2 Universal Database Trademarks technical information Overview of DB2 Universal Database Inde 309 technical information FixPaks for db2 documentation Co Ing IBM 315 Printing DB2 books from PDF files nation Categories of DB2 technical infor Product informatio
Appendix B. National language support (NLS) . . . . . . . . . . . . . 225 National language versions . . . . . . 225 Supported territory codes and code pages 225 Enabling and disabling euro symbol support 245 Conversion table files for euro-enabled code pages . . . . . . . . . . . . . . 246 Conversion tables for code pages 923 and 924. . . . . . . . . . . . . . . 256 Choosing a language for your database . . 257 Locale setting for the DB2 Administration Server. . . . . . . . . . . . . 257 Enabling bidirectional support . . . . . 258 Bidirectional-specific CCSIDs . . . . . . 259 Bidirectional support with DB2 Connect . . 262 Collating Sequences . . . . . . . . . 264 Collating Thai characters . . . . . . . 266 Date and time formats by territory code . . 266 Unicode character encoding . . . . . . 269 UCS-2. . . . . . . . . . . . . 270 UTF-8. . . . . . . . . . . . . 270 UTF-16 . . . . . . . . . . . . 270 Unicode implementation in DB2 . . . . . 271 Code Page/CCSID Numbers . . . . . 273 Unicode handling of data types . . . . . 274 Creating a Unicode database . . . . . . 275 Unicode literals . . . . . . . . . . 276 String comparisons in a Unicode database 276 Appendix C. DB2 Universal Database technical information . . . . . . . . 279 Overview of DB2 Universal Database technical information . . . . . . . . 279 FixPaks for DB2 documentation . . . . 279 Categories of DB2 technical information 279 Printing DB2 books from PDF files . . . . 287 Ordering printed DB2 books . . . . . . 288 Accessing online help . . . . . . . . 288 Finding topics by accessing the DB2 Information Center from a browser . . . . 290 Finding product information by accessing the DB2 Information Center from the administration tools . . . . . . . . . 292 Viewing technical documentation online directly from the DB2 HTML Documentation CD. . . . . . . . . . . . . . . 294 Updating the HTML documentation installed on your machine . . . . . . . . . . 294 Copying files from the DB2 HTML Documentation CD to a Web server. . . . 296 Troubleshooting DB2 documentation search with Netscape 4.x . . . . . . . . . . 297 Searching the DB2 documentation . . . . 298 Online DB2 troubleshooting information . . 299 Accessibility . . . . . . . . . . . 299 Keyboard Input and Navigation . . . . 300 Accessible Display . . . . . . . . 300 Alternative Alert Cues . . . . . . . 300 Compatibility with Assistive Technologies 300 Accessible Documentation . . . . . . 300 DB2 tutorials . . . . . . . . . . . 301 DB2 Information Center accessed from a browser . . . . . . . . . . . . . 302 Appendix D. Notices . . . . . . . . 303 Trademarks . . . . . . . . . . . . 306 Index . . . . . . . . . . . . . 309 Contacting IBM . . . . . . . . . . 315 Product information . . . . . . . . . 315 Contents v
About this book The Administration Guide in its three volumes provides information necessary (RDBMS) Products, and includes Information about database design(found in Administration Guide: Planning) Information about implementing and managing databases(found in Administration Guide: Implementation Information about configuring and tuning your database environment to improve performance(found in Administration Guide: Performance) Many of the tasks described in this book can be performed using different interfaces: The Command Line Processor, which allows you to access and manipul databases from a graphical interface. From this interface, you can also execute SQL statements and DB2 utility functions. Most examples in this book illustrate the use of this interface. For more information about using the command line processor, see the Command reference. The application programming interface, which allows you to execute DB2 utility functions within an application program. For more information about using the application programming interface, see the Administrative API Refe The Control Center, which allows you to use a graphical user interface to perform administrative tasks such as configuring the system, managing directories, backing up and recovering the system, scheduling jobs, and managing media. The Control Center also contains Replication Administration, which allows you set up the replication of data between systems. Further, the Control Center allows you to execute DB2 utility functions through a graphical user interface. There are different methods to invoke the Control Center depending on your platform. For example,use the db2cc command on a command line, select the Control Center icon from the DB2 folder, or use the Start menu on Windows platforms. For introductory help, select Getting started from the Help pull-down of the Control Center window. The Visual Explain and Performance Monitor tools are invoked from the Control Center There are other tools that you can use to perform administration tasks. they The Script Center to store small applications called scripts. These scripts may contain SQL statements, DB2 commands, as well as operating system commands right IBM Corp. 1993-2002
About this book The Administration Guide in its three volumes provides information necessary to use and administer the DB2 relational database management system (RDBMS) products, and includes: v Information about database design (found in Administration Guide: Planning) v Information about implementing and managing databases (found in Administration Guide: Implementation) v Information about configuring and tuning your database environment to improve performance (found in Administration Guide: Performance) Many of the tasks described in this book can be performed using different interfaces: v The Command Line Processor, which allows you to access and manipulate databases from a graphical interface. From this interface, you can also execute SQL statements and DB2 utility functions. Most examples in this book illustrate the use of this interface. For more information about using the command line processor, see the Command Reference. v The application programming interface, which allows you to execute DB2 utility functions within an application program. For more information about using the application programming interface, see the Administrative API Reference. v The Control Center, which allows you to use a graphical user interface to perform administrative tasks such as configuring the system, managing directories, backing up and recovering the system, scheduling jobs, and managing media. The Control Center also contains Replication Administration, which allows you set up the replication of data between systems. Further, the Control Center allows you to execute DB2 utility functions through a graphical user interface. There are different methods to invoke the Control Center depending on your platform. For example, use the db2cc command on a command line, select the Control Center icon from the DB2 folder, or use the Start menu on Windows platforms. For introductory help, select Getting started from the Help pull-down of the Control Center window. The Visual Explain and Performance Monitor tools are invoked from the Control Center. There are other tools that you can use to perform administration tasks. They include: v The Script Center to store small applications called scripts. These scripts may contain SQL statements, DB2 commands, as well as operating system commands. © Copyright IBM Corp. 1993 - 2002 vii
The Alert Center to monitor the messages that result from other DB2 operations The Health Center provides a tool to assist DBAs in the resolution of performance and resource allocation problems The Tools Settings to change the settings for the Control Center, Alert Center, and Replication. The Journal to schedule jobs that are to run unattended. The Data Warehouse Center to manage warehouse objects Who should use this book This book is intended primarily for database administrators, system administrators, security administrators and system operators who need to design, implement and maintain a database to be accessed by local or remote lients. It can also be used by programmers and other users who require an understanding of the administration and operation of the DB2 relational database management system How this book is structured This book contains information about the following major topics Database Concepts Chapter 1, Basic relational database concepts", presents an overview of database objects and database concepts Chapter 2, "Parallel database systems", provides an introduction to the types of parallelism available with DB2 Chapter 3, "About data warehousing", provides an overview of data tasks Database Design Chapter 4, " Logical database design", discusses the concepts and guidelines for logical database design Chapter 5, Physical database design", discusses the guidelines for physical database design, including space requirements and table space design. Chapter 6, Designing Distributed Databa discusses how you can access multiple trar Chapter 7,"Designing for XA-compliant transaction managers", discusses how you can use your databases in a distributed transaction processing ministration Guide: Plann
v The Alert Center to monitor the messages that result from other DB2 operations. v The Health Center provides a tool to assist DBAs in the resolution of performance and resource allocation problems. v The Tools Settings to change the settings for the Control Center, Alert Center, and Replication. v The Journal to schedule jobs that are to run unattended. v The Data Warehouse Center to manage warehouse objects. Who should use this book This book is intended primarily for database administrators, system administrators, security administrators and system operators who need to design, implement and maintain a database to be accessed by local or remote clients. It can also be used by programmers and other users who require an understanding of the administration and operation of the DB2 relational database management system. How this book is structured This book contains information about the following major topics: Database Concepts v Chapter 1, “Basic relational database concepts”, presents an overview of database objects and database concepts. v Chapter 2, “Parallel database systems”, provides an introduction to the types of parallelism available with DB2. v Chapter 3, “About data warehousing”, provides an overview of data warehousing and data warehousing tasks. Database Design v Chapter 4, “Logical database design”, discusses the concepts and guidelines for logical database design. v Chapter 5, “Physical database design”, discusses the guidelines for physical database design, including space requirements and table space design. v Chapter 6, “Designing Distributed Databases”, discusses how you can access multiple databases in a single transaction. v Chapter 7, “Designing for XA-compliant transaction managers”, discusses how you can use your databases in a distributed transaction processing environment. Appendixes viii Administration Guide: Planning
Appendix A, " Incompatibilities between releases", presents the incompatibilities introduced by Version 7 and Version 8, as well as future incompatibilities that you should be aware of Appendix B, "National language support(NLS)", introduces DB2 National Language Support, including information about territories, languages, and code pages a brief overview of the other administration guide volumes Administration Guide: Implementation The Administration Guide: Implementation is concerned with the implementation of your database design. The specific chapters and appendixes in that volume are briefly described here Implementing Your Design Before Creating a Database"describes the prerequisites before you create a atabase Creating a Database"describes those tasks associated with the creation of a database and related database objects Altering a Database"discusses what must be done before altering a database and those tasks associated with the modifying or dropping of a database or related database objects. Database Security Controlling Database Access"describes how you can control access to your database's resources Auditing DB2 Activities" describes how you can detect and monitor unwanted or unanticipated access to data Appendix Naming Rules" presents the rules to follow when naming databases and Lightweight Directory Access Protocol(LDAP)Directory Services provides information about how you can use LDAP Directory Services Issuing Commands to Multiple Database Partition"discusses the use of the db2__all and rah shell scripts to send commands to all partitions in a partitioned database environment Windows Management Instrumentation(WMI) Support"describes how DB2 supports this management infrastructure standard to integrate various hardware and software management systems. Also discussed is how DB2 integrates with WMI How DB2 for Windows NT Works with Windows NT Security"describes how db2 works with Windows Nt securit IX
v Appendix A, “Incompatibilities between releases”, presents the incompatibilities introduced by Version 7 and Version 8, as well as future incompatibilities that you should be aware of. v Appendix B, “National language support (NLS)”, introduces DB2 National Language Support, including information about territories, languages, and code pages. A brief overview of the other Administration Guide volumes Administration Guide: Implementation The Administration Guide: Implementation is concerned with the implementation of your database design. The specific chapters and appendixes in that volume are briefly described here: Implementing Your Design v ″Before Creating a Database″ describes the prerequisites before you create a database. v ″Creating a Database″ describes those tasks associated with the creation of a database and related database objects. v ″Altering a Database″ discusses what must be done before altering a database and those tasks associated with the modifying or dropping of a database or related database objects. Database Security v ″Controlling Database Access″ describes how you can control access to your database’s resources. v ″Auditing DB2 Activities″ describes how you can detect and monitor unwanted or unanticipated access to data. Appendixes v ″Naming Rules″ presents the rules to follow when naming databases and objects. v ″Lightweight Directory Access Protocol (LDAP) Directory Services″ provides information about how you can use LDAP Directory Services. v ″Issuing Commands to Multiple Database Partition″ discusses the use of the db2_all and rah shell scripts to send commands to all partitions in a partitioned database environment. v ″Windows Management Instrumentation (WMI) Support″ describes how DB2 supports this management infrastructure standard to integrate various hardware and software management systems. Also discussed is how DB2 integrates with WMI. v ″How DB2 for Windows NT Works with Windows NT Security″ describes how DB2 works with Windows NT security. About this book ix
Using the Windows Performance Monitor"provides information about registering DB2 with the Windows NT Performance Monitor, and using the performance information "Working with Windows Database Partition Servers"provides information about the utilities available to work with database partition servers on Windows nt or windows 2000 Configuring Multiple Logical Nodes"describes how to configure multiple logical nodes in a partitioned database environment. Extending the Control Center" provides information about how you can extend the Control Center by adding new tool bar buttons including new actions, adding new object definitions, and adding new action definitions Note: Two chapters have been removed from this book All of the information on the DB2 utilities for moving data, and the comparable topics from the Command Reference and the administrative API Reference, have been consolidated into the Data Movement Utilities The Data Movement Utilities Guide and Reference is your primary, single source of information for these topics To find out more about replication of data, see Replication Guide and Reference All of the information on the methods and tools for backing up and recovering data, and the comparable topics from the Command Referenc and the Administrative API Reference, have been consolidated into the Data Recovery and High Availability Guide and reference The Data Recovery and High Availability Guide and Reference is your primary, single source of information for these topics. Administration Guide: Performance The Administration Guide: Performance is concerned with performance issues that is, those topics and issues concerned with establishing, testing, and improving the performance of your application, and that of the DB2 Universal Database product itself. The specific chapters and appendixes in that volume are briefly described here introduction to performance Introduction to Performance"introduces concepts and considerations for managing and improving DB2 UDB performance Architecture and Processes" introduces underlying DB2 Universal Database architecture and processes x Administration Guide Planning
v ″Using the Windows Performance Monitor″ provides information about registering DB2 with the Windows NT Performance Monitor, and using the performance information. v ″Working with Windows Database Partition Servers″ provides information about the utilities available to work with database partition servers on Windows NT or Windows 2000. v ″Configuring Multiple Logical Nodes″ describes how to configure multiple logical nodes in a partitioned database environment. v ″Extending the Control Center″ provides information about how you can extend the Control Center by adding new tool bar buttons including new actions, adding new object definitions, and adding new action definitions. Note: Two chapters have been removed from this book. All of the information on the DB2 utilities for moving data, and the comparable topics from the Command Reference and the Administrative API Reference, have been consolidated into the Data Movement Utilities Guide and Reference. The Data Movement Utilities Guide and Reference is your primary, single source of information for these topics. To find out more about replication of data, see Replication Guide and Reference. All of the information on the methods and tools for backing up and recovering data, and the comparable topics from the Command Reference and the Administrative API Reference, have been consolidated into the Data Recovery and High Availability Guide and Reference. The Data Recovery and High Availability Guide and Reference is your primary, single source of information for these topics. Administration Guide: Performance The Administration Guide: Performance is concerned with performance issues; that is, those topics and issues concerned with establishing, testing, and improving the performance of your application, and that of the DB2 Universal Database product itself. The specific chapters and appendixes in that volume are briefly described here: Introduction to Performance v ″Introduction to Performance″ introduces concepts and considerations for managing and improving DB2 UDB performance. v ″Architecture and Processes″ introduces underlying DB2 Universal Database architecture and processes. x Administration Guide: Planning