Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2004
    Posts
    21

    Unanswered: Extend Db size over Unix filesystem

    We have an application that uses ASE 12.5 and when it was installed
    they didn't allocate enough raw data on the disks. So the database gets
    full all the time and we can't bcp big tables into it.

    We have plenty of space on the SUN server, so is it possible to increase
    (alter) the database over a Solaris filesystem?

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Yes. You use the normal DISK INIT command to create a new device as a Unix file, and then alter your database to use the new device.

    Something like:

    disk init name='newdev', physname='/sybase/data/newdev.dat', size='10g'
    go
    alter database foo on newdev='10g'
    go

    Michael

  3. #3
    Join Date
    Sep 2005
    Location
    France, Paris
    Posts
    34
    Hi,

    If you work with filesystems, I suggest to put dsync option on.

    At device creation time:

    disk init name='newdev', physname='/sybase/data/newdev.dat', size='10g', dsync = true
    go

    Or you can do that after device creation with sp_deviceattr system stored procedure:

    sp_deviceattr newdev, dsync, true
    go

    Unfortunately,after using sp_deviceattr to change the dsync setting, you must reboot Adaptive Server before the change takes affect.

    This is option is meaningful with filesystems indeed writes to the database device occur directly to the physical storage media, and Adaptive Server can recover data on the device in the event of a system failure.
    This could help you to avoid some issues in case of disaster (like violent server crash etc...)
    Regards.

  4. #4
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    Note that dsync is on by default...

    Michael

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •