Results 1 to 8 of 8
  1. #1
    Join Date
    Dec 2003
    Posts
    9

    Unanswered: DB2 Administration Client Installation on AIX P-Series machine

    Hi,

    I have installed DB2 Administration Client on AIX machine. The installation says successful.
    I would like to know what are the folders which I have to check to ensure that the installation is successful
    and how can I invoke the DB2 control center on AIX (I mean I would like to know the command to invoke the control center)

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    admin

    lspp - smitty can list installed products
    see /usr/opt/db2_... directories
    create a client instance - logon to this instance - db2cc
    graphical terminal should be available or if using windows - telnet -
    use cygwin with free x-manager - export DISPLAY and start db2cc
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Dec 2003
    Posts
    9

    Question

    Thanks for the response

    I have seen db2_08_01 present in /usr/opt.

    Also I have created the user while installing DB2 Client. I logged using the same userid and pwd

    When I issue the command db2cc, it gives me a error

    $ pwd
    /home/db2inst2
    $ db2cc
    /usr/bin/ksh: db2cc: not found.

    Do I need to give any other command before db2cc ?

  4. #4
    Join Date
    Nov 2004
    Posts
    374

    client

    when you logon : do you see sqllib in homedir
    if not : user is not a client instance or instance was not correctly created
    /usr/opt/db2../instance/db2icrt will create instance
    check $PATH
    type db2level
    all should work correctly
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  5. #5
    Join Date
    Dec 2003
    Posts
    9
    Hi,

    I have created the instance. It seems that this is related to java error

    I have given below commands and the error msgs are as below

    # ./db2cc
    ./db2cc[26]: db2javit: not found.

    # $PATH
    /usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/dt/bin:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin: not found.

    Is it something related to Java or SDK path which we need to set? My requirement is that I have to invoke the Control Center to connect to the Server and I am installing using DB2 Administration Client.

  6. #6
    Join Date
    Nov 2004
    Posts
    374

    client

    the path does not contain sqllib/bin and other below sqllib
    are you logon in the instance user ?
    check for sqllib below your homedir
    if present check for db2profile to be invoked from .profile
    something is anyhow wrong..
    db2cc can be invoked from any path, as it is in $PATH
    should not be invoked from root as the environment is not set for DB2
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  7. #7
    Join Date
    Dec 2003
    Posts
    9
    Thanks Przytula,

    I have included the db2profile in the .profile and executed the .profile. Then I could open the control ceter.
    One doubt, I have is everytime, I logon I am executing .profile with out which control center is not working. Actually .profile should be automatically run when we logon to the system which is not happening.
    How to execute the .profile automatically when we logon to the system (AIX on P-Series)

    Thanks in advance

  8. #8
    Join Date
    Nov 2004
    Posts
    374

    db2cc

    as this is a client instance - it does not need to be (auto)started as it should for a server instance.
    because user will only be used if db2cc will be started manually, so logon is needed and profile executed
    you can also install admin on remote/windows machine and declare the servers/nodes...
    I don't see your problem
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.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
  •