When trying to create a foreign key constraint on a table in a z/OS database, the following error appears:
'Template repository is not installed on server. Please install QUEST.QCTEMPLATE_REPO200'
The message appears when the Toad Mainframe components have not been installed on the mainframe machine.
The mainframe components are needed in order to execute the CHECK DATA utility, after the ALTER TABLE statement where the foreign key is added.
Please install the Toad Mainframe components.
The document on how to install the mainframe components can be found at C:\Program Files\Quest Software\Toad for DB2 4.6\Quest_zOS_component_InstallGuide.pdf
Enhancement request CR 72437 has been submitted to Development for consideration in a future release of Toad for DB2.