|
View previous topic :: View next topic
|
| Author |
Message |
shalug
New User
Joined: 15 Feb 2008
Posts: 3
Location: atlanta
|
|
|
|
The below questions were asked during my interview.
1) Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program?
2) Changed map field length and the corresponding program also changed. By mistake, moved program only to production. What error will occur while accessing this map/program?
3) Record length 100 is defined in File Description. If I move 200 length data to that record field, what error will occur?
4) What error will occur, if move data to column field in DB2 table. Data size is larger than column field size?
5) Select 'abc' from table table_name, what will it return result. If 'abc' value is in the table.
Can anyone please answer to these questions?
Thanks |
|
| Back to top |
|
 |
murmohk1
Senior Member
.jpg)
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
Shalug,
| Quote: |
| Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program? |
A simple search in all the libs with search string as 'prog name' provides you the list.
| Quote: |
| Record length 100 is defined in File Description. If I move 200 length data to that record field, what error will occur? |
Truncation. |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
| murmohk1 wrote: |
| Quote: |
| Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program? |
A simple search in all the libs with search string as 'prog name' provides you the list. |
Hi,
I think interviewer was asking if the JOBs are 'running', at that given moment which JOB is using the load module of that program...
...just a different perception about the same question. |
|
| Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India
|
|
|
|
Anuj,
| Quote: |
| I think interviewer was asking if the JOBs are 'running', at that given moment which JOB is using the load module of that program... |
Manual search. |
|
| Back to top |
|
|
jpraveenreddy
New User
Joined: 30 Nov 2007
Posts: 28
Location: mysore
|
|
|
|
| Quote: |
| 1) Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program? |
I think looking into spool can help.
Correct me if i am wrong |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi Murali,
I didn't get You, what do You want to convey here?
BTW, if I go with my assumption, I'll say, LOD modules are with DISP=SHR, who is bothered to check which JOB is using the LOD module. I don't think that interviewer wanted to listen about the ISPF 3.14 option. |
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi.........
| Quote: |
| Changed map field length and the corresponding program also changed. By mistake, moved program only to production. What error will occur while accessing this map/program? |
If u move the changed program with out staging in to the production, during AUDIT process you will get SYNC10 or SYNC12 error |
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hiiiiiiii.......
| Quote: |
What error will occur, if move data to column field in DB2 table. Data size is larger than column field size |
obviously data get truncated. |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| shalug wrote: |
| 1) Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program? |
Huh?
| Quote: |
| 2) Changed map field length and the corresponding program also changed. By mistake, moved program only to production. What error will occur while accessing this map/program? |
Truncation...
| Quote: |
| 3) Record length 100 is defined in File Description. If I move 200 length data to that record field, what error will occur? |
Truncation...
| Quote: |
| 4) What error will occur, if move data to column field in DB2 table. Data size is larger than column field size? |
Truncation...
| Quote: |
| 5) Select 'abc' from table table_name, what will it return result. If 'abc' value is in the table. |
Just the 'abc' literal you specified.....
Note: the 'Truncation' answer assumes COBOL.... |
|
| Back to top |
|
|
nbalajibe
Warnings : 1
New User
Joined: 28 Nov 2006
Posts: 75
Location: India
|
|
|
|
| Quote: |
| 1) Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program? |
Using the command "/DISP A" in the corresponding online region we can get the details of the JOBs running and the programs they access. |
|
| Back to top |
|
|
nbalajibe
Warnings : 1
New User
Joined: 28 Nov 2006
Posts: 75
Location: India
|
|
|
|
| Quote: |
| 5) Select 'abc' from table table_name, what will it return result. If 'abc' value is in the table. |
If there are n records in the table, the literal 'abc' would be returned n times. |
|
| Back to top |
|
|
CICS Guy
Senior Member
Joined: 18 Jul 2007
Posts: 2146
Location: At my coffee table
|
|
|
|
| [quote="nbalajibeUsing the command "/DISP A" in the corresponding online region we can get the details of the JOBs running and the programs they access.[/quote]"/DISP"? |
|
| Back to top |
|
|
nbalajibe
Warnings : 1
New User
Joined: 28 Nov 2006
Posts: 75
Location: India
|
|
|
|
This is a command to be given in the online region. |
|
| Back to top |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007
Posts: 275
Location: Bang,iflex
|
|
|
|
Hi nbalajibe......
this commands are company specific. It differs form one organisation to other (Its a kind of in house tool). |
|
| Back to top |
|
|
shalug
New User
Joined: 15 Feb 2008
Posts: 3
Location: atlanta
|
|
|
|
| Anuj D. wrote: |
| murmohk1 wrote: |
| Quote: |
| Job1, job2, job3 are using one common program. Each job executes this program for it specific process. How would you find/know which job is using this program? |
A simple search in all the libs with search string as 'prog name' provides you the list. |
Hi,
I think interviewer was asking if the JOBs are 'running', at that given moment which JOB is using the load module of that program...
...just a different perception about the same question. |
Anuj, interviewer has asked the same.
Thanks all for the answers...
I told to interviewer that truncation error. But, he was asked the specific error message/code...
Thanks |
|
| Back to top |
|
|
|
|
