Viewing large tables or views

If the Db2® table or view requires more storage than is available in the TSO region, you will have to restrict the data that FM/Db2 loads from Db2®. The most convenient way to do this is to select "large mode" by specifying ALL, 0 or * in the Row count field on the entry panel. Large mode may not be available if the product installer has chosen to disable it.

When processing an object containing large object columns, FM/Db2 requires at least as much memory (virtual storage) as that needed to store one row of data from the object, with every large object column at the maximum possible size for that column. This may not be possible with a small TSO region size and large object data in the megabyte (or greater) range. To process an object with large object columns, create a Db2® view of the object without the large object columns present, and then process the view.

The following sections describe other ways in which you can restrict the data that FM/Db2 loads.

Related references

• Specifying the editor session mode: "normal mode" or "large mode"