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
 

 

Queries in IMS DC and in DBD

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
krishna_mf

New User


Joined: 31 Jan 2007
Posts: 56
Location: banglore

PostPosted: Thu Feb 08, 2007 11:09 am    Post subject: Queries in IMS DC and in DBD
Reply with quote

hi,

I am having following doubts.

Do we require DBD for running an IMS DC program?

Can we write IMS DC program without PLITDLI call?

In order to create a database is it sufficient to compile the DBD or any thing extra need to be done?

What does ACCESS= LOGICAL,DATASET LOGICAL mean in a DBD?

can any one clear my queries
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Feb 08, 2007 12:06 pm    Post subject:
Reply with quote

Do we require DBD for running an IMS DC program?
Code:

If the IMS DC program is a stand alone program with no access (READ/WRITE/UPDATE) to IMS DB then IMS DBD is not required.

If required you can code an IMS DC program to read DB2 table then you dont need DBD.

Can we write IMS DC program without PLITDLI call?
Code:

PLITDLI are API's to access IMS DB or DC, without this you can't do any IMS calls.
However if you have some thing like AIBTDLI then you dont need PLITDLI.



In order to create a database is it sufficient to compile the DBD or any thing extra need to be done?
Code:

After coding the DBD  macro, you need to do the DBD GEN (same as compile but the IMS term is DBD GEN). This DBD GEN just creates database definition.
However to use this newly created DBD definition You need to create physical datasets where the database will be stored.
In BATCH you can connect the DBD lib and physical database using logical DD names.
In Online programs a DBA or System Admin has to do the ACB GEN so that the database is available.

To use this newly created Database in a program you need to create PSB.

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 -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Need help with below queries ashek15 DB2 3 Thu Mar 23, 2017 1:38 am
No new posts Running queries against OLTP Database A_programmers DB2 3 Tue Jul 14, 2015 4:51 pm
No new posts Selective execution of a queries Delip DB2 9 Fri Jan 16, 2015 3:51 pm
No new posts Re-write queries to minimize the effe... Anil Khanna DB2 6 Mon Aug 04, 2014 1:49 pm
No new posts Running multiple queries in a PS file... nikhil_bansal04 JCL & VSAM 12 Wed Dec 18, 2013 12:06 pm


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