About Validation Errors

Run the validation process until no errors are reported. The most common reason that the validation process fails is because table spaces for the Siebel schema are not large enough to hold the new table definitions. If this error occurs, examine the validation log file and identify the names of the buffer pools associated with the table spaces generating errors. Increase the bufferpool sizes as necessary in the storage.ctl file.

You can amend the storage control file using any of the methods described in Methods of Modifying the Storage Control File. To amend buffer pool sizes associated with table spaces generating errors using the Database Storage Configurator (dbconf.xls), perform the following procedure. For further information on using the Database Storage Configurator, see Implementing Siebel Business Applications on DB2 for z/OS.

To amend bufferpool sizes using dbconf.xls

1. Open dbconf.xls and select Enable Macros when prompted.

2. Import the storage control file that generated the validation errors:

   1. With the Home tab active, click Import.

   2. Go to the directory where your storage control file is located and double-click the appropriate file.

   3. When the import process is completed, click OK.

3. The following message appears:

   Please enter default values for your system 
   

   Either amend the values for the displayed parameters, or accept the default values. (This screen does not appear if you have already set the default values.)

4. Click Set.

5. You are prompted to indicate whether or not you want to import row lengths. Select No.

6. Select the Functions tab, then click the Tools tab.

7. Click the Repair BP Validation button.

8. Select the log file generated by the validation process by double-clicking on the file, or selecting the file and clicking Open. This file lists the names of the buffer pools associated with the table spaces generating errors.

9. The Database Storage Configurator updates the buffer pool sizes for the table spaces generating errors in the storage control file. When the process is completed, the following message is displayed.

   Bufferpools have been updated successfully!
   

10. Click OK.

11. Click the Home tab, and then click Export to save the amended storage control file. Save the file with the same filename. A message is displayed stating that the file will be validated (the syntax is validated).

12. Click OK. When the validation process is completed, a message is displayed if the file contains any values that require review.

13. Click OK. The values in the file that require a review are displayed, such as Error: (highlighted in the color Red) and Warning: (highlighted in the color Yellow).

14. Make a note of the object that is generating the error or warning; the relevant object type tab and the object are highlighted. Click OK.

15. Navigate to the object that generated the validation warning or error by selecting Structures, and then object type. Amend the highlighted values if required, then export the file again.

16. When the validation process is completed successfully and you have exported the file, exit from the Database Storage Configurator.

17. Validate the storage control file against the target schema again using the Database Configuration Wizard.