I am using db2v8 fixpak 3 aix 5.2

I am trying to use db2expln I get error:

The result buffer was not large enough to hold the entire output.
Set the environment variable DB2EXPLN_BUFFER to at least 919739
and try the command again.

Please advise

Thanks

I have not used this parameter myself but try this from the db2 command line:

db2set DB2EXPLN_BUFFER=919739

dollar

Thank you dollar for your answer,
I did your suggestion BUT it did not work, any new idea?

Thanks

Hi M_RAS,

did you restart the instance? You can do it this way:

$ db2stop && db2start

Johann

When I tried I got error
db2set DB2EXPLN_BUFFER=919739


DBI1302E Invalid parameter detected.

Explanation:

An invalid parameter was used.

User Response:

Use the -? option for the usage help messag

do a
db2set -lr

and check if this parameter is listed and supported on your platform

Cheers
Sathyaram

I did and I could not find , our platform is aix5.2 64 bit, it means I can not run db2expln in my platform ? it does not make sence

Since db2expln is an external application and not a CLP command I assume the DB2EXPLN_BUFFER refers to an OS environment variable, not to a db2 registry variable.

Try setting the variable in the OS (like "export DB2EXPLN_BUFFER=983838383") and see if it helps.

You could also try recreating the explain table again, by running the db2-vtf $HOME/sqllib/misc/EXPLAIN.DDL maybe some of the tables are missing. I have had weird problem before when stuff was missing

Put a space around = sign...and try

db2set DB2EXPLN_BUFFER = 919739
OR
db2set DB2EXPLN_BUFFER =919739
OR
db2set DB2EXPLN_BUFFER= 919739

dollar

Can you please post a link to a document explaining the DB2EXPLN_BUFFER variable

Thanks

sathyaram

I searched a lot in www.google.com and www.ibm.com , I could not find any thing.

Thanks

It seems export DB2EXPLN_BUFFERS=999999 worked

Thank you ALL for your support