Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    61

    Unanswered: Strange problem with DB2 COmmand Center

    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,

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  3. #3
    Join Date
    Mar 2004
    Posts
    61
    Yeah, when you un-select "Automatically generate access plan", the warning will be gone. But when you select it again, it appears.

    Thanks,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •