Hi friends,

I am writing a PHP script to monitor db..Does any one know if we can call db2diag command or list history command inside php??

I know there is ADMIN_CMD proc but it does not allow for db2diag command or list history

Thanks in advance

check out in application development guide...

db2diag is not a DB2 command but rather a program. Thus, you cannot invoke it through ADMIN_CMD.

Can we invoke using C code??If so can you provide me some inputs as to how can i do that

thanks a lot

You could write a UDF or stored procedure with LANGUAGE C. Inside the routine, I would open a simple pipe (see "man popen") to invoke "db2diag" with the desired options and get its output.