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
 

 

Scrolling logic in CICS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Fri Aug 27, 2010 12:38 pm    Post subject: Scrolling logic in CICS
Reply with quote

Hi All,

I have a new requirement in which we are converting VSAM to DB2. In current process, we fetch the rows from VSAM into a TSQ and then display the results in a MAP (10 rows at a time). The limitation with this method is TSQ is unable to hold beyond 32700. After which the process abends. In this migration to DB2 we need to eliminate the TSQ and need to include a logic to directly display the reocrds fetched from cursor to the screen. We came up with Scrollable cursor. But in many sites i read the DB2 activity of the scrollable cursor is high. It means cost of the application will be high. So i am looking for some logic. Even if you could suggest a way to hold more rows in TSQ or reusing TSQ in case of max limit reached it will be very helpful.


Thanks.
Sija
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Fri Aug 27, 2010 7:16 pm    Post subject:
Reply with quote

Hello,

Suggest you proceed with the scrollable cursor. . .

All db2 activity takes resources. Poorly written queries take more resources.

If you currently have an online process that reads 32k vsam records at one time to store them off for scrolling, it probably has performance problems now. A proper bit of scrolling will run considerably better.
Back to top
View user's profile Send private message
Earl Haigh

Active User


Joined: 25 Jul 2006
Posts: 475

PostPosted: Sun Aug 29, 2010 12:49 am    Post subject:
Reply with quote

As Dick identifies, by design, your current process is already problematic.

Browsing VSAM and DB2 to display mutliple rows of data on a screen
is standard CICS application development.

It seems too often on this forum , we have requests for providing logic
to solve someone's assignment.


Is there no one out there anymore that wants to think and write their
own logic ?
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Sun Aug 29, 2010 1:28 am    Post subject: Reply to: Scrolling logic in CICS
Reply with quote

Quote:
Scrolling logic in CICS

I wonder when I see this kind of questions where IT good practices have disappeared

terminal/screen scrolling/paging has been one of the first reusable things
implemented by any serious organization dealing with cics application
the reason are obvious...
common look and feel for all applications
printing support
done once works for everybody
...
add as many pro' s as wanted

and the issue has never been left to the whims and shortsightedness of a single programmer

wandering thru the forum question seems that
while the hardware and software has gone forward
good practices have gone backward
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Aug 29, 2010 2:28 am    Post subject:
Reply with quote

Quote:
I wonder when I see this kind of questions where IT good practices have disappeared
From what i am able to gather, neither the current training (when it can even be found) nor the organizations that have large IT departments conduct proper education.

2 concepts that have been simple basics for over 35 years are forward/backward scrolling and matching/merging 2 files. These do not appear to still be taught. . .

good ol' days ON

For many years i worked at what was once the biggest paper & wood products company. For quite a few years, our IT staff was over 500 people. When people were hired immediately after college, they went into our internal training program - for 6 months or more. During this time they learned how we did things as opposed to what some instructor might have shown. They also were taught our standards and where to get answers (there was no internet then).

Once they completed this training, they were assigned to different application groups. This worked well for both our company and the new people. The plan then was for the long term, not something instantly.

Many of the new folks were not happy to spend the time in training - some of their instructors had them convinced them that they should show these employers how things should be done icon_smile.gif

They learned otherwise. . . The real world being so much different than the "lab".

good ol' days OFF
Back to top
View user's profile Send private message
sijayapal

New User


Joined: 23 Dec 2008
Posts: 69
Location: India

PostPosted: Mon Aug 30, 2010 5:56 pm    Post subject:
Reply with quote

this is what happenes when we dont choose the right field. Nowadays IT companies recruit mechanical engineers, electronics engineers, electrical engineers and then train them for 3 months in mainframes... and then put them in real time projects.

How can a person without any knowledge in programming background will be able to think of IT best practices... Thats why people like us need help from experts like you icon_smile.gif.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10232
Location: italy

PostPosted: Mon Aug 30, 2010 6:28 pm    Post subject: Reply to: Scrolling logic in CICS
Reply with quote

Quote:
Thats why people like us need help from experts like you


wrong consideration
by answering these questions we provide free consultancy services to an organization managed by idiots

training people is not the objective of any forum were ...
people reply on their own time and at no charge

these kind of issues should be solved by having the proper knowledge inside the organization
by hiring a paid consultant
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Mon Aug 30, 2010 6:40 pm    Post subject:
Reply with quote

dick scherrer wrote:
From what i am able to gather, neither the current training (when it can even be found) nor the organizations that have large IT departments conduct proper education.
Dick,

If the people doing the training do not have the experience gained through both being taught correctly and by trial and error, then how can they possibly pass it along to those that they train.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Aug 30, 2010 8:09 pm    Post subject:
Reply with quote

Hello,

Quote:
Nowadays IT companies recruit mechanical engineers, electronics engineers, electrical engineers and then train them for 3 months in mainframes... and then put them in real time projects
And they are basically commiting fraud by this practice. The clients of these companies have been told the systems will be supported by qualified people. . .

Quote:
If the people doing the training do not have the experience gained through both being taught correctly and by trial and error, then how can they possibly pass it along to those that they train.
Surely does make one wonder as to how they became trainers. . . Possibly they previously taught mechanics, electronics, etc. . . icon_confused.gif

I suspect that reviewing topics in the forums is how many people are getting "training" - what they received in class or ojt being completely lacking. We have lots of topics with hundreds or thousands of "views" - and these are very basic topics. . .
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts Asynchronous CICS Processing Question moezbud CICS 0 Mon Mar 06, 2017 6:13 pm
No new posts CICS Question RE: Browse, Readnext an... moezbud CICS 7 Sun Mar 05, 2017 5:45 am
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Need help in building a logic Benchwarmer All Other Mainframe Topics 4 Wed Feb 22, 2017 2:49 am


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