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
 

 

[Solved]If a VSAM file is opened that is not loaded what will happen

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
induajayrose
Warnings : 2

New User


Joined: 25 Jul 2005
Posts: 28
Location: Thrissur

PostPosted: Mon Aug 08, 2005 5:33 pm    Post subject: If a VSAM file is opened that is not loaded what will happen
Reply with quote

hi friends,
can anyone provide answers to these questions...

1. If a VSAM file is opened that is not loaded what will happen?
2. What are the different types of files (not in the case of VSAM)?
3. What are the abend codes we usually find in cases of DB2 and CICS?

indu
Back to top
View user's profile Send private message

Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Tue Aug 09, 2005 2:20 pm    Post subject: Re: Some interview questions
Reply with quote

1)we cannot open a Vsam thats not loaded

2)files means question not clear
files available r QSAM
BDAM
etc....................

3)DB2 common abend codes are
-818
-802
-504
+100
-812
Cics the codes are
APCT
Aey9
ASRA
AEI0
Back to top
View user's profile Send private message
induajayrose
Warnings : 2

New User


Joined: 25 Jul 2005
Posts: 28
Location: Thrissur

PostPosted: Tue Aug 09, 2005 2:33 pm    Post subject:
Reply with quote

hai,
my intervwr said dat it is possible to open a vsam file which is not loaded.are u sure it is not possible.
Thank you 4 ur kind reply prasanth.Can u tell me when APCT,AEY9,ASRA abend codes are coming.
regards indu
Back to top
View user's profile Send private message
raghs_sir

New User


Joined: 19 Jul 2005
Posts: 9
Location: Chennai

PostPosted: Tue Aug 09, 2005 6:55 pm    Post subject: it does not get open
Reply with quote

hi,
u try to open a file which's not loaded....file status code will be 35.
U can check in ur program if file-status = 35
after open statement.

Also,...U've loaded 20 records and after that deleted all 20,
Then it won't give file-status = 35, the system will open that file...
But when u'll try to read, file-status = 10 (END-OF-FILE) will be set...


Do correct me if i'm wrong.
regards,
Raghs.
Back to top
View user's profile Send private message
mmwife

Super Moderator


Joined: 30 May 2003
Posts: 1592

PostPosted: Wed Aug 10, 2005 8:09 am    Post subject:
Reply with quote

To load a VSAM file you have to open it.

What you mean is that you can't open an unloaded VSAM file for INPUT or I-O.

If you define the file as ACCESS SEQ or DYNAM, then open the file for OUTPUT and WRITE to it, you are loading the file.
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Aug 10, 2005 4:22 pm    Post subject: Re: Some interview questions
Reply with quote

Hi Indu

APCT

Explanation: One of the following has occurred:

1. The program name in the EXEC CICS HANDLE ABEND program is not usable at the time an abend occurs because:
.

2. An attempt to load a mapset or partitionset failed because although
the program is defined to CICS

3. An attempt to link to, load, or release an internal CICS program
failed because:

4 Also verify whether the if you declared program in the PPT or not.
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Aug 10, 2005 4:26 pm    Post subject: Re: Some interview questions
Reply with quote

ASRA abend occurs after a VS COBOL II subroutine (called
by CICS LINK) returns control to the VS COBOL II calling
program.

Or it can be any
Any data exception problem SOC7, SOC4 etc


AEY9

DB2/IDMS not up.
Back to top
View user's profile Send private message
induajayrose
Warnings : 2

New User


Joined: 25 Jul 2005
Posts: 28
Location: Thrissur

PostPosted: Wed Aug 10, 2005 7:34 pm    Post subject:
Reply with quote

hi,
thank u all 4 ur kind reply....
indu
Back to top
View user's profile Send private message
deepak.venkataraman

New User


Joined: 07 Sep 2005
Posts: 8
Location: Bangalore

PostPosted: Wed Sep 07, 2005 11:32 am    Post subject: we can open the vsam file without loading data into it
Reply with quote

hi indu,
normally in vsam if u attempt to open a file without data it will cause vsam open error but at the same time we can open the file in output mode...so at that time it will create a dummy record..and after closing the file it will delete that dummy record. This is called as initialization of vsam file.
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


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