QZDASOINIT and monitoring performance

All ~

Am running an application that uses the java-jt400.jar driver; When the app 
connects to the iSeriesV5R3-OS/400 it creates a QZDASOINIT job. My aim is to 
optimize performance of the application (find bad queries, see whats the 
application doing at runtime, capture most used SQL, etc).

In other environments this is commonly called as "Profiling", where we
get 
the connection-id or IP address of the User and run a trace on it.

One of my problems is when one does a wrkactjob job(qzd*) their are more 
than a dozen of these running; their is no easy way for me to identify which 
one belongs to me.

Posting into this newsgroup hoping to get some direction on how-to optimize 
performance, are their any tools that IBM provides to help the developer?

Thanks 

Some minor help, perhaps.

iSeries Navigator, which comes with iSeries Access (formerly called Client 
Access) has some good profiling tools.

If I need to find which service jobs I'm using from a client application, I 
do WRKOBJLCK userid *USRPRF to trim the number of jobs that I have to 
investigate.

Sam

"Robert" <robert@_No_Spam.Com> wrote in message 
news:fktvr7$1ig46$1@news.boulder.ibm.com...
> All ~
>
> Am running an application that uses the java-jt400.jar driver; When the 
> app connects to the iSeriesV5R3-OS/400 it creates a QZDASOINIT job. My aim

> is to optimize performance of the application (find bad queries, see whats

> the application doing at runtime, capture most used SQL, etc).
>
> In other environments this is commonly called as "Profiling",
where we get 
> the connection-id or IP address of the User and run a trace on it.
>
> One of my problems is when one does a wrkactjob job(qzd*) their are more 
> than a dozen of these running; their is no easy way for me to identify 
> which one belongs to me.
>
> Posting into this newsgroup hoping to get some direction on how-to 
> optimize performance, are their any tools that IBM provides to help the 
> developer?
>
> Thanks
> 

What release are you on?  There were some new filters added to the Database 
Monitor utility in V5R4, they are discussed in this redbook:

http://publib-b.boulder.ibm.com/Redbooks.nsf/RedPieceAbstracts/sg247326.html?

Saml wrote:
> Some minor help, perhaps.
> 
> iSeries Navigator, which comes with iSeries Access (formerly called Client

> Access) has some good profiling tools.
> 
> If I need to find which service jobs I'm using from a client application, I

> do WRKOBJLCK userid *USRPRF to trim the number of jobs that I have to 
> investigate.
> 
> Sam
> 
> "Robert" <robert@_No_Spam.Com> wrote in message 
> news:fktvr7$1ig46$1@news.boulder.ibm.com...
>> All ~
>>
>> Am running an application that uses the java-jt400.jar driver; When the

>> app connects to the iSeriesV5R3-OS/400 it creates a QZDASOINIT job. My
aim 
>> is to optimize performance of the application (find bad queries, see
whats 
>> the application doing at runtime, capture most used SQL, etc).
>>
>> In other environments this is commonly called as "Profiling",
where we get 
>> the connection-id or IP address of the User and run a trace on it.
>>
>> One of my problems is when one does a wrkactjob job(qzd*) their are
more 
>> than a dozen of these running; their is no easy way for me to identify

>> which one belongs to me.
>>
>> Posting into this newsgroup hoping to get some direction on how-to 
>> optimize performance, are their any tools that IBM provides to help the

>> developer?
>>
>> Thanks
>>
> 

Robert if you do not mind a green screen tool have a look at my 
WRKODBCJOB command:

http://home.columbus.rr.com/jbmmdietz/wrkodbcjob.html

Bryan



Robert said the following on 12/26/2007 11:34 AM:
> All ~
> 
> Am running an application that uses the java-jt400.jar driver; When the app

> connects to the iSeriesV5R3-OS/400 it creates a QZDASOINIT job. My aim is
to 
> optimize performance of the application (find bad queries, see whats the 
> application doing at runtime, capture most used SQL, etc).
> 
> In other environments this is commonly called as "Profiling",
where we get 
> the connection-id or IP address of the User and run a trace on it.
> 
> One of my problems is when one does a wrkactjob job(qzd*) their are more 
> than a dozen of these running; their is no easy way for me to identify
which 
> one belongs to me.
> 
> Posting into this newsgroup hoping to get some direction on how-to optimize

> performance, are their any tools that IBM provides to help the developer?
> 
> Thanks 
>