Results 1 to 9 of 9
  1. #1
    Join Date
    Sep 2003
    Location
    United States
    Posts
    65
    Provided Answers: 1

    Unanswered: DB2 Express-C Instance Creation

    I installed a copy of DB2 express on Ubuntu (VM on windows). I did not create instance as a part of setup in the initial stage.

    Now when I go to "/opt/ibm/db2/V9.7/instance$" folder and run "./db2icrt" command it says "DBI1052E You must be root to execute this program."

    So I did SU <user_id> and enter password and I believe now i am acting as root. And, if I run same command again "./db2icrt" i get following msg "The current DB2 copy was not installed by the user who is running the program."

    How go I get around this issue ?

    Thanks for your help!
    >>
    >> Learn PHP/MySQL for free https://www.youtube.com/watch?v=mpQts3ezPVg
    >> Free Web Hosting with PHP, MySQL, Website Builder : http://www.000webhost.com/862861.html

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    There are several limitations in effect for non-root installations.

    Limitations of non-root installations

    To have a fully functional product you should install DB2 as root, following instructions in the manual.

    If you did install software as root, do "su -", without any user ID supplied, because that's the only way to become root.

  3. #3
    Join Date
    Apr 2010
    Posts
    1
    Hello Girish,

    I made a video in Portuguese language which you can follow step by step in the command line. As I said the video was made in Portuguese, but you will be able to understand.

    Please have a look in this website - http://www.ibm.com/services/forms/pr...S_TACT=RFCTHI1

    Girish, I am doing part of DB2 Ambassador here in Brazil and I would like to ask your help too. I am participaring in a mini-challenge to spread DB2 in the globe. Please have a look in this website listed below... you will find different DB2 version in this website. Please Choose one of your interesting and do the download =)

    http://www.ibm.com/services/forms/pr...S_TACT=RFCTHI1

    Thank you in advance,
    Thiago Rossetto

  4. #4
    Join Date
    Dec 2008
    Location
    Toronto, Canada
    Posts
    399
    Quote Originally Posted by n_i View Post
    There are several limitations in effect for non-root installations.

    Limitations of non-root installations

    To have a fully functional product you should install DB2 as root, following instructions in the manual.

    If you did install software as root, do "su -", without any user ID supplied, because that's the only way to become root.
    does it mean that if i install db2 express-C on my PC i need to create 'root' userid first and perform all installation steps under this userid?
    DB2 9.5/9.7 on Unix/AIX 6.1/Linux

  5. #5
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by MarkhamDBA View Post
    does it mean that if i install db2 express-C on my PC i need to create 'root' userid first and perform all installation steps under this userid?
    No, root is for Linux/UNIX only. But when install on Windows, the install userid must have Windows Adminstrator rights.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by MarkhamDBA View Post
    i need to create 'root' userid first
    You don't create root, root creates you.

    Superuser - Wikipedia, the free encyclopedia

  7. #7
    Join Date
    Sep 2003
    Location
    United States
    Posts
    65
    Provided Answers: 1
    Quote Originally Posted by n_i View Post
    There are several limitations in effect for non-root installations.

    Limitations of non-root installations

    To have a fully functional product you should install DB2 as root, following instructions in the manual.

    If you did install software as root, do "su -", without any user ID supplied, because that's the only way to become root.
    I did root install using "su -"
    >>
    >> Learn PHP/MySQL for free https://www.youtube.com/watch?v=mpQts3ezPVg
    >> Free Web Hosting with PHP, MySQL, Website Builder : http://www.000webhost.com/862861.html

  8. #8
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by gvphubli View Post
    I did root install
    Then you must be root to run instance-level commands.

  9. #9
    Join Date
    Sep 2003
    Location
    United States
    Posts
    65
    Provided Answers: 1
    Correct I have done DB2 root instal.

    however the quest is why is it complaining that - "The current DB2 copy was not installed by the user who is running the program.". Dispite of me using "su -" option to start the "./db2icrt" program/script.
    >>
    >> Learn PHP/MySQL for free https://www.youtube.com/watch?v=mpQts3ezPVg
    >> Free Web Hosting with PHP, MySQL, Website Builder : http://www.000webhost.com/862861.html

Posting Permissions

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