IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Sequential files in an IMS DC program


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
silpa_nakada1

New User


Joined: 27 Feb 2008
Posts: 2
Location: karnataka

PostPosted: Thu Feb 28, 2008 5:49 pm
Reply with quote

Hi,

I have an IMS DC program which uses some sequential files(declared in the file control section). I'm not able to find the physical file names. PFB, the piece of code,
FILE-CONTROL.
SELECT IS01 ASSIGN TO UT-S-K211JUN.
SELECT IS02 ASSIGN TO UT-S-TABJCL01.
SELECT OS01 ASSIGN TO UT-S-INTRDR.
Could anyone please point out how to find the files and how sequential files are accessed in an online program.

Thanks and Regards
silpa
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Feb 28, 2008 6:42 pm
Reply with quote

Sorry, but this must not be an IMS DC program. There is no JCL - your program is defined in the IMS region. Your databases are defined in your PSB. Display the PSB and look at the type.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Thu Feb 28, 2008 6:56 pm
Reply with quote

Try to see the online region job.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Thu Feb 28, 2008 7:12 pm
Reply with quote

hi silpa_nakada1

In IMS-DC environment(IMS online PGM) you cannot handle PS files...you will have to use GSAM files or DB-2 or any other database instead of PS files.....
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Thu Feb 28, 2008 7:52 pm
Reply with quote

A BMP program runs with the databases up - online and available and uses JCL to execute. A DLI runs with the databases dow - offline and uses JCL to execute. A DC program is executed via an IMS online transaction with the databases up - it uses MFS screens.
Back to top
View user's profile Send private message
silpa_nakada1

New User


Joined: 27 Feb 2008
Posts: 2
Location: karnataka

PostPosted: Fri Feb 29, 2008 9:44 am
Reply with quote

Hi all,
Thanks for the input.

I have found 1 file (IS01) by trial and hit, and this file is of sequential organization. I tried to relate this with the PSB given, but didn't get any clue. So still I'm not very sure how its related to the program.

I think checking the online job log is a possibility. Could you please let me know, where we can check the online job log.



Note: The PSB definition is just as below
PRINT NOGEN
SYSPCB
PSBGEN PSBNAME=tran1,LANG=COBOL
END
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Fri Feb 29, 2008 9:51 am
Reply with quote

silpa_nakada1
Quote:
FILE-CONTROL.
SELECT IS01 ASSIGN TO UT-S-K211JUN.
SELECT IS02 ASSIGN TO UT-S-TABJCL01.
SELECT OS01 ASSIGN TO UT-S-INTRDR.
Can I know based on what information you are saying that this is IMS DC online program?
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Fri Feb 29, 2008 3:45 pm
Reply with quote

rajatbagga wrote:
hi silpa_nakada1

In IMS-DC environment(IMS online PGM) you cannot handle PS files...you will have to use GSAM files or DB-2 or any other database instead of PS files.....


GSAM is for BMP's not for MPP's.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Feb 29, 2008 4:40 pm
Reply with quote

Quote:
I think checking the online job log is a possibility. Could you please let me know, where we can check the online job log.

Why don't you try scanning your JCL library for that program name?
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Feb 29, 2008 8:22 pm
Reply with quote

I think there may be a misunderstanding - if you scan the JCL libs for that program name and it is FOUND, then it is NOT online DC. If it is found - then look at the exec statement to see if it is BMP or DLI.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Fri Feb 29, 2008 8:26 pm
Reply with quote

Quote:
I think checking the online job log is a possibility. Could you please let me know, where we can check the online job log.


Sandy suggested......: Why don't you try scanning your JCL library for that program name?

This is how the quote was meant to be. If the programname is found in one of the JCL-libraries it's either DLI or BMP but not MPP.

Sorry for my misunderstanding icon_redface.gif
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Fri Feb 29, 2008 8:29 pm
Reply with quote

Hey George icon_wink.gif

Another suggestion is to search for those files - is there a file cross reference report?

Please don't tell us that this is a NEW program and someone told you that you could create sequential files in an MPP?????
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Fri Feb 29, 2008 8:47 pm
Reply with quote

CICS??????
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Sat Mar 01, 2008 6:21 pm
Reply with quote

Bitneuker wrote:
[
GSAM is for BMP's not for MPP's.


Hi Bitneuker,

Are you sure that GSAM is not for MPP because I heard that GSAM files can be used with MPP... please correct me if i am wrong...
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Sat Mar 01, 2008 7:04 pm
Reply with quote

Go here: publib.boulder.ibm.com/infocenter/radhelp/v6r0m1/index.jsp?topic=/com.ibm.etools.egl.doc/topics/ceglasm0450.html

and look for IMS runtime support

Here is another link that is interesting:
myweb.tiscali.co.uk/lightsol/IMS_Programming.pdf
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Sat Mar 01, 2008 8:48 pm
Reply with quote

In addition to Sandy;

Quote:
Processing GSAM databases
GSAM databases are available to application programs that can run as batch programs, batch-oriented BMPs, transaction-oriented BMPs or JBPs


JBP is for Java.

Follow the sticky where to find info about IMS and search for GSAM; you would have found the quote. In fact you should have explored in advance before asking your question. Please do so next time and also search the forum; you're not the first asking this.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Mon Mar 03, 2008 9:44 am
Reply with quote

hello..

I checked in the forum today and in that sandy only said:

Sandy Zimmer wrote:

YEP - you can use GSAM for MPP - I have done it.....


please refer to the link below:
http://ibmmainframes.com/about23389.html

So what should I infer now.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Mar 03, 2008 5:16 pm
Reply with quote

You can - I have, BUT - remember that it would be a "write (insert) only" situation. GSAM has no index - it is a sequential file defined to IMS. So, you could not access it in subsequent programs. Unless it is some sort of "audit" file.

If you want to be able to access online, the best choice would be HDAM.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Mar 03, 2008 7:16 pm
Reply with quote

Let's talk about the "why" anyone would want a GSAM file in an MPP program. IMS may let you do it, but it defeats the purpose of an online interactive program. Remember you are sitting there communicating with the system. If you are trying to retrieve information from a GSAM file, you would defeat the purpose. GSAM files have no keys - the only way to read one is to do "gets" which would be horribly inefficent. They are root only because they have no keys. As I said in my last post, the ONLY reason would be for an audit trail - the situation in which I used GSAM was a very special situation.

Your best option is HDAM - especially if most of your processing against this database is online. It is keyed, but does not carry a separate sequential index as HIDAM does.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Mon Mar 03, 2008 9:06 pm
Reply with quote

Waoo...

Thanks for this usefull information Sandy I got your point.
Back to top
View user's profile Send private message
rajatbagga

Active User


Joined: 11 Mar 2007
Posts: 199
Location: india

PostPosted: Mon Mar 03, 2008 9:14 pm
Reply with quote

And Now I remember even I had used GSAM file in MPP for testing purpose. I wanted to test my online program and there I used GSAM to write only as I was not having any other option at that time...

Anyways thank you very much for this detailed information on usage of GSAM with MPP.
Back to top
View user's profile Send private message
Bitneuker

CICS Moderator


Joined: 07 Nov 2005
Posts: 1104
Location: The Netherlands at Hole 19

PostPosted: Wed Mar 05, 2008 12:52 am
Reply with quote

I'm afraid you mistake a message driven BMP for an MPP.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
Search our Forums:

Back to Top