Catalog command fails for remote DB2 database access - help please !!!

Hi,

I'm currently preparing a new setup for our Perl programs that run on HP-UX using DBD-DB2 module to access remote databases hosted in OS/400. I installed the software DB2-Application-Development-Client with the user "db2inst1" created in the HP machine. The installation went well without any error.

After completed the ADCL installation, I went on to run the db2-catalog commands for defining the remote databases, however the following error was shown every time I ran the command,

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

I tried the same setup in two different HP machines, also tried running the db2-catalog commands as root or db2inst1, but still got the same error message.

Can somebody shed me some light on this?

Thanks
Philip

A reason code: "6" has the following meaning:

An unexpected system error occurred. Try execution again. If problem persists, contact your IBM representative.

Ouch! Without additional information, I don't know what to tell you. Can you run any other DB2 commands like LIST successfully? Are your environment variables set up properly (Is db2profile being run)? I guess I'm fishing for something else that might fail and give a more meaningful error message. The message above is useless for helping solve the problem and sounds kind of grim.

you need to install db2 connect , R U try to access lower vesion DB server , from higher version client


v8 client try to access v7 db



let me know your environment.


thank you

Lekharaju Ennam

I had this error: the cause was file permisions at the top of the /db2 tree. Below this the db2 instance creation process had set the correct permissions but as a non administrative user I could not connect to the database or run commands like db2 list directory.

Once I fixed the permissions it all worked.

Regards,

Anthony