Searching for "i"

Q:

What is the use of SYSPRINT, SYSIN, DUMMY in JCL ?

Answer

SYSPRINT: All system output will appear under this DD card. Suppose you are copying a VSAM file using IDCAMS. Then, number of records processed, highest condition code etc.. will appear under sysprint. You cannot customise SYSPRINT output.


SYSIN: This is nothing but SYStem INstruction. Suppose, you want to sort a file on certain key. You have to have following command under SYSIN.


SORT FIELDS = (starting-col,length,data-type,A/D)


SUM FIELDS = NONE


DUMMY: Mainly used where user is intended to simulate a program without creating an output file.

Report Error

View answer Workspace Report Error Discuss

Q:

What are the processing modes available in IMS DB?

Answer

Batch DL/I


MPP Mode - (Message Processing Program)


BMP Mode - (Batch Message Processing)

Report Error

View answer Workspace Report Error Discuss

Q:

What are the two types of fields available in IMS DB?

Answer

Key Fields - (PROCOPT=K)


- Used to sequence the database and can't be changed


- It is the field within a segment, used to identify the occurrence of the segment


- Used to maintain the IMS segments in ascending sequence.


 


Search Fields - (PROCOPT=G)


- Used to search for a segment, without the segment being sequenced on that field


- A segment need not have a key or search field.


 


Both types of fields can be used to search the database.

Report Error

View answer Workspace Report Error Discuss

Q:

What is a key field in an IMS database?

Answer

A Field that DL/I uses to maintain the segments in the ascending order is called the key field

Report Error

View answer Workspace Report Error Discuss

Q:

What is IMS (DB/DC)?

Answer

IMS (Information Management System) is IBMs hierarchical database management system. It has mainly two components: IMS DB and IMS DC (Also know as IMS TM)


IMS DB - IMS/Database Manager as the name implies manages the IMS databases. It is used for physical storage creation and management and data retrieval.


IMS DC / IMS TM - IMS/Data Communications or IMS/Transaction Manager handles online transaction processing system.

Report Error

View answer Workspace Report Error Discuss

Q:

How can we distinguish between an online and batch program in IMS environment?

Answer

If in application program IO-PCB is there then it is a online program. In ENTRY statement IO-PCB must be listed first and then DB-PCB.

Report Error

View answer Workspace Report Error Discuss

Q:

What are the different types of VSAM files available?

Answer

ESDS: Entry Sequence Data Set


KSDS: Key Sequence Data Set


RRDS: Relative Data Set

Report Error

View answer Workspace Report Error Discuss

Q:

What are the three levels of definition for the VSAM DEFINE?

Answer

They are DEFINE CLUSTER, DATA and INDEX.

Report Error

View answer Workspace Report Error Discuss