Hi all,

I have an input file with a single sql statement. I want to explain it.
can you please give me the command.

Is it db2expln -d (databasename) - f (inputfilename) -g ???

can i have more than one sql statement in the input file?

my environment is

AIX 5.3, DB2 8.2

Thanks,
DF

db2expln -d datbase -t -stmtfile ./y -g -terminator ";" has worked for me; I have the SQL statement, terminated by ";" in file y of current directory; you get other options in Admin Guide: Performance. I find visual explain from Control center to be very useful.

Thanks..... It worked for me.
Some how visual explain doesnt show on our control center.
Does it require a das running on the server?

Anyways, thanks a lot for the reply.

Regards,
RP

Some of the functions in the Control Center require the Administrative Server (DAS) to run on the database server.