which is why I always test hints with SPUFI - it will give you the reason code.
I don't know a better way to test the hint unless you have a product. Mike On Mon, Jun 24, 2013 at 9:55 AM, Lizette Koehler <stars...@mindspring.com>wrote: > Did you check out Mike Bell's Presentation from 2008? > > http://www.hlstechnologies.com/downloads/IDUGDallas.pdf > > Or this link? http://theamericanprogrammer.com/programming/sqlcodes.shtml > > I am not sure if this applies, but what about > warning: user specified optimization hints are invalid (reason code = ''). > the optimization hints are ignored > > > Lizette > > > -----Original Message----- > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On > Behalf Of Hunkeler, Peter (TLSG 4) > Sent: Monday, June 24, 2013 7:45 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Slightly OT: How to interpret this DB2 message > > I know this is not a DB2 list, but I'm hoping someone here can give me a > hint. > > We're trying to BIND wiht OPTHINT but DB2 refuses to use the hint with the > following msg: > > DSNX105I -DAF2 BIND SQL WARNING > USING S100447 AUTHORITY > PLAN=(NOT APPLICABLE) > DBRM=A5PO356 > STATEMENT=16423 > SQLCODE=395 > SQLSTATE=01628 > TOKENS=32 > > Explanation of SQL code +395 list a number of Reason Codes, but what in the > above message is the reason code? > Is it "TOKENS="? if so, 32 means "CREATOR or TNAME is invalid." but that > does not help me, since Owner and TNAME seem to be reasonable values. > > Any issue when the SQL in the program is using a table name that actually > is > a synonym to the real table name? Which name would have to be in the > PLAB_TABLE in this case: real table or synonym? > > -- > Peter Hunkeler > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, send email > to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- Mike ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
