cancel
Showing results for 
Search instead for 
Did you mean: 

Sybase IQ 16 startup issues

Former Member
0 Kudos

Sybase IQ 16 on windows

I have installed SAP IQ  16 Demo  system and created Database based on RDS documents .

I have started and stopped server several times , it was working . there is not much activity on this server after installation.

When I tried to start  today its not starting due to some Virtual Memory issues.

Error below :

Starting Sybase IQ > All available virtual memory has been used; allocation cancelled+info: 67112959

Database server shutdown due to startup error.


Pls advise me if you have any inputs to resolve this issues.


6/01 04:16:13. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959]

-- (oslib\hos_mem.cxx 573)

06/01 05:13:38. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959]

-- (oslib\hos_mem.cxx 573)

06/03 16:49:29. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959]

-- (oslib\hos_mem.cxx 573)

09/02 03:14:04. No SYSAM License Available

11/11 13:17:22. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959]

-- (oslib\hos_mem.cxx 573)

11/11 14:14:35. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959]

-- (oslib\hos_mem.cxx 573)

11/11 16:17:25. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959]

-- (oslib\hos_mem.cxx 573)

Accepted Solutions (0)

Answers (1)

Answers (1)

tayeb_hadjou
Advisor
Advisor
0 Kudos

Hi,

This is memory resource issue.  You need increase physical/swap memory OR reduce memory allocated to IQ.

The total memory used by IQ server is main and temporary caches, plus memory used for loads, backup, users, .

Solution :

1- Add OS physical memory and/or Swap

OR

2- Reduce Pre-allocated IQ memory values by reducing in parameters iqtc, iqmc for cache,  iqlm for iq large memory.

Required Memory

Regards,

Tayeb.