View previous topic :: View next topic
|
Author |
Message |
palaveerareddy
New User
Joined: 13 Apr 2005 Posts: 5
|
|
|
|
i was asked in one interview
1)where did you use comp & comp 3 in your project.
2)how did you measure the performance with comp & without comp.
3)how to identify db2 whether it is test or production system by seeing run jcl
4)where did you use files in your project.
please give some real time examples for all above questions
thanks®ards
p.v.reddy. |
|
Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003 Posts: 568 Location: Bangalore
|
|
|
|
Quote: |
where did you use comp & comp 3 in your project. |
Counters & arithmatic operands
Quote: |
how did you measure the performance with comp & without comp. |
Try ibmmainframes.com/size.html
Quote: |
how to identify db2 whether it is test or production system by seeing run jcl |
Check your SQL messages
Quote: |
where did you use files in your project. |
Can use with LOAD utility of DB2 |
|
Back to top |
|
|
sridhar.kothakonda
New User
Joined: 27 Jun 2005 Posts: 1
|
|
|
|
1. what is the uses of com & com-3? |
|
Back to top |
|
|
MGIndaco
Active User
Joined: 10 Mar 2005 Posts: 432 Location: Milan, Italy
|
|
|
|
For the third question I think that a check of library or the WFH can help you too(see the xxxx but for the library depend of your installation):
Code: |
//STEP010U EXEC PGM=DSNTIAUL
//STEPLIB DD DSN=DB2.DSNEXIT.xxxx,DISP=SHR
// DD DSN=DB2.DSNLOAD.xxxx,DISP=SHR
// DD DSN=DB2.RUNLIB.xxxx,DISP=SHR
....
//WFHxxxx DD DUMMY |
|
|
Back to top |
|
|
|