db2advis failed with error SQL0219N

Laxman Majji

db2advis failed with error SQL0219N

Hi All

While executing db2advis plan I got the below error.Please suggest me.

 Explain tables not set up properly for schema schemaname

The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-219]

I rerun the EXPLAIN.ddl but still same error.

Philip Gunning

db2advis failed with error SQL0219N
(in response to Laxman Majji)
Drop the old advise and explain tables and recreate with EXPLAIN.ddl. Or if you migrated and did not migrate your explain tables then you might need to migrate them. Take a look at the info center. Phil



From: Laxman Majji [mailto:[login to unmask email]
Sent: Tuesday, August 15, 2017 11:58 AM
To: [login to unmask email]
Subject: [DB2-L] - db2advis failed with error SQL0219N



Hi All

While executing db2advis plan I got the below error.Please suggest me.

Explain tables not set up properly for schema schemaname

The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-219]

I rerun the EXPLAIN.ddl but still same error.



-----End Original Message-----

Laxman Majji

db2advis failed with error SQL0219N
(in response to Philip Gunning)
Hi Phil

Thanks for your response. Dropped all explain and advis tables and
recreated them but still same error.

Thank you

Regards
Laxman

On 16-Aug-2017 1:04 AM, "Phil Gunning" <[login to unmask email]> wrote:

Drop the old advise and explain tables and recreate with EXPLAIN.ddl. Or
if you migrated and did not migrate your explain tables then you might need
to migrate them. Take a look at the info center. Phil



*From:* Laxman Majji [mailto:[login to unmask email]
*Sent:* Tuesday, August 15, 2017 11:58 AM
*To:* [login to unmask email]
*Subject:* [DB2-L] - db2advis failed with error SQL0219N



Hi All

While executing db2advis plan I got the below error.Please suggest me.

Explain tables not set up properly for schema schemaname

The insert into the ADVISE_INSTANCE table has failed.

0 solutions were evaluated by the advisor

exiting with error code [-219]

I rerun the EXPLAIN.ddl but still same error.


-----End Original Message-----

-----End Original Message-----

Greg Palgrave

RE: db2advis failed with error SQL0219N
(in response to Laxman Majji)

Make sure you have created the explain tables for the correct schema. Explain tables are specific to the schema/user.

 

I think the easiest way is to use the SYSPROC.SYSINSTALLOBJECTS procedure:

https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0011876.html

 

e.g. db2 "CALL SYSPROC.SYSINSTALLOBJECTS('EXPLAIN', 'C', 'SYSTOOLSPACE', '<myschema>')"

 

Cheers

Greg



In Reply to Laxman Majji:

Thanks for your response. Dropped all explain and advis tables and
recreated them but still same error.


Laxman Majji

db2advis failed with error SQL0219N
(in response to Greg Palgrave)
Hi Greg

Thanks. Now it's working.

Regards
Laxman

On 16-Aug-2017 6:22 AM, "Greg Palgrave" <[login to unmask email]> wrote:

> Make sure you have created the explain tables for the correct schema.
> Explain tables are specific to the schema/user.
>
>
>
> I think the easiest way is to use the SYSPROC.SYSINSTALLOBJECTS procedure:
>
> https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.
> 1.0/com.ibm.db2.luw.sql.rtn.doc/doc/r0011876.html
>
>
>
> e.g. db2 "CALL SYSPROC.SYSINSTALLOBJECTS('EXPLAIN', 'C', 'SYSTOOLSPACE', '
> ')"
>
>
>
> Cheers
>
> Greg
>
>
>
> In Reply to Laxman Majji:
>
> Thanks for your response. Dropped all explain and advis tables and
> recreated them but still same error.
>
>
>
> -----End Original Message-----
>