db2 for z/OS R11 NFM - question on apcompare (error)

Chris Hoelscher

db2 for z/OS R11 NFM - question on apcompare (error)
When rebinding packages I get the following


DSNT285I *DBT3 DSNTBBP2 REBIND FOR PACKAGE =
DBT3.collid.package,
USE OF APCOMPARE RESULTS IN:
7 STATEMENTS WHERE COMPARISON IS SUCCESSFUL
0 STATEMENTS WHERE COMPARISON IS NOT SUCCESSFUL
9 STATEMENTS WHERE COMPARISON COULD NOT BE PERFORMED.

I interpret this as

7 statements where there were NO access path changes
0 statements where there WERE access path statements
9 statements where before/after could not be compared

My question is WHY the comparison could not be performed fo0r those 9?

If the package was last bound prior to R9, I would think NONE of the statements would be eligible

Any insight or guidance will be greatly appreciated!!




Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.
Attachments

  • image001.jpg (<1k)

Venkat Srinivasan

RE: db2 for z/OS R11 NFM - question on apcompare (error)
(in response to Chris Hoelscher)

Is there anything in plan table remarks? What kind of statements are they.

Venkat

In Reply to Chris Hoelscher:

When rebinding packages I get the following


DSNT285I *DBT3 DSNTBBP2 REBIND FOR PACKAGE =
DBT3.collid.package,
USE OF APCOMPARE RESULTS IN:
7 STATEMENTS WHERE COMPARISON IS SUCCESSFUL
0 STATEMENTS WHERE COMPARISON IS NOT SUCCESSFUL
9 STATEMENTS WHERE COMPARISON COULD NOT BE PERFORMED.

I interpret this as

7 statements where there were NO access path changes
0 statements where there WERE access path statements
9 statements where before/after could not be compared

My question is WHY the comparison could not be performed fo0r those 9?

If the package was last bound prior to R9, I would think NONE of the statements would be eligible

Any insight or guidance will be greatly appreciated!!




Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.

Terry Purcell

RE: db2 for z/OS R11 NFM - question on apcompare (error)
(in response to Chris Hoelscher)

Take a look at SYSPACKSTMT.STATUS column - if the value for statements in that package is <> 'C' - then that could be your reason. Typically statements are counted here if these aren't "explainable" statements, or VALIDATE(RUN) is used, or if DB2 cannot find the prior statement (for example, if this is a BIND rather than REBIND and new statements exist in the program).

Regards

Terry Purcell

In Reply to Chris Hoelscher:

When rebinding packages I get the following


DSNT285I *DBT3 DSNTBBP2 REBIND FOR PACKAGE =
DBT3.collid.package,
USE OF APCOMPARE RESULTS IN:
7 STATEMENTS WHERE COMPARISON IS SUCCESSFUL
0 STATEMENTS WHERE COMPARISON IS NOT SUCCESSFUL
9 STATEMENTS WHERE COMPARISON COULD NOT BE PERFORMED.

I interpret this as

7 statements where there were NO access path changes
0 statements where there WERE access path statements
9 statements where before/after could not be compared

My question is WHY the comparison could not be performed fo0r those 9?

If the package was last bound prior to R9, I would think NONE of the statements would be eligible

Any insight or guidance will be greatly appreciated!!




Chris Hoelscher
Technology Architect, Database Infrastructure Services
Technology Solution Services
[Description: Description: cid:[login to unmask email]
123 East Main Street
Louisville, KY 40202
Humana.com
(502) 476-2538 or 407-7266


The information transmitted is intended only for the person or entity to which it is addressed
and may contain CONFIDENTIAL material. If you receive this material/information in error,
please contact the sender and delete or destroy the material/information.