How do I install db2 Express-C 10.1 on OSX Mavericks -

-

I have tried to install DB2 Express-C10.1 on OSX Mavericks, but I get the error listed here:

The steps I have taken to set up DB2 Express C on Mac OSX Mavericks All logged in user orders; When I needed to run as a different user, I used sudo.

Step:

  1. Download DB2 Express C from:

    2. < Li>

    Open the downloaded file twice and open it.

  2. Modify the system parameter with this command:

    sudo Vi /etc/sysctl.conf

    And populate with this information: 

      kern.sysv.shmmax = 1073741824 kern.sysv.shmmin = 1 kern. Sysv.shmmni = 4096 kern.sysv.shmseg = 32 kern.sysv.shmall = 1179648 kern.maxfilesperproc = 65536 kern.maxfiles = 65536

  3. Reboot the computer # With very sad I added that instruction.

  4. Start the installation process with these commands:
    cd ~ / Downloads / expc;

  6. Accept the default path of '/opt/IBM/db2/V10.1'

  7. Run the script Wait for about three minutes.

  8. Note that a successful run has ended in 'execution successfully completed'.

  9. Create a db2inst1 user using the Mac GUI (System Preferences -> Users and Groups). Use standard (non-administrator) privileges

  10. Example with these commands:
    cd /opt/IBM/db2/V10.1/instance ; Sudo ./db2icrt -u db2inst1 db2inst1

  11. Modify your profile with this command:

    vim ~ /. Bash_profile
    and adding these lines (perhaps at the end of the file):
    Pat = $ Pat: /opt/IBM/db2/V10.1/bin
    If [[-f ~ db2inst1 / Sqllib / db2profile]] so
    source ~ db2inst1 / sqlib / db2profile
    fi

  12. enter the new terminal window to receive new settings from .bash_profile Please. Exit the old window to avoid confusion.

  13. Begin sample database using this command:
    db2sampl

  15. Test the sample database using these commands:

    16. > Connect to the DB2 sample db2 list tables

    If you have to connect to this database from a remote machine or connect to this database using Java Want to make the connection where host and port number is required , Then remove and follow the instructions to enable connection. Unless you really need to be connected in this fashion, you can stop these instructions from running. After running these instructions without having to run these instructions, you can connect using the db2 command line, you will be able to connect to any number of devices, which requires the host and port number.

    Steps to enable remote connections:

    cd ~ db2inst1

    sudo -

    U db2inst1 db2 update dbm cfg svcename using db2c_db2inst1

    The CD is required because the command must be typed in the current directory.

  16. Add Service Commands By using this service:

    sudo vim / etc / services

    And add this line as the last line in the file. The real situation is not important.

    db2c_db2inst1 50000 / tcp

  17. Set up DB2 should use TCP / IP using this command :

    sudo -u db2inst1 db2set DB2COMM = TCPIP

  18. stop and start the database with these commands:

    sudo -u db2inst1 db2stop force

    sudo -u db2inst1 db2start

    Note force < / Code> stop command will open an existing connection with it. If you want to be kind to those users who are connected, do not use force and After prompting users to disconnect, try the command again. I used to include the force in the original instructions because it is possible that any database that follows these instructions is the only user on the database.

Reference:

    • If you determine the improvement in these instructions If so, please post comments. I will be informed and will make changes.


    Comments

    Post a Comment

    Popular posts from this blog

    import - Python ImportError: No module named wmi -

    -
    I followed the instructions for downloading WMI for Python When I try to run the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = wmi.WMI (): if Raw_input ("restart% s?"% S.Caption) .upper () == "Y": s.StartService () I got the error < Code> traceback (most recent call end): file ". \", Line 1, edit: I am using Python 2.7.6 EDIT2: I am running 64-bit Windows 2008 R2, and I've downloaded WMI-1.4.9.zip (md5). I removed the content and put it in D: Python \ Tools \ Scripts I executed dragon setup.py.install I said D : \ Python \ tools \ scripts to% PATH% and when I execute the code for C.Win32_Service (StartMode = "Auto", state = "Stopped") import wmi c = Wmi.WMI (): If raw_input ("Restart% s?"% S. Caption). () == "Y": s.StartService () error me Gets traceback (most recent call final): File ". See \", line 1, &
    Read more

    Editing Python Class in Shell and SQLAlchemy -

    -
    I am working on the terminal on a shell script after this tutorial SQLAlchemy tutorial. I need to type gt; & Gt; & Gt; Sqlalchemy import column, integer, string & gt; & Gt; & Gt; Class user (base): __tablename__ = 'users' id = column (integer, primary_key = true) name = column (string) absolute name = column (string) password = column (string) def __repr __ (self): return "& lt ; User (name = '% s', absolute name = '% s', password = '% s') & gt; "% (Self.name, self.fullname, self.password) After the problem I have typed the password = column (string) I hit twice and changed .... >> I then took everything back but then an error was thrown because the class already exists ... I am not completely sure how to fix it. How do I open that slip in the shell script and edit it (Add DF to DRR) The error thrown below: / user / giripeters / TFSQLLX / Lib / python2.7 / site-packages / sqlalchemy / ext / decla
    Read more

    c# - MySQL Parameterized Select Query joining tables issue -

    -
    I am using parameterized select questions in conjunction with my program and it works entirely, When I try to join the table Everything I have done is a small fraction: using (MySqlCommand cmd = new MySqlCommand (paramQuery) ToSql (), Connection)) /etc/ paramQuery.ToSql () Equal: "Select TableOne ID, Tableon, Department, Tablet. One by name table, Table 2 h Yes TableOnEID = @Pharmak "* / for (Int Index = 0; Index and Lt; ParamariX Parameter (.c calculation; Index ++) Cmd.Parameters.AddWithValue (paramQuery.Parameters (). ElementAt (index). , ParamQuery.Parameters (). ElementAt (index) .Value); / * ParamQuery.Parameters (). ElementAt (index) .k = "@most 0" paramQuery.Parameters (). ElementAt (index) .Value = "tableTwo.ID" * / MySqlDataReader Reader = cmd.ExecuteReader (); While (reader.Read ()) {// do stuff} } One of the tables I attempt to join is For the table, two with the same id for all. Is there something that I'm doing wrong?
    Read more