7.14 Data Replication/Temp DB Spaces

Dear All, We recently enabled data replication between two NCR servers running 7.14 Online. On the primary there are 4 temp dbspaces that are defined in DBSPACETEMP. On the secondary these dbspaces are not available. The result being that queries that need temp tables will not work on the secondary server. The problem, I believe, stems from the fact that temp db spaces are not backed up. This means that while they show in the reserved pages and are listed as db spaces they were not created by the restore. Maybe we should have manually created them on the secondary before doing the restore. Basically we have the temp spaces on the primary but cannot access them on the secondary. We cannot drop and re-create them on the secondary as this is a logged operation and it cannot be performed on the secondary. Any one have thoughts on this? I believe we will have to drop and re-create them on the primary and have this replicated over onto the secondary. But we dont want to do this unless we have to. Regards, Jason