Re: tempdb tran log

Sybase????? Think you are talking to the wrong group here. This is for informix. ----- Original Message ----- From: "sspruthi" <member36482@dbforums.com> To: <informix-list@iiug.org> Sent: Thursday, August 21, 2003 06:43 Subject: tempdb tran log > > we are having a tempdb of 200 MB size on 2 different db devices with > data and log on same devices. Our prodn database size is around 6 GB.I > am facing problem of transaction log full quite often and we are not > even able to dump tran(including no_log option) to free up space in tran > log and at that time we cant execute a single command. > > tempdb size is quite less and infact we are planning to make it to > 500MB..as we cant go beyond that due to some constraints...will that > help the cause or do we need to put a separate logdevice for tempdb..and > if yes..what size it should be..?? > > I am quite a beginner in sybase so can u plz tell me how to solve > this issue.... > > > -- > pruthi > > > Posted via http://dbforums.com sending to informix-list