Results 1 to 9 of 9
  1. #1
    Join Date
    May 2014
    Posts
    15

    Unanswered: db2 10.1 installed as non root on a virtual machine

    I am installing db2 10.1 on a virtual machine with 8GB mem and 25 GB disk .
    The OS is ubuntu 12.4 server headless ( no GUI)
    The db2 instalation was done as non root . I wanted to install as root but colud not because of the following story :

    The VM is located on Openstack cloud . I used ssh -Y to access the VM from another machine with X system but
    could get the db2setup GUI only if I ssh-ed with the non root user of the VM image . If I ssh as root and then
    run ./db2setup I get the following exception:


    Exception in thread "main" java.lang.UnsatisfiedLinkError:

    /tmp/db2.tmp.3790/db2/linuxamd64/java/jre/lib/amd64/xawt/libmawt.so (libXrender.so.1: cannot open shared object file: No

    such file or directory)
    at java.lang.ClassLoader.loadLibraryWithPath(ClassLoa der.java:1165)
    at java.lang.System.load(System.java:479)
    at java.lang.ClassLoader.loadLibraryWithPath(Native Method)
    at java.lang.ClassLoader.loadLibraryWithPath(ClassLoa der.java:1157)
    at java.lang.ClassLoader.loadLibraryWithClassLoader(C lassLoader.java:112

    In the non root case no request is done for the above file and no path /tmp/db2.tmp.3790/db2/linuxamd64/java/jre/
    is generated at all

    Anyhow: assuming db2 can function with non root user I still have problems per my following 2 Questions:

    1) Running db2val (to validate db2 install) from non root I get segmentation
    error with following log file:

    Installation file validation for the DB2 copy installed at
    "/home/ubuntu/sqllib" starts.

    Task 1: Validating Installation file sets.
    Status 1 : Success

    Task 2: Validating embedded runtime path for DB2 executables and libraries.
    Status 2 : Success

    Task 3: Validating the accessibility to the installation path.
    Status 3 : Success

    Task 4: Validating the accessibility to the /etc/services file.
    Status 4 : Success

    DBI1335I Installation file validation for the DB2 copy installed at
    /home/ubuntu/sqllib was successful.

    Installation file validation for the DB2 copy installed at "/home/ubuntu/sqllib" ends.

    Instance validation for "ubuntu" starts.

    Task 5: Validating symbolic links in the instance directory.
    Status 5 : Success

    Task 6: Validating instance file ownership and permission.
    Files with wrong ownership:


    so Task 6 failed and caused the segmentation fault

    However :
    --------
    db2val run as root ('sudo su' from non root user prompt ) is finished ok (no
    tasks beyond #4 at the log file) as follows:

    DBI1379I The db2val command is running. This can take several minutes.

    DBI1335I Installation file validation for the DB2 copy installed at
    /home/ubuntu/sqllib was successful.

    DBI1343I The db2val command completed successfully. For details, see
    the log file /tmp/db2val-140519_152153.log.


    Should I consider the db2val results ok or not and if not what is the
    remedy ?

    2) Although /tmp/db2setup_ubuntu.log shows everything during installation succeded (db2setup_ubuntu.err is empty)
    including generation of db instance 'ubuntu' and user 'ubuntu' , the db manager is not started and I cannot
    start it :

    db2start (as ubuntu user - non root) returns :

    05/19/2014 15:50:33 0 0 SQL1220N The database manager failed
    to allocate shared memory.

    SQL1032N No start database manager command was issued.
    SQLSTATE=57019

    Googling for these SQL messages I see that I should set dbm cfg
    INSTANCE_MEMORY value to AUTOMATIC

    I did that + verified that instance memory is automatic but still have the
    above shared memory problem .
    (verified by: db2 get dbm cfg | grep -i instance_memory)

    The Googled instructions also say :

    "If INSTANCE_MEMORY is already set to automatic and you encounter the
    error again. Then either remove the capping from
    zone.max-locked-memory; or work with your system administrator to set
    the privileged limit for "zone.max-locked-memory" high enough for DB2 to
    start."

    I am not familiar with "zone.max-locked-memory" . Don't know how to
    remove the capping and I do not have the utility
    'zonecfg' on my system as per this document
    http://docs.huihoo.com/opensolaris/s...ners-resource-
    management-and-solaris-zones/html/p56.html#z.conf.start-29


    Any idea how to overcome the db2start problem ?


    thanks

  2. #2
    Join Date
    May 2014
    Posts
    15

    db2 10.1 installed as non-root

    mistaken answer . still waiting for help
    Last edited by zvidubi; 05-19-14 at 13:29.

  3. #3
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    I never use non-root installs for the db2 server , too many restrictions.
    Why don't you ssh as yourself to the box, then sudo su - to become root.
    You don't need a GUI to install the db2 v10.1 server on linux , because the db2_install still works although is deprecated, and you can also install the db2 with a response-file (unattended), so there's no need for a GUI at all.

    But one crucially important detail is that after you become root, and before you install db2 components, you should run the db2prereqcheck tool (with the appropriate command line options), and you should resolve *every* "not matched" requirement before you install the db2 product. Avoid that step, and you invite pain...

    I'd uninstall the non-root stuff, and start again with root (via sudo) and non-gui install only after resolving every db2prereqcheck item relevant to the db2-server style you want.

  4. #4
    Join Date
    May 2014
    Posts
    15

    db2 10.1 installed as non root (reply)

    thanks db2mor

    I have run the db2prereqcheck and it seems to finish ok (so is also the final statement) I am using a 64 bit machine and the only deviation in the output is a missing 32 bit library "libstdc++.so.6". I gues this does not matter . Does it ?

    Here is the last lines of output of the prereqcheck:

    Validating 32 bit version of libstdc++.so.6 ...
    Found the 64 bit "/usr/lib/x86_64-linux-gnu/libstdc++.so.6" in the following directory "/usr/lib/x86_64-linux-gnu".
    DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: "libstdc++.so.6".

    DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met for DB2 database server . Version: "10.1.0.0".

  5. #5
    Join Date
    May 2014
    Posts
    15

    db2 10.1 installed as root with db_install

    Hi

    Following your advice I run db_install (deprecated) as root and I do have problems :

    ./db2_install -b /opt/ibm/db2/V10.1

    I am asked to choose one of : ESE, CLIENT, RTCL

    I chose : ESE

    The asked if to include DB2 pureScale feature and answered 'no'

    and in response got an exception:

    DB2 installation is being initialized.

    *** glibc detected *** /tmp/db2.tmp.5075/db2/linuxamd64/install//db2iure: malloc(): memory corruption: 0x0000000001e4fd10 ***
    ======= Backtrace: =========
    /lib/x86_64-linux-gnu/libc.so.6(+0x7eb96)[0x7f77391b1b96]
    /lib/x86_64-linux-gnu/libc.so.6(+0x80d5b)[0x7f77391b3d5b]
    /lib/x86_64-linux-gnu/libc.so.6(__libc_malloc+0x75)[0x7f77391b5f95]
    /usr/lib/x86_64-linux-gnu/libstdc++.so.6(_Znwm+0x1d)[0x7f77397beded]
    /usr/lib/x86_64-linux-gnu/libstdc++.so.6(_Znam+0x9)[0x7f77397bef09]
    ./libdb2ure.so.1(_ZN14MsgTokenHolder8addTokenEPKc+0x 4c)[0x7f7739e1eb4c]
    ./libdb2ure.so.1(_ZN11GPFSFileset9initLevelEbPcb+0xa 5e)[0x7f7739f40c6e]
    ./libdb2ure.so.1(_ZN11GPFSFileset8initSpecEb+0x2c8)[0x7f7739f41c28]
    ./libdb2ure.so.1(_ZN9ExFileset13initMediaSpecEv+0xc)[0x7f7739f41e1c]
    ./libdb2ure.so.1(_ZN11GPFSFileset7setOnCDEv+0x3db)[0x7f7739f3c41b]
    ./libdb2ure.so.1(_ZN11FilesetList13setExternOnCDEv+0 x86)[0x7f7739f33986]
    ./libdb2ure.so.1(_ZN14FilesetUtility9scanMediaEPKc+0 x593)[0x7f7739f21903]
    ./libdb2ure.so.1(_ZN11FilesetList4initEv+0x384)[0x7f7739f39a24]
    ./libdb2ure.so.1(_ZN11FilesetList11getInstanceEv+0x1 39)[0x7f7739f36d99]
    ./libdb2ure.so.1(_ZN14FilesetUtility10scanSystemEv+0 xf3)[0x7f7739f20103]
    ./libdb2ure.so.1(_ZN14FilesetUtility11readRspFileEb+ 0x43)[0x7f7739f21203]
    ./libdb2ure.so.1(_ZN14FilesetUtility11isRspFileOKEv+ 0x16)[0x7f7739f211b6]
    ./libdb2ure.so.1(_Z18iSilentInstallMainiPPc+0xf7f)[0x7f7739ea8cdf]
    /tmp/db2.tmp.5075/db2/linuxamd64/install//db2iure(main+0x25)[0x401e75]
    /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xed)[0x7f773915476d]
    /tmp/db2.tmp.5075/db2/linuxamd64/install//db2iure(__gxx_personality_v0+0x49)[0x401db9]

    what is causing this ?

    I am using Ubuntu 12.4 headless (server no GUI)

  6. #6
    Join Date
    May 2014
    Posts
    15

    db2_install issue

    Installing the missing libstdc.0.6 library for 32 bit to the DB2 server ( db2prereqcheck complained . anyhow I am using 64 bit machine)
    did not help solve the db2_install problem cited above

  7. #7
    Join Date
    Apr 2012
    Posts
    1,035
    Provided Answers: 18
    Can you confirm that the db2prereqcheck output report
    had no other "requirement not matched" lines , apart from the missing library?

  8. #8
    Join Date
    May 2014
    Posts
    15

    db2_install with exception (DB2 10.1)

    Below is the db2prereqcheck output after I also added (apt-get) the missing 32 bit library and still I have the above mentioned exception while running db2_install. Note the my DB2 is 10.1 not 9.7:

    Checking DB2 prerequisites for DB2 database version 10.1.0.0 on operating system "Linux"

    Validating Linux distribution ...
    Requireed minimum UBUNTU version: 10.04
    Actual version: 12.04
    Requirement matched.

    Validating kernel level ...
    Required minimum operating system kernel level : "2.6.16".
    Actual operating system kernel level: "3.11.0".
    Requirement matched.

    Validating C++ Library version ...
    Required minimum C++ library: libstdc++.so.6
    Standard C++ library is located in the following directory: "/usr/lib/x86_64-linux-gnu/libstdc++.so.6.0.16".
    Actual C++ library: CXXABI_1.3.1
    Requirement matched.

    Validating 32 bit version of libstdc++.so.6 ...
    Found the 64 bit "/usr/lib/x86_64-linux-gnu/libstdc++.so.6" in the following directory "/usr/lib/x86_64-linux-gnu".
    Found the 32 bit "/usr/lib32/libstdc++.so.6" in the following directory "/usr/lib32".
    Requirement matched.

    DBT3533I The db2prereqcheck utility has confirmed that all installation prerequisites were met for DB2 database server . Version: "10.1.0.0".
    DB2 version 9.8.0.4 is not supported on the current platform.
    DB2 version 9.8.0.3 is not supported on the current platform.
    DB2 version 9.8.0.2 is not supported on the current platform.

  9. #9
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ---
    "It does not work" is not a valid problem statement.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •