Topic
3 replies Latest Post - ‏2012-10-15T16:40:04Z by pascals
pascals
pascals
3 Posts
ACCEPTED ANSWER

Pinned topic Problem connect to database!

‏2012-10-12T20:55:36Z |
Hey guys,

hope somebody could help starting database. At first, I have to say, that I allready read forums and google this topic thousend times and tried and tried and ....

I manually changed shmall (3gb) and shmmax (2gb) value because of

"SQL1084C Shared memory segments cannot be allocated. SQLSTATE=57019"

Then I tried to start my database and get

"SQL10003C There are not enough system resources to process the request. The
request cannot be processed. SQLSTATE=57011"

After I restart my instance, the values of shmall and shmmax has been changed as follows
max seg size (kbytes) = 110887092
max total shared memory (kbytes) = 221774184

DB2 seems to set the shared memory value to 8gb (default) but the machine got no more than 4gb.

Can somebody give an advice? Which parameters I have to changed?

Thanks in Advanced and

Best regards

Pascal Stieber
Updated on 2012-10-15T16:40:04Z at 2012-10-15T16:40:04Z by pascals
  • SystemAdmin
    SystemAdmin
    5837 Posts
    ACCEPTED ANSWER

    Re: Problem connect to database!

    ‏2012-10-15T12:04:59Z  in response to pascals
    Hello,

    Can you post the output of db2prereqcheck (to be run by root) ? This utility is located in the top directory of the install media.

    Can you also post the output of db2val (to be run by instance owner).

    Yves-Antoine Emmanuelli
    • pascals
      pascals
      3 Posts
      ACCEPTED ANSWER

      Re: Problem connect to database!

      ‏2012-10-15T16:18:39Z  in response to SystemAdmin
      Hello Yves-Antoine,

      who is db2prereqcheck located? I have to say that I installed version 9.7!

      db2level output:

      cat: ASNDONE/files: Not a directory
      cat: ASNLOAD/files: Not a directory
      cat: MQLInstall.sql/files: Not a directory
      cat: asnacmd/files: Not a directory
      cat: asnadmt/files: Not a directory
      cat: asnadmtora/files: Not a directory
      cat: asnapply/files: Not a directory
      cat: asncap/files: Not a directory
      cat: asnccmd/files: Not a directory
      cat: asnmail/files: Not a directory
      cat: asnmcmd/files: Not a directory
      cat: asnmon/files: Not a directory
      cat: asnoqcap/files: Not a directory
      cat: asnoqccmd/files: Not a directory
      cat: asnqacmd/files: Not a directory
      cat: asnqapp/files: Not a directory
      cat: asnqcap/files: Not a directory
      cat: asnqccmd/files: Not a directory
      cat: asnqmfmt/files: Not a directory
      cat: asntrc/files: Not a directory
      cat: asntrcbp/files: Not a directory
      cat: db2/files: Not a directory
      cat: db2IdentifyType1/files: Not a directory
      cat: db2IdentifyType1_exe/files: Not a directory
      cat: db2IdentifyType1_v8_32/files: Not a directory
      cat: db2IdentifyType1_v8_64/files: Not a directory
      cat: db2IdentifyType1_v9_32/files: Not a directory
      cat: db2IdentifyType1_v9_64/files: Not a directory
      cat: db2PArcmd/files: Not a directory
      cat: db2_aram/files: Not a directory
      cat: db2_call_stack/files: Not a directory
      cat: db2_local_ps/files: Not a directory
      cat: db2_ps/files: Not a directory
      cat: db2acsutil/files: Not a directory
      cat: db2addicons/files: Not a directory
      cat: db2adutl/files: Not a directory
      cat: db2advis/files: Not a directory
      cat: db2am/files: Not a directory
      cat: db2batch/files: Not a directory
      cat: db2bfd/files: Not a directory
      cat: db2bp/files: Not a directory
      cat: db2bpq/files: Not a directory
      cat: db2ca/files: Not a directory
      cat: db2caem/files: Not a directory
      cat: db2cat/files: Not a directory
      cat: db2cc/files: Not a directory
      cat: db2ce/files: Not a directory
      cat: db2cfexp/files: Not a directory
      cat: db2cfimp/files: Not a directory
      cat: db2chglibpath/files: Not a directory
      cat: db2ckbkp/files: Not a directory
      cat: db2cklog/files: Not a directory
      cat: db2ckmig/files: Not a directory
      cat: db2ckrst/files: Not a directory
      cat: db2ckupgrade/files: Not a directory
      cat: db2ckupgrade32_exe/files: Not a directory
      cat: db2ckupgrade64_exe/files: Not a directory
      cat: db2cli/files: Not a directory
      cat: db2cmnclp/files: Not a directory
      cat: db2cos/files: Not a directory
      cat: db2cos_clp/files: Not a directory
      cat: db2cos_datacorruption/files: Not a directory
      cat: db2cos_hang/files: Not a directory
      cat: db2cos_lib/files: Not a directory
      cat: db2cos_perf/files: Not a directory
      cat: db2cos_preupgrade/files: Not a directory
      cat: db2cos_threshold/files: Not a directory
      cat: db2cos_trap/files: Not a directory
      cat: db2dasstm/files: Not a directory
      cat: db2dclgn/files: Not a directory
      cat: db2demigdbd/files: Not a directory
      cat: db2desktop/files: Not a directory
      cat: db2diag/files: Not a directory
      cat: db2disable_soap_udf/files: Not a directory
      cat: db2drdat/files: Not a directory
      cat: db2dsdcfgfill/files: Not a directory
      cat: db2egcf/files: Not a directory
      cat: db2empfa/files: Not a directory
      cat: db2enable_soap_udf/files: Not a directory
      cat: db2eva/files: Not a directory
      cat: db2evmon/files: Not a directory
      cat: db2evtbl/files: Not a directory
      cat: db2exfmt/files: Not a directory
      cat: db2exmig/files: Not a directory
      cat: db2expln/files: Not a directory
      cat: db2fedgentf/files: Not a directory
      cat: db2flsn/files: Not a directory
      cat: db2fm/files: Not a directory
      cat: db2fmcd/files: Not a directory
      cat: db2fmcu/files: Not a directory
      cat: db2fmd/files: Not a directory
      cat: db2fodc/files: Not a directory
      cat: db2fopt/files: Not a directory
      cat: db2fs/files: Not a directory
      cat: db2ftok/files: Not a directory
      cat: db2fupdt/files: Not a directory
      cat: db2gcf/files: Not a directory
      cat: db2gdeps/files: Not a directory
      cat: db2genseed/files: Not a directory
      cat: db2gpinf/files: Not a directory
      cat: db2gpmap/files: Not a directory
      cat: db2greg/files: Not a directory
      cat: db2haicu/files: Not a directory
      cat: db2hareg/files: Not a directory
      cat: db2hc/files: Not a directory
      cat: db2help/files: Not a directory
      cat: db2iauto/files: Not a directory
      cat: db2ic/files: Not a directory
      cat: db2icdocs/files: Not a directory
      cat: db2ilist/files: Not a directory
      cat: db2imaudcfg/files: Not a directory
      cat: db2imdbd/files: Not a directory
      cat: db2imdbm/files: Not a directory
      cat: db2imnod/files: Not a directory
      cat: db2imsslcfg/files: Not a directory
      cat: db2indbt/files: Not a directory
      cat: db2inspf/files: Not a directory
      cat: db2javit/files: Not a directory
      cat: db2jcc/files: Not a directory
      cat: db2jdbcbind/files: Not a directory
      cat: db2jdkp/files: Not a directory
      cat: db2langdir/files: Not a directory
      cat: db2latchtrace/files: Not a directory
      cat: db2ldcfg/files: Not a directory
      cat: db2lddrg/files: Not a directory
      cat: db2level/files: Not a directory
      cat: db2logsForRfwd/files: Not a directory
      cat: db2look/files: Not a directory
      cat: db2lspwd/files: Not a directory
      cat: db2lueff/files: Not a directory
      cat: db2memvis/files: Not a directory
      cat: db2move/files: Not a directory
      cat: db2mqCheck/files: Not a directory
      cat: db2mqlsn/files: Not a directory
      cat: db2mtrk/files: Not a directory
      cat: db2ncstk/files: Not a directory
      cat: db2nkill/files: Not a directory
      cat: db2nps/files: Not a directory
      cat: db2palog/files: Not a directory
      cat: db2pdraw/files: Not a directory
      cat: db2profc/files: Not a directory
      cat: db2profp/files: Not a directory
      cat: db2rbind/files: Not a directory
      cat: db2rc/files: Not a directory
      cat: db2rcmd/files: Not a directory
      cat: db2recri/files: Not a directory
      cat: db2refs.ndx/files: Not a directory
      cat: db2relocatedb/files: Not a directory
      cat: db2rmicons/files: Not a directory
      cat: db2rrest/files: Not a directory
      cat: db2rspgn/files: Not a directory
      cat: db2sampl/files: Not a directory
      cat: db2scont/files: Not a directory
      cat: db2setres/files: Not a directory
      cat: db2sqljbind/files: Not a directory
      cat: db2sqljcustomize/files: Not a directory
      cat: db2sqljprint/files: Not a directory
      cat: db2support/files: Not a directory
      cat: db2symlookup/files: Not a directory
      cat: db2tapemgr/files: Not a directory
      cat: db2tbst/files: Not a directory
      cat: db2tdbmgr/files: Not a directory
      cat: db2top/files: Not a directory
      cat: db2ts/files: Not a directory
      cat: db2ucsmi/files: Not a directory
      cat: db2uext2.pe/files: Not a directory
      cat: db2uext2.v2/files: Not a directory
      cat: db2untag/files: Not a directory
      cat: db2updserv/files: Not a directory
      cat: db2updv97/files: Not a directory
      cat: db2usrinf/files: Not a directory
      cat: db2val/files: Not a directory
      cat: db2vend/files: Not a directory
      cat: db2wrapperconfig/files: Not a directory
      cat: db2xdbmig/files: Not a directory
      cat: db2xdbsg/files: Not a directory
      cat: disable_MQFunctions/files: Not a directory
      cat: dynexpln/files: Not a directory
      cat: enable_MQFunctions/files: Not a directory
      cat: hostlookup/files: Not a directory
      cat: ipclean/files: Not a directory
      cat: ipquery/files: Not a directory
      cat: ktdscvr/files: Not a directory
      cat: latchtrace/files: Not a directory
      cat: pctt/files: Not a directory
      cat: profconv/files: Not a directory
      cat: profdb/files: Not a directory
      cat: profp/files: Not a directory
      cat: readme.pct/files: Not a directory
      cat: routine/files: No such file or directory
      cat: sdscvr/files: Not a directory
      cat: sqlj/files: Not a directory
      cat: whichdist/files: Not a directory
  • pascals
    pascals
    3 Posts
    ACCEPTED ANSWER

    Re: Problem connect to database!

    ‏2012-10-15T16:40:04Z  in response to pascals
    (sorry for grammatical mistakes!)