Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

outer join causing disk full

Status
Not open for further replies.

koolskins

IS-IT--Management
Nov 22, 2003
79
US
I have a report running on CR9 on an Informix database where several tables are joined to show inventory data combining the master record and two different types of issues. One of the subverient issue tables is set to an outer join with no problem, but when I set the other subverient issue table to an outer join, the report bombs with a disk full message from the server. If I keep the second table at an inner join, the report runs, but I'm missing data from the report that should be there but isn't because it does not have info from that table. Any thoughts on why this would occur and is there any way to redirect on the server side what partition is being used for tempory file construction. My current /var/tmp partition that is being used is not that small, but I definitely have larger ones that I could use, but can't see where you would redirect Crystal from.

Thanks.
Randy
 
Randy I would check your linking. It is possible that when your report runs it is pulling all the records of a table for every record of another table; not just the corresponding records it needs and this is why it is blowing away your swap file.

Just a thought

Mark
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top