A - B - C - D - E - G - I - L - M - N - O - P - R - S - T - U - W - Z

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


Back to top


B

buffer pools, allocating space and storage groups  1


Back to top


C

CCSID, about choosing for implementation  1

Character Large Object support, about  1

.ctl file

See Cloning an z/OS and OS/390 Database


Back to top


D

data

See 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 DSNZPARM Parameters for Setting Up the Subsystem

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

Database Storage Configuration

See Using the Siebel Database Storage Configurator See About the Siebel Database Storage Configurator

DB2 catalog

storage file, extracting under UNIX  1

storage file, extracting under Windows  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

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 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 z/OS and OS/390 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

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

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

Windows, custom installation  1

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 Using the Siebel Database Storage Configurator See About the Siebel Database Storage Configurator

Deployment Planning Worksheet

about using  1

Master Worksheet  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


Back to top


E

EBCDIC-based CCSID, about choosing for implementation  1

EIM tables partitioning strategies  1

external security adapter

OS/390, using  1

z/OS, using  1


Back to top


G

Generate DDL Into Files, migrating customization to target db  1

global statement caching

See About DB2 Dynamic Statement Caching

grantstat.sql script, running  1

group ID protection scheme, about  1


Back to top


I

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 for Siebel Clients

DBADM/CREATEDBA, roles and permissions required for  1

group ID protection scheme, about  1

SYSADM, roles and permissions required for  1


Back to top


L

local environment, updating  1

log files

Siebel Repository, reviewing  1

Siebel Repository, troubleshooting  1

UNIX, reviewing  1

Windows, reviewing  1


Back to top


M

maintenance

fragmented tables and indexes, reorganizing  1

statistics, updating  1

migrating rules  1

Mobile Web Clients

See Data Transmission Security for Siebel Clients


Back to top


N

NUMLKUS, considerations when setting up DSNZPARM parameters  1


Back to top


O

odbcsql.exe, using to verify network connectivity  1

OS/390 development database, cloning

See also Cloning an z/OS and OS/390 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 About Using an External Security Adapter

external security adapter, using  1

passwords, about changing  1


Back to top


P

password, changing and expiration  1

performance

fragmented tables and indexes, reorganizing  1

statistics, updating  1


Back to top


R

Run DDL Automatically, migrating customizations to target db  1

RUNSTATS

migrate data, using for  1


Back to top


S

S_ESCL_LOG table

See Partitioning S_ESCL_REQ and S_ESCL_LOG Tables

S_ESCL_REQ table

 1

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 ,  2

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 Enterprise Integration Manager

See 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, Export, 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

about  1 ,  2

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


Back to top


T

tables

See also Considerations for EIM Tables

fragmented tables, reorganizing  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

templates

See About Siebel Objects See About the 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


Back to top


U

Unicode conversion tables  1

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

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

storage file, extracting from the DB2 catalog  1


Back to top


W

Web Client

See Data Transmission Security for Siebel Clients

Windows

Database Server software, choosing different directory  1

Database Server software, installing under  1

DB2 UDB, Siebel Schema installation, custom installation  1

DB2 UDB, Siebel Schema installation, reviewing log files  1

DDL file, generating  1 ,  2

multilingual seed data, installing  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

worksheet, Deployment Planning  1


Back to top


Z

z/OS development database, cloning

See also Cloning an z/OS and OS/390 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 About Using an External Security Adapter

external security adapter, using  1

zSeries customers, about changing passwords  1

Back to top

Implementing Siebel eBusiness Applications on DB2 UDB for z/OS and OS/390