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
 

 

Table handling - increased maximum limit

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> COBOL Programming
View previous topic :: :: View next topic  
Author Message
creator.abhishek

New User


Joined: 07 May 2006
Posts: 32
Location: Pune

PostPosted: Fri Feb 10, 2012 10:25 pm    Post subject: Table handling - increased maximum limit
Reply with quote

I am running with one problem and in short i will explain .. One program is having 160K occurence table to process data from different input files. Initially it was some 40K limit and data received was near about 140K something and Job abendaid due to that, so i had increased the limit to 200 K but again found abend S878. Later came to know that the max available limit is 167 K something for one table.

The problem is business is saying this increment is only 20% there will be 80% more on that so trying to find out any simple solution that can implement within 1 month.

Ideas on this are most welcome...
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Feb 10, 2012 10:48 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

the question is clear as mud ...
anyway look at the compiler limits
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IGY3LR31/APPENDIX1.2?SHELF=IGY3SH33&DT=20060329140556
up to You to find the proper manual for Your version of cobol

if Your storage definitions/requirement hit any one of the compiler limits
You will have to redesign the whole process.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Fri Feb 10, 2012 10:50 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

What is your version/release of COBOL?

What did you set your REGION parm at?

200K, causing an S878, sounds suspicious....

Mr. Bill
Back to top
View user's profile Send private message
creator.abhishek

New User


Joined: 07 May 2006
Posts: 32
Location: Pune

PostPosted: Fri Feb 10, 2012 10:57 pm    Post subject:
Reply with quote

REGIOn Parameter is 0M (Max).. however 100M, 200M like wise also not worked...

Limitations of a table is listed here..

http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.iseries.langref.doc/c0925395250.htm
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10202
Location: italy

PostPosted: Fri Feb 10, 2012 11:07 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

it is You that should read the manual, do not expect that somebody her will do the reading on Your behalf,

anyway the link You posted pints to the wrong COBOL ...
ILE COPBOLS Is for Iseries operating systems ( AS400 family ) not Enterprise cobol



what is the reason code for the s878 abend ???
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/IEA2H792/2.511?SHELF=IEA2BK91&DT=20090112020001&CASE=
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7905
Location: Bellevue, IA

PostPosted: Fri Feb 10, 2012 11:22 pm    Post subject:
Reply with quote

Quote:
Later came to know that the max available limit is 167 K something for one table.
The actual limit will vary, depending upon the size of each table element and the version of COBOL you are dealing with. If you're using Enterprise COBOL, 167000 occurrences would translate into a table element length of about 800 bytes.

If you are truly running against a compiler limit, you have one and only one choice: change your design. You cannot, for example, get around the maximum table size set by the compiler -- so your best choice would be to use a file to hold the data you were going to put into the table. But since you've explained very little about what you're doing and the precise problem you're having or even the compiler you're using, there's not much more we can tell you -- give us generic data, we give you generic solutions.
Back to top
View user's profile Send private message
creator.abhishek

New User


Joined: 07 May 2006
Posts: 32
Location: Pune

PostPosted: Fri Feb 10, 2012 11:32 pm    Post subject:
Reply with quote

It is S878-10

10
There is not enough virtual private area storage available to satisfy the request. This is due to one of the following:

A program is requesting virtual storage, but not subsequently freeing the storage.

The region size specified is too small.

An installation exit is requesting virtual storage from a V=R region before initialization of the region has completed.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7224

PostPosted: Fri Feb 10, 2012 11:44 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

Perhaps you can show us some code? Like the table definition, how you are using it. In the Code tags, please.
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Fri Feb 10, 2012 11:52 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

Are these files fixed-length VSAM KSDS or ESDS?

Mr. Bill
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Sat Feb 11, 2012 12:56 am    Post subject:
Reply with quote

gentlemen,

you misinterpret the question.

the TS has no intention of creating a design that will work.

he wants a solution that will enable his bad design to work:
sort of how can he pack more than 5 pounds in a 2 pound sack.

after all, he only has a month to fix the problem.......
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Sat Feb 11, 2012 2:18 am    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

Quote:
the TS has no intention of creating a design that will work.

Yes, Dick you're correct. There's always time to do it wrong but never time to do it right.... icon_wink.gif

Mr. Bill
Back to top
View user's profile Send private message
creator.abhishek

New User


Joined: 07 May 2006
Posts: 32
Location: Pune

PostPosted: Mon Feb 13, 2012 10:15 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

Thanks to all whoever provided own inputs on that.. I have found the solution that can be impliment perfectly within a month time.. This is as simple adding a new table and calling the second once the limit reached from one..
Back to top
View user's profile Send private message
Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2502
Location: Atlanta, Georgia, USA

PostPosted: Mon Feb 13, 2012 10:26 pm    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

Quote:
Are these files fixed-length VSAM KSDS or ESDS?

Never did get an answer.

I have a reason for asking....

Mr. Bill
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7224

PostPosted: Tue Feb 14, 2012 12:55 am    Post subject: Reply to: Table handling - increased maximum limit
Reply with quote

Don't understand how you get an 878 with what little you have described.

Don't see how, if you've hit a limit on one table, you are able to add another. A Cobol program can have a max working-storage of 128mb. A Cobol table can have a max size of 128mb. If you've hit the limit with a table, you've also hit the limit for working-storage.

So I'm sure nothing is as you've described it so far, let alone asnwering anyone's questions.

If you're happy, OK, but I'm with dbz and Mr Bill in thinking that you've got yourself a bad design, which you are going to implement, come what may.
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 -> COBOL Programming All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts Need Rexx Program to Load in to DB2 T... Hareesh Verma CLIST & REXX 22 Tue Sep 20, 2016 2:59 pm
No new posts Command UNIQUE CONSTRAINT on any tabl... rohanthengal DB2 2 Thu Aug 18, 2016 3:48 pm
No new posts Updating online Db2 table kishpra DB2 3 Fri Aug 12, 2016 2:44 pm
No new posts ON ERROR handling soundarr PL/I & Assembler 2 Wed May 11, 2016 3:37 am


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