Hi,

Can you please tell me how to execute EXPALIN.DDL

when I give db2> -tvf EXPLAIN.DDL
it says tvf is invalid command

when I give dbe -tvf EXPLAIN.DDL

it says db2 isinvalid
Please help

<instance-home>/sqllib/misc

Assuming you're on a unix system, just run the following on the command line:
When you're on MS-Windows, and you've opened the Command Line Processor (CLP), just type the command "quit", then (at the DOS prompt) type the above (possibly after having changed your current directory with the CD command).

thanks so much

Hi
When i execute db2 -tvf EXPLAIN.DDL I get DB21005E An error occured while accessing EXPLAIN.ddl.
Is it beacause of file permissions.How should I correct it
Thanks

Use the instance owner id to create the tables. You can also do a Visual Explain from the Control Center and the tables will be created for you automatically.

I think it's because CLP cannot find the file. Why don't you specify the full path to EXPLAIN.DDL.

Most likely the file is not in the current directory.
Use the "cd" command, as I stated in my earlier post.
Suppose the file EXPLAIN.ddl is in C:\EXPLAIN.dll
Either type the following two commands:
or just the following:

I am working in UNIX box.Tries all possible options,Still it gives the same error.I am executing the db2 -tvf Explain.ddl inthe path SQLIB/MISC where I can see EXPLAIN.DDL

That will never work, certainly not on a unix system.
Try to change that to(File names are case sensitive on UNIX.)