Insufficient memory in file aid browse..

niks_jude · Posted: Thu Apr 26, 2007 1:36 pm

I am getting an "insufficient memory" error while browsing an RRDS VSAM file in file aid. Its showing only 1100 record but the file is having around 3000 records. I was browsing in char format using 'N' in selection criteria usage field. The help of fileaid suggests to use some other selection criteria usage. Can someone throw a light on which one to use and what other things I would be needed to give if I select a different selection criteria usage?

murmohk1 · Posted: Thu Apr 26, 2007 2:22 pm

niks_jude,

Selection criteria is to filter out records basing on some condition. Since you had used N (no condition) option, you will get all the records. If you wanted to see few records (basing on some condition) try either Q or E option.

niks_jude · Posted: Thu Apr 26, 2007 2:26 pm

OK. The idea to chnage selection criteria usage was wrong for seeing all the records. How can I see all the 3000 records. How can I increase the space of temporary file used by file aid to conatin the records of the file I am browsing.

murmohk1 · Posted: Thu Apr 26, 2007 2:33 pm

I dont think its possible for you to increase the space.

niks_jude · Posted: Thu Apr 26, 2007 3:08 pm

So that means I have no option to see all the records?

murmohk1 · Posted: Thu Apr 26, 2007 3:19 pm

cpuhawg · Posted: Thu Apr 26, 2007 5:46 pm

In FILEAID, Use Option 0 Parameters, then Option 1 System to change your primary and secondary allocations.

niks_jude · Posted: Fri Apr 27, 2007 1:27 am

Thanks....I will try it.

rahulkolhe2003 · New User Joined: 06 Mar 2007 Posts: 12 Location: columbus

cpuhawg,

I tried to change the parameters and tried to view the big file with first Track 10, 5 and could view only 168983 records out of 1076866. And after the prarmeter change from Trks to cyls the results did not changed and could only view again 168983 records out of 1076866.

I am also facing the same issue again again and fileaid says "INSUFFICIENT MEMORY" which causes many problems and iterations for me.

Is there no way to atleast browse all records in fileaid? Is it the limitation of fileaid?

Regards,
Rahul

dick scherrer · Posted: Fri Apr 27, 2007 4:50 am

Hello,

Browsing over a million records is (IMHO) just not a good thing to try. What if the file had 100 million records? Point being that at some volume, there will not be a system big enough to handle the size.

What would you do if you could access that many?

My guess is that you'd be looking for something specific (no way could a million records be scrolled thru and looked at a screen at a time). I'd suggest creating some sort control statements or a simple program to read the file and copy selected records into a file containing only a small number of records.

When ths smaller file is created, it will be easy to browse with 3.4 or FileAid or whatever.

cpuhawg · Posted: Fri Apr 27, 2007 6:12 pm

Niks_jude,

Check out this link concerning the amount of storage available to your TSO session.

ibmmainframes.com/viewtopic.php?t=12298&highlight=maxsize

rahulkolhe2003 · New User Joined: 06 Mar 2007 Posts: 12 Location: columbus

I agree that smaller file size is always a better idea.

I just want to raise a question on number of records/bytes can be browsed at one time. Is there any such limitation in fileaid?

In above example I changed the system parameters from TRKS to cylinder but it did not add a single record in addition to the number of records it showed earlier.

cpuhawg,

I checked the link and checked that for my USERID it shows the MAXSIZE as 0. Please find below.

TSO INFORMATION
---------------
ACCTNUM= 01400,01400,0140000,T,A,TSOEXXX
HOLDCLASS= J
JOBCLASS= L
MSGCLASS= J
PROC= ICQUSER
SIZE= 00008800
MAXSIZE= 00000000
SYSOUTCLASS= J
USERDATA= 0000
COMMAND= logoff
***

cpuhawg · Posted: Fri Apr 27, 2007 10:27 pm

There is no limitation for browse, only for edit. The amount of records you can edit is related to your SIZE and MAXSIZE parameter under your TSO segment in RACF. The higher the SIZE and MAXSIZE, the greater the number of records that can be edited in FILEAID.

There are two things at play here. The original question in this post had to do with the amount of temporary space allocated to view your records. The insufficient memory error is directly related to the SIZE and MAXSIZE parameters for your TSO session.