Discussion:
Load : Not enough space
(too old to reply)
News
2006-08-09 11:10:50 UTC
Permalink
I get these errors when I try to restore 11.5 database on HP-UX 10.20.
The target database is large enough. Any hints ?

1> load database LOGISTIC from '..'

2> go


Backup Server session id is: 14. Use this value when executing the
'sp_volchanged' system stored procedure after fulfilling any volume
change request from the BackupServer.

Backup Server: 4.141.2.57: [62] The 'ioctl' call failed for device
'/dev/vg03/logistic2' with error number 12 (Not enough space). Refer to
your operating system documentation for further details.

Backup Server: 4.86.2.1: Unable to initialize Async IO on the database
device /dev/vg03/logistic2. Backup Server must use Async IO on a block
special devices because Adaptive Server Enterprise is doing the same.
News
2006-08-10 08:21:22 UTC
Permalink
Post by News
Backup Server: 4.141.2.57: [62] The 'ioctl' call failed for device
'/dev/vg03/logistic2' with error number 12 (Not enough space). Refer to
your operating system documentation for further details.
could someone confirm that the problem is described here ?

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_12.5.svrtsg/html/svrtsg/svrtsg247.htm


----------------------------------------
An error such as

ioctl(ASYNC_CONFIG) failed: Not enough space

means that the operating system does not have enough shared lockable
memory to allocate to asynchronous I/O buffers. Solutions vary,
depending on the available resources and the type of tuning you choose.
Options include:

- Increase swap space. Ensure that the primary swap space is at least
1.5 times the amount of RAM.

- Add more physical memory.

- Reboot the machine. If the space problem is due to memory
fragmentation, a reboot may solve the immediate problem (which will
eventually reappear).

- Reduce the server's memory usage. If you have multiple ASE servers
running on the machine, consider the usage of all such servers.

- Set the kernel parameter SWAPMEM_ON to 0, increasing the amount of
shared lockable memory available.

- Examine the kernel parameter UNLOCKABLE_MEM. A value of 0 allows the
operating system to dedicate 75% of physical memory to lockable memory.
Consult the HP-UX documentation at http://www.hp.com for details.
News
2006-08-10 12:29:57 UTC
Permalink
Post by News
- Set the kernel parameter SWAPMEM_ON to 0
- Reboot the machine
I followed these steps and it worked

Loading...