|
View previous topic :: View next topic
|
| Author |
Message |
sijayapal
New User
.jpg)
Joined: 23 Dec 2008
Posts: 69
Location: India
|
|
|
|
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 |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
Earl Haigh
Active User
Joined: 25 Jul 2006
Posts: 475
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
| 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 
They learned otherwise. . . The real world being so much different than the "lab".
good ol' days OFF |
|
| Back to top |
|
|
sijayapal
New User
Joined: 23 Dec 2008
Posts: 69
Location: India
|
|
|
|
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 . |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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. . . 
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 |
|
|
|
|
