Using Oracle

You should use the cost-based optimizer during the upgrade. The application engine scripts use MetaSQL to run the update statistics command at various times during data conversion. If you are running the rule-based optimizer, you will not take advantage of these statements.

When running the alter scripts, remember the Oracle hint /*APPEND*/. This command will improve the performance of your alter script if you are doing an “Alter by Rename.” This hint performs like an Oracle Direct Load Insert and does not capture redo or recovery information. The syntax is as follows:

INSERT  /*+ APPEND */  INTO TABLENAME  (FIELD1, FIELD2, ...

Make sure your database administrator has turned autoextend on. Autoextend allows tablespaces to grow larger than their set maximum size and will be useful during the upgrade process since tablespaces grow several times larger than they would in production.

Alter the tablespace for PSIMAGE and increase it to 200 MB; autoextend on the next 10 MB; set the maxsize to unlimited.