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

interview ques based on SOC7 and Substem down in DB2


IBM Mainframe Forums -> Mainframe Interview Questions
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 62
Location: Boston

PostPosted: Mon Mar 01, 2010 4:25 pm
Reply with quote

I have attened the interview i get stuckup to answer the below questions.

1) Let me give the Scenario You get SOC7 error. You know the variable which is causing the SOC7 error and also you know in which part of move statement. You need to process millions of records how to narrow down which specific record is causing the SOC7 problem.

I told to create a log file for the processing records. From that we can identify the records.i think they are not satisfied.

2) If the DB2 Subsystem is Down due to maintance work and we are trying to excute the DB2 program what type of error you are expecting.

I told Resource not available (-904). he said it is wrong

3) in Cobol prog the output file has LRECL as 3000 .what will be LREC in JCL if the record format is FB/VB


i told for FB = 3000
for VB = 2996

Can some one help to let me know the answers.
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 62
Location: Boston

PostPosted: Mon Mar 01, 2010 11:02 pm
Reply with quote

for second question the answer is
-923 CONNECTION NOT ESTABLISHED: DB2 condition REASON reason-code, TYPE resource-type, NAME resource-name

Can any one confirm me that this is correct
Back to top
View user's profile Send private message
CICS Guy

Senior Member


Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table

PostPosted: Mon Mar 01, 2010 11:49 pm
Reply with quote

Karthikeyan Subbarayan wrote:
1) Let me give the Scenario You get SOC7 error. You know the variable which is causing the SOC7 error and also you know in which part of move statement. You need to process millions of records how to narrow down which specific record is causing the SOC7 problem.

I told to create a log file for the processing records. From that we can identify the records.i think they are not satisfied.
Wouldn't it be a lot quicker and easier to just read the dump for the source of the S0C7?
Quote:
3) in Cobol prog the output file has LRECL as 3000 .what will be LREC in JCL if the record format is FB/VB

i told for FB = 3000
for VB = 2996
Wouldn't that be 3000 & 3004?
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 62
Location: Boston

PostPosted: Tue Mar 02, 2010 12:23 am
Reply with quote

Thanks for the reply

but for Quest 1..... In dump, where exactly I can locate the record that causes the soc7 .......... i reprhase the question ..where to locate the Source of the S0C7
Back to top
View user's profile Send private message
technut

New User


Joined: 27 Dec 2007
Posts: 73
Location: India

PostPosted: Wed Mar 03, 2010 10:46 am
Reply with quote

You have abend aid in your shop? You wrote that in your resume?
If yes, It shows the current record in error and the previous record.. From there you skip all the millions of records until the current record using a simple SORT and you arrive at the abend record.
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 62
Location: Boston

PostPosted: Wed Mar 03, 2010 2:28 pm
Reply with quote

thanks a lot Technut iam clear now
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Wed Mar 03, 2010 9:39 pm
Reply with quote

Karthikeyan Subbarayan wrote:
3) in Cobol prog the output file has LRECL as 3000 .what will be LREC in JCL if the record format is FB/VB


i told for FB = 3000
for VB = 2996

Can some one help to let me know the answers.
VB files have 4-byte long RDW (Record Descriptor Word) - so you need to add it to LRECL, you don't subtract it...so for VB it should be 3004, as CG has said.
Back to top
View user's profile Send private message
Karthikeyan Subbarayan

New User


Joined: 24 Feb 2008
Posts: 62
Location: Boston

PostPosted: Wed Mar 03, 2010 10:16 pm
Reply with quote

Anuj,

thanks but i get Cleared already ........... icon_cool.gif
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 To search DB2 table based on Conditio... DB2 1
This topic is locked: you cannot edit posts or make replies. Merge 2 input files based on the reco... JCL & VSAM 2
No new posts Split large FB file based on Key coun... DFSORT/ICETOOL 4
No new posts Mass JCL release via IDZ tool(eclipse... CA Products 1
No new posts Merge 2 lines based on Space from a S... DFSORT/ICETOOL 5
Search our Forums:

Back to Top