Hi,

I am trying to generate explain plan using db2exfmt:I get below error when I execute the command:

db2exfmt -d $dbname -e IDM_DEV -s $schema -w -1 -n $pkgname -g TIC -# 0 -o $procedure.exp -u cc uu

error:
No Explain instances (plans) were found for database X, source pattern: P2490890 for explain table schema "Y".

Please help
Thanks