Skip to main content

developerWorks >  Information Management  >  Forums  >  DB2 for Linux, UNIX, and Windows  >  developerWorks

DB2 installation on AIX    Point your RSS reader here for a feed of the latest messages in this thread


     

 
 

My developerWorks
 Welcome, Guest
Sign in or register
Permlink Replies: 8 - Pages: 1 - Last Post: Nov 19, 2009 2:22 AM Last Post By: 1029384756 Threads: [ Previous | Next ]
1029384756

Posts: 9
Registered: Nov 06, 2009 08:35:43 AM
DB2 installation on AIX
Posted: Nov 06, 2009 08:41:11 AM
Click to report abuse...   Click to reply to this thread Reply
Hello all !

I'm new in Unix systems
I have allready installed DB2 on AIX and it does not work
The sign of it is that for example I can't run db2 command from /opt/IBM/db2/V9.5/bin/ directory
in case of root this command not exist and in case of db2inst1 result is following:

SQL10007N Message "-1390" could not be retrieved. Reason code: "3"

Please, can anyone tell me what to do on it ?

thanks.
impetej

Posts: 3
Registered: Nov 06, 2009 07:56:53 AM
Re: DB2 installation on AIX
Posted: Nov 06, 2009 08:59:39 AM   in response to: 1029384756 in response to: 1029384756's post
Click to report abuse...   Click to reply to this thread Reply
My guess is that your environment is not set up.

I use this in my .profile (provided by DB2 install, assuming your instance owner had a .profile when the instance is created)

  1. The following three lines have been added by UDB DB2.
if -f <instance owner home dir>/sqllib/db2profile ; then
. <instance owner home dir>/sqllib/db2profile
fi

If for some reason, you don't want it in the .profile you can source the db2profile which will set it up.

I think the "1390" message is:

SQL1390C The environment variable DB2INSTANCE is not defined or is
invalid.

Explanation:

The environment variable DB2INSTANCE is not defined or is not set to a
valid instance owner.

User response:

Set the DB2INSTANCE environment variable to the name of the instance to
use. If you do not know the name of the instance to use or how to set
the DB2INSTANCE environment variable to the instance name, refer to the
Administration Guide.

Federated system users: refer to the Federated Systems Guide for
DB2INSTANCE information.

Ensure your PATH environment variable contains the sqllib/adm path in
the home directory of the instance you want to use (for example,
/u/instance/sqllib/adm, where /u/instance is the home directory of the
instance owner on a UNIX system).
1029384756

Posts: 9
Registered: Nov 06, 2009 08:35:43 AM
Re: DB2 installation on AIX
Posted: Nov 06, 2009 09:06:12 AM   in response to: impetej in response to: impetej's post
Click to report abuse...   Click to reply to this thread Reply
thanks impetej

but,
there is not sqllib directory exist in corresponding path

how can i create that one ? - I mean, it must be create by some installation step or it must create manually ?
impetej

Posts: 3
Registered: Nov 06, 2009 07:56:53 AM
Re: DB2 installation on AIX
Posted: Nov 06, 2009 09:14:06 AM   in response to: 1029384756 in response to: 1029384756's post
Click to report abuse...   Click to reply to this thread Reply
You may not have created an instance as part of the install or as a post installation step.

To confirm, run <db2 install path>/instance/db2ilist

That will let you know if you created one or not. If not, you will need to create one with <db2 install path>/instance/db2icrt.

Check the install docs for more information on this step.

Hope it helps!
Pete
1029384756

Posts: 9
Registered: Nov 06, 2009 08:35:43 AM
Re: DB2 installation on AIX
Posted: Nov 06, 2009 10:54:15 AM   in response to: impetej in response to: impetej's post
Click to report abuse...   Click to reply to this thread Reply
ok

I allready try to run db2ilist when I used install doc but there were some errors,

right now I have not access to that system and monday I'll try it again
and post error detailes

thank you !
George
1029384756

Posts: 9
Registered: Nov 06, 2009 08:35:43 AM
Re: DB2 installation on AIX
Posted: Nov 09, 2009 12:51:01 AM   in response to: 1029384756 in response to: 1029384756's post
Click to report abuse...   Click to reply to this thread Reply
ok.

when I run db2ilist

in case of root there is an error: ksh: db2ilist: not found
(I also use chmod 777 for this directory)

and

in case of db2inst1 no any output, only #.
1029384756

Posts: 9
Registered: Nov 06, 2009 08:35:43 AM
Re: DB2 installation on AIX
Posted: Nov 10, 2009 12:41:24 AM   in response to: 1029384756 in response to: 1029384756's post
Click to report abuse...   Click to reply to this thread Reply
So situation is following:

I want to connect to *DB2*(on *AIX*) on the remote computer.
As it is known the server is runed and the port is opened (I test port), but I cant connect to them by client app, there are some connection errors,

than I check an existance of db2 command on server, but it dose not work, following error was occured:
SQL10007N Message "-1390" could not be retrieved. Reason code: "3"

The matter is, that the DB2 server is not installed by me and now my aim is to check is it completelly installed or not
how to do it ?

Can anyone tell me.
pound

Posts: 7
Registered: Nov 18, 2009 02:34:43 PM
Re: DB2 installation on AIX
Posted: Nov 18, 2009 03:43:07 PM   in response to: 1029384756 in response to: 1029384756's post
Click to report abuse...   Click to reply to this thread Reply
I have some clarifications in your question. Are you sure the DB2 installation went fine ? You can verify the DB2 installation from the DB2 server using this. (NOT FROM THE DB2 CLIENT). Make sure you are verifying this in the DB2 server
for DB2 V8.1 or V8.2 - lslpp -l | grep db2 (u should see DB2 components as committed)

for DB2 v9 and more = db2ls

Once this verification is done. Try to login to the instance in the DB2 server and type db2. If you are able to enter the command prompt then its good. Or please check the .profile in the instance home directory /home/<instancename>.
Then add these lines in the .profile and execute it.

if -f /db2home/<instancename>/sqllib/db2profile ; then
. /db2home/<instancename>/sqllib/db2profile
fi

Where instancename=your instance name
then execute the .profile with this command
. .profile
Then you may exit out of the instance login back and check it should work.
After this we may proceed to remote client connection which involves cataloging of the database.

Hope this helps

thanks
1029384756

Posts: 9
Registered: Nov 06, 2009 08:35:43 AM
Re: DB2 installation on AIX
Posted: Nov 19, 2009 02:22:36 AM   in response to: pound in response to: pound's post
Click to report abuse...   Click to reply to this thread Reply
Ok, I'l try to post step-by-step:

1.
the command:
/opt/IBM/db2/V9.5/install/db2ls
gives following:
/opt/IBM/db2/V9.5 9.5.0.4 4 Sat Oct 17 17:10:44 2009 CDT 0
2.
the directory sqllib not exist but db2pro file exist in /opt/IBM/db2/V9.5/cfg/
3.
Sorry but I not fully understend what dose it means:
*if -f /db2home/<instancename>/sqllib/db2profile ; then
. /db2home/<instancename>/sqllib/db2profile
fi*
but I add last line to .profile, so its content now is following:

*PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:.
export PATH
if # This is at Shell startup. In normal
then echo "$MAILMSG" # operation, the Shell checks
fi # periodically.
. /opt/IBM/db2/V9.5/cfg/db2profile*

4.
then I login with db2inst1 but 'db2' command steel not works.

5.
Now the server is stoped, I stop it with db2stop but when I try to start with db2start , it gives following:
SQL10007N Message "-1390" could not be retrieved. Reason code: "3"

Thanks
 Tags
Help

Use the search field to find all types of content in My developerWorks with that tag.

Use the slider bar to see more or fewer tags.

Popular tags shows the top tags for this particular type of content or application that you're viewing.

My tags shows your tags for this particular type of content or application that you're viewing.

 

MoreLess 


Point your RSS reader here for a feed of the latest messages in all forums