Saturday, 27 August 2011

IBM AS400 Interview Questions Answers: Series III

What are the types of data areas?
Ans:
User defined Data Area, Local Data Area (LDA), Group Data Area (GDA), Program Initialization Parameter (PIP) Data Area.

What is LDA?
Ans
:LDA is created by the system for each job in the system, including auto-start jobs, jobs started on the system by a reader, and subsystem monitor jobs.

What is the type, length of a LDA?
Ans:
*CHAR, 1024 bytes

What is GDA?
Ans:
The system creates a GDA when an interactive job becomes group jobs. Only one GDA can exists for group.

How can a data area be locked after being updated?
Ans:
Using OUT *LOCK

What is the use of Data Queues?
Ans:
Data queue is a type of system object that you can create. Data Queues are used in Program to program communication.

How to create a data queues?
Ans
:Using CRTDTAQ command.



What are the valid data types in Data Queue?
Ans
:Char, Numeric, and Logical

What are the two types of read performed on data queues?
Ans:
Read with lock, and read without lock.

How do you use DEBUG utility?
Ans
:STRDBG program-name UPDPROD(*YES)

What is an authorization list?
Ans:
A lists of two or more user Ids & their authorities for system resources. The system identifies it an object type *AUTL

How do you grant authority?
Ans:
Using GRTOBJAUT command

What are the types of object authorities?
Ans
:*USE, *CHANGE, *ADD, *DLT, *READ, *UPD, *ALL, *EXCLUDE, *OBJEXIST, *OBJMGT, *OBJOPR

How do you put jobs in batch mode?
Ans
:SBMJOB

What is the use of OVRDBF ?
Ans
:You can use the Override with Database file (OVRDBF) command to replace the database file named in a CL program or to change certain parameters of the existing database file.

What is the use of OVRPRTF ?
Ans
:Override with Printer file (OVRPRTF) command is used to override certain parameters of the printer files used in the program or to replace the printer file.

How to change file attributes such as size, file wait time, record wait time etc. , permanently?
Ans
:Using CHGPF command

What is the use purpose of CRTCMD?
Ans:
To create user defined command.

What is class of service ?
Ans
:A set of link and node characteristics associated with a session.

How to see active jobs of the system.
Ans:
Using WRKACTJOB command

How do you detect unused spool storage?
Ans:
Using Reclaim Spool Storage.

What are the functions of Remote Job Entry (RJE) ?
Ans:
Allows user of AS/400 system to submit jobs and receive jobs from a host system.

What is the function of RJE Conversion Utility?
Ans
:It converts compressed data written to an AS/400 database file to decompressed data written to another AS/400 database, diskette, or device file.

What process the command SBMRJEJOB does?
Ans:
Sends RJE input stream to host system

What is journaling & Commitment Control?
Ans
:Journaling is a function which records the changes in a file in a journal. These record images are used to recover the changes in the file should the system ends abnormally. Commitment control is a function that allows you to define and process a number of changes to database files as a single unit (transaction).

What is the purpose of STRCMTCTL command?
Ans:
Starts commitment control for files that are being journalled.

What are the system objects required for journalling?
Ans
:Journal receiver, journal and PFs to be journalled.

What are the different definition levels in Data Description Specifications?
Ans:
File level, Record level, Field level, Join level, Keyfield level, Select/Omit level.

What the difference between Source Physical File and Physical File?
Ans:
A Source Physical File contains the source for the various objects created this file has specific structure. A Physical File contains data, and the record format can be different for different physical files.

What is an access path?
Ans
:The order in which the database fields are organized for processing in the program.

What are all the different types of access path?
Ans:
Arrival sequence access path. Keyed sequence access path.

What is the default value for the number of increment for the physical file?
Ans:
Three

When does the DFT keyword in PF be used?
Ans:
To specify the default value it a field.

How to create a user defined (general) data area?
Ans:
Using CRTDTAARA command

What are the different ways to input data into data area?
Ans:
CHGDTAARA (using CL)
Using OUT opcode in RPG

How to retrieve data from data area?
Ans:

Using RTVDTAARA command in CL.
Using IN opcode in RPG


Source: aired.in

No comments:

Post a Comment