Is there any way to get an access plan for db2 stored procedure......the same way as we get the access plan for a sql query

Find its corresponding package name and run db2expln for that package.

Yes, you have to determine the package name, then run db2expln on that package.

Andy

can you give me the syntax i was not able to find one

One i tried out is
db2expln -schema SCHEMA-NAME -package PACKAGE-NAME

which ofcourse gave a syntax error

Did you try the Command Reference manual? All the manuals are downloadable for free from the IBM website.

A package contains (usually) more than a single SQL statement. That's why you should also specify the -section option.

And what exactly was the error message you got with your example? I would expect something like "database not specified" or so because you have no -d option. But that's just a guess...