db2: not found

[Former Member]

Hi All,

I am facing a problem, my db2 command is not found in dev server since few months ago.

sap instance can start, but I can't using db2 command (i.e: backup offline )

I already checked /db2/db2xxx/db2_software/bin , db2 is not in there

I tried to copy db2 from other instance but it's not work.

How to solve this issue?

Below is startdb.log

Database Manager started
/usr/sap/xxx/SYS/exe/run/startdb[112]: /db2/db2xxx/sqllib/bin/db2:  not found
Activate database failed

------------------------------ Sat, Jul 7, 2012 11:36:15 AM
R3trans connect to the database

R3trans check finished with return code: 0

R3trans connect successfull

[Frank-Martin]

Hi,

are you trying to execute db2 CLP on the database server or on an SAP appserver. As a default SAP appservers do not get a DB2 instance and therefore db2 CLP is not available.

If you are logged on to the DB2 database server, db2 CLP should be available. E.g. if your instance name is db2xxx, log on as db2xxx user and db2 should be in the search path. If not something may be wrong with your user environment. In this case try to source the DB2 login sripts.

source /db2/db2xxx/sqllib/db2cshrc

After that db2, db2level , etc. should work. If not, you are in trouble and may have lost some files or filesystems . However in this case you should not be able to bring up your database server any more.

Regards

                  Frank

[Former Member]

Hi

Please make sure you are login to SAP database instance.Other servers do not have DB2 instance on them and thus db2 CLP will not work.

You can check this by firing command df -g and check filesystems /db2/<SID>/sapdata(n) exisitng on the server you are logged in. If not exisitng then most probaly you are on App server of SAP where database is not residing.

[Former Member]

Hi Frank,

I have done as per your suggestion, I am affraid db2 file lost .

Should I reinstall/system copy dev server or any better idea?

xxxadm 22>  source /db2/db2xxx/sqllib/db2cshrc

xxxadm 23> db2

db2: Command not found.

xxxadm 24> db2level

DB21085I  Instance "db2xxx" uses "64" bits and DB2 code release "SQL09074" with

level identifier "08050107".

Informational tokens are "DB2 v9.7.0.4", "s110330", "IP23239", and Fix Pack

"4".

Product is installed at "/db2/db2xxx/db2_software".

Hi Mohammed,

we have one server only for app and db, I have tried log in SAP instance using db2xxx and xxxadm , both have same message "db2 not found "

[rajan_thomas]

hi

did you tried db2iupdt from root.

Regards,

Rajan

[Frank-Martin]

Hi,

I agree with Rajan. Check

ls -la /db2/db2xxx/db2_software/bin/db2

ls -la /db2/db2xxx/sqllib/bin/db2

If only the second one is missing, try  "/db2/db2xxx/db2_software/instance/db2iupdt db2xxx" as root.

If the first one is missing, you have destroyed your DB2 software installation and need to reinstall DB2.

Regards

                  Frank

[Former Member]

# ls -la /db2/db2xxx/sqllib/bin/db2

/db2/db2xxx/sqllib/bin/db2 not found

# ls -la /db2/db2xxx/sqllib/bin/db2

/db2/db2xxx/sqllib/bin/db2 not found

Ok , I will try to reinstall db2.

Thanks all for your response.

[rajan_thomas]

hi

use this thread in sdn it might be helpful

http://scn.sap.com/thread/3249814

Regards,

Rajan