Есть следующие ошибки:

Warning: sybase_query(): Sybase: Server message: Can't allocate space for object 'documentation_values' in database 'wb' because 'default' segment is full/has no free extents. If you ran out of space in syslogs, dump the transaction log. Otherwise, use ALTER DATABASE to increase the size of the segment. (severity 17, procedure N/A) in

Warning: sybase_query(): Sybase: Server message: Unable to allocate new text value, dbid 4. (severity 17, procedure N/A) in

Пробовал следующее:
sp_extendsegment 'default', 'wb','wb'
Пишет: No such device exists -- run sp_helpdb to list the devices for the current database.
(return status = 1)


1> sp_helpdb
2> go
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- ------------------------------------------------------------------------------------------------------
master 6.0 MB sa 1 Aug 22, 2006 mixed log and data
model 2.0 MB sa 3 Aug 22, 2006 mixed log and data
sybsystemdb 2.0 MB sa 31513 Aug 22, 2006 mixed log and data
sybsystemprocs 120.0 MB sa 31514 Aug 22, 2006 trunc log on chkpt, mixed log and data
tempdb 203.0 MB sa 2 May 21, 2008 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
wb 2348.0 MB cyber 4 Aug 22, 2006 select into/bulkcopy/pllsort, mixed log and data




1> sp_helpdb wb
2> go
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- ------------------------------------------------------------------------------------------------------
wb 2348.0 MB cyber 4 Aug 22, 2006 select into/bulkcopy/pllsort, mixed log and data

(1 row affected)
device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------- ----------------
data 10.0 MB data only Aug 23 2006 9:53PM 14
data 5.0 MB log only Aug 23 2006 9:53PM not applicable
data 285.0 MB data only Aug 23 2006 9:53PM 42
data 300.0 MB log only Aug 23 2006 9:53PM not applicable
data 400.0 MB data and log Aug 23 2006 9:53PM 14
data 50.0 MB log only Aug 23 2006 9:53PM not applicable
data 200.0 MB data and log Aug 23 2006 9:53PM 140
data 5.0 MB log only Aug 23 2006 9:53PM not applicable
data 113.0 MB data and log Aug 23 2006 9:53PM 280
data 1.0 MB log only Aug 23 2006 9:53PM not applicable
data 679.0 MB data and log Aug 23 2006 9:53PM 2324
logs 300.0 MB data and log Aug 23 2006 9:53PM 0

--------------------------------------------------------------
log only free kbytes = 301140
device segment
------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
data default
data logsegment
data system
logs default
logs logsegment
logs system


Как исправить ошибку?

Заранее спасибо!

select @@version
Adaptive Server Enterprise/12.5.2/EBF 11949 ESD#1/P/Linux Intel/Enterprise Linux/ase1252/1838/32-bit/OPT/Sat May 29 01:03:02 2004

1> exec sp_helpdevice
2> go
device_name physical_name description status cntrltype device_number low high
------------------------------ ---------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------ --------- ------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
data /opt/sybase/12.5/data/data.dat special, dsync on, physical disk, 3072.00 MB 16386 0 2 33554432 35127295
logs /opt/sybase/12.5/data/logs.dat special, dsync on, physical disk, 600.00 MB 16386 0 3 50331648 50638847
master /opt/sybase/12.5/data/master.dat special, dsync on, default disk, physical disk, 30.00 MB 3 0 0 0 15359
sysprocsdev /opt/sybase/12.5/data/sybsysproc.dat special, dsync on, physical disk, 120.00 MB 16386 0 1 16777216 16838655
tapedump1 /dev/nst0 disk, dump device 16 2 0 0 20000
tapedump2 /dev/nst1 tape, 625 MB, dump device 16 3 0 0 20000

sp_configure 'number of '


Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
number of alarms 40 4 40 40 number dynamic
number of aux scan descriptors 200 #232 200 200 number dynamic
number of ccbs 0 0 0 0 number static
number of checkpoint tasks 1 0 1 1 number dynamic
number of devices 10 #10 10 10 number dynamic
number of dtx participants 500 146 500 500 number dynamic
number of dump threads 1 0 1 1 number dynamic
number of engines at startup 1 0 1 1 number static
number of histogram steps 20 0 20 20 number dynamic
number of index trips 0 0 0 0 number dynamic
number of java sockets 0 0 0 0 number dynamic
number of large i/o buffers 6 3112 6 6 number dynamic
number of locks 5000 754 5000 5000 number dynamic
number of mailboxes 30 6 30 30 number dynamic
number of messages 64 6 64 64 number dynamic
number of oam trips 0 0 0 0 number dynamic
number of open databases 12 1416 12 12 number dynamic
number of open indexes 500 592 500 500 number dynamic
number of open objects 500 719 500 500 number dynamic
number of pre-allocated extent 2 0 2 2 number dynamic
number of remote connections 20 33 20 20 number static
number of remote logins 20 22 20 20 number static
number of remote sites 10 1547 10 10 number static
number of sort buffers 500 0 500 500 number dynamic
number of user connections 25 3861 25 25 number dynamic
number of worker processes 0 0 0 0 number dynamic

(1 row affected)

1> use master
2> go
1> alter database wb on data='1024M' with override
2> go
Extending database by 421888 pages (824.0 megabytes) on disk data
Caution: You have set up this database to include space on disk 2 for both data and the transaction log. This can make recovery impossible if that disk fails.



1> sp_helpdb wb
2> go
name db_size owner dbid created status
------------------------ ------------- ------------------------ ------ -------------- ------------------------------------------------------------------------------------------------------
wb 3172.0 MB cyber 4 Aug 22, 2006 select into/bulkcopy/pllsort, mixed log and data

(1 row affected)
device_fragments size usage created free kbytes
------------------------------ ------------- -------------------- ------------------- ----------------
data 10.0 MB data only Aug 23 2006 9:53PM 14
data 5.0 MB log only Aug 23 2006 9:53PM not applicable
data 285.0 MB data only Aug 23 2006 9:53PM 42
data 300.0 MB log only Aug 23 2006 9:53PM not applicable
data 400.0 MB data and log Aug 23 2006 9:53PM 14
data 50.0 MB log only Aug 23 2006 9:53PM not applicable
data 200.0 MB data and log Aug 23 2006 9:53PM 140
data 5.0 MB log only Aug 23 2006 9:53PM not applicable
data 113.0 MB data and log Aug 23 2006 9:53PM 280
data 1.0 MB log only Aug 23 2006 9:53PM not applicable
data 679.0 MB data and log Aug 23 2006 9:53PM 2324
logs 300.0 MB data and log Aug 23 2006 9:53PM 0
data 824.0 MB data and log May 22 2008 11:49AM 840386

--------------------------------------------------------------
log only free kbytes = 1138100
device segment
------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
data default
data logsegment
data system
logs default
logs logsegment
logs system
(return status = 0)


1> use master
2> go
1> sp_configure 'memory'
2> go


Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
additional network memory 0 0 0 0 bytes dynamic
allocate max shared memory 0 0 0 0 switch dynamic
heap memory per user 4096 0 4096 4096 bytes dynamic
lock shared memory 0 0 0 0 switch static
max memory 32768 320426 160213 160213 memory pages(2k) dynamic
memory alignment boundary 2048 0 2048 2048 bytes static
memory per worker process 1024 4 1024 1024 bytes dynamic
Memory Use 0 0 0 0 not applicable NULL
messaging memory 400 0 400 400 memory pages(2k) dynamic
Physical Memory 0 0 0 0 not applicable NULL
shared memory starting address 0 0 0 0 not applicable static
total logical memory 32768 177332 88666 88666 memory pages(2k) read-only
total physical memory 0 177332 0 88666 memory pages(2k) read-only

(1 row affected)
An additional 143094 K bytes of memory is available for reconfiguration. This is the difference between 'max memory' and 'total logical memory'.
(return status = 1)


1> sp_helpcache
2> go
Cache Name Config Size Run Size Overhead
------------------------ ------------- ---------- ----------
default data cache 100.00 Mb 100.00 Mb 6.58 Mb


Memory Available For Memory Configured
Named Caches To Named Caches
-------------------- ----------------
100.01 Mb 100.00 Mb


------------------ Cache Binding Information: ------------------

Cache Name Entity Name Type Index Name Status
---------- ----------- ---- ---------- ------
(return status = 0)

1> sp_configure 'cache'
2> go

Parameter Name Default Memory Used Config Value Run Value Unit Type
------------------------------ ----------- ----------- ------------ ----------- -------------------- ----------
abstract plan cache 0 0 0 0 switch dynamic
Cache Manager 0 0 0 0 not applicable NULL
extended cache size 0 32 0 0 memory pages(2k) dynamic
global cache partition number 1 0 1 1 number static
Meta-Data Caches 0 0 0 0 not applicable NULL
permission cache entries 15 #190 15 15 number dynamic
procedure cache size 3271 42346 20000 20000 memory pages(2k) dynamic
size of unilib cache 0 120 0 0 bytes dynamic
statement cache size 0 0 0 0 memory pages(2k) dynamic
total data cache size 0 109134 0 109134 kilobytes read-only
user log cache size 2048 0 2048 2048 bytes static
user log cache spinlock ratio 20 0 20 20 ratio dynamic


1> use wb
2> go
1> sp_helpsegment logsegment
2> go
segment name status
------- ------------------------------ ------
2 logsegment 0
device size
------------------------------ ----------------------
data 2577.0MB
logs 300.0MB
free_pages
-----------
569018
table_name index_name indid
------------------------------ ------------------------------ ------
syslogs syslogs 0
total_size total_pages free_pages used_pages reserved_pages
----------------- --------------- --------------- --------------- ---------------
2877.0MB 1473024 569018 7720 0
(return status = 0)

Спасибо большое за помощь