How to increase size of system DB data in Sybase Database

Procedure 

System database consist system database and database SID ( XXX). We can add space by two different method.

1: By adding new device

2: Resizing existing device

We will see resizing existing device means add space in existing device

 Login with sybase user on OS level

         Su – syb<sid>                              SID will be your system SID e.g AB2

        Isql –Usapsa –S<SID> -X             we can you user sa/ sapsso /  and it will ask password 

i

     sp_helpdevice                             This command will show you all device and file system path

\

i

è we need to check free space on file system before executing command for resize at OS level

  $ df  -h /sybase/SID/sybsystem

as sufficient space is available now we execute command for space resize

database = sybmgmtdb

Device= sybmgmtdev

In below command we are adding 1 GB space in database "SYBMGMTDB"

disk resize name = 'sybmgmtdev' , size = '1G'
alter database sybmgmtdb on sybmgmtdev = '1G'

We have added 1 GB space in system database