A correction to my previous posts. SYSCAT.COLDIST contents is not important here. I got the same warning, for example, on a simple query like: "SELECT * FROM MYSCHEMA.MYTAB WHERE IDX COL=?" after manual column statistics update: "UPDATE SYSSTAT.COLUMNS SET COLCARD=-1 WHERE (TABSCHEMA, TABNAME,...
Mark, It appears that last INNER JOIN with table PNET.CR RND on column CR RND ID appears to be expecting column distribution data - which apparently are missing...
The IBM API Connect API Agent just became even more powerful with the addition of MCP server support in the v12.1.0 release. This enables you to configure and use custom or third-party MCP servers directly within your API Agent. With this new capability, you can seamlessly interact with...
Thank you Kurt! That was our problem.
Hi Mark, The bottom line of my question is: The optimizer (not db2exfmt - it's just an access plan formatter of some existing plan) executes SELECT * FROM SYSCAT.COLDIST WHERE (TABSHEMA, TABNAME, COLNAME) = ('PNET', 'CR RND', 'CR RND ID') when it decides, that it needs the CR RND ID column...
Thanks, Tarcio. I reinstalled IBM MQ twice following that guide. On our machine, step 4 fails: Executing runmqsc -u 'Magadmin' RPASYSTEM the command fails! (The quotes are necessary because the IBM RPA command cannot interpret lowercase usernames.) Executing: runmqsc RPASYSTEM Using the current...
Hi Mark, Would it be possible to get db2look outout for this cse (in mimic mode) - for participating tables? I would like to play with this scenario...
Is there a way to generate a QNaN in IBM PL/I? This is usually accomplished by dividing (0.0 / 0.0),but that results in an INVALIDOP condition in PL/I (either at compile-time or run-time.) I see the general testing builtins (ISNAN, ISFINITE, ISNORMAL, etc..) but can't find an easy way to...