Re: DR Question
On Thu, 17 Apr 1997, David Williams wrote:
}
} In article <5j0ihd$gf2@cssun.mathcs.emory.edu>, Con Woodall <cwoodall@vt
} h4.vth.colostate.edu> writes
} >There is some inconsistency here, bot it doesn't "always" work but I
} >find that I need to have teh DBSPACETEMP variable set
} >
} >for example
} >export DBSPACETEMP=space1,space2
} >
} >if you have space1 and space 2 identified in your onconfig file. I have only
} >seen this when working with the secondary portion of a Data Replication
} >pair. My experience has been through dbaccess or isql/report where
} >I am connecting to the secondary from another service, eith through
} >the Connect option in dbaccess or the database statement in isql/report
} >
} >Hope this helps
} >
}
} Remember that a secondary instance MUST have one dbspace which is A
} TEMPORARY DBSPACE (create dbspace with TEMP=Y in monitor) or use
} -t option to onspaces.
}
} --
} David Williams
}
Not to beat a dead horse, but the spaces in question are indeed there and
so specified on the secondary according to onmonitor and onstat - d
in the sample I cited with the "export DBSPACETEMP....." above. and
it certainly appears from onstat -d that those temp spaces are indeed
being used for temporary tables, sorts, etc.
This is 7.11.uc1 by the way.
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523,
USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu
"There is no 'maybe' in Boolean algebra."
--