Accessing IMS/DB with batch job and control cards



IBM's hierarchical database management system with a Database Manager (IMS DB) and a Transaction Manager(IMS DC)

Accessing IMS/DB with batch job and control cards

Postby Mike1304 » Wed Mar 30, 2011 11:46 pm

Hi,

I'm looking for utility to access IMS/DB databases with different types of calls (GU, GN..).
I do not want to write a program myself, but use input cards to decide which DBD and which access should be done.

I think there is a utility which sounds like [diddledoo], but I do not remember how it is spelled.

best regards
Mike
Mike1304
 
Posts: 36
Joined: Mon Feb 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Accessing IMS/DB with batch job and control cards

 

Re: Accessing IMS/DB with batch job and control cards

Postby Mike1304 » Thu Mar 31, 2011 12:42 am

found it!
DDLT0 or exact DFSDDLT0
Mike1304
 
Posts: 36
Joined: Mon Feb 28, 2011 4:14 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Accessing IMS/DB with batch job and control cards

Postby DFSHDC40 » Thu Mar 31, 2011 3:38 am

to know it is to lose hair :o)
If the code hasn't been changed, why is the LKED date today?
User avatar
DFSHDC40
 
Posts: 41
Joined: Sat Oct 16, 2010 4:16 pm
Location: IMS.SDFSRESL
Has thanked: 0 time
Been thanked: 0 time

Re: Accessing IMS/DB with batch job and control cards

Postby Ed Goodman » Thu Jun 16, 2011 12:23 am

I like the "diddle-do" name better!
Please be careful with DLT0, it's nothing more than a program that makes IMS calls. So it can destroy something just as quickly as a COBOL program can. If you're doing any sort of quantity updates, you have to mind your log file and do checkpoints, just like a program.

We use it to delete segments and such, but for extracting data, it's kind useless because of the format of the output.

I use it mostly to test theories about how pointers and indexes work. It's very simple to set up the retrieval calls in the order you want.
Ed Goodman
 
Posts: 341
Joined: Thu Feb 24, 2011 12:05 am
Has thanked: 3 times
Been thanked: 17 times

Re: Accessing IMS/DB with batch job and control cards

Postby Alison Oliveira » Mon Jan 23, 2012 5:55 pm

This "DFSDDLT0" is a standard IMS program to create or reload or download an IMS-DB??
Could you explain to me???

Thankss for help
Alison Oliveira
 
Posts: 37
Joined: Fri Jan 20, 2012 9:08 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Accessing IMS/DB with batch job and control cards

Postby Ed Goodman » Mon Jan 23, 2012 8:44 pm

Yes, it's a supplied program that come with IMS. You run it like this:
//JS010  EXEC  PGM=DFSRRC00,                                       
//       PARM=(DLI,DFSDDLT0,GWP013,007,0000,,0,,N,0,T,,,Y,Y,IRLE,Y)


The second parm is a PSB that has what you need in it.

The parm cards look like:

//*-+----1----+----2----+----3----+----4----+----5----+----6--   
S 1 1 1 1 1    WGDB03PC                                         
L        GU    GS03INDV*---(RECIP   EQ «)                   


The S command picks a PCB to work with, along with some options.
The L commands are the DL/I calls

The whole thing is covered in the "Application Programming: Database Manager" book, in a chapter called "DL/I Test Program (DFSDDLT0)"
Ed Goodman
 
Posts: 341
Joined: Thu Feb 24, 2011 12:05 am
Has thanked: 3 times
Been thanked: 17 times

Re: Accessing IMS/DB with batch job and control cards

Postby Alison Oliveira » Mon Jan 23, 2012 8:55 pm

Thanks a lot man... but i don´t understand about this "parm card"...

I see this in others manuals and i keep confused...

What about this cards??? Why i need it?? What is it for???
Alison Oliveira
 
Posts: 37
Joined: Fri Jan 20, 2012 9:08 pm
Has thanked: 0 time
Been thanked: 0 time


Return to IMS DB/DC

 


  • Related topics
    Replies
    Views
    Last post