Bookshelf Home | Contents | Index | PDF |
AASCII-based CCSID, about choosing for implementation 1 Assignment Manager customize applications, using for 1 table partitioning strategies 1 authorizations, based on implementation task (table) 1 , 2 auxiliary objects, naming conventions 1 Bbuffer pools, allocating space and storage groups 1 CCCSID, about choosing for implementation 1 Character Large Object support, about 1 Ddata See About Setting Up EIM for DB2 data mapping MS_IDENT, caution about loading 1 necessary data, about loading 1 presorting data during load, about 1 database schema changes, about updating local databases 1 schema extensions, applying to development database 1 target database, applying schema changes to 1 target database, migrating rules 1 target database, preparing 1 Database Manager Configuration Parameters See Recommended DSNZPARM Parameter Settings database objects distribution, about planning for 1 estimating number required, about and table 1 Siebel tables. frequently used and largest (table) 1 Database Server software Windows, choosing different directory 1 , 2 Windows, installing under 1 Database Storage Configuration See Modifying Storage Control Files Using the Database Storage Configurator See Modifying the Storage Control File DB2 catalog storage file, extracting under Windows 1 DB2 Connect Connect Personal Edition (PE), used to support Siebel Developer Web Client 1 EE, ASE or UE, using to support Siebel Web Client 1 DB2 connect editions of 1 setup instructions for configuration, about 1 setup options 1 DB2 global statement caching about using 1 cached statements, invalidating 1 DB2 host, preparing for implementation on buffer pools, allocating space and storage groups 1 database CCSID, choosing 1 database object, estimating number required 1 database objects, about planning distribution of 1 database objects, frequently used and largest Siebel tables (table) 1 database, about connecting to 1 DB2 connect, setup options 1 DB2, setup instructions 1 odbcsql.exe, using to verify network connectivity 1 storage space, estimating 1 system connectivity architecture 1 DB2 operating system, about security 1 DB2, file installation Siebel Database Server software, purpose of installing 1 Siebel Database server, preinstallation tasks 1 UNIX installation directory structure 1 Windows installation directory structure 1 Windows, installing Database Server software under 1 DB2, from development to production See also Process of Cloning a DB2 for z/OS Database Siebel Schema, applying schema changes to target db 1 Siebel Schema, applying schema extensions to development database 1 Siebel Schema, making custom extensions to 1 Siebel Schema, migrating customizations to target database 1 Siebel Schema, preparing target database 1 Siebel Schema, tasks overview 1 DB2, post-installation tasks database, validating 1 loadstat.sql script, editing and running 1 Siebel File System, populating 1 table privileges, granting 1 UNIX, importing new language 1 UNIX, installing multilingual seed data 1 Windows, importing new language 1 Windows, installing multilingual seed data 1 DB2, Siebel Repository installation and configuration tasks, table of 1 log files, reviewing 1 log files, troubleshooting 1 DB2, Siebel Schema installation DB2 catalog, extracting storage file under Windows 1 DDL, applying on DB2 host 1 installation and configuration tasks, table of 1 installation process, about 1 rerunning the installation 1 Siebel Database Storage Configurator, using to automate configuration 1 Siebel tables, validating 1 storage control file, about preparing and methods 1 UNIX, custom installation 1 UNIX, reviewing log files 1 Windows, custom installation 1 , 2 Windows, reviewing log files 1 Windows, standard install option 1 DB2/Connect installation 1 DBADM/CREATEDBA, about 1 dbchck, running to validate database 1 dbconf.xls See Modifying Storage Control Files Using the Database Storage Configurator See Modifying the Storage Control File Deployment Planning Worksheet about using 1 development database, applying schema extension to 1 DSNZPARM parameters cached statements, invalidating 1 DB2 global statement caching, about 1 NUMLKUS considerations 1 Siebel dynamic SQL, about 1 EEBCDIC-based CCSID, about choosing for implementation 1 EIM tables partitioning strategies 1 GGenerate DDL Into Files, migrating customization to target database 1 global statement caching See Enabling DB2 Dynamic Statement Caching grantstat.sql script, running 1 group ID protection scheme, about 1 Iimporting, improving EIM performance DEFAULT COLUMN, using to improve throughput 1 EIM import process, tuning 1 transaction logging, disabling 1 unused nonunique indexes, dropping 1 unused triggers. dropping 1 indexes, reorganizing fragmented indexes 1 installation See also Data Transmission Security for Siebel Clients DBADM/CREATEDBA, roles and permissions required for 1 group ID protection scheme, about 1 SYSADM, roles and permissions required for 1 Llocal environment, updating 1 log files Siebel Repository, reviewing 1 Siebel Repository, troubleshooting 1 UNIX, reviewing 1 Windows, reviewing 1 Mmaintenance fragmented tables and indexes, reorganizing 1 statistics, updating 1 migrating rules 1 Mobile Web Clients See Data Transmission Security for Siebel Clients NNUMLKUS, considerations when setting up DSNZPARM parameters 1 Oodbcsql.exe, using to verify network connectivity 1 Ppassword, changing and expiration 1 performance fragmented tables and indexes, reorganizing 1 statistics, updating 1 RRun DDL Automatically, migrating customizations to target database 1 RUNSTATS migrate data, using for 1 SS_ESCL_LOG table See The S_ESCL_REQ and S_ESCL_LOG Tables S_ESCL_REQ table SADMIN, about changing 1 security See also Data Transmission Security for Siebel Clients data transmission, about 1 DB2 operating system 1 password change and expiration, about 1 required authorizations, table of 1 , 2 Siebel application data security, about 1 seed data UNIX, installing multilingual seed data 1 Windows, installing multilingual seed data 1 Siebel application data security, about 1 Siebel Database Server UNIX, installation directory structure 1 Windows, installation directory structure 1 Siebel Database Server for DB2, installing directory, choosing different 1 Siebel Database Storage Configurator about 1 CLOBs, activating 1 control files, configuring 1 partitions, decreasing the number of 1 partitions, increasing the number of 1 worksheet, validating 1 Siebel Developer Web Client DB2 Connect PE, using to support 1 Siebel dynamic SQL, about 1 Siebel EIM, using to migrate data for DB2 application dictionary, failed to load message 1 data mapping, planning 1 database logging, optimizing 1 EIM aborts with not authorized to for RUNSTATS 1 EIM batch size, choosing optimal size 1 import considerations 1 load process, performance degradation during 1 maximum locks exceeded, about 1 parallel streams, choosing optimal number 1 partitioning scheme, choosing 1 RUNSTATS, using 1 S_LST_OF_VAL Table, updating 1 setting up for 1 SQLPROFILE log, reviewing 1 Siebel Enterprise Integration Manager See About Setting Up EIM for DB2 Siebel File System, populating 1 Siebel Mobile Web Client data transmission security, about 1 Siebel objects naming conventions 1 Siebel Remote Transaction Logging table performance considerations 1 transaction logging, turning off 1 Siebel Repository See Siebel Repository Import and Postinstallation Tasks Siebel Schema changes, about applying to local databases 1 extensions, applying schema changes to target db 1 extensions, applying to development database 1 extensions, making custom extensions to 1 extensions, migrating customization to target database 1 extensions, preparing target database 1 extensions, tasks overview 1 migrating rules 1 Siebel storage control file templates buffer pools 1 object naming conventions 1 partitioning, changing partition keys 1 partitioning, deciding what to and example 1 prepartitioned Siebel tables, table of 1 storage groups, about 1 table spaces, about 1 tables, without page-level locking (table of) 1 Siebel templates partitioning, changing partition keys 1 partitioning, deciding what to and example 1 prepartitioned Siebel tables, table of 1 Siebel Tools See also Application Customization Using Assignment and Workflow Rules Character Large Object (CLOB) support, about 1 configuration file parameters, table of 1 database options, setting 1 index truncation, about 1 table grouping file names, about 1 unused indexes, about deleting 1 VARCHAR field length, about reducing 1 Siebel Web Client data transmission security, about 1 DB2 Connect EE, ASE or UE, using to support 1 Siebel Workflow, using to customize applications 1 SQLPROFILE log, reviewing 1 SSEROLE, about changing names 1 statistics, updating 1 storage control file, about preparing and methods 1 storage space, estimating 1 synchronizing, about data transmission security 1 SYSADM, about 1 Ttables See also Considerations for EIM Tables fragmented tables, reorganizing 1 tables, partitioning about 1 Assignment Manager and Workflow tables, partitioning Strategies 1 EIM tables, partitioning strategies 1 partitioning index, about and diagram example 1 Siebel Remote Transaction Logging table, about and strategies 1 triggering, about using for performance 1 target database customization, migrating from development to target db 1 migrating rules 1 preparing target db 1 schema changes, applying to target db 1 templates See Siebel Objects See Siebel Storage Control File Templates Time Sharing Option (TSO), about changing passwords 1 transaction logging, disabling to improve EIM performance 1 triggers unused triggers, dropping to improve EIM performance 1 tuning fragmented tables and indexes, reorganizing 1 statistics, updating 1 UUnicode conversion tables 1 UNIX DB2, Siebel Schema installation, custom installation 1 DB2, Siebel Schema installation, reviewing log files 1 log files, acceptable errors 1 multilingual seed data, installing 1 Siebel Database Server, installation directory structure 1 Siebel Repository, importing new language 1 Siebel Repository, reviewing log files 1 Siebel Repository, troubleshooting log files 1 WWeb Client See Data Transmission Security for Siebel Clients Windows Database Server software, choosing different directory 1 , 2 Database Server software, installing under 1 DB2, Siebel Schema installation, custom installation 1 , 2 DB2, Siebel Schema installation, reviewing log files 1 multilingual seed data, installing 1 schema, migrating 1 Siebel Database Server, installation directory structure 1 Siebel Repository, importing new language 1 Siebel Repository, reviewing log files 1 Siebel Repository, troubleshooting log files 1 Siebel Schema on DB2, standard install option 1 storage file, extracting from the DB2 catalog 1 Workflow table partitioning strategies 1 worksheet, Deployment Planning 1 Zz/OS development database, cloning See also Process of Cloning a DB2 for z/OS Database about 1 storage control file, extracting from development database 1 z/OS users, about changing passwords 1 |
Implementing Siebel Business Applications on DB2 UDB for z/OS |