GeekInterview.com
Submitted Questions

Db2 large objects (lob) columns

Asked By: Munni_27 | Asked On: Jun 16th, 2008

In db2, large objects (lob) columns are used to store large objects (documents, pictures, voice, and mixed media) in database. Which of the following clauses can't be used on lob columns?A) group byb) havingc) order byd) none of the above

Answered by: kris mohan on: Sep 13th, 2011

None of the above

Answered by: lomo_ve on: Dec 14th, 2010

d

Cics command to enable writing mixed characters in cics region

Asked By: Munni_27 | Asked On: Jun 16th, 2008

What is the cics command to enable writing mixed characters in cics region? A). Cemt caps offb). Caps offc). Cktid). Ceot trae). Ceot caps off

Answered by: RameshMohanan on: Jan 8th, 2009

d). CEOT Tra

Space identifier (asid)

Asked By: Munni_27 | Asked On: Jun 16th, 2008

What is the name of the job that has an address space identifier (asid) of one?

Answered by: dhs01 on: Apr 15th, 2009

ASID 1 is generally assigned to the master scheduler. Most shops will have the basically the same first 30 or so ASID tasks. 

Component of cics is used to control the number of instances

Asked By: Munni_27 | Asked On: Jun 10th, 2008

Which component of cics is used to control the number of instances of a program that can run concurrently in a cics region?A). Task b). Transaction c). Tclass d). Connection e). Uow

Answered by: Anupam Srivastava on: Mar 11th, 2011

a). Task  -  Multi tasking 

Answered by: kckinney on: Sep 3rd, 2010

RTM, it's really not that hard.

Db2 plans

Asked By: Munni_27 | Asked On: Jun 10th, 2008

How many db2 plans can be connected to cics region at a time? A). Infinite b). 1 c). Depends on cics region definitions d). 255 e). None of the above

Answered by: sravanthivajpaee on: Jan 28th, 2009

Plans are allocated to transactions rather than regions. For every transaction there exsists an entry for the Plan in the RCT table.
In a region multiple transactions can be present so multiple Plans can be holded to each region.

Jcl spool command

Asked By: Munni_27 | Asked On: Jun 9th, 2008

Which spool command is used to release a job that has been submitted with hold option?

Answered by: AshwiniPriya on: Sep 15th, 2010

"A" beside the job name in spool area

Answered by: kckinney on: Sep 3rd, 2010

None of the other people answering the question are console jockeys.

SDSF translates the "A" command into a JES2 command in the format of - $AJxxxxx where xxxxx the job number.
Console jockeys will just enter this rather than signing on to TSO.

Interview Question

 Ask Interview Question?

 

Career Counselling

 Have Career Question?

 Ask Chandra

 Ask Only Career questions.

Follow us: