topic Re: Server migration in SAS Enterprise Guide

Server migration

suraj — Fri, 14 Apr 2017 10:12:41 GMT

Hello,

My firm currently has batch jobs running in linux server. There are permanent dataset stored in SASSPDS.

NOTE: This session is executing on the Linux 2.6.32-642.6.2.el6.x86_64 (LINX64) platform.

NOTE: Updated analytical products:

SAS/STAT 14.1
SAS/ETS 14.1

NOTE: Additional host information:

Linux LIN X64 2.6.32-642.6.2.el6.x86_64 #1 SMP Mon Oct 24 10:22:33 EDT 2016
x86_64 Red Hat Enterprise Linux Server release 6.8 (Santiago)

You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see
http://support.sas.com/rnd/migration/planning/platform/64bit.html

Now thery are planning to migrate to GRID Server. I donnt have an idea about server knowledge.

Can you please provide a reference how should I start with this and also how can I plan this migration. Do I need to change the hole code for this or just the datasets and path. Please guide me thorough this.

Thanks for sharing your knowledge.

Re: Server migration

JuanS_OCS — Fri, 14 Apr 2017 10:35:45 GMT

Hello @suraj,

while SAS GRID is really powerfull, SAS GRID is not an easy platform, quite complex with a lot of variables/architecture settings to consider.

I would stronlgy suggest you to consider to align with your SAS representative, to get the right and trusted teams to help you.

Meanwhile, if you still want to learn a about SAS GRID, you can give a look into this:

An overview: https://support.sas.com/rnd/scalability/grid/index.html

And the documentation, a lot to read:

http://support.sas.com/software/products/gridmgr/#s1=2

https://support.sas.com/rnd/scalability/grid/gridinstall.html

https://support.sas.com/rnd/scalability/grid/griddocs.html

Re: Server migration

suraj — Fri, 14 Apr 2017 13:22:59 GMT

Thanks a lot for your guidance. I will check with SAS team and would also go through the links you have provide.

This was helpful!

Re: Server migration

Doc_Duke — Fri, 14 Apr 2017 13:55:27 GMT

Suraj,

A well implemented grid migration can be reasonably transparent to the SAS users. Even changing libnames may not be needed if you are in a pretty structured environment to begin with. Your biggest change may be how you submit the jobs themselves, especially if you are currently submitting in batch.

JuanS's comments were about doing it yourself. In a word, don't. That's why you have SAS admins. Part of their job is to provide guidance documents to address the local changes the grid brings about.

Besides load balancing, the SAS grid can allow you to get much better performance with the HP procedures. Some SAS BASE procedures are 'grid aware' so you can get a performance improvement without even tweaking your code.

Doc

Re: Server migration

LinusH — Mon, 17 Apr 2017 08:10:32 GMT

If you have the plan to keep SPD Server as a storage platform in the grid environment, here's a best practice paper that could be helpful:

https://www.google.se/url?sa=t&source=web&rct=j&url=https://support.sas.com/rnd/scalability/grid/SPDSonGrid.pdf&ved=0ahUKEwi6k57Bg6vTAhVhOpoKHdceD0cQFggaMAA&usg=AFQjCNG8VhWWssSyRjaBweUf13fk1L2SYQ&sig2=1EiGznpMeU7_xNCR0i8W3A

Although you may need to develop strategies for data update / write locking (which wasn't really discussed in the paper).

Re: Server migration

suraj — Mon, 17 Apr 2017 10:24:05 GMT

Hello LinusH ,

Thanks for your help! One more doubt I have.

I am currently running SAS on unix. Is there any way I can use SAS EG tool and also connct to all the datasets which are currently there in UNIX.

What does it really means to have installation on UNIX. I have mentioned the screenshot of SAS software in my first question.

Thanks for your guidance

Re: Server migration

LinusH — Mon, 17 Apr 2017 20:04:30 GMT

Sorry I wasn't able to locate your screen shot.
Also, try to keep threads clean. If you have additional inquiries create a ned post instead of changing the focus on an existing one.

Do the UNIX you mention I'd not the grid?
To be able to access any SAS server you need at least Integration Technologies, which will let you launch a Workspace server via the object spawner.

Re: Server migration

suraj — Wed, 19 Apr 2017 13:21:19 GMT

Hello LinusH,

Below is the notes whic I get when connects to SAS.

NOTE: This session is executing on the Linux 2.6.32-642.6.2.el6.x86_64 (LINX64) platform.

NOTE: Updated analytical products:

SAS/STAT 14.1
SAS/ETS 14.1

NOTE: Additional host information:

Linux LIN X64 2.6.32-642.6.2.el6.x86_64 #1 SMP Mon Oct 24 10:22:33 EDT 2016
x86_64 Red Hat Enterprise Linux Server release 6.8 (Santiago)

You are running SAS 9. Some SAS 8 files will be automatically converted
by the V9 engine; others are incompatible. Please see

Here I checked the data sets are stored in sas spds and also they are using oracle and teradata queries to pull data.

Now my question is how can I get acess to all those things by with SAS EG. Thanks for help!

Godspeed!

Re: Server migration

LinusH — Thu, 20 Apr 2017 05:57:47 GMT

My understanding is that you need all components replicated or accessible with the same paths (shared file system) on all grid nodes.
Again, this is part of your grid design process that should be developed together with a grid experienced partner.