Hi there,

Once I tried to build an access plan for a SQL statement, it failed because the index tablespace was full. I added more space to it, and built couple of access plans successfully. But every time I connect to the database in the command center, it pops up an warning message window:

DBA2179: An access plan cannot be created because the statement you used is not in the correct format or is not a query.

How is to get rid of the warning message?

Thanks,

Go to options and un-select "build access plan." I don't have access to DB2 right now, so the exact words I used may be different.

Yeah, when you un-select "Automatically generate access plan", the warning will be gone. But when you select it again, it appears.

Thanks,