Monday 6 August 2012

ibm as400 interview questions answers pdf free download


IBM AS-400 Interview Questions-->5


141. What is Folder?
 A Folder is a named object that is used as a directory for documents and other folders.  
 Folders can be filed with in another folder.

142. What is Spool file, why is it required?
 A file that holds output data to be processed, such as information waiting to be printed.

143. What is Job, What are the attributes of a Job?
     A Job is a basic unit of work on AS/400.
     The attributes are:
     Job Number Unique system generated sequential number
     Job Name Any user defined name (Max 10 char)
     User Name Who initiated the job.

144. What is Job description?
A Job description defines an environment in which a batch job or an interactive job to be executed.

145. What is the difference between Interactive & Batch Job?
Interactive Job: A Job started for a person who SIGNON to a workstation.
Batch Job: A predefined group of processing actions submitted to the system to be performed.

146. What is Group Job?
A Group Job is attached to one workstation and a user.   There should be an initial group job and it can be branched to many other group jobs.   The group jobs can have different library lists and different output, message queues. Group Job is useful in enhancing the programmer’s productivity.  It is as though logging into the same user-id many times.

147.  What are the two main attributes, which govern the execution of a job?
 Run time priority and Time slice

148. What is Sub-System?
Sub-Systems are specific user defined partitions of the CPU where various jobs may be executed.  One subsystem can have more than one active job at a time.

149.  What is a Device file?
A device file contains the description of how data is to be presented to a program from a device or vice versa.   Device file can be Printer, Disk, Tape and Remote system.

150. What is an ICF file?
A device file that allows a program on the system to communicate with program in other system.
151.  What is a message file?
It is a file which contains the messages of an application.   For example all RPG/400 messages are stored in a file, all COBOL/400 messages are stored in a file.

152. What is a job log?
A record of request submitted to system be a job.   The message related to the requests, and action performed by the system on the log.  The system program maintains it.

153. What is the purpose of OPNQRYF (Open Query File)?
OPNQRYF is used to select certain records of the database file based on the QRYSLT (Query select) condition.

154.How to create files dynamically without DDS?
Through OPNQRYF

155. What command must be executed before executing OPNQRYF command?
OVRDBF (Override Data base file)

156.What is Data Area?
Data area is an object used to hold data for access by any job running on the system.  A data area can be locked to a single user, thus preventing other users from processing at the same time.

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

158. What is LDA?
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.

159.What is the type, length of a LDA?
 *CHAR, 1024 bytes

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

161. How to create a user defined (general) data area?
Using CRTDTAARA command

162.What are the different ways to input data into data area?
CHGDTAARA (using CL)
Using OUT OPCODE in RPG

163.How to retrieve data from data area?
By using RTVDTAARA command in CL.
By using IN OPCODE in RPG

164.   What are the valid user defined data area types?
         CHAR, NUMERIC and LOGICAL

165.   How can a data area be locked after being updated?
         Using OUT *LOCK

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

167.   How to create a data queues?
         By using CRTDTAQ command.

168.   What are the valid data types in Data Queue?
         Char, Numeric, and Logical

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

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

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

172. How do you grant authority?
Using GRTOBJAUT command

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

174.How do you put jobs in batch mode?
SBMJOB

175.What is the use of OVRDBF?
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.

176. What is the use of OVRPRTF?
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.

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

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

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

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

181.How do you detect unused spool storage?
By using “Reclaim Spool Storage”.

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

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

184.What process the command SBMRJEJOB does?
Sends RJE input stream to host system

185.What is journaling & Commitment Control?
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).

186.What is the purpose of STRCMTCTL command?
Start commitment control for files that are being “Journalled”.

187.What is the system objects required for journalling?
Journal receiver, journal and PFs to be journalled.

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

189.What the difference between Source Physical File and Physical File?
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.

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

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

192.What is the default value for the number of increment for the physical file?
Three

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

194.What is Multi-format logical file?
Logical file which uses fields from two or more physical files.

195.   What are the Select and Omit criteria in logical file?
This is used to specify rules for the Selection/Omission of records from a Physical File.

196. Can fields be concatenated in a logical file level?
Yes. By using CONCAT keyword

197. When would the ALL keyword be used?
Use with Select or Omit, to select/omit records.

199.What are the different types of keywords in display files?
File level, Record format level, Field level

200.What is the maximum number of records you can specify in a display file?
1024


Remaining (201-700) download Interview Questions download the PDF Link:

0 comments:

Post a Comment