Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Query on DB2 BIND

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
balubhat

New User


Joined: 04 Oct 2005
Posts: 19
Location: Singapore

PostPosted: Tue Sep 15, 2009 3:29 pm    Post subject: Query on DB2 BIND
Reply with quote

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
View user's profile Send private message

Raghu navaikulam

Active User


Joined: 27 Sep 2008
Posts: 186
Location: chennai

PostPosted: Tue Sep 15, 2009 4:14 pm    Post subject: Reply to: Query on DB2 BIND
Reply with quote

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
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Tue Sep 15, 2009 4:14 pm    Post subject:
Reply with quote

Bala,
You can refer to SYSIBM.SYSPACKSTMT table.
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Tue Sep 15, 2009 4:16 pm    Post subject:
Reply with quote

HI Bala,

Probably you can also try SYSIBM.SYSPLANS table.

Thanks
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Tue Sep 15, 2009 9:41 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Omegamon for DB2 query ashek15 DB2 0 Wed Feb 15, 2017 11:25 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us