DB2 Client insallation

[Former Member]

Hi Expert,

I have succesffuly installed DB2 Client software as root user version (8.1)

I have added the PATH , Library and when I try to invoke the db2 command. I am getting an error message

as below

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

Please note: I am trying to connect to external DB2 database.

Any lead on this highly appreciated.

Thanks

Ahamed

[Frank-Martin]

Hi Ahamed,

the DB2 runtime client needs the variable DB2INSTANCE to find its message files, etc.

I assume that you have already created a clinet instance.

I suggest to

- undo your manual settings from the library path, etc.

- setenv DB2INSTANCE = instance name

- source $DB2INSTANCE/sqllib/db2cshrc

( add to your login scripts )

- run "db2"

Regards

Frank

[Former Member]

Hi Frank,

Thanks for the information. I have undo the manual enviornmental settings and re-created the client instance.

The following enviornmental path set automatically like.

DB2INSTANCE = instance name, PATH & Sqlib directory set automatically.

I have a new problem under my /adm directory, I could not find the executable "db2licm".

(Using, db2_install I have installed the db2client)

From where can I download the license for the DB2 client? Followed note: 8163773 , but the OEM license link is missing in SMP.

I am missing somethingh ere?

Thanks

ahamed

Edited by: Ahamed Yasin on Aug 24, 2010 12:33 PM

[Frank-Martin]

Hi Ahamed,

the DB2 client does not require a license as long as you do not connect to a DB2/Z or DB2/iSeries Database.

Regards

Frank

[Former Member]

Hi Frank,

You are absolutely right, we are trying to connect to DB2/Z database.

But , I dont have db2licm executable available under /adm folder.

Thanks

Ahamed