BookmarkSubscribeRSS Feed
againreddy
Obsidian | Level 7

Hi , SAS admin is receiving teradata idle sessions alerts for the sas users. We have a couple of preassigned libraries for teradata with defer=yes and connection=sharedread.  Are there any best practices to end the idle sessions alerts. Please advice.

1 REPLY 1
nhvdwalt
Barite | Level 11

I can't speak of any best practices, but my rule of thumb is always.... Open a database connection (libname) when you need it, close it when your done. I'm very cautious about pre-assigned libraries, especially to RDMBs. If the DB is down when you run you pre-assignment, you Workspace Server will not start and you know how may many clients use a Workspace Server. Also, over time, you find these things accumulate for no good reason, and at some point you have a gazillion pre-assigned libraries and most aren't even used. Idle session also use some resources on both SAS and the database. That's probably why your Teradata DBA is alerting you about these sessions.

 

So to answer your question, for me it's not a case of ending the alerts, it's not having idle sessions in the first place. Good, clean housekeeping.

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 

CLI in SAS Viya

Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.

Find more tutorials on the SAS Users YouTube channel.

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