Bookshelf Home | Contents | Index | PDF |
Numerics7.7.x release, new database schema structure 1 7.x release, upgrading from 1 Aadding 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 Bbackup and recovery stages, planning 1 Ccapacity 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 using Oracle's Application Expert Services 1 Customer Repository, preparing for merge 1 custrep.dat file, regenerating 1 Ddata 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 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 EEBCDIC 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 Ffailed merges, recovering from 1 failed upgrade jobs, restarting 1 file system attachments, updating 1 GGen 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 Hhardware and software, obtaining 1 IIBM 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 JJCL 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 Kkey members in DSNHLQ.SIEBEL.EXEC 1 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 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 Mmapping your upgrade environments 1 master configuration file 1 merging the repository ASCII database 1 compiling an .srf file after 1 EBCDIC database 1 regenerating repository definition files 1 renaming tables before 1 Nnaming 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 Oobsolete indexes, rebuilding 1 obsolete tables, reviewing 1 optimizing repository merge performance 1 optimizing unload and load job performance 1 override file, description 1 PPause 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 Rrecovery, 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 SS_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 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 Ttable 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 UUnicode 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 Vvalidating 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 Wworkflows, inbound, updating 1 worksheet, upgrade Planning 1 Zz/OS host setup data set, defining and allocating 1 upgrade environment, setting up 1 upgrade requirements 1 |
Siebel Database Upgrade Guide for DB2 for z/OS | Copyright © 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |