SYSPROC.MON_GET_APPLICATION_ID SP for 9.7 fp3

#1

Hi
I am in need of this SP and the get application_handle that gets created byrunning db2updv97 script. I am in fp 2 and the DBA team is not going to update the fixpack in near future. Is there any place I can get the script ofthese SPs? My interest on these have been partly due to the sql profiler from sqltips4db2luw blog by serge.

Thanks
Arun

#2

On Monday, August 20, 2012 11:22:26 PM UTC+2, Arun Srini wrote:

Quote:

Hi

I am in need of this SP and the get application_handle that gets created by running db2updv97 script. I am in fp 2 and the DBA team is not going to update the fixpack in near future. Is there any place I can get the script of these SPs? My interest on these have been partly due to the sql profilerfrom sqltips4db2luw blog by serge.

Thanks

Arun

Can't you use view SYSIBMADM.SNAPAPPL_INFO instead ?

#3

On Tuesday, 21 August 2012 02:29:10 UTC-5, Luiz da Silva wrote:

Quote:

On Monday, August 20, 2012 11:22:26 PM UTC+2, Arun Srini wrote:

Hi

I am in need of this SP and the get application_handle that gets created by running db2updv97 script. I am in fp 2 and the DBA team is not going to update the fixpack in near future. Is there any place I can get the script of these SPs? My interest on these have been partly due to the sql profiler from sqltips4db2luw blog by serge.

Thanks

Arun

Can't you use view SYSIBMADM.SNAPAPPL_INFO instead ?

Trying, but thought the SPs I requested will make the job straightforward 'cos, like I said I am trying to implement the SQL profiler from the db2 blog that requires this .

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SYSPROC.MON_GET_APPLICATION_ID SP for 9.7 fp3

comp.databases.ibm-db2 comp.databases.ibm-db2

SYSPROC.MON_GET_APPLICATION_ID SP for 9.7 fp3 - 08-20-2012 , 04:22 PM

Re: SYSPROC.MON_GET_APPLICATION_ID SP for 9.7 fp3 - 08-21-2012 , 02:29 AM

Re: SYSPROC.MON_GET_APPLICATION_ID SP for 9.7 fp3 - 08-21-2012 , 08:46 AM