Can't allocate IQ 16 memory on HP unix

[Former Member]

My HP machine has 256G ram , but I can't allocate over 20G ram. I already modified the parameters on install guide. Server Version      : 16.0.0.809/sp08.35 Thanks for your support ! #dmesg|grep Physical     Physical: 268428152 Kbytes, lockable: 212451928 Kbytes, available: 240089012 Kbytes $ cat iqdemo.cfg # iqdemo.cfg # ------------------------------------------------------------ # Default startup parameters for the ASIQ demo database # ------------------------------------------------------------ -n  UIDEDQ01_iqdemo -x  tcpip{port=2638} # The following parameters are also found in the configuration file # /sybase/IQ-16_0/scripts/default.cfg.  Any parameters not specified below # and not in the start up parameter list, will be added by start_iq # using default.cfg as a guide. -c  48m -gc 20 -gd all -gl all -gm 10 -gp 4096 -iqmc 10000 -iqtc 10000 $ start_iq @iqdemo.cfg iqdemo.db Starting server UIDEDQ01_iqdemo on UIDEDQ01 at port 2638 (10/06 11:22:28) Run Directory      : /sybase/IQ-16_0/demo Server Executable  : /sybase/IQ-16_0/bin64/iqsrv16 Server Output Log  : /sybase/IQ-16_0/logfiles/UIDEDQ01_iqdemo.0002.srvlog Server Version      : 16.0.0.809/sp08.35 16.0.0/HP-UX B.11.31 Open Client Version : N/A User Parameters    : '@iqdemo.cfg' 'iqdemo.db' Default Parameters  : -ti 4400 -tl 0 -gn 25 I. 10/06 11:22:34. SAP IQ I. 10/06 11:22:34. Version 16.0 I. 10/06 11:22:34. (64bit mode) I. 10/06 11:22:34. Copyright 1992-2014 by SAP AG or an SAP affiliate company. All rights reserved I. 10/06 11:22:34. Copyright (c) 2014 SAP AG or an SAP affiliate company. I. 10/06 11:22:34. All rights reserved. I. 10/06 11:22:34. Use of this software is governed by the Sybase License Agreement. I. 10/06 11:22:34. Refer to http://www.sybase.com/softwarelicenses. I. 10/06 11:22:34. I. 10/06 11:22:34. Processors detected: 96 I. 10/06 11:22:34. Maximum number of processors the server will use: 96 physical processor(s), 96 core(s) I. 10/06 11:22:34. Running HP-UX B.11.31 U on IA64 I. 10/06 11:22:34. Server built for IA64 processor architecture I. 10/06 11:22:34. 49152K of memory used for caching I. 10/06 11:22:34. Minimum cache size: 49152K, maximum cache size: 262144K I. 10/06 11:22:34. Using a maximum page size of 4096 bytes I. 10/06 11:22:34. Multiprogramming level: 25 I. 10/06 11:22:34. Automatic tuning of multiprogramming level is disabled ============================================================= IQ server starting with:     10 connections        (      -gm )     26 cmd resources      ( -iqgovern )     459 threads            (    -iqmt )     512 Kb thread stack size  (  -iqtss  )   235008 Kb thread memory size ( -iqmt * -iqtss )       8 IQ number of cpus  ( -iqnumbercpus )       0 MB maximum size of IQMSG file ( -iqmsgsz )       0 copies of IQMSG file archives ( -iqmsgnum ) ============================================================= DBSPAWN ERROR:  -82 Unable to start specified database: autostarting database failed         ********************************************************     **     **      Informational stack trace from out of virtual memory condition     **      at slib/s_bufpool.cxx:604  on thread 35 (TID 2)     **      Failed allocation request (bytes): 67112959     **      Failed allocation request type:  s_bufpoolSegment::_allocation     **     **     **      End of informational stack trace from out of virtual memory condition     **     ********************************************************     Exception Thrown from oslib/hos_mem.cxx:578, Err# 1, tid 2 origtid 2   O/S Err#: 0, ErrID: 517 (hos_memexception); SQLCode: -1006042, SQLState: 'QBA42', Severity: 14 [20280]: All available virtual memory has been used; allocation cancelled: [Extra info: 67112959] -- (oslib/hos_mem.cxx 578) I. 10/06 11:22:35. Starting database "iqdemo" (/sybase/IQ-16_0/demo/iqdemo.db) at Tue Oct 06 2015 11:22 E. 10/06 11:22:35. Error: All available virtual memory has been used; allocation cancelled: [Extra info: 67112959] -- (oslib/hos_mem.cxx 578) E. 10/06 11:22:35. All available virtual memory has been used; allocation cancelled: [Extra info: 67112959] -- (oslib/hos_mem.cxx 578) I. 10/06 11:22:35. Database server shutdown due to startup error I. 10/06 11:22:35. Database server stopped at Tue Oct 06 2015 11:22 Error: All available virtual memory has been used; allocation cancelled: [Extra info: 67112959] All available virtual memory has been used; allocation cancelled: [Extra info: 67112959] Server failed to start

[Gisung · Accepted solution]

Hi,

Could you please check the below two values regarding memory on HPI?

1) vmemory or memory //ulimit -a

2) Maxdsiz_64bit //kernel value

If possible, Please try to increase those two values.

Troubleshooting HP Memory Issues

On HP-UX, check the value of the maxdsiz_64bit kernel parameter. This parameter restricts the amount of virtual memory available to SAP Sybase IQ on 64-bit HP processors. See the Installation and Configuration Guide for the recommended value.

Here are associated URL.

1) Adjust the Kernel Parameters

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39500.1604/doc/html/san12...

2) Wired Memory
    SyBooks Online

==

Gi-Sung Jang