Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Natural Program Performance Tuning

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
Geeta_A

New User


Joined: 17 Feb 2009
Posts: 1
Location: India

PostPosted: Thu May 07, 2009 1:42 am    Post subject: Natural Program Performance Tuning
Reply with quote

Hi,

Can anybody suggest what all points to look into while doing performance tuning for Natural programs?
Back to top
View user's profile Send private message

monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Mon Jul 27, 2009 11:02 pm    Post subject: Re: Natural Program Performance Tuning
Reply with quote

Hi Geeta,
From my point of view, the first and foremost thing that should be looked into to tune the performance of the program is 'Looking at the database access statements'..

Possibly relacing the complex FIND statements with READ statements....

And may be (I am not very sure), the numeric data definitions can be considered............

I would appreciate if someone correct me if I am wrong....


Thanks
Back to top
View user's profile Send private message
Steve Robinson

New User


Joined: 14 Nov 2009
Posts: 12
Location: U.S.

PostPosted: Sat Nov 14, 2009 11:57 pm    Post subject:
Reply with quote

At least half of Natural's statements have performance considerations. So, the first thing you have to do is learn these.

Then, you have to learn how Adabas works, and how Natural interacts with Adabas.

The you should learn the use of SETTIME.....*TIMD

steve
Back to top
View user's profile Send private message
monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Mon Nov 16, 2009 8:43 pm    Post subject:
Reply with quote

Hi Steve,

Thank you for your response on this topic. Can you please tell few Natural statements which are performance consideration?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Mon Nov 16, 2009 8:58 pm    Post subject:
Reply with quote

Quote:
Can you please tell few Natural statements which are performance consideration?


and hope he only picks statements that you have used?

Steve's comments almost sounded like RTFM.
Back to top
View user's profile Send private message
Steve Robinson

New User


Joined: 14 Nov 2009
Posts: 12
Location: U.S.

PostPosted: Mon Nov 16, 2009 9:16 pm    Post subject:
Reply with quote

For example:

READ, FIND, HISTOGRAM, READ WORK FILE, WRITE WORK FILE, GET

All arithmetic statements, ADD, SUBTRACT, MULTIPLY, DIVIDE, COMPUTE

CALLNAT, PERFORM, FETCH, FETCH RETURN

COMPRESS, SEPARATE, EXAMINE

DECIDE FOR, DECIDE ON, IF

FOR, REPEAT

MOVE, MOVE BY NAME, MOVE BY POSITION

REDUCE, EXPAND, RESIZE

SORT , SORTED BY clause of FIND


And I am sure I have skipped a few.

steve
Back to top
View user's profile Send private message
monasu1998

Active User


Joined: 23 Dec 2005
Posts: 176
Location: India

PostPosted: Tue Nov 17, 2009 10:21 pm    Post subject:
Reply with quote

This list is nice to see Steve. Thank you very much icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Reg:Displaying the particular month o... bhavana yalavarthi All Other Mainframe Topics 4 Sat Jul 08, 2017 8:13 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts CONTIG for performance? JPVRoff JCL & VSAM 7 Fri Jun 09, 2017 8:39 am
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us