on 10-07-2015 3:30 AM
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
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.
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
2) Wired Memory
SyBooks Online
==
Gi-Sung Jang
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.