IMS and DB2 in the same program......

Ask question on - DataBase Concepts, IBM Mainframe DB2, DB2/UDB, DB2 Tools, SQL , DB2 programming with languages like COBOL, PL1.

Moderators: Kalicharan, Moderator Group

Post Reply
bbersani
Member
Posts: 1
Joined: Fri Apr 14, 2006 12:08 am

IMS and DB2 in the same program......

Post by bbersani » Fri Apr 14, 2006 12:13 am

Does anyone out there know how to set up the JCL to run a program that contains both IMS and DB2 statements? There MUST be a way!!

User avatar
arrbee
Active Member
Posts: 144
Joined: Fri Feb 24, 2006 11:33 am

Post by arrbee » Fri Apr 14, 2006 8:01 am

You need to use DFSRRC00 utility for IMS/DB - DB2 program.

Code: Select all

//XX050    EXEC PGM=DFSRRC00,
//             PARM=(BMP,                                         
//             XXXXX400,        PROGRAM NAME                      
//             XXXXX400,        PSB NAME                          
//             ,                TRANSACTION IN NAME               
//             ,                TRANSACTION OUT NAME              
//             X00000,          CNTL PGM OPT,SPIE,TEST ADD,DIRCA  
//             ,                PRELOAD OPTION                    
//             1,               TIMER                             
//             ,                PUT THE CHECKPOINT ID ON THIS LINE
//             ,                PARALLEL OPERATION                
//             ,                CPU TIME                          
//             ,                FAST PATH DATABASES               
//             ,                FAST PATH PAGE-FIXED BUFFERS      
//             XXX2,            SYSTEM ID                         
//             XXXXXX1,         APPLICATION GROUP NAME            
//             DXXX)            DB2 REGION                        
HTH.
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)

cartigaELangovan
Member
Posts: 3
Joined: Wed Nov 12, 2008 10:58 am
Location: chennai

Post by cartigaELangovan » Tue Nov 18, 2008 11:27 am

Hi,

Can anybody point out some of the differences between IMS and DB2. Also code if anything special about IMS that mainframes miss because of IMS elimination,..?


Thanks,
Cartiga

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Sun Nov 23, 2008 4:32 am

Hi,
cartigaELangovan wrote:Can anybody point out some of the differences between IMS and DB2.
IMS is an Hirercical Database while on the other hand DB2 is a relational Database. This is on very high level basic deference between them - if you are looking for something specific you need to tell us that specific question.

Also code if anything special about IMS that mainframes miss because of IMS elimination,..?
Sorry not trying to sound rude but I didn't get any meaning out of this, please start over & reframe your question, Thanks.
Last edited by Anuj Dhawan on Wed Nov 26, 2008 3:19 am, edited 1 time in total.
Regards,
Anuj

cartigaELangovan
Member
Posts: 3
Joined: Wed Nov 12, 2008 10:58 am
Location: chennai

Post by cartigaELangovan » Tue Nov 25, 2008 2:57 pm

Hi Anuj,
Sorry for my unclear question. Can you please explain about the DB2 PLAN?


Thanks,
Cartiga

User avatar
Vamsi99
Active Member
Posts: 183
Joined: Wed Nov 05, 2008 11:20 am

DB2 Plan

Post by Vamsi99 » Tue Nov 25, 2008 4:44 pm

Hi Cartiga,

Please start a new topic in DB2 forum. This is a JCL forum.
It will be helpful, if we start a new topic for each question.

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed Nov 26, 2008 3:21 am

Hi Cartiga,

you are getting into DB2 related details, I would suggest to follow the post from Vamsi99, Thanks.
Regards,
Anuj

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others