Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
A
ASCII-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
B
buffer pools, allocating space and storage groups 1
C
CCSID, about choosing for implementation 1
Character Large Object support, about 1
Client Configuration Assistant, testing the connection 1
cursor close, configuring
about and parameters 1
D
Data Distribution Facility, customizing 1
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 objects
distribution, about planing for 1
estimating number required, about and table 1
Siebel tables. frequently used and largest (table) 1
Database Server software
UNIX, installing under 1
Windows, choosing different directory 1
Windows, installing under 1
DB2 catalog
storage file, extracting under UNIX 1
storage file, extracting under Windows 1
DB2 Client Configuration Assistant, testing the connection, testing 1
DB2 Command Window, using to verify network connectivity 1
DB2 connect
Connect Personal Edition (PE), used to support Siebel Dedicated Web Client 1
editions of 1
EE, using to support Siebel Web Client 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
Data Distribution Facility, customizing and setting up Workload Manager 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
DSNZPARM parameters, setting up the subsystem 1
IBM Fix Packs, about installing 1
odbcsql.exe, using to verify network connectivity 1
storage space, estimating 1
subsystem, setting up 1
system connectivity architecture 1
UNIX, verifying network and database connectivity 1
Windows, verifying network and database connectivity 1
DB2 operating system, about security 1
DB2 UDB, file installation
Siebel Database Server software, purpose of installing 1
Siebel Database server, preinstallation tasks 1
Siebel Schema, preparing for installing 1
UNIX installation directory structure 1
UNIX, installing Database Server software under 1
Windows installation directory structure 1
Windows, installing Database Server software under 1
DB2 UDB, from development to production
See also Cloning an OS/390 or 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 UDB, 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 UDB, Siebel Repository
installation and configuration tasks, table of 1
log files, reviewing 1
log files, troubleshooting 1
UNIX, importing under 1
Windows, importing under 1
DB2 UDB, Siebel Schema installation
DB2 catalog, extracting storage file under UNIX 1
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
missing tables, querying to identify 1
rerunning the installation 1
Siebel Database Storage Configurator, using to automate configuration 1 , 2
Siebel tables, validating 1
storage control file, about preparing and methods 1
UNIX, custom installation 1
UNIX, reviewing log files 1
UNIX, standard install option 1
Windows, custom installation 1
Windows, reviewing log files 1
Windows, standard install option 1
DB2/Connect installation 1
DBADN/CREATEDBA, about 1
dbchck, running to validate database 1
Deployment Planning Worksheet
about using 1
Master Worksheet 1
development database, applying schema extension to 1
documentation, additional 1
DSNZPARM parameters
cached statements, invalidating 1
DB2 global statement caching, about 1
NUMLKUS considerations 1
Siebel dynamic SQL, about 1
subsystem. about setting up 1
E
EBCDIC-based CCSID, about choosing for implementation 1
EIM tables partitioning strategies 1
external security adapter
LDAP configuration 1
OS/390, using 1
z/OS, using 1
G
Generate DDL Into Files, migrating customization to target db 1
grantstat.sql script, running 1
group ID protection scheme, about 1
guide
organization of 1
I
IBM Fix Packs, about installing 1
importing, improving EIM performance
DEFAULT COLUMN, using to improve throughput 1
EIM import process, tuning 1
transaction logging, disabling 1
unused non-unique indexes, dropping 1
unused triggers. dropping 1
indexes, reorganizing fragmented indexes 1
installation
See also Data Transmission Security
DBADN/CREATEDBA, roles and permissions required for 1
group ID protection scheme, about 1
SYSADM, roles and permissions required for 1
L
LDAP configuration
about 1
configuring (procedure) 1
local environment, updating 1
log files
Siebel Repository, reviewing 1
Siebel Repository, troubleshooting 1
UNIX, reviewing 1
Windows. reviewing 1
M
maintenance
fragmented tables and indexes, reorganizing 1
statistics, updating 1
migrating rules 1
N
NUMLKUS, considerations when setting up DSNZPARM parameters 1
O
odbcsql.exe, using to verify network connectivity 1
organization of guide 1
OS/390
system resource utilization, using cursor close 1
OS/390 development database, cloning
See also Cloning an OS/390 or z/OS Database
about 1
customizing using Assignment Manager and Siebel Workflow 1
migrating rules 1
schema changes, about applying to other databases 1
storage control file, extracting from development db 1
UNIX, generating DDL file 1
Windows, generating DDL file 1 , 2
OS/390 security
See also Using an External Security Adapter
external security adapter, using 1
passwords, about changing 1
P
password, changing and expiration 1
performance
fragmented tables and indexes, reorganizing 1
statistics, updating 1
R
resources, addition 1
Run DDL Automatically, migrating customizations to target db 1
RUNSTATS
caution about using to update statistics 1
migrate data, using for 1
S
SADMIN, about changing 1
security
See also Data Transmission Security
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 Storage Configurator
CLOBs, activating 1
control files, configuring 1
partitions, decreasing the number of 1
partitions, increasing the number of 1
worksheet, validating 1
Siebel Dedicated 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 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 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 Customizing Applications 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, 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
T
tables
See also Updating the S_LST_OF_VAL Table
fragmented tables, reorganizing 1
missing tables, querying to identify 1
tables, partitioning
about 1
Assignment Manager and Workflow tables, about and 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
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
See also About Cursor Close
fragmented tables and indexes, reorganizing 1
statistics, updating 1
U
UNIX
Database Server software, installing under 1
DB2 UDB, Siebel Schema installation, custom installation 1
DB2 UDB, Siebel Schema installation, reviewing log files 1
DDL, generating file 1
log files, acceptable errors 1
multilingual seed data, installing 1
network connectivity, verifying 1
schema, migrating 1
Siebel Database Server, installation directory structure 1
Siebel Repository, importing 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
W
Windows
Database Server software, choosing different directory 1
Database Server software, installing under 1
DB2 host, verifying network and database connectivity 1
DB2 UDB, Siebel Schema installation, custom installation 1
DB2 UDB, Siebel Schema installation, reviewing log files 1
multilingual seed data, installing 1
network connectivity, using DB2 Command Window to verify 1
schema, migrating 1
Siebel Database Server, installation directory structure 1
Siebel Repository, importing 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
Workload Manager, setting up 1
worksheet, Deployment Planning 1
Z
z/OS
system resource utilization, using cursor close 1
z/OS development database, cloning
See also Cloning an OS/390 or z/OS Database
about 1
storage control file, extracting from development, db 1
UNIX, generating DDL file 1
Windows, generating DDL file 1 , 2
z/OS security
See also Using an External Security Adapter
external security adapter, using 1
zSeries customers, about changing passwords 1
Bookshelf Home | Contents | Index | Search | PDF | ![]() ![]() ![]() ![]() |
Implementing Siebel eBusiness Applications on DB2 UDB for OS/390 and z/OS Published: 18 April 2003 |