sybase 12.5 hpux increase device size
Posted on 2011-10-10
I've ran out of devices on my Sybase 12.5 install, and need to increase the sizse of them. I thought the following would work:
recreate lvms of bigger size
recreate database for load
load database back
is this the correct procedure? I had to re-map my segments which was a little tricky (using dbartisan GUI), but running DBCC checktable has returned some unexpected results. it appears that i've lost a lot of data.
Can anyone tell me what the correct way perform this maintenance?
thanks in advance.