BookmarkSubscribeRSS Feed
KannanBaskar
Calcite | Level 5

Hi All,

We are using proc asi2 in our scripts on mainframes and I need to improve performance for the existing scripts which are used proc asi2. 

Usually proc asi2 reads from  IDMS database.


We want to improve performance for these scripts.

Kindly provide me which optimize techniques do we have to use to improve the performance?

Kindly give suggestions.


Hope somebody gives suggestions to improve performance for my
scripts.

Thanks,

Kannan

1 REPLY 1
jakarman
Barite | Level 11

Proc ASI2 is an interface to IDMS using that  Database.
It will not run faster as allowed by the schema / network access statements.

International Software Products - ASI2 and ASI2LR Sample Code

IDMS is a network database (NOSQL).

Accessing a network database can be superfast or very slow dependent of the quality of the access paths (set first-next).

The LRF option when used does a translation to a relation approach at the cost of overhead.

Your IDMS DBA should be able to  help you with performance issues   

---->-- ja karman --<-----

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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