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: 1239
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 Join in SQL Query vickey_dw DB2 2 Tue Jan 17, 2017 12:15 am
This topic is locked: you cannot edit posts or make replies. MQ setup query mohitsaini Java & MQSeries 4 Sun Jan 08, 2017 1:53 am
No new posts DB2 query Using Recursion, Converting... smilewithashu2 DB2 1 Tue Jan 03, 2017 12:50 pm
No new posts SQL query to run through list of valu... Ni3-db2 DB2 14 Wed Dec 14, 2016 9:52 am
This topic is locked: you cannot edit posts or make replies. Db2 SQL query to convert rows into co... subratarec DB2 5 Thu Nov 17, 2016 4:51 pm


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