topic Re: how to avoid table locks in sas dataset? in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/how-to-avoid-table-locks-in-sas-dataset/m-p/120764#M1498 <HTML><HEAD></HEAD><BODY><P>If you can't control the jobs so they won't write to the audit table at the same time, there are a number of options available to you.</P><OL><LI>have the audit table store in a schema that supports simultaneous updates. Examples of this is&nbsp; SAS/SHARE, SAS SPD Server, end practically any other RDBMS.</LI><LI>Make a macro that checks if a lock is available on the audit table, if not, wait for n seconds and then retries, and so on.</LI><LI>Have the individual audit tables. They could be appended in an ordered fashion once a day (or any other time interval that suits your needs).</LI></OL></BODY></HTML> Mon, 12 Nov 2012 11:34:32 GMT LinusH 2012-11-12T11:34:32Z how to avoid table locks in sas dataset? https://communities.sas.com/t5/SAS-Data-Management/how-to-avoid-table-locks-in-sas-dataset/m-p/120763#M1497 <HTML><HEAD></HEAD><BODY><P>We have serveral jobs running parallely. Each job will make an entry to the audit dataset.So we want to avoid locks on the audit dataset.</P><P>Please suggest an optimised approach for this requirement.</P></BODY></HTML> Thu, 08 Nov 2012 10:24:14 GMT https://communities.sas.com/t5/SAS-Data-Management/how-to-avoid-table-locks-in-sas-dataset/m-p/120763#M1497 Sandhyaa 2012-11-08T10:24:14Z Re: how to avoid table locks in sas dataset? https://communities.sas.com/t5/SAS-Data-Management/how-to-avoid-table-locks-in-sas-dataset/m-p/120764#M1498 <HTML><HEAD></HEAD><BODY><P>If you can't control the jobs so they won't write to the audit table at the same time, there are a number of options available to you.</P><OL><LI>have the audit table store in a schema that supports simultaneous updates. Examples of this is&nbsp; SAS/SHARE, SAS SPD Server, end practically any other RDBMS.</LI><LI>Make a macro that checks if a lock is available on the audit table, if not, wait for n seconds and then retries, and so on.</LI><LI>Have the individual audit tables. They could be appended in an ordered fashion once a day (or any other time interval that suits your needs).</LI></OL></BODY></HTML> Mon, 12 Nov 2012 11:34:32 GMT https://communities.sas.com/t5/SAS-Data-Management/how-to-avoid-table-locks-in-sas-dataset/m-p/120764#M1498 LinusH 2012-11-12T11:34:32Z