BookmarkSubscribeRSS Feed
Sandhyaa
Calcite | Level 5

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.

Please suggest an optimised approach for this requirement.

1 REPLY 1
LinusH
Tourmaline | Level 20

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.

  1. have the audit table store in a schema that supports simultaneous updates. Examples of this is  SAS/SHARE, SAS SPD Server, end practically any other RDBMS.
  2. 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.
  3. 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).
Data never sleeps

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 2053 views
  • 0 likes
  • 2 in conversation