This happen quite frequently . Btw, from the uvconfig file the setting is below. Is there anyway that i can get to know the total cache size which is run the process so that i can check if is exceed the below setting ?
# JOINBUF - Specifies the size of the cache used by # the optimizer for JOINs with explicit ids or indexes. # The default setting is 4095, maximum is 32363. JOINBUF 4095 # TXMEM - This is the amount of memory allocated # for the private transaction cache. It is # specified in 1K units (1024 bytes). TXMEM 32 > -----Original Message----- > From: kmbodine [SMTP:[EMAIL PROTECTED] > Sent: Sunday, 02 May, 2004 10:11 PM > To: 'Ang Suan Yong' > Subject: RE: FATAL : Cannot create transaction cache file > > Does this happen every time? If so then check the cache file size. It > many be to small to handle the file you are processing. > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > On Behalf Of Ang Suan Yong > Sent: Tuesday, April 27, 2004 6:34 PM > To: U2-users > Subject: FATAL : Cannot create transaction cache file > > Dear All, > > Do any one having facing the below problem before where the > program > run half way it prompt "Cannot create transaction cache file" . When > such a > problem occur, what we do is just rerun the program and is working well. > > Is it possible that this is due to hitting the maximun record > lock ? > > > > Program "UPD.SUB": Line 45, FATAL: Cannot create > transactio > n cache file. > Rolling back uncommitted transactions begun within this > execution environment. > > > > Thanks and Regards > > > > DISCLAIMER:- > <<This email is confidential and intended only for the use of the > individual > or entity named above and may contain information that is privileged. If > you > are not the intended recipient, you are notified that any dissemination, > distribution or copying of this email is strictly prohibited. If you > have > received this email in error, please notify us immediately by return > email > or telephone and destroy the original message. Thank you.>> > > > -- > u2-users mailing list > [EMAIL PROTECTED] > http://www.oliver.com/mailman/listinfo/u2-users > > > DISCLAIMER:- <<This email is confidential and intended only for the use of the individual or entity named above and may contain information that is privileged. If you are not the intended recipient, you are notified that any dissemination, distribution or copying of this email is strictly prohibited. If you have received this email in error, please notify us immediately by return email or telephone and destroy the original message. Thank you.>> ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
