SAP Knowledge Base Article - Preview

3202061 - Creating an IQ Database Fails with message: "limit on number of process identifiers" - SAP IQ


  • When trying to build an new IQ server received the following:
    dbisql -c 'uid=DBA;pwd=sybase;eng=util_svr;dbn=utility_db' -nogui create_db.sql

    [0.278s][warning][os,thread] Failed to start thread - pthread_create failed (EAGAIN) for attributes: stacksize: 1024k, guardsize: 0k, detached.
    Error occurred during initialization of VM

    java.lang.OutOfMemoryError: unable to create new native thread (1 threads running, rlimit: STACK 8192k, CORE 0k, NPROC 4096, NOFILE 4096, AS infinity, DATA infinity, CPU infinity, FSIZE infinity, MEMLOCK 0x0000000000000040k ,  /proc/sys/kernel/threads-max (system-wide limit on the number of threads): 4126106   /proc/sys/vm/max_map_count (maximum number of memory map areas a process may have): 65530   /proc/sys/kernel/pid_max (system-wide limit on number of process identifiers): 81920   Memory: 4k page, physical 528176404k(200207404k free), swap 131071996k(131069436k free)  )

        at java.lang.Thread.start0()V(Native Method)
        at java.lang.Thread.start()V(
        at java.lang.ref.Reference.<clinit>()V(
        (A log is saved as hs_err_pid14866_0.log which may contain useful information.

  • Is there anything that can be configured to resolve this issue?



  • SAP IQ 16.1
  • Linux


SAP IQ 16.1


KBA , BC-SYB-IQ , Sybase IQ , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.