View previous topic :: View next topic
|
Author |
Message |
balubhat
New User
Joined: 04 Oct 2005 Posts: 19 Location: Singapore
|
|
|
|
Hii Friends
I need some information on DB2 BIND.
What is the output of DB2 BIND? For COBOL program, the output of compilation is the Load module which are stored in the PDS. Similarly, when we BIND the Plan it creates executable code for the SQL thru the DBRM and using the DB2 optimizer to create the optimal access path to execute that query. So where these executable instructions are stored?
Can we see these executable instructions just like Cobol load module?
Please let me know if anybody know the answer.
Thanks
Bala |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi balubhat
The output of BIND , the Plan, is stored in the DB2 Directory.
DSNDB01 is the default DB2 Directory name and that can not queried or opened like any other database or datasets.
Hope this will help you
Regards
Raghu |
|
Back to top |
|
|
Srihari Gonugunta
Active User
Joined: 14 Sep 2007 Posts: 295 Location: Singapore
|
|
|
|
Bala,
You can refer to SYSIBM.SYSPACKSTMT table. |
|
Back to top |
|
|
Keanehelp
New User
Joined: 27 May 2008 Posts: 71 Location: USA, CA.
|
|
|
|
HI Bala,
Probably you can also try SYSIBM.SYSPLANS table.
Thanks |
|
Back to top |
|
|
Terry Heinze
JCL Moderator
Joined: 14 Jul 2008 Posts: 1249 Location: Richfield, MN, USA
|
|
|
|
Quote: |
So where these executable instructions are stored?
Can we see these executable instructions just like Cobol load module? |
The executable instructions are in the load module. Look at your source listing output of the compiler and you'll see that the SQL has been commented and replaced by COBOL verbs and CALL statements which are in your load module. |
|
Back to top |
|
|
|