Hi All
I am using Sybase 11.5 on Solaris. I have a autosys job
running on
server. The job runs everyday. It picks up the data from a text file
and insert data into one table, after that one stored procedure
process the data and puts the data into different tables. The stored
procedure internally calls 10 sub procedues. The problem is when the
job executes first time in the morning, it fails with the Error code
1105, state 4. i.e. transaction_log becomes full and there is no space
left in the segment. After receiving this error the job fails and it
rerun. But the second time it gets executed successfully without any
problem. And this happnes everyday. I am unable to understand/locate
where the problem lies exactly. Can somebody please suggest/advise how
to resolve this.
What steps should be useful to check the transaction log? Does
increasing the log space size would help? One thing I want to say that
all my stored procedures use temporary tables. There are almost 10
temp table used. Can use of temp tables causing the problem? The
problem is not of tempdb. The error displays user database.


Thanks
-Abhi