checkpoint
Posted in 2005
Hi there, I try to run a sql query statement in background, but seems the thread dead or gone without any error. I know the query will return some data, but when I check, there is no data been generated. I check the online log, and find out that there is a checkpoint when I run the sql. Will it cause trouble? From the manual, it was saying "The database server prevents user threads from entering critical sections." How system will handle it after checkpoint. My understand is it will continue to process the thread. Thanks for any advice. Denny ******************************************* The information contained in this e-mail message may contain privileged and confidential information. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you have received this message in error, please notify the sender by return e-mail, delete this message and destroy any copies. Internet e- mail is not guaranteed to be secure or error-free. Messages could be intercepted, corrupted, lost, arrive late or contain viruses. Livingston International will not be liable for these risks. ******************************************* Ce message electronique pourrait contenir des informations privilegiees et confidentielles. Si vous n'en etes pas le recipiendaire prevu, nous vous signalons qu'il est strictement interdit d'examiner, de diffuser, de distribuer et de reproduire le present message. Si vous l'avez recu par erreur, veuillez prevenir l'expediteur par courriel, puis effacer ce message et en detruire toute copie. Le courrier electronique n'est pas garanti securitaire ni exempt d'erreurs. Les messages pourraient etre interceptes, corrompus, egares, retardes ou contamines par des virus. La Societe internationale Livingston n'est pas responsable de ces risques.