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: Steven Cruz <steve at nextopia dot com>
Subject: Re: only one record in table
Date: Aug 3 1999 2:00PM


	It seems you ran out of database space. You have to add a new device to
the database server, then alter the databsae on the that device. 

	If you need more information please let me know. 

Steven Cruz
Oliver Scheit wrote:
> 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.
> Regards,
> Oliver Scheit