Interview Questions

shivanag · New User Joined: 22 Feb 2005 Posts: 1 Location: banglore

how to know the other persons job status?
2. how to pass return codes from cobol to jcl?
3. how to repair the table?
4.how to see the status of the table?
5. how to load the data to a table?
6. how to increase the table space in db2?
7.if i inserted a new column to the existing databese then what will happen to the original database size?
8 how to read a vsam file?
9 i have 1000 records in vasm , i want to read records 500 to 900? how can i read?
10what is severity one error in production support?

himanshu · Posted: Tue Feb 22, 2005 8:17 pm

1.how to know the other persons job status?
A. i dont know what u r saying here, but u can use the PREFIX <userid> here to check the other persons spool

2. how to pass return codes from cobol to jcl?
A. there is a system register called RETURN-CODE. put ur RC in this reg. do not declare a variable by this name in ur prog.

3. how to repair the table?
A. no idea boss

4.how to see the status of the table?
A. sorry

5. how to load the data to a table?
A. hmmm...sorry m8 cant remember at this point.

6. how to increase the table space in db2?
A. sorry

7.if i inserted a new column to the existing databese then what will happen to the original database size?
A. will increase? i dont know, gussed...

8 how to read a vsam file?
A. use open, read, readnext, read prev, etc. start to start with a position, etc

9 i have 1000 records in vasm , i want to read records 500 to 900? how can i read?
a. u can give skip and count option in repro.

10what is severity one error in production support?
A. sorry

[/i]

Rajshekhar V Patil · New User Joined: 23 Feb 2005 Posts: 7 Location: Mumbai

2. how to pass return codes from cobol to jcl?
A. move return code to jcl.
3. how to repair the table?
A.
4.how to see the status of the table?
A. SYSIBM.SYSTABLES WHERE one of the columns is STATUS.
In STATUS 3 types.
S--
X--
P--
5. how to load the data to a table?
A. DSNUPROC OR IKJEFT01 using this IBM supplied ulility program.
6. how to increase the table space in db2?
A. In Alter command
You can add the volume series & Buffer spaces

Rajshekhar V Patil

anuradha · Posted: Wed Mar 02, 2005 10:37 am

Hi ShivaNag,

You could have posted your query as a new topic instead of continuing with another topic.

sunnyk · New User Joined: 20 Oct 2004 Posts: 59

Hi ,
To know others persons job status u need to give the following command:
pre *;owner *******.............where ***** means id of the person whose job status u want to see.

And miss anuradha i have SDSF on my mainframe but no such command like s;init exists.Can u clarify.

Thanks
sunny

anuradha · Posted: Wed Mar 02, 2005 5:51 pm

Hi Sunny,

If you have SDSF just type S in the command prompt,it wil show you all the options it has in SDSF. There is SDSF panel, the following are the options right:

sunnyk · New User Joined: 20 Oct 2004 Posts: 59

Hi anuradha,
Thanx for the update but i guess this feature is in newer versions of SDSF b`coz i have only following functions in SDSF:

COMMAND INPUT ===>

DA Active users
I Input queue
O Output queue
H Held output queue
ST Status of jobs

LOG System log

END Exit SDSF

And i forgot to mention that command (pre *;owner *******) should be typed after entering S.ST on the command prompt.Feel sorry for that.

Well many of us are using the older versions of SDSF,right board.

Thanks
sunny