Sybase- adding space
Posted on 2012-09-20
Am I doing this correct to add free space in sybase db ? the only problems with below is I found the same device exist in default segment and also in Segment_Data_02, how do I make sure I only extend Segment_Data_02 on the device size below ?
disk init name='secdisk1', physname='/dev/md/rdsk/d436',vdevno=12,size='2000M'
alter database sybsecurity on secdisk1 = "1000M"
sp_extendsegment Segment_Data_02, sybsecurity, secdisk1