DB2 OPx question, additional

Joel Goldstein

DB2 OPx question, additional
Hi Max,
Just to clarify #2 below a bit for others, the system posts buffer
availability to come get the data, at a default value of 80% full.
Then it's up to the application, or monitor, to read it and perform its
functions.
The OPx buffers are not written out anyplace by DB2 itself.
So - when the application does not have adequate system priority, and cannot
get dispatched quickly enough to empty (read) the buffer
before it fills, we get buffer full, and lost data.

Regards,
Joel


----- Original Message -----
From: "Max Scarpa" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Friday, December 02, 2005 5:18 AM
Subject: Re: [DB2-L] DB2 OPx question


> Missy
>
> AFAIK:
>
> 1) DB2 writes its data in SMF or in other places according the
> specifications you give when starting a trace (stat,accounting,performance
> etc) in DEST parameter
>
> 2) There's no roll as log.You choose a buffer and data are writtenn there
> as far as the trace is active.I think buffers are rewritten when full (As
> I
> saw when playing with traces and OPx)
>
> 3) I've no answer for it. I use small buffers for my tests with REXX and
> IFCIDs.
>
> HTH
>
> Max Scarpa
>
> ---------------------------------------------------------------------------------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
> home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
> select "Join or Leave the list". The IDUG DB2-L FAQ is at
> http://www.idugdb2-l.org. The IDUG List Admins can be reached at
> [login to unmask email] Find out the latest on IDUG conferences
> at http://conferences.idug.org/index.cfm
>
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Max Scarpa

Re: DB2 OPx question, additional
(in response to Joel Goldstein)
Hi Joel

Yes that's absolutely correct as your clarification is. It's application
which have to execute READA (if async) call to unload buffers on timely
basis and to bring them to a (monitor) program.

Anyway DB2 warns that data were lost if it happened (field IFCARLC) so at
least the program can display a warning message as well.

Thank you for you clarification.

Best regards

Max Scarpa

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm