·
If not performed by the CSR
during the outage window, run checktable DBC
only at level 3. This should only take a
few minutes.
·
If not performed by the CSR
during the outage window, run scandisk and checktable to verify the rest of the
file system is clean.
·
Backup DBC and any other
critical databases. If any new system
databases were created as part of the upgrade, remember to grant the
appropriate dump/restore privileges on them and add them to your BAR scripts.
·
Run collect stats on
application tables if recommended for this upgrade version.
·
Check/reset TDWM,
DBScontrol, XCTL and PSF settings.
·
Restart DBQL, Access
logging, System Security, Priority scheduler, etc. as before.
·
Restart Viewpoint
monitoring by enabling the system on the Viewpoint servers and/or restart the Teradata
Manager server
·
Recreate Hash, Join Indexes, Triggers and UDFs that were
dropped prior to the upgrade.
·
Recreate journal tables (if any).
·
Make sure the default date format
is set correctly. This often gets changed.
·
The upgrade scripts would
have identified and recompiled any Teradata Stored Procedures (TDSP).
·
Recompile and test any user stored
procedures. The upgrade will not have recompiled any stored
procedures whose code
is stored outside the system
·
Restore DDL for system databases
that you may have modified (i.e. Sys_Calendar.CALENDAR).
·
Validate statistics are
collected as should be on DBC and user tables.
Recollect if necessary.
·
If you have to restore a
PPI table you may need to revalidate the Primary Index afterwards : 'Alter
table x revalidate primary index'. This command normally runs quickly.
·
May need to adjust user
spool settings if number of amps changed.
·
DBA regression testing. Run test program to validate all settings,
connectivity, programs, DBC tables, procedures, etc.
·
Test applications such as
SQL Assistant, BTEQ, BTEQWin, OLELoad, Teradata Administrator, Visual Edge,
TASM, AQM, Teradata Manager, backup, restore etc.
·
Start/confirm TDP's and
enable logons.
·
Restart job schedulers such as AutoSys, cron, etc.
·
Restart open systems backup
application.
·
Notify customers of system
availability.
·
Sign off on user acceptance
of upgrade with Teradata.
·
Close Change Controls –
Teradata & Local.
