MVSFORUMS.com

nileshpalve · Beginner Joined: 06 Nov 2006 Posts: 10 Topics: 4

Hi,

I did a search for this topic, I did get 3 hits but they were driven in different direction.

My Question is, its always recommended that we should not use CICS-DB2 combination for browing data Online, since the cursors get closed and we have to repoint them during pseudoconversation.

To solve this problem, why cant we use CICS PAGING serives, I mean logical page building facility that is available? Is there any reason we should not do this? Or is this recommended?

Regards
Nilesh

Manas Biswal · Posted: Wed Apr 25, 2007 7:09 am Post subject:

nileshpalve,

nileshpalve · Beginner Joined: 06 Nov 2006 Posts: 10 Topics: 4

Thats a IBM recommendation that if u have huge data, CICS-DB2 combination is a bad choice.

I think you misunderstood my question, I am asking, if I fetch all the data that I need for browing into a cursor and do a SEND MAP with PAGING option.

After I do that, I will offer getpage option to user to navigate thru' data.

Is this recommended? Or anyone has seen problems with this approach.

dbzTHEdinosauer · Posted: Wed Apr 25, 2007 11:55 am Post subject:

nileshpalve,

how much data is involved?

the original concept of paging was to answer the problem of multiple screen displays for an account............................

if you are trying to use CICS to 'browse' thru a DB2 table, yes - you are misusing (abusing!!) CICS.

most multi-page displays are handled with the 'drill down' concept. That means gather enough data to provide a start. Then with each additional request from the user,
-keyed to something on the currently displayed screen -
gather the data necessary and display another screen. this is typical for management reports that 'just have to be on-line'.

Stacking data in memory - in case it is needed - is not recommended and is poor design. CICS was designed to be single screen, paging option is available when it is known that all pages will accessed.

if you would provide a more specific explanation of what you need to do, we would know what to say.
_________________
Dick Brenholtz
American living in Varel, Germany

nileshpalve · Beginner Joined: 06 Nov 2006 Posts: 10 Topics: 4

The request from my client is to display a report Online for a certain given criteria. The requested data is all available in DB2 and can be easily fetched with a SQL. The given criteria when converted into a Cursor, fetches around 10K rows (on average).

What do u recommend, is the data small enough for Paging? Or its too large that Paging is out of question, my lean towards Paging is due its simplicity (as a programmer).

If Paging is out, what do u recommend?

Nic Clouston · Posted: Thu Apr 26, 2007 4:33 am Post subject:

CICS isn't a report viewer - 10,000 rows to be displayed?! The user has to be joking - Oh - sorry - I wasn't thinking - it is a user Very Happy

_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

dbzTHEdinosauer · Posted: Thu Apr 26, 2007 5:30 am Post subject:

I agree with Nic........ at 21 lines per screen that is about 500+ screens. I personally could not page thru 500 screens in a day - especially if I was reading anything except the page number.

a screen has about 1920 char possible. 20 display lines per screen, 5 columns each with 10 char (i am being intentionally conservative!) 50X20 - let us say that you would be only transmitting 1000 char per screen. that means you would be storing 500+ 1k screens or 500K worth of data.

I would talk to the systems people and ask if you can stack 500k worth of pages (for each user....). If they say it is ok, then ok...............................not my machine.
_________________
Dick Brenholtz
American living in Varel, Germany