declare @pagesize int
select @pagesize=(select @@maxpagesize)
SELECT Database Name = CONVERT(char(20), db_name(D.dbid)),
Data Size = STR(SUM(CASE WHEN U.segmap != 4 THEN U.size*@pagesize/1048576 END),10,1),
Used Data = STR(SUM(CASE WHEN U.segmap != 4 THEN size - curunreservedpgs(U.dbid, U.lstart, U.unreservedpgs)END)*@pagesize/1048576,10,1),
Data Full% = STR(100 * (1 - 1.0 * SUM(CASE WHEN U.segmap != 4 THEN curunreservedpgs(U.dbid, U.lstart, U.unreservedpgs) END)/SUM(CASE WHEN U.segmap != 4 THEN U.size END)),9,1) + %,
Log Size = STR(SUM(CASE WHEN U.segmap = 4 THEN U.size*@pagesize/1048576 END),10,1),
Free Log = STR(lct_admin(logsegment_freepages,D.dbid)*@pagesize/1048576,10,1),
Log Full% = STR(100 * (1 - 1.0 * lct_admin(logsegment_freepages,D.dbid) /
SUM(CASE WHEN U.segmap = 4 THEN U.size END)),8,1) + %
FROM master..sysdatabases D,
master..sysusages U
WHERE U.dbid = D.dbid
AND ((D.dbid > 3) AND (D.dbid < 31513) AND (D.status != 256))
...

How to increase the size of sybase database device dynamically

Use Command : disk resize

The disk resize command allows you to increase the size of your database devices dynamically, rather than initializing a new device. For example, if /sybase/testdev.dat requires an additional 10MB of space, you can run disk resize and allocate this amount of space to the device. The create and alter database commands can use this added space.

You can use disk resize to increase the size for both devices on raw partitions and for file systems. The minimum amount of space by which you can increase a device is 1MB or an allocation unit, whichever is greater.

disk resize syntax

disk resize has the following syntax:

disk resize
name = “device_name”,
size = additional_space

Where device_name is the name of the device you are increasing and additional_space is the additional disk space you are adding to this device.
...

Do you know the maximum size of a sybase database ?

A Sybase database can contain up to 2,147,483,648 logical pages, so its maximum size depends on its logical page size:

• The maximum database size on a 2K page server is 4TB.
• The maximum database size on a 4K page server is 8TB.
• The maximum database size on an 8K page server is 16TB.
• The maximum database size on a 16K page server is 32TB.


Thanks,
Joshi Pratap

Query to find out the size of tables and indexes in any Sybase tempdb
by : Mich Talebzadeh (Copyright)

Note: This has not been tested by me.Please try it yourself first, modify and post them here if required.

To find out the size of tables and indexes in any tempdb, the owners and the processes creating them, you can use the following stored procedure. However, you need to execute it in the tempdb database it is intended for:

use sybsystemprocs
go
create procedure sp__tempdb3
as
create table #trouble3 (name varchar(30), indid int, size int)
insert #trouble3
select a.name, b.indid, data_pgs(b.id, doampg)*1024/512
from tempdb3..sysobjects a,
tempdb3..sysindexes b
where a.id=b.id
and (b.indid <2) and a.type='U'
union
select a.name, b.indid, isnull(sum(data_pgs(b.id, ioampg))*1024/512,0)
from tempdb3..sysobjects a,
tempdb3..sysindexes b
where a.id=b.id and b.indid >1 and (a.type='U')
...