find if database is running.

[Former Member]

Hi Gurus,

My environment is ECC6.0 on AIX 5.3 and my database is DB2. I would like to know how i can find if the database is running from the AIX level.

Thanks,

Sachin.

[Former Member]

su to sidadm

eg su - <sid>adm

password

cd /usr/sap/SID/SYS/exe/run

R3trans -x

This command will give us if Database is running or not.

[former_member204746]

try: R3trans -d

evaluate return code. This works for Oracle but should also work for any other database.

[Former Member]

db2pd -alldbs -memsets|grep Database

[former_member640873]

Hi Sachin,

Depends on what you mean by running. If you like to check if the instance is up, you can run "ps -ef|grep db2" to check if there is any db2 processes. If you like to know if the database is activate, as db2<sid>, you can run db2 activate db <sid> and you may get:

lucka:db2lr1 19> db2 activate db lr1

SQL1490W Activate database is successful, however, the database has already

been activated on one or more nodes.

which means the database is already active.

For the SAP level, you can run "ps -ef|grep dw" to check if the SAP work processes are up. You can also check the available.log to see if the SAP system is up:

lucka:lr1adm 16> pwd

/usr/sap/LR1/DVEBMGS90/work

lucka:lr1adm 17> cat available.log

Unavailable 24.09.2008 08:11:48 - 24.09.2008 08:11:48

Available 24.09.2008 08:12:48 - 26.09.2008 01:35:19

Unavailable 26.09.2008 01:36:19 - 26.09.2008 01:36:19

Available 26.09.2008 01:37:19 - 26.09.2008 02:08:19

Unavailable 26.09.2008 02:09:19 - 26.09.2008 02:09:19

Available 26.09.2008 02:10:19 - 26.09.2008 02:43:19

Unavailable 26.09.2008 02:44:19 - 26.09.2008 02:50:20

Available 26.09.2008 02:51:20 - 27.09.2008 01:10:37

Unavailable 27.09.2008 01:11:37 - 27.09.2008 01:12:37

Available 27.09.2008 01:13:37 - 28.09.2008 02:07:00

Unavailable 28.09.2008 02:08:00 - 28.09.2008 02:23:00

Available 28.09.2008 02:24:00 - 30.09.2008 11:36:34

Unavailable 30.09.2008 11:37:34 - 30.09.2008 14:05:36

Available 30.09.2008 14:06:36 - 06.10.2008 11:42:01

I hope this helps. Free feel to let me know if you have any further question.

Regards,