Upgrade Guide for DB2 UDB for z/OS > Postupgrade Tasks for Applications >

Upgrading the Test Status in Siebel Training After Upgrade

Upgrades: Releases 7.0.x, 7.5.x.

Environments: Production test, production.

This topic is part of an upgrade process. See How to Perform the Upgrade.

As of Release 7.7, completed tests can have one of two statuses:

• Completed-Passed
• Completed-Failed

In previous releases, completed tests had only one status: Completed.

If you want to revise existing data to reflect the new completion statuses, you can write a script to revise the records. The script should use the following logic:

• If at least one test has reached the maximum attempts and not been passed, mark the status as Completed-Failed.
• If all tests have been passed at least once, mark the status as Completed-Passed. Not all test attempts have to be cleared. If there were three attempts allowed and the student failed on the first two but passed on the third attempt, this is acceptable.
• If at least one test has not been attempted, then there should be no change in the status of the registration. So, if a course had a Course Survey associated to it, and if the user had not attempted it yet, its status cannot go to Completed-Passed.
• Else CompletedFailed takes precedence over Completed-Passed.