Nội dung

DB2 Version 9.5 for Linux, UNIX, and Windows
 Data Servers, Databases, and Database Objects Guide Updated March, 2008 SC23-5849-01 DB2 Version 9.5 for Linux, UNIX, and Windows
 Data Servers, Databases, and Database Objects Guide Updated March, 2008 SC23-5849-01 Note Before using this information and the product it supports, read the general information under Appendix B, “Notices,” on page 603. Edition Notice This document contains proprietary information of IBM. It is provided under a license agreement and is protected by copyright law. The information contained in this publication does not include any product warranties, and any statements provided in this manual should not be interpreted as such. You can order IBM publications online or through your local IBM representative. v To order publications online, go to the IBM Publications Center at www.ibm.com/shop/publications/order v To find your local IBM representative, go to the IBM Directory of Worldwide Contacts at www.ibm.com/ planetwide To order DB2 publications from DB2 Marketing and Sales in the United States or Canada, call 1-800-IBM-4YOU (426-4968). When you send information to IBM, you grant IBM a nonexclusive right to use or distribute the information in any way it believes appropriate without incurring any obligation to you. © Copyright International Business Machines Corporation 1993, 2008. All rights reserved. US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Contents About this book . . . . . . . . . . . ix Part 1. Data servers . . . . . . . . . 1 Chapter 1. DB2 data servers . . . . . . 3 Management of data server capacity . . . . . . 3 Enabling large page support in a 64-bit environment (AIX) . . . . . . . . . . . . . . . . . 4 Chapter 2. Multiple DB2 copies . . . . . 7 Default IBM database client interface copy . . . . 7 Setting the DAS when running multiple DB2 copies 10 Setting the default instance when using multiple DB2 copies (Windows) . . . . . . . . . . . 11 Multiple instances of the database manager . . . . 11 Multiple instances (Windows) . . . . . . . . 12 Updating DB2 copies (Windows) . . . . . . . 13 Running multiple instances concurrently (Windows) 14 Working with instances on the same or different DB2 copies . . . . . . . . . . . . . . 14 Chapter 3. Autonomic computing . . . 17 Automatic features . . . . . . . . . . . . Automatic maintenance . . . . . . . . . . Maintenance windows . . . . . . . . . . Self-tuning memory . . . . . . . . . . . Memory allocation in DB2 . . . . . . . . Self tuning memory operational details and limitations . . . . . . . . . . . . . . Operational details, limitations, and interaction between memory parameters . . . . . . . Enabling self tuning memory . . . . . . . Disabling self tuning memory . . . . . . . Determining which memory consumers are enabled for self tuning. . . . . . . . . . Self tuning memory in partitioned database environments . . . . . . . . . . . . . Using self-tuning memory in partitioned database environments . . . . . . . . . Configuring memory and memory heaps . . . . Agent and process model configuration . . . . Agent, process model, and memory configuration Automatic storage . . . . . . . . . . . . Automatic storage table spaces . . . . . . . Automatic storage databases. . . . . . . . Automatic storage restrictions . . . . . . . Automatic (compression) dictionary creation (ADC) Data row compression . . . . . . . . . . Configuration Advisor . . . . . . . . . . . Tuning configuration parameters using the Configuration Advisor . . . . . . . . . . Generating database configuration recommendations . . . . . . . . . . . © Copyright IBM Corp. 1993, 2008 17 19 19 20 21 Example: Requesting configuration recommendations using the Configuration Advisor . . . . . . . . . . . . Utility throttling . . . . . . . . . . . Asynchronous index cleanup . . . . . Asynchronous index cleanup for MDC tables . . . . . . . . 51 54 54 56 Chapter 4. Instances . . . . . . . . . 59 Designing instances. . . . . . . . . . . Default instance . . . . . . . . . . . Instance directory . . . . . . . . . . Multiple instances (Linux, UNIX) . . . . . Multiple instances (Windows) . . . . . . Creating instances . . . . . . . . . . . Modifying instances . . . . . . . . . . Updating the instance configuration (Linux, UNIX) . . . . . . . . . . . . . . Updating the instance configuration (Windows) Working with instances . . . . . . . . . Auto-starting instances . . . . . . . . Starting instances (Linux, UNIX) . . . . . Starting instances (Windows) . . . . . . Attaching to and detaching from instances . . Working with instances on the same or different DB2 copies . . . . . . . . . . . . Stopping instances (Linux, UNIX) . . . . . Stopping instances (Windows) . . . . . . Dropping instances . . . . . . . . . . . . . . . . . . 60 61 62 62 63 64 65 . 65 66 . 67 . 67 . 67 . 68 . 68 . . . . 69 69 70 71 24 Chapter 5. Lightweight Directory Access Protocol (LDAP) . . . . . . . 73 25 27 27 Security considerations in an LDAP environment . LDAP object classes and attributes used by DB2 . Extending the LDAP directory schema with DB2 object classes and attributes . . . . . . . . Supported LDAP client and server configurations LDAP support and DB2 Connect . . . . . Extending the directory schema for IBM Tivoli Directory Server . . . . . . . . . . . Netscape LDAP directory support and attribute definitions . . . . . . . . . . . . . Extending the directory schema for Sun One Directory Server . . . . . . . . . . . Windows Active Directory . . . . . . . Enabling LDAP support after installation is complete . . . . . . . . . . . . . Configuring DB2 in the IBM LDAP environment Registering LDAP entries . . . . . . . . . Registration of DB2 servers after installation . Catalog a node alias for ATTACH . . . . . Registration of databases in the LDAP directory Deregistering LDAP entries . . . . . . . . Deregistering the DB2 server . . . . . . Deregistering the database from the LDAP directory . . . . . . . . . . . . . 28 29 31 32 35 36 38 38 44 47 47 49 50 50 51 . 73 . 74 . 84 84 . 85 . 86 . 87 . 89 . 91 . 94 95 . 95 . 95 . 96 97 . 97 . 97 . 97 iii Configuring LDAP users . . . . . . . . . . 98 Creating an LDAP user . . . . . . . . . 98 Configuring the LDAP user for DB2 applications 98 Setting DB2 registry variables at the user level in the LDAP environment . . . . . . . . . 99 Disabling LDAP support . . . . . . . . . . 99 Updating the protocol information for the DB2 server . . . . . . . . . . . . . . . . 99 Rerouting LDAP clients to another server . . . . 99 Attaching to a remote server in the LDAP environment . . . . . . . . . . . . . . 100 Refreshing LDAP entries in local database and node directories . . . . . . . . . . . . 101 Searching the LDAP servers . . . . . . . . 102 Part 2. Databases . . . . . . . . . 103 Chapter 6. Databases . . . . . . . . 105 Designing databases . . . . . . . . . . . Database directories and files . . . . . . . Space requirements for database objects . . . Space requirements for log files . . . . . . Lightweight Directory Access Protocol (LDAP) directory service . . . . . . . . . . . Creating databases. . . . . . . . . . . . Automatic storage databases . . . . . . . Cataloging databases . . . . . . . . . . Binding utilities to the database . . . . . . Creating database aliases . . . . . . . . Connecting to distributed relational databases . . Remote unit of work for distributed relational databases . . . . . . . . . . . . . . Application-directed distributed unit of work Application process connection states . . . . Connection states . . . . . . . . . . . Options that govern unit of work semantics . . Data representation considerations . . . . . Viewing the local or system database directory files Dropping databases . . . . . . . . . . . Dropping aliases . . . . . . . . . . . 105 106 113 114 115 116 117 124 125 126 127 127 130 131 132 133 134 134 134 135 Chapter 7. Database partitions . . . . 137 Chapter 8. Buffer pools . . . . . . . 139 Designing buffer pools . . . . . . . . . Buffer pool memory protection (AIX running on POWER6) . . . . . . . . . . . . . Creating buffer pools . . . . . . . . . . Modifying buffer pools . . . . . . . . . Dropping buffer pools . . . . . . . . . . 139 . . . . 141 142 143 144 Chapter 9. Table spaces . . . . . . . 145 Designing table spaces . . . . . . . . Types of table spaces . . . . . . . . Comparison of SMS and DMS table spaces Considerations when choosing table spaces your tables . . . . . . . . . . . Automatic re-sizing of table spaces . . . iv . . . for . . . 146 . 148 . 162 . 164 . 165 Data Servers, Databases, and Database Objects Guide Automatic prefetchsize adjustment after adding or dropping containers . . . . . . . . . Table spaces without file system caching . . . Table space extent sizes . . . . . . . . . Table space page sizes . . . . . . . . . Table space disk I/O . . . . . . . . . . Defining initial table spaces . . . . . . . . Attaching DMS direct disk access devices . . . Configuring and setting up DMS direct disk access (Linux) . . . . . . . . . . . . Creating table spaces . . . . . . . . . . . Altering table spaces . . . . . . . . . . . Altering SMS table spaces . . . . . . . . Altering DMS table spaces . . . . . . . . Altering automatic storage table spaces . . . . Renaming a table space . . . . . . . . . . Switching table spaces from offline to online . . . Optimizing table space performance when data is on RAID devices . . . . . . . . . . . . Dropping table spaces . . . . . . . . . . 169 171 176 177 178 179 181 182 183 187 187 188 200 200 201 201 202 Chapter 10. Schemas . . . . . . . . 205 Designing schemas . . . . . . . . . . . Grouping objects by schema . . . . . . . Schema name restrictions and recommendations Creating schemas . . . . . . . . . . . . Copying schemas . . . . . . . . . . . . Example of schema copy using the ADMIN_COPY_SCHEMA procedure . . . . Examples of schema copy using the db2move utility . . . . . . . . . . . . . . . Restarting a failed copy schema operation . . . . Dropping schemas. . . . . . . . . . . . 206 208 209 210 210 212 212 213 216 Part 3. Database objects . . . . . 217 Chapter 11. Tables . . . . . . . . . 219 Types of tables . . . . . . . . . . . . Designing tables . . . . . . . . . . . Table design concepts . . . . . . . . Space requirements for tables . . . . . . Space requirements for user table data . . . Space compression for tables . . . . . . Optimistic locking . . . . . . . . . . Table partitioning and data organization schemes Creating tables . . . . . . . . . . . . Declaring global temporary tables . . . . Creating tables like existing tables . . . . Creating tables for staging data . . . . . Modifying tables . . . . . . . . . . . Altering materialized query table properties . Refreshing the data in a materialized query table . . . . . . . . . . . . . . Changing column properties . . . . . . Renaming tables and columns . . . . . . . Recovering inoperative summary tables . . . Viewing table definitions . . . . . . . . Table or view aliases . . . . . . . . . Dropping tables . . . . . . . . . . . Dropping materialized query or staging tables . . . . . . . . . . . . . . . . . . . . 219 221 221 230 232 234 238 247 247 248 248 249 250 250 251 251 254 254 255 255 255 256 Scenarios and examples of tables . . . . . . Scenarios: Optimistic locking and time-based detection . . . . . . . . . . . . . . 256 . 256 Chapter 12. Constraints . . . . . . . 261 Types of constraints . . . . . . . . . . NOT NULL constraints . . . . . . . . Unique constraints . . . . . . . . . Primary key constraints . . . . . . . . (Table) Check constraints . . . . . . . Foreign key (referential) constraints . . . . Informational constraints . . . . . . . Designing constraints . . . . . . . . . . Designing unique constraints . . . . . . Designing primary key constraints . . . . Designing check constraints . . . . . . Designing foreign key (referential) constraints Designing informational constraints . . . . Creating and modifying constraints . . . . . Viewing constraint definitions for a table . . . Dropping constraints . . . . . . . . . . Chapter 13. Indexes . . . . . . . . . . . . . . . 261 262 262 263 263 263 268 268 268 269 269 271 276 278 279 280 . . . . . . . . 283 Types of indexes . . . . . . Designing indexes . . . . . . Tools for designing indexes . . Space requirements for indexes Creating indexes . . . . . . Modifying indexes . . . . . Renaming indexes . . . . . . Rebuilding indexes . . . . . Dropping indexes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 284 286 288 288 291 292 292 293 294 Chapter 14. Triggers . . . . . . . . 295 Types of triggers . . . . . . . . . . . . BEFORE triggers . . . . . . . . . . . AFTER triggers . . . . . . . . . . . . INSTEAD OF triggers . . . . . . . . . Designing triggers . . . . . . . . . . . . Specifying what makes a trigger fire (triggering statement or event) . . . . . . . . . . Specifying when a trigger fires (BEFORE, AFTER, and INSTEAD OF clauses) . . . . . Defining conditions for when trigger-action will fire (WHEN clause) . . . . . . . . . . Supported SQL PL statements in triggers . . . Accessing old and new column values in triggers using transition variables . . . . . Referencing old and new table result sets using transition tables . . . . . . . . . . . Creating triggers . . . . . . . . . . . . Modifying and dropping triggers . . . . . . . Examples of triggers and trigger use . . . . . Examples of interaction between triggers and referential constraints . . . . . . . . . . Examples of defining actions using triggers . . Example of defining business rules using triggers . . . . . . . . . . . . . . Example of preventing operations on tables using triggers . . . . . . . . . . . . 296 297 297 298 299 Chapter 15. Sequences . . . . . . . 315 Designing sequences . . . . . . . . . . Managing sequence behavior . . . . . . Application performance and sequences . . Sequences compared to identity columns . . Creating sequences . . . . . . . . . . Generating sequential values . . . . . . Determining when to use identity columns or sequences . . . . . . . . . . . . Modifying sequences . . . . . . . . . . Viewing sequence definitions . . . . . . . Dropping sequences . . . . . . . . . . Examples of how to code sequences . . . . . Sequence reference . . . . . . . . . . . . . . . . 315 316 317 318 319 320 . . . . . . 320 321 322 322 323 324 Chapter 16. Views . . . . . . . . . 329 Designing views . . . . . . . . . . . System catalog views . . . . . . . . . Views with the check option . . . . . . Deletable views . . . . . . . . . . Insertable views . . . . . . . . . . Updatable views . . . . . . . . . . Read-only views . . . . . . . . . . Creating views . . . . . . . . . . . . Creating views that use user-defined functions (UDFs) . . . . . . . . . . . . . Modifying typed views . . . . . . . . . Recovering inoperative views . . . . . . . Dropping views . . . . . . . . . . . . . . . . . . . 330 330 331 333 334 334 335 335 . . . . 336 337 337 338 Part 4. Reference . . . . . . . . . 339 Chapter 17. Conforming to naming rules . . . . . . . . . . . . . . . 341 301 Naming rules . . . . . . . . . DB2 object naming rules . . . . . . Delimited identifiers and object names . User, user ID and group naming rules . Naming rules in an NLS environment . Naming rules in a Unicode environment 302 Chapter 18. SQL and XML limits . . . 347 304 305 Chapter 19. Registry and environment variables . . . . . . . . . . . . . 357 306 307 308 310 310 310 312 313 314 . . . . . . . . . . . . Environment variables and the profile registry Declaring, showing, changing, resetting, and deleting registry and environment variables . Setting environment variables on Windows Setting environment variables on Linux and UNIX operating systems. . . . . . . Setting the current instance environment variables . . . . . . . . . . . . Aggregate registry variables . . . . . . DB2 registry and environment variables . . General registry variables . . . . . . System environment variables . . . . . Communications variables . . . . . . Command-line variables . . . . . . . . . . . . . . . . . . . 341 342 343 344 344 345 . . 357 . . . 359 . 361 . . 363 . . . . . . . . . . . . . . 364 365 366 370 378 386 389 Contents v Partitioned database environment variables Query compiler variables . . . . . . Performance variables . . . . . . . Miscellaneous variables . . . . . . . . . . . Chapter 20. Configuration parameters . . . . 429 Configuring the DB2 database manager with configuration parameters . . . . . . . . . Configuration parameters summary . . . . . . Configuration parameters that affect the number of agents . . . . . . . . . . . . . . . . Configuration parameters that affect query optimization . . . . . . . . . . . . . . Restrictions and behavior when configuring max_coordagents and max_connections . . . . Database Manager configuration parameters . . . agent_stack_sz - Agent stack size . . . . . . agentpri - Priority of agents . . . . . . . aslheapsz - Application support layer heap size audit_buf_sz - Audit buffer size . . . . . . authentication - Authentication type . . . . . catalog_noauth - Cataloging allowed without authority . . . . . . . . . . . . . . clnt_krb_plugin - Client Kerberos plug-in . . . clnt_pw_plugin - Client userid-password plug-in . . . . . . . . . . . . . . cluster_mgr - Cluster manager name . . . . comm_bandwidth - Communications bandwidth conn_elapse - Connection elapse time . . . . cpuspeed - CPU speed . . . . . . . . . dft_account_str - Default charge-back account dft_monswitches - Default database system monitor switches . . . . . . . . . . . dftdbpath - Default database path . . . . . diaglevel - Diagnostic error capture level . . . diagpath - Diagnostic data directory path . . . dir_cache - Directory cache support . . . . . discover - Discovery mode . . . . . . . . discover_inst - Discover server instance . . . fcm_num_buffers - Number of FCM buffers . . fcm_num_channels - Number of FCM channels fed_noauth - Bypass federated authentication federated - Federated database system support federated_async - Maximum asynchronous TQs per query configuration parameter . . . . . fenced_pool - Maximum number of fenced processes . . . . . . . . . . . . . . group_plugin - Group plug-in . . . . . . . health_mon - Health monitoring . . . . . . indexrec - Index re-creation time . . . . . . instance_memory - Instance memory . . . . intra_parallel - Enable intra-partition parallelism java_heap_sz - Maximum Java interpreter heap size . . . . . . . . . . . . . . . . jdk_path - Software Developer’s Kit for Java installation path . . . . . . . . . . . keepfenced - Keep fenced process . . . . . local_gssplugin - GSS API plug-in used for local instance level authorization . . . . . . . . max_connections - Maximum number of client connections . . . . . . . . . . . . . vi 390 392 396 413 Data Servers, Databases, and Database Objects Guide 430 433 445 446 448 450 450 451 453 454 455 457 457 457 458 458 459 460 460 461 462 463 464 465 466 467 467 468 469 469 470 470 472 472 473 475 477 477 478 479 480 480 max_connretries - Node connection retries . . . max_coordagents - Maximum number of coordinating agents . . . . . . . . . . max_querydegree - Maximum query degree of parallelism . . . . . . . . . . . . . max_time_diff - Maximum time difference among nodes . . . . . . . . . . . . maxagents - Maximum number of agents . . . maxcagents - Maximum number of concurrent agents . . . . . . . . . . . . . . . mon_heap_sz - Database system monitor heap size . . . . . . . . . . . . . . . . nodetype - Machine node type . . . . . . notifylevel - Notify level . . . . . . . . . num_initagents - Initial number of agents in pool . . . . . . . . . . . . . . . num_initfenced - Initial number of fenced processes . . . . . . . . . . . . . . num_poolagents - Agent pool size . . . . . numdb - Maximum number of concurrently active databases including host and System i databases . . . . . . . . . . . . . . query_heap_sz - Query heap size . . . . . . release - Configuration file release level . . . resync_interval - Transaction resync interval . . rqrioblk - Client I/O block size . . . . . . sheapthres - Sort heap threshold . . . . . . spm_log_file_sz - Sync point manager log file size . . . . . . . . . . . . . . . . spm_log_path - Sync point manager log file path . . . . . . . . . . . . . . . spm_max_resync - Sync point manager resync agent limit . . . . . . . . . . . . . spm_name - Sync point manager name . . . . srvcon_auth - Authentication type for incoming connections at the server . . . . . . . . srvcon_gssplugin_list - List of GSS API plug-ins for incoming connections at the server . . . . srvcon_pw_plugin - Userid-password plug-in for incoming connections at the server . . . . srv_plugin_mode - Server plug-in mode . . . start_stop_time - Start and stop timeout . . . svcename - TCP/IP service name . . . . . . sysadm_group - System administration authority group name . . . . . . . . . sysctrl_group - System control authority group name . . . . . . . . . . . . . . . sysmaint_group - System maintenance authority group name . . . . . . . . . . . . . sysmon_group - System monitor authority group name . . . . . . . . . . . . . tm_database - Transaction manager database name . . . . . . . . . . . . . . . tp_mon_name - Transaction processor monitor name . . . . . . . . . . . . . . . trust_allclnts - Trust all clients . . . . . . . trust_clntauth - Trusted clients authentication util_impact_lim - Instance impact policy . . . wlm_collect_int - Workload management collection interval configuration parameter . . Database configuration parameters . . . . . . 481 481 482 483 483 484 485 486 486 487 488 488 489 490 491 491 492 493 494 495 496 496 496 497 497 498 498 499 500 500 501 501 502 503 504 505 506 506 507 alt_collate - Alternate collating sequence . . . app_ctl_heap_sz - Application control heap size appgroup_mem_sz - Maximum size of application group memory set . . . . . . . appl_memory - Application Memory configuration parameter . . . . . . . . . applheapsz - Application heap size . . . . . archretrydelay - Archive retry delay on error auto_del_rec_obj - Automated deletion of recovery objects configuration parameter . . . auto_maint - Automatic maintenance . . . . autorestart - Auto restart enable . . . . . . avg_appls - Average number of active applications . . . . . . . . . . . . . backup_pending - Backup pending indicator blk_log_dsk_ful - Block on log disk full . . . catalogcache_sz - Catalog cache size . . . . . chngpgs_thresh - Changed pages threshold . . codepage - Code page for the database . . . . codeset - Codeset for the database . . . . . collate_info - Collating information . . . . . country/region - Database territory code . . . database_consistent - Database is consistent . . database_level - Database release level . . . . database_memory - Database shared memory size . . . . . . . . . . . . . . . . db_mem_thresh - Database memory threshold dbheap - Database heap . . . . . . . . . decflt_rounding - Decimal floating point rounding configuration parameter . . . . . dft_degree - Default degree . . . . . . . . dft_extent_sz - Default extent size of table spaces . . . . . . . . . . . . . . . dft_loadrec_ses - Default number of load recovery sessions . . . . . . . . . . . dft_mttb_types - Default maintained table types for optimization . . . . . . . . . . . dft_prefetch_sz - Default prefetch size . . . . dft_queryopt - Default query optimization class dft_refresh_age - Default refresh age. . . . . dft_sqlmathwarn - Continue upon arithmetic exceptions . . . . . . . . . . . . . discover_db - Discover database . . . . . . dlchktime - Time interval for checking deadlock dyn_query_mgmt - Dynamic SQL and XQuery query management . . . . . . . . . . enable_xmlchar - Enable conversion to XML configuration parameter . . . . . . . . . failarchpath - Failover log archive path . . . . groupheap_ratio - Percent of memory for application group heap . . . . . . . . . hadr_db_role - HADR database role . . . . . hadr_local_host - HADR local host name . . . hadr_local_svc - HADR local service name . . hadr_peer_window - HADR peer window configuration parameter . . . . . . . . . hadr_remote_host - HADR remote host name hadr_remote_inst - HADR instance name of the remote server . . . . . . . . . . . . hadr_remote_svc - HADR remote service name 507 508 509 510 511 511 512 512 514 515 516 516 516 518 518 519 519 520 520 520 521 522 523 525 526 527 527 528 528 529 530 530 532 532 533 533 534 534 535 535 535 536 536 537 537 hadr_syncmode - HADR synchronization mode for log write in peer state . . . . . . . . hadr_timeout - HADR timeout value . . . . jdk_64_path - 64-Bit Software Developer’s Kit for Java installation path DAS . . . . . . . locklist - Maximum storage for lock list . . . locktimeout - Lock timeout . . . . . . . . log_retain_status - Log retain status indicator logarchmeth1 - Primary log archive method . . logarchmeth2 - Secondary log archive method logarchopt1 - Primary log archive options . . . logarchopt2 - Secondary log archive options . . logbufsz - Log buffer size . . . . . . . . logfilsiz - Size of log files . . . . . . . . loghead - First active log file . . . . . . . logindexbuild - Log index pages created . . . logpath - Location of log files . . . . . . . logprimary - Number of primary log files . . . logretain - Log retain enable . . . . . . . logsecond - Number of secondary log files . . max_log - Maximum log per transaction . . . maxappls - Maximum number of active applications . . . . . . . . . . . . . maxfilop - Maximum database files open per application . . . . . . . . . . . . . maxlocks - Maximum percent of lock list before escalation . . . . . . . . . . . . . . min_dec_div_3 - Decimal division scale to 3 . . mincommit - Number of commits to group . . mirrorlogpath - Mirror log path . . . . . . multipage_alloc - Multipage file allocation enabled . . . . . . . . . . . . . . newlogpath - Change the database log path . . num_db_backups - Number of database backups . . . . . . . . . . . . . . num_freqvalues - Number of frequent values retained . . . . . . . . . . . . . . num_iocleaners - Number of asynchronous page cleaners . . . . . . . . . . . . . . num_ioservers - Number of I/O servers . . . num_log_span - Number log span . . . . . num_quantiles - Number of quantiles for columns . . . . . . . . . . . . . . numarchretry - Number of retries on error . . numsegs - Default number of SMS containers overflowlogpath - Overflow log path . . . . pagesize - Database default page size . . . . pckcachesz - Package cache size . . . . . . priv_mem_thresh - Private memory threshold rec_his_retentn - Recovery history retention period . . . . . . . . . . . . . . . restore_pending - Restore pending . . . . . restrict_access - Database has restricted access configuration parameter . . . . . . . . . rollfwd_pending - Roll forward pending indicator . . . . . . . . . . . . . . self_tuning_mem- Self-tuning memory . . . . seqdetect - Sequential detection flag . . . . . sheapthres_shr - Sort heap threshold for shared sorts . . . . . . . . . . . . . . . Contents 537 538 539 539 542 543 543 544 545 546 546 547 548 548 548 548 550 551 552 552 553 554 556 557 558 559 559 561 561 562 564 565 565 566 567 567 568 568 570 571 571 571 572 572 574 574 vii softmax - Recovery range and soft checkpoint interval . . . . . . . . . . . . . sortheap - Sort heap size . . . . . . . stat_heap_sz - Statistics heap size. . . . . stmtheap - Statement heap size . . . . . territory - Database territory . . . . . . trackmod - Track modified pages enable . . tsm_mgmtclass - Tivoli Storage Manager management class . . . . . . . . . . tsm_nodename - Tivoli Storage Manager node name . . . . . . . . . . . . . . tsm_owner - Tivoli Storage Manager owner name . . . . . . . . . . . . . . tsm_password - Tivoli Storage Manager password . . . . . . . . . . . . . user_exit_status - User exit status indicator . userexit - User exit enable . . . . . . . util_heap_sz - Utility heap size . . . . . vendoropt - Vendor options . . . . . . DB2 Administration Server (DAS) configuration parameters . . . . . . . . . . . . . authentication - Authentication type DAS . . contact_host - Location of contact list . . . das_codepage - DAS code page . . . . . das_territory - DAS territory . . . . . . dasadm_group - DAS administration authority group name . . . . . . . . . . . . db2system - Name of the DB2 server system discover - DAS discovery mode . . . . . exec_exp_task - Execute expired tasks . . . jdk_path - Software Developer’s Kit for Java installation path DAS . . . . . . . . . viii . . . . . . 575 577 578 579 579 580 . 580 sched_enable - Scheduler mode . . . . . . sched_userid - Scheduler user ID . . . . . . smtp_server - SMTP server . . . . . . . . toolscat_db - Tools catalog database . . . . . toolscat_inst - Tools catalog database instance toolscat_schema - Tools catalog database schema 588 588 589 589 590 590 Part 5. Appendixes . . . . . . . . 591 . 580 Appendix A. Overview of the DB2 technical information . . . . . . . . 593 . 581 DB2 technical library in hardcopy or PDF format Ordering printed DB2 books . . . . . . . . Displaying SQL state help from the command line processor . . . . . . . . . . . . . . . Accessing different versions of the DB2 Information Center . . . . . . . . . . . Displaying topics in your preferred language in the DB2 Information Center . . . . . . . . . . Updating the DB2 Information Center installed on your computer or intranet server . . . . . . . DB2 tutorials . . . . . . . . . . . . . DB2 troubleshooting information . . . . . . . Terms and Conditions . . . . . . . . . . . . . . . 581 582 582 583 583 . . . . . 584 584 584 585 585 . 585 586 . 586 . 587 . 588 Data Servers, Databases, and Database Objects Guide 593 596 596 597 597 598 599 600 600 Appendix B. Notices . . . . . . . . 603 Index . . . . . . . . . . . . . . . 607