topic Re: How to improve performance for PROC ASI2 procedure? in SAS Procedures

How to improve performance for PROC ASI2 procedure?

KannanBaskar — Tue, 03 Dec 2013 10:14:03 GMT

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

jakarman — Tue, 03 Dec 2013 18:37:38 GMT

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

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