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

Numerics

7.7.x release, new database schema structure   1

7.x release, upgrading from   1


Back to top


A

adding a Siebel user   1

additive schema upgrade files

applying in one job   1

applying individually   1

applying to the staging database   1

applying to the target database   1

description   1

implementing   1

preparing   1

SQL and JCL templates   1

allocating z/OS setup data sets   1

applicability of upgrade topics   1

ASCII database, merging the repository   1

attachments, file system   1


Back to top


B

backup and recovery stages, planning   1


Back to top


C

capacity planning   1

code page conversion   1

code page support   1

columns, denormalized in 7.5.3 Siebel Financial Services applications   1

configuration file   1

locating master file   1

new custom configuration file, producing   1

converting LONG VARCHAR columns   1

creating the staging database

generating DDL files   1

process of   1

required tasks   1

transferring staging DDL to the host   1

custom upgrades

support for   1 ,  2

using Oracle's Application Expert Services   1

Customer Repository, preparing for merge   1

custrep.dat file, regenerating   1


Back to top


D

data migration

creating temporary tables and indexes   1

on the target database   1

PRESCHEM jobs   1

running Gen Primary scripts   1

running scripts   1

data sets

allocating and populating   1

members in DSNHLQ.SIEBEL.EXEC   1

Database Configuration Utilities   1

Database Configuration Wizard

about running   1

Extract option   1

information required   1

information required for production only   1

modes   1

Prepare for Production mode   1

running on UNIX   1

running on Windows   1

database configuration, verifying   1 ,  2

database growth during upgrade   1

database schema

backing up   1

new structure in 7.7   1

testing before production upgrade   1

database size, estimating   1

Database Storage Configurator, using to amend bufferpool size   1

database template file, regenerating   1

database, preparing for upgrade

estimating database size   1

New Customer Repository, preparing to import   1

development database, backing up   1

development environment, postupgrade tasks

database template file, regenerating   1

obsolete tables, reapplying custom extensions   1

development upgrade

checking in development repository projects   1

creating storage groups   1

database configuration, verifying   1

DB2 software, upgrading   1

description   1

development database, backing up   1

foreground performance, increasing   1

preparing for intersection table maintenance and deduplication   1

process of   1

repositories for an ASCII database, merging   1

repositories for an EBCDIC database, merging   1

repository merge, about   1

repository merge, categories of object differences   1

repository merge, optimizing performance   1

requirements   1

schema, storage layout   1

schema, synchronizing   1 ,  2

Siebel user, adding   1

storage control file, modifying   1

storage control file, reviewing   1

storage control file, validating   1

tasks   1

driver files

about   1

example   1

locating   1

DSNTIAUL utility

@@TIAUL USERMOD patch   1

about   1

applying the patch   1

CCSID conversion errors   1


Back to top


E

EBCDIC database, merging repositories   1

EIM table partitioning, reviewing   1

environments, upgrade

development   1

production   1

production test   1

upgrade sequence   1

error messages

errors.htm file   1

errors.rtf file   1

errors.txt file   1

reviewing log files   1


Back to top


F

failed merges, recovering from   1

failed upgrade jobs, restarting   1

file system attachments, updating   1


Back to top


G

Gen Primary indexes   1

generating upgrade files

about   1

building JCL templates   1

process of   1

required tasks   1

transferring additive schema and JCL files to the z/OS host   1

transferring SCINDX.SQL to the z/OS host   1

group names, updating   1


Back to top


H

hardware and software, obtaining   1


Back to top


I

IBM utilities, obtaining required   1

importing development repository and schema definition files   1

importing seed data   1

indexes

about creating during the additive upgrade process   1

creating for data migration   1

Gen Primary indexes   1

rebuilding obsolete indexes   1

rebuilding on the target database   1

restructuring the index DDL   1

SCINDX.SQL file   1

infrastructure, upgrade   1

in-place target database upgrade   1

inputs to the production upgrade   1

interface tables and triggers, removing   1 ,  2

intersection tables

maintaining   1

preparing for maintenance and deduplication   1


Back to top


J

JCL template files, building   1

JCL UNIT parameter, customizing   1

JCL upgrade jobs

description   1

job cards   1

job dependencies   1

load and unload jobs   1

preparing   1

job cards   1

job flow of a production upgrade   1

job scheduling mode   1

job submission order, changing   1

@JOBPRFX member   1


Back to top


K

key members in DSNHLQ.SIEBEL.EXEC   1


Back to top


L

@LASTJOB member   1

license keys, adding new keys   1

load and unload jobs   1

load cards, adding the statistics clause to   1

loading log tables on the target database   1

loading the schema on the target database   1

log files

about   1

archiving manually   1

process log file   1

reviewing for errors   1 ,  2

running SQL against   1

SiebSrvr log files, about saving   1

state log file   1

log tables

creating and unloading   1

LONG VARCHAR columns, converting   1


Back to top


M

mapping your upgrade environments   1

master configuration file   1

merging the repository

about   1 ,  2

ASCII database   1

compiling an .srf file after   1

EBCDIC database   1

regenerating repository definition files   1

renaming tables before   1


Back to top


N

naming conventions   1

new customer repository, backing up   1

nonadditive schema upgrade files

applying to the staging database   1

applying to the target database   1

description   1

preparing and executing   1

preparing SQL and JCL templates   1

transferring to the z/OS host   1


Back to top


O

obsolete indexes, rebuilding   1

obsolete tables, reviewing   1

optimizing repository merge performance   1

optimizing unload and load job performance   1

override file, description   1


Back to top


P

Pause 1 files   1

Pause 2 files   1

Pause 3 files   1

planning the upgrade

backup and recovery stages, planning   1

code page support, considering   1

IBM utilities, obtaining required   1

new database schema structure in 7.7   1

process of   1

schedule, creating   1

security privileges, obtaining required   1

Siebel-scheduled mode or vendor-schedule mode   1

software and hardware, required   1

staging and target database   1

testing before production upgrade   1

postupgrade tasks

about   1

file system attachments, updating   1

for the Siebel application   1

inbound workflows, updating   1

log files, manually archiving   1

new custom configuration file, producing   1

upgrading seeded workflows   1

Prepare for Production mode

information required by Database Configuration Wizard   1

purpose   1

PRET jobs

about running   1

running on the target database   1

PRET members generated by Pretedit.txt   1

PRET processing

tables amended during unload processing   1

target tables amended   1

preupgrade tasks

about   1

New Customer Repository, preparing to import   1

target database   1

process log file   1

production environment upgrade

description   1

development environment, upgrading without   1

development repository and schema definition, importing   1

job flow   1

maintaining intersection tables   1

New Customer Repository, preparing to import   1

process of   1

production environment repositories, preparing for upgrade   1

renaming the production repository   1

requirements   1

tasks   1

testing before   1

z/OS host, requirements for upgrade   1

z/OS setup data set, defining and allocating   1

z/OS upgrade environment, setting up   1

production test environment

description   1

process of upgrading   1

tasks   1


Back to top


R

recovery, planning and backup stages   1

regenerating the custrep.dat file   1

regenerating the schema.ddl file   1

renaming the production environment repository   1

repositories

merging for an ASCII database   1

merging for an EBCDIC database   1

optimizing merge performance   1

production environment repositories, preparing for upgrade   1

regenerating definition files   1

renaming   1

renaming tables before merging   1

repository merge, about   1

repository merge, categories of object differences   1

repository merge, increasing the foreground performance   1

upgrading   1

resources for planning the upgrade   1

roadmap for performing the upgrade   1

running load and unload jobs in parallel   1

RUNSTATS jobs, generating   1


Back to top


S

S_LIT files, upgrading to S_CB_ASSET_VER files   1

schedule, planning   1

scheduling mode

about   1

specifying   1

schema

planning physical layout changes   1

storage layout, preparing   1

synchronizing   1 ,  2

schema.ddl file, regenerating   1

SCINDX.SQL file, transferring to the z/OS host   1

security, obtaining required privileges   1

seed data, importing   1

seeded workflows, upgrading   1

Siebel Application Integration (EAI), about using SAP and upgrading   1

Siebel database expected growth during upgrade (table)   1

Siebel Financial Services, denormalized columns for 7.5.3   1

Siebel Repository File (.srf)

compiling after the merge   1

compiling after the upgphys upgrade   1

creating a new .srf file   1

Siebel Upgrade Wizard

about   1

restarting   1

restarting after pauses   1

starting   1

stopping   1

Siebel user, adding   1

Siebel Workflow, inbound workflow, updating   1

SiebSrvr log files, about saving   1

software and hardware, obtaining   1

SQL and JCL templates   1

srf file

See Creating a New Siebel Repository File

staging database

about   1

applying additive schema upgrade files   1

applying nonadditive schema upgrade files   1

building   1

creating   1

generating schema DDL files   1

preparing for table creation   1

removing   1

required tasks   1

table creation   1

transferring staging DDL to the host   1

state log file   1

@STGTAR member   1

storage control file

extracting   1

modifying   1

preparing for the upgrade   1

reviewing   1

validating   1

validating extracted file   1

storage groups, creating   1

storage layout of the schema   1

storage_dedup.ctl file, creating   1

stored procedures

deleting   1

deploying   1

supported upgrade paths   1


Back to top


T

table creation on the staging database   1

table spaces, moving   1

tables

about moving   1

amended by PRET processing   1

amended during PRET unload processing   1

estimating number   1

intersection tables, preparing maintenance and deduplication   1

obsolete tables, reapplying custom extensions   1

reorganizing before the repository merge   1

target database

applying additive upgrade files   1

applying nonadditive schema upgrade files   1

creating and loading log tables   1

creating the schema   1

deploying stored procedures   1

in-place upgrade   1

loading the schema   1

migrating data   1

preupgrade tasks   1

process of upgrading   1

rebuilding indexes   1

removing interface tables and triggers   1

removing views   1

running PRET jobs   1

target tables amended by PRET processing   1

@TBOSTG member   1

@TBOTAR member   1

template files used during extract or merge operations   1

testing before production upgrade   1

tuning upgrade scripts

about   1

adding the statistics clause to load cards   1

changing job submission order   1

contacting Oracle's Application Expert Services   1

optimizing unload and load jobs   1

process of   1

running load and unload jobs in parallel   1

typographical conventions   1


Back to top


U

Unicode

migrating to   1

support   1

unload data sets, deleting   1

unload jobs

running on the target database   1

tables modified   1

@UPGFLOW member   1

@UPGPATH member   1

upgrade environments   1

development   1

production   1

production test   1

upgrade files

configuration file   1

deleting redundant files   1

driver files   1

generated for the upgrade   1

process of generating   1

required tasks   1

transferring to the z/OS host   1

upgrade files, generating   1

upgrade paths to Siebel CRM 8.1   1

upgrade planning resources   1

Upgrade Planning Worksheet   1

upgrade process

flow of   1

Pause 1   1

Pause 2   1

Pause 3   1

upgrade scripts, customizing   1 ,  2

upgrade tasks

development environment   1

production environment   1

production test environment   1

upgrade repository and import seed data   1

Upgrading from Siebel 6.x, 7.0.x, and 7.5.2   1

Upgrading from Siebel Release 7.x and Siebel Release 8.0.x

roadmap   1

Upgrading from Siebel Release 7.x and Siebel Release 8.0.x Without a Development Environment   1

upgrep+upgphys modes of Database Configuration Wizard   1

@UPGTYPE member   1

user, adding Siebel user   1

utilities

DSNTIAUL utility, using   1

IBM utilities, obtaining required   1


Back to top


V

validating the storage control file   1

validation errors for the storage control file   1

version 7.7, new database schema structure   1

views, removing from target database   1


Back to top


W

workflows, inbound, updating   1

worksheet, upgrade Planning   1


Back to top


Z

z/OS host

setup data set, defining and allocating   1

upgrade environment, setting up   1

upgrade requirements   1

Back to top

Siebel Database Upgrade Guide for DB2 for z/OS Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices.