If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > DB2 Administration Client Installation on AIX P-Series machine

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-30-06, 10:38
tnssrini tnssrini is offline
Registered User
 
Join Date: Dec 2003
Posts: 9
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)
Reply With Quote
  #2 (permalink)  
Old 01-31-06, 03:05
przytula przytula is offline
Registered User
 
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
Reply With Quote
  #3 (permalink)  
Old 01-31-06, 06:37
tnssrini tnssrini is offline
Registered User
 
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 ?
Reply With Quote
  #4 (permalink)  
Old 01-31-06, 08:13
przytula przytula is offline
Registered User
 
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
Reply With Quote
  #5 (permalink)  
Old 02-05-06, 09:59
tnssrini tnssrini is offline
Registered User
 
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.
Reply With Quote
  #6 (permalink)  
Old 02-06-06, 04:09
przytula przytula is offline
Registered User
 
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
Reply With Quote
  #7 (permalink)  
Old 02-06-06, 09:23
tnssrini tnssrini is offline
Registered User
 
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
Reply With Quote
  #8 (permalink)  
Old 02-07-06, 04:43
przytula przytula is offline
Registered User
 
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On