6 Validations and Checks
Table 6-1 Validations and Checks
| Before txns posting |
|---|
| Set logging parameter to 'N' |
| Turn scheduler off on Test system |
| Ensure that setup tables are not truncated before refresh (only in case of a new refresh). |
| Ensure that jobs, job_sets, job_threads and job_buckets are copied over from Prod onto test (only in the case of new refresh). |
| Make sure that the batch jobs are setup the same in Prod and Test. |
| Ensure sequences are in sync with Production |
| Bump up sequences - recreate sequences |
| Ensure that the Test specific setup scripts are run for 1) all seed data 2) DML scripts to create data in the new tables |
| Check GL post date |
| Check log tables have just one day's transactions |
| Query by txn_tcd_code, check numbers match on Prod and Test |
| Drop index TXNT_LOG_UDX |
| Make sure that the batch jobs have no sequence numbers overlapping - the scheduler might not start because of this. |
| Run all the DML scripts - for seed data and others |
| Check for database locks on both test systems |
| Check run_dt_nxt on all batch jobs - should be updated correctly |