Locked Database
Posted: Thu Sep 06, 2001 2:02 pm
Hi All
Im accessing a Microsoft Access database via DataStage 4.0.2 running on NT. The DataStage update job was aborted, recompiled and rerun. The job which normally runs in a few minutes is now running for hours and not really doing anything. The job was aborted again. The Access database is now in a locked state. Any ideas on how to release the Access database without rebooting the NT server? Also, why is DataStage not updating as it used to? Is there some phantom job locking up everything?
Thanks in advance for your input.
*********************************************************************
This footnote confirms that this e-mail message has been scanned for the presence of known computer viruses by the MessageLabs Virus
Control Centre. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
*********************************************************************
Im accessing a Microsoft Access database via DataStage 4.0.2 running on NT. The DataStage update job was aborted, recompiled and rerun. The job which normally runs in a few minutes is now running for hours and not really doing anything. The job was aborted again. The Access database is now in a locked state. Any ideas on how to release the Access database without rebooting the NT server? Also, why is DataStage not updating as it used to? Is there some phantom job locking up everything?
Thanks in advance for your input.
*********************************************************************
This footnote confirms that this e-mail message has been scanned for the presence of known computer viruses by the MessageLabs Virus
Control Centre. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
*********************************************************************