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

A

accessing the DB2 catalog   1

application data security   1

Assignment Manager

customize applications, using for   1

table partitioning strategies   1

authorizations, based on implementation task (table)   1 ,  2

Back to top

B

buffer pools

allocating space   1

errors   1

Back to top

C

Character Large Object support, about   1

CLOB columns

converting Long Varchars   1

enabling for a table   1

extension columns   1

in Siebel CRM tables   1

issues with using   1

clustering index

choosing   1

prepartitioned tables   1

connecting to DB2

CREATEDBA privileges   1

DBADM privileges   1

SYSADM privileges   1

connectivity architecture   1

Back to top

D

data

See About Setting Up EIM for DB2

Data Distribution Facility   1

data mapping

MS_IDENT, caution about loading   1

necessary data, about loading   1

presorting data during load, about   1

data transmission security   1

database

estimating number of objects   1

installing on DB2 for z/OS   1

objects in the storage control file   1

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  See DSNZPARM Parameter Settings for Siebel Business Applications

database objects, estimating number required   1

Database Storage Configuration

See Amending the Storage Control File for New Schema Objects See Using the Siebel Database Storage Configurator See About Modifying Storage Control Files

DB2 catalog

extracting a storage control file   1

granting access to   1

validating extracted storage control file   1

DB2 Connect

binding packages   1

configuration tasks   1

Connect Personal Edition (PE), used to support Siebel Developer Web Client   1

editions of   1

EE, ASE or UE, using to support Siebel Web Client   1

Enable_Euro_Codepage variable   1

installation   1

postinstallation tasks   1

setup instructions for configuration, about   1

setup options   1

testing the database connection (UNIX)   1

testing the database connection (Windows)   1

DB2 file installation, preinstallation tasks   1

DB2 global statement caching

about using   1

cached statements, invalidating   1

DB2 host, preparing for implementation on

buffer pools, allocating space   1

database objects, estimating number required   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 Siebel Repository, troubleshooting log files   1

DB2 subsystem, setting up

about   1

choosing the database CCSID   1

configuring DDF and WLM   1

Unicode conversion tables   1

using separate subsystems for Siebel   1

DB2, from development to production

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

Siebel File System, populating   1

table privileges, granting   1

Windows, importing new language   1

Windows, installing multilingual seed data   1

DB2, Siebel Schema installation

DB2 catalog, extracting storage file   1

DDL, applying on DB2 host   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, preparing and methods   1

Windows, custom installation   1

DB2Connect_Enable_Euro_Codepage variable   1

DB2CONNECT_IN_APP_PROCESS variable   1

DBADM and CREATEDBA, about   1

dbchck, running to validate database   1

dbconf.xls

See Amending the Storage Control File for New Schema Objects See Using the Siebel Database Storage Configurator See About Modifying Storage Control Files

deploying Siebel on z/OS, preparing   1

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

NOT PADDED parameter   1

NUMLKUS considerations   1

Siebel dynamic SQL, about   1

Back to top

E

EIM tables   1

encoding systems sort order   1

errors generated on DB2 for z/OS V9   1

euro codepage support   1

even data distribution, partitioning for   1

extension columns

CLOB data types   1

creating   1

Back to top

F

fix packs, IBM   1

Back to top

G

Generate DDL Into Files, migrating customization to target database   1

global statement caching

See Enabling DB2 Dynamic Statement Caching

grantstat.sql script, running   1 ,  2

group ID protection scheme, about   1

Back to top

I

IBM fix packs   1

IDTHTOIN parameter   1

importing the Siebel Repository   1

importing, improving EIM performance

DEFAULT COLUMN, using to improve throughput   1

EIM import process, tuning   1

transaction logging, disabling   1

unused nonunique indexes, removing   1

indexes, reorganizing fragmented indexes   1

installing Siebel

DBADM and CREATEDBA, roles and permissions required for   1

group ID protection scheme, about   1

SYSADM, roles and permissions required for   1

Back to top

L

LOBVALA parameter   1

LOBVALS parameter   1

local environment, updating   1

log files

Siebel Repository, troubleshooting   1

Unicode migration   1

Long columns

about   1

converting to CLOB columns   1

DB2 for z/OS version 9   1

errors generated on DB2 for z/OS V9   1

moving table spaces   1

table space storage   1

Back to top

M

maintenance tasks

fragmented tables and indexes, reorganizing   1

statistics, updating   1

MAXAGENTS parameter, specifying a value for   1

migrating rules   1

migrating the Siebel schema to Unicode   1

Back to top

N

naming conventions

auxiliary objects   1

file paths and directories   1

objects   1

partitioning triggers   1

table spaces   1

NOT PADDED DSNZPARM parameter   1

NUMLKUS parameter   1

Back to top

O

odbcsql.exe, using to verify network connectivity   1

operating system security   1

Back to top

P

PADIX parameter   1

partitioning indexes, using   1

partitioning triggers, naming conventions   1

passwords

changing and expiration   1

changing from client computers   1

performance

fragmented tables and indexes, reorganizing   1

statistics, updating   1

postinstallation tasks   1

preparing to deploy Siebel on z/OS   1

Back to top

R

Run DDL Automatically, migrating customizations to target database   1

RUNSTATS, using   1

Back to top

S

S_ESCL_LOG table   1

S_ESCL_REQ table   1

SADMIN, about changing   1

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

Siebel application data security, about   1

Siebel Database Storage Configurator

about   1

CLOBs, activating   1

control files, configuring   1

partitioning tables   1

using to convert the storage control file to Unicode   1

worksheet, validating   1

Siebel Developer Web Client, DB2 Connect PE   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

about   1

naming conventions   1

Siebel Remote Transaction Logging table

performance considerations   1

transaction logging, turning off   1

Siebel Repository

importing   1

importing a new language   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

validating   1

Siebel storage control file templates

about   1 ,  2

buffer pools   1

object naming conventions   1

partitioning, changing partition keys   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

Character Large Object (CLOB) support, about   1

configuration file parameters, table of   1

database options, setting   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

sort order, encoding systems   1

SQLPROFILE log, reviewing   1

SSEROLE, about changing names   1

statistics, updating   1

storage control file

about   1

amending for new schema objects   1

buffer pools   1

creating   1

database objects   1

default objects   1

partition base definition   1

partition definition   1

partition part definition   1

preparing and methods   1

symbolic variables in   1

table objects   1

table space definition   1

table space objects   1

templates   1

Tsparts definition   1

validating   1

storage groups   1

storage space, estimating   1

synchronizing, about data transmission security   1

SYSADM, about   1

Back to top

T

table objects in the storage control file   1

table partitioning

about   1 ,  2

Assignment Manager and Workflow tables, partitioning Strategies   1

choosing a clustering index   1

choosing a partitioning key column   1

customizing   1

EIM tables   1

EIM tables, partitioning strategies   1

example   1

example DDL   1

partitioning index, about and diagram example   1

partitioning keys   1

partitioning methods   1

prepartitioned tables   1

S_DOCK_TXN_LOG   1

S_ESCL_REQ and S_ESCL_LOG   1

Siebel Remote Transaction Logging table, about and strategies   1

storage control file templates   1

triggering, about using for performance   1

using dbconf.xls   1

using indexes   1

using partitioning indexes   1

with DB2 Version 8   1

table spaces

determining the appropriate size   1

in the storage control file   1

LONG columns   1

moving tables between   1

naming conventions   1

tables

fragmented tables, reorganizing   1

moving table spaces   1

target database

customization, migrating from development to target db   1

migrating rules   1

preparing target database   1

schema changes, applying to target db   1

templates

See About Siebel Objects See About Storage Control File Templates

Time Sharing Option (TSO), about changing passwords   1

transaction logging, disabling to improve EIM performance   1

Back to top

U

Unicode

conversion tables   1

migrating the Siebel schema to   1

schema storage requirements   1

Back to top

V

validating the Siebel Schema   1

Back to top

W

Windows

DB2, Siebel Schema installation, custom installation   1

multilingual seed data, installing   1

schema, migrating   1

Siebel Repository, importing new language   1

Siebel Repository, troubleshooting log files   1

storage file, extracting from the DB2 catalog   1

Workflow table partitioning strategies   1

Workload Manager   1

worksheet, Deployment Planning   1

Back to top

Z

z/OS development database, cloning

about   1

storage control file, extracting from development database   1

z/OS users, about changing passwords   1

Back to top