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
 

 

interview ques based on SOC7 and Substem down in DB2

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

New User


Joined: 24 Feb 2008
Posts: 56
Location: Boston

PostPosted: Mon Mar 01, 2010 4:25 pm    Post subject: interview ques based on SOC7 and Substem down in DB2
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: 56
Location: Boston

PostPosted: Mon Mar 01, 2010 11:02 pm    Post subject:
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: 2150
Location: At my coffee table

PostPosted: Mon Mar 01, 2010 11:49 pm    Post subject: Re: interview ques based on SOC7 and Substem down in DB2
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: 56
Location: Boston

PostPosted: Tue Mar 02, 2010 12:23 am    Post subject:
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    Post subject: Reply to: interview ques based on SOC7 and Substem down in D
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: 56
Location: Boston

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

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

Senior Member


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

PostPosted: Wed Mar 03, 2010 9:39 pm    Post subject: Re: interview ques based on SOC7 and Substem down in DB2
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: 56
Location: Boston

PostPosted: Wed Mar 03, 2010 10:16 pm    Post subject:
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    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 Split file based on comparsion to 2 f... Div Grad DFSORT/ICETOOL 3 Thu Jul 27, 2017 9:16 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts The Last Two Question For You To Ask ... CaptBill Mainframe Interview Questions 0 Fri Apr 14, 2017 5:42 am
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts Inserting records based on conditions vickey_dw DFSORT/ICETOOL 9 Wed Feb 22, 2017 1:33 pm


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