BookmarkSubscribeRSS Feed
woo
Barite | Level 11 woo
Barite | Level 11

Hello, can someone please help to prov8de high level suggestion or find some best practice paper on below topics?
We will be using SAS94 M6 on AIX 7.x. (non-grid). We have two data center and both are prod all in one server + they are going to be replicas. Data will be sync'd everyday to keep it mirrored.
A) what is the best way to get users sync'd across two data center so that we don't have to manage users separately, we will split users in half on those 2 servers.
B) what is the best way to have batch jobs running?
C) what is the best approach for load balancing in this scenario?

Thank you

5 REPLIES 5
AhmedAl_Attar
Ammonite | Level 13

Hi,

First, I would like to suggest, you skip SAS 9.4 M6 and move to SAS 9.4 M7 instead. M7 contains the latest fixes and feature enhancements

Second, you make sure you have a plan in place for implementing/applying SAS Hotfixes on a periodic bases.

 

Now, it would help us better if you could specify/elaborate, Which SAS 9.4 Mx products/solutions you are planning to install/deploy, as they could have their own specific best practices/suggestions

 

Hope this helps,

Ahmed

woo
Barite | Level 11 woo
Barite | Level 11

Thanks. We will be using SAS OA, SAS/ACCESS to DB22, Teradata, SAS SPDS and SAS PC file server on AIX 7.2.

AhmedAl_Attar
Ammonite | Level 13

@woo 

For

Sajid01
Meteorite | Level 14

A. Consider metadata based access control for your situation. Multiple users may be needed for each level of access which can be mapped to an authdomain and a library. 

B. Batch jobs use the authdomain option in their connection statement. Production jobs typically run with generic ID.
C. Load balancing best left to DBA's. SAS points to the load balancer.

 

Sajid01
Meteorite | Level 14

Hello @woo 

C) what is the best approach for load balancing in this scenario?

If SAS programming jobs are being run, SAS grid is the appropriate choice.
You don't have the grid, so the option would be to divide the users in to two groups.
Each group having access to one environment only .

B) what is the best way to have batch jobs running?

Depends upon your environment. Typically at many places SAS jobs are scheduled using external job schedulers such as Autosys/Control-M etc.
If that is feasible the job can be scheduled using any of the schedulers. Again you have the choice of distributing them between servers, with or without reference to SAS Metadata Server.


A) what is the best way to get users sync'd across two data center so that we don't have to manage users separately, we will split users in half on those 2 servers.
Depends upon your environment. If AD is being used, then they can be synced from it. In that case divide users into groups. One AD group for environment and another AD for another environment.
In principle it should be possible to export and import metadata from a SAS dataset. SAS Tech Support may be able to speak on this.

 

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Discussion stats
  • 5 replies
  • 2696 views
  • 0 likes
  • 3 in conversation