Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Oliver Scheit <oscheit at quoka dot com>
Subject: only one record in table
Date: Aug 2 1999 12:14PM

Please excuse my bad knowledge about this.

I have a table where I can insert one record.
If I try to insert a second record, I get:

Message String: Can't allocate space for object 'net_hw' in database
'db2' because the 'default' segment is full. If you ran out of space in
syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or
sp_extendsegment to increase the size of the segment.

Server message:
Message number: 7101, Severity 17, State 1, Line 1
Message String: Unable to allocate new text value, dbid 5.

I don't really understand, what is wrong.
Also, I don't really understand what I'm supposed to do.
How can I find out whether I ran out of space in syslogs or not?
How to dump the transaction log?

If anyone could find the time to give me a hint,
I'd be grateful.

Oliver Scheit