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.
*********************************************************************
Locked Database
Hi,
Try to:
- First delete the LDB file thats created by Access in the same directory that MDB file. Try it.
- Open the DATABASE in exclusive mode. Try again.
- Compact and repare the database (Tools/Utilities).
Respect DS, it sounds like problems with permissions. Check the lock record options and Open method type in Access
> -----Mensaje original-----
> De: Ewart-Phipps,Mark [SMTP:Mark.Ewart-Phipps@afrox.boc.com]
> Enviado el: jueves 6 de septiembre de 2001 16:03
> Para: datastage-users@oliver.com
> Asunto: Locked Database
>
> 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.
> *********************************************************************
>
Try to:
- First delete the LDB file thats created by Access in the same directory that MDB file. Try it.
- Open the DATABASE in exclusive mode. Try again.
- Compact and repare the database (Tools/Utilities).
Respect DS, it sounds like problems with permissions. Check the lock record options and Open method type in Access
> -----Mensaje original-----
> De: Ewart-Phipps,Mark [SMTP:Mark.Ewart-Phipps@afrox.boc.com]
> Enviado el: jueves 6 de septiembre de 2001 16:03
> Para: datastage-users@oliver.com
> Asunto: Locked Database
>
> 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.
> *********************************************************************
>