Discussion:
ASE 12.5.3 disk resize
(too old to reply)
Juergen Schroeder
2012-02-04 22:33:38 UTC
Permalink
Hi,

on SYBASE 12.5.3 on solaris 10 I tried to enlarge a segment but I get an
error about insufficient disk space. The segments are files on disk, There
is enought disk space available. The database had had 2x 12 G devices
lbs_data_01_dev and lbs_data_02_dev before. The resized file size
(lbs_data_02_dev) has now the size of 24 GB.

Thats the command:

disk resize name = "lbs_data_02_dev", size = "12288M";
Initializing 1532328 pages only; insufficient disk space.

00:00000:00175:2012/02/04 21:25:10.26 kernel \
Initializing device /path/to/sybdb/lbs_data_02.dev from offset 12884901888
with zeros.
00:00000:00175:2012/02/04 21:26:48.58 kernel \
udzero_out: attempt to write page 7823785 on device '
/path/to/sybdb/lbs_data_02.dev'
failed, system error is: Invalid argument

Is there a limit in segment size? File size on sol 10 can't be the error. I
have larger ones.

TIA

Jürgen
Antony
2012-02-07 00:26:50 UTC
Permalink
Sorry to post the obvious - but have you checked the filesystem has not reached 100% full ?
Juergen Schroeder
2012-02-07 08:57:53 UTC
Permalink
Post by Antony
Sorry to post the obvious - but have you checked the filesystem has not reached 100% full ?
You are absolutely right. I had checked the size of the fs below. But the
devices were in a (direct io) mounted directory on top of that.

I could swear that the size of the device file had had been the wished size
of 12 G in the first try.

Thanks a lot. Now I have increased the size and altered the database,
everything looks fine. The resize function is very nice.

Jürgen
Juergen Schroeder
2012-02-07 17:00:58 UTC
Permalink
Post by Antony
Sorry to post the obvious - but have you checked the filesystem has not reached 100% full ?
You are absolutely right. I had checked the size of the fs below. But the
devices were in a (direct io) mounted directory on top of that.

I could swear that the size of the device file had had been the wished size
of 12 -> 24 G in the first try.

Thanks a lot. Now I have increased the size and altered the database,
everything looks fine. The resize function is very nice.

Jürgen

Loading...