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

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


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
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
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
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
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
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
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
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
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
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
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> Mainframe Interview Questions

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 8
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
Search our Forums:

Back to Top