View previous topic :: View next topic
|
Author |
Message |
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008 Posts: 62 Location: Boston
|
|
|
|
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 |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008 Posts: 62 Location: Boston
|
|
|
|
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 |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007 Posts: 2146 Location: At my coffee table
|
|
|
|
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 |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008 Posts: 62 Location: Boston
|
|
|
|
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 |
|
|
technut
New User
Joined: 27 Dec 2007 Posts: 73 Location: India
|
|
|
|
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 |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008 Posts: 62 Location: Boston
|
|
|
|
thanks a lot Technut iam clear now |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
Karthikeyan Subbarayan
New User
Joined: 24 Feb 2008 Posts: 62 Location: Boston
|
|
|
|
Anuj,
thanks but i get Cleared already ........... |
|
Back to top |
|
|
|