Process Tree

db2db2 · #1 (**permalink**) 03-26-04, 11:45

All,

Is there a process tree command (db2ptree) for AIX ?
I came across an article that explained about db2ptree command for Solaris.

Thanks
Chenni

sathyaram_s · #2 (**permalink**) 03-26-04, 12:06

I'm not sure if you read this or someother article :

Quote:

Since the ps command on Sun's operating system does not provide the real process name of the DB2 processes (instead ps shows only "db2sysc") a new tool db2ptree was developed.
With db2ptree the DBA is able to see all DB2 processes of one instance with their real names (e.g. db2wdog, db2pfchr etc.). The result is in an easy-to-read tree structure. db2ptree is part of the standard DB2 installation image on Sun. It is located in the sqllib/bin subdirectory.

This explains why IBM has provided db2ptree only for Solaris ... I think you should be able to script one for AIX yourself

Cheers
Sathyaram

Quote:

Originally posted by db2db2
All,

Is there a process tree command (db2ptree) for AIX ?
I came across an article that explained about db2ptree command for Solaris.

Thanks
Chenni

db2db2 · #3 (**permalink**) 03-26-04, 12:16

Sathya, Thanks for the immediate response and your reply explains why Solaris has db2ptree command. Btw, I don't see the command in ../sqllib/bin directory.

I will develop one soon.

Thanks
Chenni

sathyaram_s · #4 (**permalink**) 03-27-04, 18:59

Are you on Solaris platform ?

I have used this db2ptree on Solaris

Quote:

Btw, I don't see the command in ../sqllib/bin directory.

db2db2 · #5 (**permalink**) 03-27-04, 21:41

Sathya,

I'm on AIX. I downloaded a perl script pstree from WEB and it works like a charm.

-Chenni

Quote:

Originally posted by sathyaram_s
Are you on Solaris platform ?

I have used this db2ptree on Solaris

RKrick · #6 (**permalink**) 03-29-04, 02:40

Don't you have db2_local_ps on AIX? What db2ptree gives you that db2_local_ps doesn't?

db2db2 · #7 (**permalink**) 03-29-04, 15:52

I completely forgot about db2_local_ps and i never thought it can do the same.
pstree is no different than db2_local_ps.

Thanks for your post.

-Chenni

Quote:

Originally posted by RKrick
Don't you have db2_local_ps on AIX? What db2ptree gives you that db2_local_ps doesn't?

Internet Services

Web Development

Digital Marketing

Consumer Tech